ps-enterprise
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
contact_company_association
68 730
rows
Columns
Related columns
Constraint
Comments
Search:
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
contact_id
varchar
8
null
crm_contacts
.id
contact_company_association_contact_id_fkey
R
company_id
varchar
8
null
crm_companies
.id
contact_company_association_company_id_fkey
R
Showing 1 to 2 of 2 entries
Previous
1
Next
Indexes
Search:
Constraint Name
Type
Sort
Column(s)
contact_company_association_pkey
Primary key
Asc
/
Asc
contact_id + company_id
contact_company_association_company_id_contact_id_idx
Performance
Asc
/
Asc
company_id + contact_id
contact_company_association_company_id_idx
Performance
Asc
company_id
contact_company_association_contact_id_company_id_idx
Performance
Asc
/
Asc
contact_id + company_id
contact_company_association_contact_id_idx
Performance
Asc
contact_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