Tables
Relationships
Utility Tables
Constraints
Anomalies
Columns
Donate
Table
srdb
.
srdb
.
fishbasesaupcodes
Generated by
SchemaSpy
Related columns
Constraints
Comments
Legend
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
taxonkey
int4
10
√
null
specode
int4
10
√
null
taxonnom_taxonname
varchar
200
√
null
commonname
varchar
100
√
null
scientificname
varchar
200
√
null
taxonomy
.scientificname
fishbasesaupcodes_scientificname_fkey
R
Table contained 279 rows at Fri Dec 09 15:00 PST 2011
Close relationships
within
one
two degrees
of separation
: