Table srdb.srdb.taxonomy
Taxonomic information obtained from the Integrated Taxonomic Information System (ITIS). Negative values for taxonomic serial number (TSN) are used in cases where a stock is of a species not present in ITIS.

 Generated by
SchemaSpy
Legend: SourceForge.net
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
tsn int4 10
stock.tsn stock_tsn_fkey R
scientificname varchar 200  √  null
fishbasesaupcodes.scientificname fishbasesaupcodes_scientificname_fkey R
kingdom varchar 200  √  null
phylum varchar 200  √  null
classname varchar 200  √  null
ordername varchar 200  √  null
family varchar 200  √  null
genus varchar 200  √  null
species varchar 200  √  null
myersname varchar 20  √  null
commonname1 varchar 200  √  null
commonname2 varchar 200  √  null
myersscientificname varchar 200  √  null
myersfamily varchar 50  √  null

Table contained 283 rows at Fri Dec 09 15:00 PST 2011

Indexes:
Column(s) Type Sort Constraint Name Anomalies
tsn Primary key Asc taxonomy_pkey  
scientificname Must be unique Asc scientificname_id This unique column is also nullable

Close relationships  within of separation: