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

Activity contact id

activity_id INT UNSIGNED 10 null FK_civicrm_activity_contact_activity_id C

Foreign key to the activity for this record.

contact_id INT UNSIGNED 10 null FK_civicrm_activity_contact_contact_id C

Foreign key to the contact for this record.

record_type_id INT UNSIGNED 10 null

Nature of this contact's role in the activity: 1 assignee, 2 creator, 3 focus or target.

Table contained 0 rows


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
index_record_type Performance Asc/Asc activity_id + record_type_id
UI_activity_contact Must be unique Asc/Asc/Asc contact_id + activity_id + record_type_id