organism

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
organism_id serial 10 √ nextval('sgn.organism_organism_id_seq'::regclass)
organism.sgn_organism_id organism_sgn_organism_id_fkey R
accession.organism_id organism_id_fk R
deprecated_map_cross.organism_id organism_id_fk R
library.organism_id Implied Constraint R
organism_name varchar 80 √ null
common_name_id int8 19 null
common_name.common_name_id common_name_id_fk R
organism_descrip text 2147483647 √ null
specie_tax varchar 80 √ null
genus_tax int4 10 √ null
taxonomy.tax_id organism_genus_tax_fkey R
subfamily_tax int4 10 √ null
taxonomy.tax_id organism_subfamily_tax_fkey R
family_tax int4 10 √ null
taxonomy.tax_id organism_family_tax_fkey R
order_tax int4 10 √ null
taxonomy.tax_id organism_order_tax_fkey R
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
chado_organism_id int4 10 √ null
organism.organism_id organism_chado_organism_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
organism_pkey Primary key Asc organism_id
unique_organism_name Must be unique Asc organism_name

Relationships

Close relationships within degrees of separation