Table zfindb.informix.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 varchar 50
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
zdb_active_data.zactvd_zdb_id exp_zdb_id_foreign_key_odc C
exp_name varchar 255
exp_source_zdb_id varchar 50
zdb_active_source.zactvs_zdb_id exp_source_zdb_id_foreign_key_odc C

Table contained 14,329 rows at Tue Nov 10 13:18 PST 2015

Indexes:
Column(s) Type Sort Constraint Name
exp_name + exp_source_zdb_id Must be unique Asc/Asc experiment_alternate_key_index
exp_name Performance Asc experiment_name_index
exp_zdb_id Must be unique Asc experiment_primary_key_index
exp_source_zdb_id Performance Asc experiment_pub_zdb_id_foriegn_key_index

Close relationships  within of separation: