GeneX-2.0 DB: Sample Table
GeneX-2.0 DB: Sample Table
Table TypeInheritsComment
DATAIdentifiable The Sample table gives detailed information concerning the derivation of the DNA used to hybridize with an instance of an Array.

Column Information
Column NameFull NameData TypeNot NULLComment
abrc_acc_numABRC Accession Numberchar128false
ageAgeintfalse
age_unitsAge Unitschar128falsecontrolled vocab
atcc_cell_typeATCC Cell Typechar128falsecontrolled vocab
cell_lineCell Linechar128false
common_acc_numCommon Accession Numberchar128false
cultivar_nameCultivar Namechar128false
dev_stage_nameDevelopment Stage Namechar128falsecontrolled vocab
dev_stage_timeDevelopment Stage Timedatetimefalse
dev_stage_unitsDevelopment Stage Unitschar128falsecontrolled vocab
genetic_statusGenetic Statuschar128falsecontrolled vocab
genetic_status_commentGenetic Status Commenttextfalse
genotypeGenotypechar128false
growth_condGrowth Conditiontextfalse
nottingham_acc_numNottingham Accession Numberchar128false
organ_typeOrgan Typechar128falsecontrolled vocab
organism_intactnessOrganism Intactnesschar128falsecontrolled vocab
pathology_descrPathology Descriptiontextfalse
phenotype_namePhenotype Namechar128false
primary_cell_typePrimary Cell Typechar128falsecontrolled vocab
provider_con_fkData Providerinttrue the supplier of the sample
seed_supplier_cat_numSeed Supplier Catalog Numberchar128false
sex_mating_typeSex/Mating Typechar128falsecontrolled vocab
smp_pkAccession Numberserialfalse
spc_fkSpeciesinttrue the species from which the sample was derived
strainStrainchar128false
tissue_typeTissue Typechar128falsecontrolled vocab
varietyVarietychar128false

Primary Key Information
Column Name
smp_pk

Foreign Key Information
Column NameForeign TablePrimary Key in Foreign TableForeign Key Type
provider_con_fkContactcon_pkMANY_TO_ONE
spc_fkSpeciesspc_pkMANY_TO_ONE

Unique Column Information
Column Names
provider_con_fk name

Index Information
NameColumn Name
provider_con_fksample_provider_con_fk
spc_fksample_spc_fk