civicrm_case_contact - civicrm Database

Search:

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

FK_civicrm_case_contact_case_idC

Case ID of case-contact association.

contact_id

INT UNSIGNED

10

null

FK_civicrm_case_contact_contact_idC

Contact ID of contact record given case belongs to.

Showing 1 to 3 of 3 entries

Search:

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

Showing 1 to 3 of 3 entries