Table zfindb.informix.fish_experiment 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
genox_zdb_id varchar 50
clean_expression_fast_search.cefs_genox_zdb_id clean_expression_fast_search_genox_zdb_id_foreign_key_odc C
disease_annotation_model.damo_genox_zdb_id damo_genox_zdb_id_fk_odc C
expression_experiment2.xpatex_genox_zdb_id xpatex2_genox_foreign_key R
mutant_fast_search.mfs_genox_zdb_id mutant_fast_search_genox_zdb_id_foreign_key_odc C
phenotype_experiment.phenox_genox_zdb_id phenox_genox_foreign_key_odc C
tmp_genox.genox_zdb_id Implied Constraint R
zdb_active_data.zactvd_zdb_id genotype_experiment_genox_foregin_key_odc C
genox_exp_zdb_id varchar 50
genox_is_standard boolean 1  √  f
genox_is_std_or_generic_control boolean 1  √  f
genox_fish_zdb_id varchar 50
fish.fish_zdb_id genox_fish_zdb_id_foreign_key_odc C

Table contained 37,111 rows at Thu Jun 22 08:42 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
genox_is_standard + genox_is_std_or_generic_control + genox_fish_zdb_id + genox_exp_zdb_id Must be unique Asc/Asc/Asc/Asc fish_experiment_alternate_key_index
genox_is_standard + genox_is_std_or_generic_control + genox_exp_zdb_id Performance Asc/Asc/Asc genotype_experiment_exp_zdb_id_foreign_key_index
genox_is_standard + genox_is_std_or_generic_control + genox_zdb_id Must be unique Asc/Asc/Asc genotype_experiment_primary_key_index
genox_is_standard + genox_is_std_or_generic_control + genox_fish_zdb_id Performance Asc/Asc/Asc genox_fish_zdb_id_fk_index

Close relationships  within of separation: