Table topp.deprecated.species 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
speciesname varchar 80  √  null
genus varchar 80  √  null
species varchar 80  √  null
taxongroup varchar 80  √  null
workinggroup varchar 80  √  null
abreviation varchar 20  √  null
speciescode varchar 2
animals.speciescode $1 R
cases.speciescode $3 R
deployments.speciescode $2 R
files.speciescode Implied Constraint R
speciesaliases.speciescode $1 R
concatname text 2147483647  √  null

Table contained 69 rows at Wed Dec 27 13:21 PST 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
speciescode Primary key Asc species_pkey  
abreviation Must be unique Asc species_abreviation_key This unique column is also nullable

Close relationships  within of separation: