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

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

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 DATE 10 null

Stores the date from the entity which triggered this reminder action (e.g. membership.end_date for most membership renewal reminders)

Table contained 0 rows


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