Table zfindb.informix.term_group_member 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
tgm_pk_id serial8 19  √ 
tgm_group_id int8 19
tgm_member_name varchar 50  √  null
tgm_member_id varchar 50

Table contained 904,733 rows at Tue Nov 10 13:18 PST 2015

Indexes:
Column(s) Type Sort Constraint Name
tgm_group_id Performance Asc term_group_member_group_id_index
tgm_member_id Performance Asc term_group_member_id_index
tgm_pk_id Must be unique Asc term_group_member_primary_key_index