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 <type>int unsigned
</type>
12 <required>true
</required>
17 <autoincrement>true
</autoincrement>
20 <name>contact_id
</name>
21 <type>int unsigned
</type>
22 <comment>FK to Contact ID
</comment>
26 <name>contact_id
</name>
27 <table>civicrm_contact
</table>
30 <onDelete>CASCADE
</onDelete>
33 <name>entity_id
</name>
34 <type>int unsigned
</type>
35 <required>true
</required>
36 <comment>FK to id of the entity that the action was performed on. Pseudo - FK.
</comment>
40 <name>entity_table
</name>
43 <comment>name of the entity table for the above id, e.g. civicrm_activity, civicrm_participant
</comment>
47 <idColumn>entity_id
</idColumn>
48 <typeColumn>entity_table
</typeColumn>
52 <name>action_schedule_id
</name>
53 <type>int unsigned
</type>
54 <required>true
</required>
55 <comment>FK to the action schedule that this action originated from.
</comment>
59 <name>action_schedule_id
</name>
60 <table>civicrm_action_schedule
</table>
63 <onDelete>CASCADE
</onDelete>
66 <name>action_date_time
</name>
68 <comment>date time that the action was performed on.
</comment>
75 <comment>Was there any error sending the reminder?
</comment>
81 <comment>Description / text in case there was an error encountered.
</comment>
85 <name>repetition_number
</name>
86 <type>int unsigned
</type>
87 <comment>Keeps track of the sequence number of this repetition.
</comment>