phenome_genotype

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
phenome_genotype_id serial 10 √ nextval('phenome.genotype_genotype_id_seq'::regclass)
genotype_region.phenome_genotype_id genotype_region_genotype_id_fkey C
polymorphic_fragment.phenome_genotype_id polymorphic_fragment_genotype_id_fkey R
individual_id int8 19 √ null
individual.individual_id genotype_individual_id_fkey C
experiment_name varchar 100 √ null
reference_map_id int8 19 √ null
map.map_id genotype_reference_map_id_fkey R
background_accession_id int8 19 √ null
accession.accession_id genotype_background_accession_id_fkey R
preferred bool 1 √ null
sp_person_id int8 19 √ null
sp_person.sp_person_id genotype_sp_person_id_fkey R
modified_date timestamptz 35,6 √ null
create_date timestamptz 35,6 √ null
obsolete bool 1 √ false
genotype_experiment_id int8 19 √ null
genotype_experiment.genotype_experiment_id genotype_genotype_experiment_id_fkey R
stock_id int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
genotype_pkey Primary key Asc phenome_genotype_id
genotype_individual_id_idx Performance Asc individual_id
genotype_reference_map_id_idx Performance Asc reference_map_id

Relationships

Close relationships within degrees of separation