opportunities_contacts


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
contact_id CHAR 36 null
contacts.id Defined in XMLR
opportunity_id CHAR 36 null
opportunities.id Defined in XMLR
contact_role VARCHAR 50 null
date_modified DATETIME 26 null
deleted BIT 1 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_con_opp_con Performance Asc contact_id
idx_con_opp_opp Performance Asc opportunity_id
idx_del_opp_con Performance Asc/Asc/Asc deleted + opportunity_id + contact_id
idx_opportunities_contacts Performance Asc/Asc opportunity_id + contact_id

Relationships