deal_company_association

213 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
deal_id varchar 8 null
crm_deals.id deal_company_association_deal_id_fkey R
company_id varchar 8 null
crm_companies.id deal_company_association_company_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
deal_company_association_pkey Primary key Asc/Asc deal_id + company_id
deal_company_association_company_id_deal_id_idx Performance Asc/Asc company_id + deal_id
deal_company_association_company_id_idx Performance Asc company_id
deal_company_association_deal_id_company_id_idx Performance Asc/Asc deal_id + company_id
deal_company_association_deal_id_idx Performance Asc deal_id

Relationships