civicrm_activity_contact

0 rows


Columns

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

Activity contact id

activity_id INT UNSIGNED 10 null
civicrm_activity.id FK_civicrm_activity_contact_activity_idC

Foreign key to the activity for this record.

contact_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_activity_contact_contact_idC

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.

Indexes

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

Relationships