Table zfindb.public.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 text 2147483647
linkage_member.lnkgmem_linkage_zdb_id lpmem_linkage_member_foreign_key R
lpmem_member_zdb_id text 2147483647
linkage_member.lnkgmem_member_zdb_id lpmem_linkage_member_foreign_key R
lpmem_linkage_pair_zdb_id text 2147483647
linkage_pair.lnkgpair_zdb_id lpmem_linkage_pair_zdb_id_foreign_key C

Table contained 1,644 rows at Mon Sep 03 04:09 PDT 2018

Indexes:
Column(s) Type Sort Constraint Name
lpmem_linkage_zdb_id + lpmem_member_zdb_id + lpmem_linkage_pair_zdb_id Primary key Asc/Asc/Asc linkage_pair_member_primary_key
lpmem_linkage_pair_zdb_id Performance Asc lpmem_linkage_pair_zdb_id_index
lpmem_linkage_zdb_id Performance Asc lpmem_linkage_zdb_id_index
lpmem_member_zdb_id Performance Asc lpmem_member_zdb_id_index

Close relationships  within of separation: