Table d47civi_0z3xa.civicrm_action_log Generated by
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √ 
contact_id int unsigned 10  √  null FK_civicrm_action_log_contact_id C
FK to Contact ID
entity_id int unsigned 10 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 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 at mer. avr. 13 16:52 EDT 2016

Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
action_schedule_id Performance Asc FK_civicrm_action_log_action_schedule_id
contact_id Performance Asc FK_civicrm_action_log_contact_id

Close relationships  within of separation: