civicrm_case_contact


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null

Unique case-contact association id

case_id INT UNSIGNED 10 null
civicrm_case.id FK_civicrm_case_contact_case_id C

Case ID of case-contact association.

contact_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_case_contact_contact_id C

Contact ID of contact record given case belongs to.

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_case_contact_contact_id Performance Asc contact_id
UI_case_contact_id Must be unique Asc/Asc case_id + contact_id

Relationships