Table zfindb.public.tmp_fish_thatfitthebill 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_zdb_id text 2147483647  √  null
fish.fish_zdb_id Implied Constraint R
fish_name text 2147483647  √  null
affected_components text 2147483647  √  null
genox_exp_zdb_id text 2147483647  √  null
exp_name text 2147483647  √  null
genox_zdb_id text 2147483647  √  null
fish_experiment.genox_zdb_id Implied Constraint R
e1subtermid varchar 2147483647  √  null
e1subtermname varchar 2147483647  √  null
psg_e1_relation_name text 2147483647  √  null
e1supertermid varchar 2147483647  √  null
e1supertermname varchar 2147483647  √  null
e2subtermid varchar 2147483647  √  null
e2subtermname varchar 2147483647  √  null
psg_e2_relation_name text 2147483647  √  null
e2supertermid varchar 2147483647  √  null
e2supertermname varchar 2147483647  √  null
psg_tag text 2147483647  √  null
qualityid varchar 2147483647  √  null
psg_quality_name text 2147483647  √  null
fig_zdb_id text 2147483647  √  null
figure.fig_zdb_id Implied Constraint R
fig_label text 2147483647  √  null
fig_source_zdb_id text 2147483647  √  null
pubmedid int4 10  √  null

Table contained 873 rows at Wed Sep 15 00:41 PDT 2021


Close relationships: