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>
21 <autoincrement>true
</autoincrement>
24 <name>contact_id
</name>
25 <title>Contact ID
</title>
26 <type>int unsigned
</type>
27 <comment>FK to Contact ID
</comment>
29 <label>Contact
</label>
34 <name>contact_id
</name>
35 <table>civicrm_contact
</table>
38 <onDelete>CASCADE
</onDelete>
41 <name>entity_id
</name>
42 <title>Entity ID
</title>
43 <type>int unsigned
</type>
44 <required>true
</required>
45 <comment>FK to id of the entity that the action was performed on. Pseudo - FK.
</comment>
49 <name>entity_table
</name>
51 <title>Entity Table
</title>
53 <comment>name of the entity table for the above id, e.g. civicrm_activity, civicrm_participant
</comment>
57 <idColumn>entity_id
</idColumn>
58 <typeColumn>entity_table
</typeColumn>
62 <name>action_schedule_id
</name>
63 <title>Schedule ID
</title>
64 <type>int unsigned
</type>
65 <required>true
</required>
66 <comment>FK to the action schedule that this action originated from.
</comment>
68 <label>Schedule
</label>
73 <name>action_schedule_id
</name>
74 <table>civicrm_action_schedule
</table>
77 <onDelete>CASCADE
</onDelete>
80 <name>action_date_time
</name>
81 <title>Action Date And Time
</title>
83 <comment>date time that the action was performed on.
</comment>
91 <comment>Was there any error sending the reminder?
</comment>
96 <title>Message
</title>
98 <comment>Description / text in case there was an error encountered.
</comment>
102 <name>repetition_number
</name>
103 <title>Repetition Number
</title>
104 <type>int unsigned
</type>
105 <comment>Keeps track of the sequence number of this repetition.
</comment>
109 <name>reference_date
</name>
110 <title>Reference Date
</title>
111 <type>datetime
</type>
112 <default>NULL
</default>
113 <comment>Stores the date from the entity which triggered this reminder action (e.g. membership.end_date for most membership renewal reminders)
</comment>
115 <change>5.17</change>