Table test_seqware_meta_db.public.organism
Track organisms for samples and lanes

Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
organism_id serial 10  √  nextval('organism_organism_id_seq'::regclass)
lane.organism_id lane_organism_id_fkey R
sample.organism_id sample__organism_fk R
code text 2147483647
name text 2147483647  √  null
accession text 2147483647  √  null
ncbi_taxid int4 10  √  null

Table contained 56 rows at Mon Mar 31 13:20 EDT 2014

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

Close relationships  within of separation: