Table zfindb.informix.linkage_pair_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
lpmem_linkage_zdb_id varchar 50
linkage_member.lnkgmem_linkage_zdb_id lpmem_linkage_member_foreign_key R
lpmem_member_zdb_id varchar 50
linkage_member.lnkgmem_member_zdb_id lpmem_linkage_member_foreign_key R
lpmem_linkage_pair_zdb_id varchar 50
linkage_pair.lnkgpair_zdb_id lpmem_linkage_pair_zdb_id_foreign_key C

Table contained 1,644 rows at Thu Jun 22 08:42 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
lpmem_linkage_zdb_id + lpmem_member_zdb_id + lpmem_linkage_pair_zdb_id Must be unique Asc/Asc/Asc linkage_pair_member_primary_key_index
lpmem_linkage_zdb_id + lpmem_member_zdb_id Performance Asc/Asc lpmem_linkage_member_index
lpmem_linkage_pair_zdb_id Performance Asc lpmem_linkage_pair_zdb_id_index

Close relationships  within of separation: