Table cxgn.phenome.individual

 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
individual_id serial 10  √  nextval('individual_individual_id_seq'::regclass)
genotype.individual_id genotype_individual_id_fkey
germplasm.individual_id germplasm_individual_id_fkey
individual_allele.individual_id individual_allele_individual_id_fkey
individual_dbxref.individual_id individual_dbxref_individual_id_fkey
individual_history.individual_id individual_history_individual_id_fkey
individual_locus.individual_id individual_locus_individual_id_fkey
name varchar 100  √  null
description text 2147483647  √  null
sp_person_id int8 19  √  null
create_date timestamptz 35,6  √  now()
modified_date timestamptz 35,6  √  null
obsolete bool 1  √  false
population_id int8 19  √  null
population.population_id individual_population_id_fkey
updated_by int4 10  √  null
common_name_id int8 19  √  null

Table contained 7,565 rows at Sat Oct 11 01:31 EDT 2008

Indexes:
Column(s) Type Sort Constraint Name
individual_id Primary key Asc individual_pkey
name Performance Asc phenome_individual_name_idx
population_id Performance Asc phenome_population_id_idx

Close relationships  within one two degrees of separation :