1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
5 <class>ActionSchedule
</class>
6 <name>civicrm_action_schedule
</name>
7 <comment>Table to store the reminders.
</comment>
11 <type>int unsigned
</type>
12 <required>true
</required>
17 <autoincrement>true
</autoincrement>
24 <comment>Name of the action(reminder)
</comment>
32 <comment>Title of the action(reminder)
</comment>
36 <name>recipient
</name>
39 <comment>Recipient
</comment>
46 <comment>Is this the recipient criteria limited to OR in addition to?
</comment>
50 <name>entity_value
</name>
53 <comment>Entity value
</comment>
57 <name>entity_status
</name>
60 <comment>Entity status
</comment>
64 <name>start_action_offset
</name>
65 <type>int unsigned
</type>
66 <comment>Reminder Interval.
</comment>
70 <name>start_action_unit
</name>
72 <values>hour,day,week,month,year
</values>
73 <comment>Time units for reminder.
</comment>
80 <name>start_action_condition
</name>
83 <comment>Reminder Action
</comment>
87 <name>start_action_date
</name>
90 <comment>Entity date
</comment>
94 <name>is_repeat
</name>
95 <title>Repeat?
</title>
101 <name>repetition_frequency_unit
</name>
103 <values>hour,day,week,month,year
</values>
104 <comment>Time units for repetition of reminder.
</comment>
111 <name>repetition_frequency_interval
</name>
112 <type>int unsigned
</type>
113 <comment>Time interval for repeating the reminder.
</comment>
117 <name>end_frequency_unit
</name>
119 <values>hour,day,week,month,year
</values>
120 <comment>Time units till repetition of reminder.
</comment>
127 <name>end_frequency_interval
</name>
128 <type>int unsigned
</type>
129 <comment>Time interval till repeating the reminder.
</comment>
133 <name>end_action
</name>
136 <comment>Reminder Action till repeating the reminder.
</comment>
140 <name>end_date
</name>
143 <comment>Entity end date
</comment>
147 <name>is_active
</name>
150 <comment>Is this option active?
</comment>
154 <name>recipient_manual
</name>
155 <title>Recipient Manual
</title>
158 <comment>Contact IDs to which reminder should be sent.
</comment>
162 <name>recipient_listing
</name>
163 <title>Recipient Listing
</title>
166 <comment>listing based on recipient field.
</comment>
170 <name>body_text
</name>
171 <type>longtext
</type>
172 <comment>Body of the mailing in text format.
</comment>
176 <name>body_html
</name>
177 <type>longtext
</type>
178 <comment>Body of the mailing in html format.
</comment>
185 <comment>Subject of mailing
</comment>
189 <name>record_activity
</name>
191 <default>NULL
</default>
192 <comment>Record Activity for this reminder?
</comment>
196 <name>mapping_id
</name>
197 <type>int unsigned
</type>
198 <comment>FK to mapping which is being used by this reminder
</comment>
202 <name>mapping_id
</name>
203 <table>civicrm_action_mapping
</table>
205 <onDelete>SET NULL
</onDelete>
208 <name>group_id
</name>
209 <type>int unsigned
</type>
210 <comment>FK to Group
</comment>
212 <table>civicrm_group
</table>
213 <keyColumn>id
</keyColumn>
214 <labelColumn>title
</labelColumn>
222 <name>group_id
</name>
223 <table>civicrm_group
</table>
225 <onDelete>SET NULL
</onDelete>
228 <name>msg_template_id
</name>
229 <type>int unsigned
</type>
230 <comment>FK to the message template.
</comment>
233 <name>msg_template_id
</name>
234 <table>civicrm_msg_template
</table>
236 <onDelete>SET NULL
</onDelete>
239 <name>absolute_date
</name>
241 <comment>Date on which the reminder be sent.
</comment>