Table zfindb.informix.feature_marker_relationship_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
fmreltype_name varchar 60
feature_marker_relationship.fmrel_type fmrel_type_foreign_key R
genotype_component_significance.gcs_fmrel_type gcs_fmrel_type_foreign_key R
fmreltype_ftr_type_group varchar 30
feature_type_group.ftrgrp_name fmreltype_ftr_type_group_ftr_foreign_key R
fmreltype_mrkr_type_group varchar 20
marker_type_group.mtgrp_name fmreltype_ftr_type_group_mrkr_foreign_key R
fmreltype_1_to_2_comments varchar 255  √  null
fmreltype_2_to_1_comments varchar 255  √  null
fmreltype_produces_affected_marker boolean 1 f

Table contained 7 rows at Tue Dec 20 09:53 PST 2016

Indexes:
Column(s) Type Sort Constraint Name
fmreltype_produces_affected_marker + fmreltype_ftr_type_group Performance Asc/Asc feature_marker_relationship_type_ftr_group_index
fmreltype_produces_affected_marker + fmreltype_mrkr_type_group Performance Asc/Asc feature_marker_relationship_type_mrkr_group_index
fmreltype_produces_affected_marker + fmreltype_name Must be unique Asc/Asc feature_marker_relationship_type_primary_key_index

Close relationships  within of separation: