Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
|
||||
| contact_id | INT UNSIGNED | 10 | √ | null |
|
|
FK to Contact ID |
|||
| entity_id | INT UNSIGNED | 10 | null |
|
|
FK to id of the entity that the action was performed on. Pseudo - FK. |
||||
| entity_table | VARCHAR | 255 | √ | null |
|
|
name of the entity table for the above id, e.g. civicrm_activity, civicrm_participant |
|||
| action_schedule_id | INT UNSIGNED | 10 | null |
|
|
FK to the action schedule that this action originated from. |
||||
| action_date_time | DATETIME | 19 | √ | null |
|
|
date time that the action was performed on. |
|||
| is_error | TINYINT | 3 | √ | 0 |
|
|
Was there any error sending the reminder? |
|||
| message | TEXT | 65535 | √ | null |
|
|
Description / text in case there was an error encountered. |
|||
| repetition_number | INT UNSIGNED | 10 | √ | null |
|
|
Keeps track of the sequence number of this repetition. |
|||
| reference_date | DATETIME | 19 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| FK_civicrm_action_log_action_schedule_id | Performance | Asc | action_schedule_id |
| FK_civicrm_action_log_contact_id | Performance | Asc | contact_id |
Relationships
Close relationships within degrees of separation
