Table zfindb.public.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 text 2147483647
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_restore.genox_zdb_id Implied Constraint R
zdb_active_data.zactvd_zdb_id genotype_experiment_genox_foregin_key_odc C
genox_exp_zdb_id text 2147483647
genox_is_standard bool 1  √  false
genox_is_std_or_generic_control bool 1  √  false
genox_fish_zdb_id text 2147483647
fish.fish_zdb_id genox_fish_zdb_id_foreign_key_odc C

Table contained 42,614 rows at Mon Sep 03 04:09 PDT 2018

Indexes:
Column(s) Type Sort Constraint Name
genox_zdb_id Primary key Asc genotype_experiment_primary_key
genox_fish_zdb_id + genox_exp_zdb_id Must be unique Asc/Asc fish_experiment_alternate_key_index
genox_exp_zdb_id Performance Asc genotype_experiment_exp_zdb_id_foreign_key_index
genox_fish_zdb_id Performance Asc genox_fish_zdb_id_fk_index

Close relationships  within of separation: