Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
|
Activity contact id |
|||
| activity_id | INT UNSIGNED | 10 | null |
|
|
Foreign key to the activity for this record. |
||||
| contact_id | INT UNSIGNED | 10 | null |
|
|
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
Close relationships within degrees of separation
