Table zfindb.informix.feature_marker_relationship 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
fmrel_zdb_id varchar 50
zdb_active_data.zactvd_zdb_id fmrel_zdb_id_foreign_key C
fmrel_type varchar 60
feature_marker_relationship_type.fmreltype_name fmrel_type_foreign_key R
fmrel_ftr_zdb_id varchar 50
feature.feature_zdb_id fmrel_ftr_zdb_id_foreign_key C
fmrel_mrkr_zdb_id varchar 50
zdb_active_data.zactvd_zdb_id fmrel_mrkr_zdb_id_foreign_key C

Table contained 69,527 rows at Tue Dec 20 09:53 PST 2016

Indexes:
Column(s) Type Sort Constraint Name
fmrel_ftr_zdb_id + fmrel_mrkr_zdb_id Must be unique Asc/Asc feature_marker_relationship_alternate_key_index
fmrel_zdb_id Must be unique Asc feature_marker_relationship_primary_key_index
fmrel_ftr_zdb_id Performance Asc fmrel_ftr_zdb_id_index
fmrel_mrkr_zdb_id Performance Asc fmrel_mrkr_zdb_id_index
fmrel_type Performance Asc fmrel_type_index

Close relationships  within of separation: