contact_company_association

68730 rows


Columns

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

Indexes

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

Relationships