Table cxgn.sgn.organism

 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
organism_id serial 10  √  nextval('organism_organism_id_seq'::regclass)
accession.organism_id organism_id_fk
deprecated_map_cross.organism_id organism_id_fk
organism_name varchar 80  √  null
common_name_id int8 19
common_name.common_name_id common_name_id_fk
organism_descrip text 2147483647  √  null
specie_tax varchar 80  √  null
genus_tax int4 10  √  null
taxonomy.tax_id organism_genus_tax_fkey
subfamily_tax int4 10  √  null
taxonomy.tax_id organism_subfamily_tax_fkey
family_tax int4 10  √  null
taxonomy.tax_id organism_family_tax_fkey
order_tax int4 10  √  null
taxonomy.tax_id organism_order_tax_fkey
chr_n_gnmc int4 10  √  null
polypl_gnmc varchar 50  √  null
genom_size_gnmc varchar 50  √  null
genom_proj_gnmc text 2147483647  √  null
est_attribution_tqmc text 2147483647  √  null

Table contained 55 rows at Wed May 20 01:50 EDT 2009

Indexes:
Column(s) Type Sort Constraint Name Anomalies
organism_id Primary key Asc organism_pkey  
organism_name Must be unique Asc unique_organism_name This unique column is also nullable

Close relationships  within one two degrees of separation :