SchemaSpy - Table zfindb.public.fish

Generated by
SchemaSpy

Legend:

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_fish_thatfitthebill.genox_zdb_id	Implied Constraint R
tmp_fishnoeap.genox_zdb_id	Implied Constraint R
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

experiment.exp_zdb_id

fish_experiment_experiment_foreign_key C

genox_is_standard

bool

√

false

genox_is_std_or_generic_control

bool

√

false

genox_fish_zdb_id

text

2147483647

fish.fish_zdb_id

genox_fish_zdb_id_foreign_key_odc C

Table contained 55,377 rows at Wed Sep 15 00:41 PDT 2021

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