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 <title>Action Schedule ID
</title>
12 <type>int unsigned
</type>
13 <required>true
</required>
18 <autoincrement>true
</autoincrement>
25 <comment>Name of the action(reminder)
</comment>
33 <comment>Title of the action(reminder)
</comment>
37 <name>recipient
</name>
40 <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>
73 <comment>Time units for reminder.
</comment>
75 <callback>CRM_Core_SelectValues::getScheduleReminderFrequencyUnits
</callback>
83 <name>start_action_condition
</name>
86 <comment>Reminder Action
</comment>
90 <name>start_action_date
</name>
93 <comment>Entity date
</comment>
97 <name>is_repeat
</name>
98 <title>Repeat?
</title>
104 <name>repetition_frequency_unit
</name>
107 <comment>Time units for repetition of reminder.
</comment>
109 <callback>CRM_Core_SelectValues::getScheduleReminderFrequencyUnits
</callback>
117 <name>repetition_frequency_interval
</name>
118 <type>int unsigned
</type>
119 <comment>Time interval for repeating the reminder.
</comment>
123 <name>end_frequency_unit
</name>
126 <comment>Time units till repetition of reminder.
</comment>
128 <callback>CRM_Core_SelectValues::getScheduleReminderFrequencyUnits
</callback>
136 <name>end_frequency_interval
</name>
137 <type>int unsigned
</type>
138 <comment>Time interval till repeating the reminder.
</comment>
142 <name>end_action
</name>
145 <comment>Reminder Action till repeating the reminder.
</comment>
149 <name>end_date
</name>
152 <comment>Entity end date
</comment>
156 <name>is_active
</name>
157 <title>Schedule is Active?
</title>
160 <comment>Is this option active?
</comment>
164 <name>recipient_manual
</name>
165 <title>Recipient Manual
</title>
168 <comment>Contact IDs to which reminder should be sent.
</comment>
172 <name>recipient_listing
</name>
173 <title>Recipient Listing
</title>
176 <comment>listing based on recipient field.
</comment>
180 <name>body_text
</name>
181 <title>Reminder Text
</title>
182 <type>longtext
</type>
183 <comment>Body of the mailing in text format.
</comment>
187 <name>body_html
</name>
188 <title>Reminder HTML
</title>
189 <type>longtext
</type>
190 <comment>Body of the mailing in html format.
</comment>
194 <name>sms_body_text
</name>
195 <title>SMS Reminder Text
</title>
196 <type>longtext
</type>
197 <comment>Content of the SMS text.
</comment>
202 <title>Reminder Subject
</title>
205 <comment>Subject of mailing
</comment>
209 <name>record_activity
</name>
210 <title>Record Activity for Reminder?
</title>
212 <default>NULL
</default>
213 <comment>Record Activity for this reminder?
</comment>
217 <name>mapping_id
</name>
218 <title>Reminder Mapping
</title>
219 <type>int unsigned
</type>
220 <comment>FK to mapping which is being used by this reminder
</comment>
224 <name>mapping_id
</name>
225 <table>civicrm_action_mapping
</table>
227 <onDelete>SET NULL
</onDelete>
230 <name>group_id
</name>
231 <title>Reminder Group
</title>
232 <type>int unsigned
</type>
233 <comment>FK to Group
</comment>
235 <table>civicrm_group
</table>
236 <keyColumn>id
</keyColumn>
237 <labelColumn>title
</labelColumn>
245 <name>group_id
</name>
246 <table>civicrm_group
</table>
248 <onDelete>SET NULL
</onDelete>
251 <name>msg_template_id
</name>
252 <title>Reminder Template
</title>
253 <type>int unsigned
</type>
254 <comment>FK to the message template.
</comment>
257 <name>msg_template_id
</name>
258 <table>civicrm_msg_template
</table>
260 <onDelete>SET NULL
</onDelete>
263 <name>sms_template_id
</name>
264 <title>SMS Reminder Template
</title>
265 <type>int unsigned
</type>
266 <comment>FK to the message template.
</comment>
269 <name>msg_template_id
</name>
270 <table>civicrm_msg_template
</table>
272 <onDelete>SET NULL
</onDelete>
275 <name>absolute_date
</name>
276 <title>Fixed Date for Reminder
</title>
278 <comment>Date on which the reminder be sent.
</comment>
282 <name>from_name
</name>
283 <title>Reminder from Name
</title>
286 <comment>Name in
"from" field
</comment>
290 <name>from_email
</name>
291 <title>Reminder From Email
</title>
294 <comment>Email address in
"from" field
</comment>
299 <title>Message Mode
</title>
300 <default>"Email"</default>
303 <comment>Send the message as email or sms or both.
</comment>
305 <optionGroupName>msg_mode
</optionGroupName>
313 <name>sms_provider_id
</name>
314 <title>SMS Provider
</title>
315 <type>int unsigned
</type>
322 <name>sms_provider_id
</name>
323 <table>civicrm_sms_provider
</table>
325 <onDelete>SET NULL
</onDelete>
329 <name>used_for
</name>
332 <comment>Used for repeating entity
</comment>