ps-enterprise
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
deal_contact_association
1 008
rows
Columns
Related columns
Constraint
Comments
Search:
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
deal_id
varchar
8
null
crm_deals
.id
deal_contact_association_deal_id_fkey
R
contact_id
varchar
8
null
crm_contacts
.id
deal_contact_association_contact_id_fkey
R
Showing 1 to 2 of 2 entries
Previous
1
Next
Indexes
Search:
Constraint Name
Type
Sort
Column(s)
deal_contact_association_pkey
Primary key
Asc
/
Asc
deal_id + contact_id
deal_contact_association_contact_id_deal_id_idx
Performance
Asc
/
Asc
contact_id + deal_id
deal_contact_association_contact_id_idx
Performance
Asc
contact_id
deal_contact_association_deal_id_contact_id_idx
Performance
Asc
/
Asc
deal_id + contact_id
deal_contact_association_deal_id_idx
Performance
Asc
deal_id
Showing 1 to 5 of 5 entries
Previous
1
Next
Relationships
Close relationships within degrees of separation
One
Two degrees
One implied
Two implied