Table zfindb.informix.fish_staging 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
fish_id varchar 50  √  null
fish_search.fish_id Implied Constraint R
geno_id varchar 50  √  null
strs multiset 1914  √  null

Table contained 29,976 rows at Tue Nov 10 13:18 PST 2015

Indexes:
Column(s) Type Sort Constraint Name
strs + fish_id Performance Asc/Asc f_id_index
strs + geno_id Performance Asc/Asc ge_id_index

Close relationships: