Table cxgn.phenome.population

 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
population_id serial 10  √  nextval('population_population_id_seq'::regclass)
individual.population_id individual_population_id_fkey
phenotype.population_id phenotype_population_id_fkey
population_dbxref.population_id population_dbxref_population_id_fkey
name varchar 100  √  null
description text 2147483647  √  null
person_id int4 10  √  null
sp_person_id int8 19  √  null
create_date timestamptz 35,6  √  now()
modified_date timestamptz 35,6  √  null
background_accession_id int8 19  √  null
obsolete bool 1  √  false

Table contained 17 rows at Sun Sep 07 01:30 EDT 2008

Indexes:
Column(s) Type Sort Constraint Name Anomalies
population_id Primary key Asc population_pkey  
name Must be unique Asc population_name_key This unique column is also nullable

Close relationships  within one two degrees of separation :