Table zfindb.informix.feature_group_member Generated by
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
fgm_group_id int8 19
fgm_member_name varchar 50  √  null
fgm_member_id varchar 50  √  null
fgm_genotype_id varchar 50  √  null
fgm_significance int 10  √  null
fgm_feature_type varchar 30  √  null
fgm_pk_id serial8 19  √ 

Table contained 391,336 rows at Thu Jun 22 08:42 PDT 2017

Column(s) Type Sort Constraint Name
fgm_genotype_id Performance Asc feature_group_member_genotype_id_index
fgm_group_id Performance Asc feature_group_member_group_id_index
fgm_member_id Performance Asc feature_group_member_id_index
fgm_pk_id Must be unique Asc feature_group_member_primary_key_index