Table cxgn.phenome.phenotype

 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
phenotype_id serial 10  √  nextval('phenotype_phenotype_id_seq'::regclass)
image.phenotype_id image_phenotype_id_fkey
phenotype_term.phenotype_id phenotype_term_phenotype_id_fkey
population_id int4 10  √  null
population.population_id phenotype_population_id_fkey
allele_id int4 10  √  null
allele.allele_id phenotype_allele_id_fkey
locus_id int4 10  √  null
locus.locus_id phenotype_locus_id_fkey
allele_type varchar 255  √  null
verified_allele bool 1  √  null
phenotype_accession varchar 20
phenotype_type varchar 11  √  null
phenotype_details text 2147483647  √  null

Table contained 0 rows at Thu Aug 21 01:31 EDT 2008

Indexes:
Column(s) Type Sort Constraint Name
phenotype_id Primary key Asc phenotype_pkey
phenotype_accession Must be unique Asc phenotype_accession_key

Close relationships  within one two degrees of separation :