SchemaSpy - Table zfindb.public.experiment

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

exp_zdb_id

text

2147483647

experiment_condition.expcond_exp_zdb_id	experiment_zdb_id_foreign_key C
experiment_condition_restricted.ecr_exp_zdb_id	experiment_condition_restricted_exp_foreign_key R
fish_experiment.genox_exp_zdb_id	fish_experiment_experiment_foreign_key C

zdb_active_data.zactvd_zdb_id

exp_zdb_id_foreign_key_odc C

exp_name

text

2147483647

exp_source_zdb_id

text

2147483647

zdb_active_source.zactvs_zdb_id

exp_source_zdb_id_foreign_key_odc C

Table contained 20,206 rows at Wed Sep 15 00:41 PDT 2021

Indexes:

Column(s)	Type	Sort	Constraint Name
exp_zdb_id	Primary key	Asc	exp_zdb_id_primary_key
exp_name + exp_source_zdb_id	Must be unique	Asc/Asc	experiment_alternate_key_index
exp_name	Performance	Asc	experiment_name_index
exp_source_zdb_id	Performance	Asc	experiment_pub_zdb_id_foriegn_key_index