Table zfindb.informix.genotype_component_significance 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
gcs_pk_id serial8 19  √ 
gcs_mrkr_type varchar 10
marker_types.marker_type gcs_mrkr_type_foreign_key R
gcs_ftr_type varchar 30
feature_type.ftrtype_name gcs_ftr_type_foreign_key R
gcs_fmrel_type varchar 60
feature_marker_relationship_type.fmreltype_name gcs_fmrel_type_foreign_key R
gcs_significance int 10

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

Indexes:
Column(s) Type Sort Constraint Name
gcs_fmrel_type Performance Asc gcs_fmrel_type_index
gcs_ftr_type Performance Asc gcs_ftr_type_index
gcs_mrkr_type Performance Asc gcs_mrkr_type_index
gcs_mrkr_type + gcs_ftr_type + gcs_fmrel_type + gcs_significance Must be unique Asc/Asc/Asc/Asc gsc_alternate_key_index
gcs_pk_id Must be unique Asc gsc_primary_key_index

Close relationships  within of separation: