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