1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
5 <class>ActionLog
</class>
6 <name>civicrm_action_log
</name>
7 <comment>Table to store log for the reminder.
</comment>
11 <title>Action Schedule ID
</title>
12 <type>int unsigned
</type>
13 <required>true
</required>
18 <autoincrement>true
</autoincrement>
21 <name>contact_id
</name>
22 <title>Action Schedule Contact ID
</title>
23 <type>int unsigned
</type>
24 <comment>FK to Contact ID
</comment>
28 <name>contact_id
</name>
29 <table>civicrm_contact
</table>
32 <onDelete>CASCADE
</onDelete>
35 <name>entity_id
</name>
36 <title>Entity ID
</title>
37 <type>int unsigned
</type>
38 <required>true
</required>
39 <comment>FK to id of the entity that the action was performed on. Pseudo - FK.
</comment>
43 <name>entity_table
</name>
45 <title>Entity Table
</title>
47 <comment>name of the entity table for the above id, e.g. civicrm_activity, civicrm_participant
</comment>
51 <idColumn>entity_id
</idColumn>
52 <typeColumn>entity_table
</typeColumn>
56 <name>action_schedule_id
</name>
57 <title>Schedule
</title>
58 <type>int unsigned
</type>
59 <required>true
</required>
60 <comment>FK to the action schedule that this action originated from.
</comment>
64 <name>action_schedule_id
</name>
65 <table>civicrm_action_schedule
</table>
68 <onDelete>CASCADE
</onDelete>
71 <name>action_date_time
</name>
72 <title>Action Date And Time
</title>
74 <comment>date time that the action was performed on.
</comment>
82 <comment>Was there any error sending the reminder?
</comment>
87 <title>Message
</title>
89 <comment>Description / text in case there was an error encountered.
</comment>
93 <name>repetition_number
</name>
94 <title>Repetition Number
</title>
95 <type>int unsigned
</type>
96 <comment>Keeps track of the sequence number of this repetition.
</comment>
100 <name>reference_date
</name>
101 <title>Reference Date
</title>
102 <type>datetime
</type>
103 <default>NULL
</default>
104 <comment>Stores the date from the entity which triggered this reminder action (e.g. membership.end_date for most membership renewal reminders)
</comment>
106 <change>5.17</change>