civicrm_case_activity


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_id C

Case ID of case-activity association.

activity_id INT UNSIGNED 10 null
civicrm_activity.id FK_civicrm_case_activity_activity_id C

Activity ID of case-activity association.

Table contained 0 rows

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