Table cxgn.phenome.genotype

 Generated by
SchemaSpy
Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
genotype_id serial 10  √  nextval('genotype_genotype_id_seq'::regclass)
genotype_region.genotype_id genotype_region_genotype_id_fkey
polymorphic_fragment.genotype_id polymorphic_fragment_genotype_id_fkey
individual_id int8 19  √  null
individual.individual_id genotype_individual_id_fkey
experiment_name varchar 100  √  null
reference_map_id int8 19  √  null
background_accession_id int8 19  √  null
preferred bool 1  √  null
sp_person_id int8 19  √  null
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

Table contained 1,103 rows at Sat Oct 11 01:31 EDT 2008

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

Close relationships  within one two degrees of separation :