Table zfindb.informix.marker_type_group 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
mtgrp_name varchar 60
feature_marker_relationship_type.fmreltype_mrkr_type_group fmreltype_ftr_type_group_mrkr_foreign_key R
marker_relationship_type.mreltype_mrkr_type_group_1 mreltype_mrkr_type_group_1_foreign_key R
marker_relationship_type.mreltype_mrkr_type_group_2 mreltype_mrkr_type_group_2_foreign_key R
marker_type_group_member.mtgrpmem_mrkr_type_group mtgrpmem_mrkr_type_group_foreign_key R
mtgrp_comments lvarchar 2048
mtgrp_searchable boolean 1  √  f
mtgrp_display_name varchar 80  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
mtgrp_comments + mtgrp_searchable + mtgrp_name Must be unique Asc/Asc/Asc marker_type_group_primary_key_index

Close relationships  within of separation: