Table zfindb.informix.genotype_figure_fast_search 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
gffs_serial_id serial8 19  √ 
gffs_geno_zdb_id varchar 50
genotype.geno_zdb_id gffs_geno_zdb_id_foreign_key C
gffs_fig_zdb_id varchar 50
figure.fig_zdb_id gffs_fig_zdb_id_foreign_key C
gffs_morph_zdb_id varchar 50  √  null
marker.mrkr_zdb_id gffs_morph_zdb_id_foreign_key C
gffs_pg_id int8 19
gffs_date_created datetime year to second 19 current
gffs_psg_id int8 19  √  null
gffs_fish_zdb_id varchar 50
fish.fish_zdb_id gffs_fish_zdb_id_foreign_key C
gffs_genox_zdb_id varchar 50  √  null

Table contained 86,668 rows at Tue Dec 20 09:53 PST 2016

Indexes:
Column(s) Type Sort Constraint Name
gffs_serial_id Must be unique Asc 4141_41828
gffs_fig_zdb_id Performance Asc genotype_figure_fast_search_fig_zdb_id_foreign_key_index
gffs_fish_zdb_id Performance Asc genotype_figure_fast_search_fish_zdb_id_foreign_key_index
gffs_geno_zdb_id Performance Asc genotype_figure_fast_search_geno_zdb_id_foreign_key_index
gffs_morph_zdb_id Performance Asc genotype_figure_fast_search_morph_zdb_id_foreign_key_index
gffs_pg_id Performance Asc genotype_figure_fast_search_pg_id_foreign_key_index
gffs_psg_id Performance Asc genotype_figure_fast_search_psg_id_foreign_key_index

Close relationships  within of separation: