Table zfindb.public.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
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

Close relationships  within of separation: