Table zfindb.informix.condition_data_type 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
cdt_zdb_id varchar 50
experiment_condition_restricted.ecr_cdt_zdb_id experiment_condition_restricted_cdt_foreign_key R
zdb_active_data.zactvd_zdb_id condition_data_type_zdb_active_data_foreign_key C
cdt_name varchar 100
cdt_group varchar 100
condition.condition_group condition_data_type_cdt_group_foreign_key C
cdt_significance int 10

Table contained 65 rows at Thu Jun 22 08:42 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
cdt_name + cdt_group Must be unique Asc/Asc condition_data_type_alternate_key_index
cdt_group Performance Asc condition_data_type_group_foreign_key_index
cdt_zdb_id Must be unique Asc condition_data_type_primary_key_index

Close relationships  within of separation: