civicrm_case_activity

0 rows


Columns

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

Unique case-activity association id

case_id INT UNSIGNED 10 null
civicrm_case.id FK_civicrm_case_activity_case_idC

Case ID of case-activity association.

activity_id INT UNSIGNED 10 null
civicrm_activity.id FK_civicrm_case_activity_activity_idC

Activity ID of case-activity association.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_case_activity_activity_id Performance Asc activity_id
UI_case_activity_id Performance Asc/Asc case_id + activity_id

Relationships