Table zfindb.informix.fish 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 varchar 50
fish_experiment.genox_fish_zdb_id genox_fish_zdb_id_foreign_key_odc C
fish_str.fishstr_fish_zdb_id fishstr_fish_zdb_id_foreign_key_odc C
genotype_figure_fast_search.gffs_fish_zdb_id gffs_fish_zdb_id_foreign_key C
zdb_active_data.zactvd_zdb_id fish_zdb_active_data_foreign_key_odc C
fish_genotype_zdb_id varchar 50
genotype.geno_zdb_id fish_genotype_zdb_id_foreign_key_odc C
fish_name lvarchar 255
fish_handle varchar 255
fish_name_order varchar 255
fish_modified boolean 1  √  f
fish_order int8 19
fish_functional_affected_gene_count int8 19
fish_is_wildtype boolean 1 f
fish_full_name varchar 255  √  null

Table contained 34,178 rows at Thu Jun 22 08:42 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
fish_is_wildtype + fish_modified + fish_name + fish_genotype_zdb_id Performance Asc/Asc/Asc/Asc fish_genotype_foreign_key_index
fish_is_wildtype + fish_modified + fish_name + fish_handle Must be unique Asc/Asc/Asc/Asc fish_handle_ak_index
fish_is_wildtype + fish_modified + fish_name + fish_zdb_id Must be unique Asc/Asc/Asc/Asc fish_zdb_id_pk_index

Close relationships  within of separation: