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>
54 <serialize>SEPARATOR_TRIMMED
</serialize>
58 <name>entity_status
</name>
61 <comment>Entity status
</comment>
62 <serialize>SEPARATOR_TRIMMED
</serialize>
66 <name>start_action_offset
</name>
67 <type>int unsigned
</type>
68 <comment>Reminder Interval.
</comment>
73 <name>start_action_unit
</name>
76 <comment>Time units for reminder.
</comment>
78 <callback>CRM_Core_SelectValues::getRecurringFrequencyUnits
</callback>
86 <name>start_action_condition
</name>
89 <comment>Reminder Action
</comment>
93 <name>start_action_date
</name>
96 <comment>Entity date
</comment>
100 <name>is_repeat
</name>
101 <title>Repeat?
</title>
107 <name>repetition_frequency_unit
</name>
110 <comment>Time units for repetition of reminder.
</comment>
112 <callback>CRM_Core_SelectValues::getRecurringFrequencyUnits
</callback>
120 <name>repetition_frequency_interval
</name>
121 <type>int unsigned
</type>
123 <comment>Time interval for repeating the reminder.
</comment>
127 <name>end_frequency_unit
</name>
130 <comment>Time units till repetition of reminder.
</comment>
132 <callback>CRM_Core_SelectValues::getRecurringFrequencyUnits
</callback>
140 <name>end_frequency_interval
</name>
141 <type>int unsigned
</type>
142 <comment>Time interval till repeating the reminder.
</comment>
147 <name>end_action
</name>
150 <comment>Reminder Action till repeating the reminder.
</comment>
154 <name>end_date
</name>
157 <comment>Entity end date
</comment>
161 <name>is_active
</name>
162 <title>Schedule is Active?
</title>
165 <comment>Is this option active?
</comment>
169 <name>recipient_manual
</name>
170 <title>Recipient Manual
</title>
173 <comment>Contact IDs to which reminder should be sent.
</comment>
174 <serialize>COMMA
</serialize>
178 <name>recipient_listing
</name>
179 <title>Recipient Listing
</title>
182 <comment>listing based on recipient field.
</comment>
186 <name>body_text
</name>
187 <title>Reminder Text
</title>
188 <type>longtext
</type>
189 <comment>Body of the mailing in text format.
</comment>
193 <name>body_html
</name>
194 <title>Reminder HTML
</title>
195 <type>longtext
</type>
196 <comment>Body of the mailing in html format.
</comment>
200 <name>sms_body_text
</name>
201 <title>SMS Reminder Text
</title>
202 <type>longtext
</type>
203 <comment>Content of the SMS text.
</comment>
208 <title>Reminder Subject
</title>
211 <comment>Subject of mailing
</comment>
215 <name>record_activity
</name>
216 <title>Record Activity for Reminder?
</title>
218 <default>NULL
</default>
219 <comment>Record Activity for this reminder?
</comment>
223 <name>mapping_id
</name>
224 <title>Reminder Mapping
</title>
227 <comment>Name/ID of the mapping to use on this table
</comment>
231 <name>group_id
</name>
232 <title>Reminder Group
</title>
233 <type>int unsigned
</type>
234 <comment>FK to Group
</comment>
236 <table>civicrm_group
</table>
237 <keyColumn>id
</keyColumn>
238 <labelColumn>title
</labelColumn>
246 <name>group_id
</name>
247 <table>civicrm_group
</table>
249 <onDelete>SET NULL
</onDelete>
252 <name>msg_template_id
</name>
253 <title>Reminder Template
</title>
254 <type>int unsigned
</type>
255 <comment>FK to the message template.
</comment>
258 <name>msg_template_id
</name>
259 <table>civicrm_msg_template
</table>
261 <onDelete>SET NULL
</onDelete>
264 <name>sms_template_id
</name>
265 <title>SMS Reminder Template
</title>
266 <type>int unsigned
</type>
267 <comment>FK to the message template.
</comment>
270 <name>sms_template_id
</name>
271 <table>civicrm_msg_template
</table>
273 <onDelete>SET NULL
</onDelete>
276 <name>absolute_date
</name>
277 <title>Fixed Date for Reminder
</title>
279 <comment>Date on which the reminder be sent.
</comment>
283 <name>from_name
</name>
284 <title>Reminder from Name
</title>
287 <comment>Name in
"from" field
</comment>
291 <name>from_email
</name>
292 <title>Reminder From Email
</title>
295 <comment>Email address in
"from" field
</comment>
300 <title>Message Mode
</title>
301 <default>"Email"</default>
304 <comment>Send the message as email or sms or both.
</comment>
306 <optionGroupName>msg_mode
</optionGroupName>
314 <name>sms_provider_id
</name>
315 <title>SMS Provider
</title>
316 <type>int unsigned
</type>
323 <name>sms_provider_id
</name>
324 <table>civicrm_sms_provider
</table>
326 <onDelete>SET NULL
</onDelete>
330 <name>used_for
</name>
333 <comment>Used for repeating entity
</comment>
337 <name>filter_contact_language
</name>
340 <comment>Used for multilingual installation
</comment>
344 <name>communication_language
</name>
347 <comment>Used for multilingual installation
</comment>
351 <name>created_date
</name>
352 <title>Created Date
</title>
353 <uniqueName>action_schedule_created_date
</uniqueName>
354 <type>timestamp
</type>
355 <comment>When was the scheduled reminder created.
</comment>
356 <required>false
</required>
357 <export>true
</export>
358 <default>CURRENT_TIMESTAMP
</default>
362 <name>modified_date
</name>
363 <type>timestamp
</type>
364 <comment>When the reminder was created or modified.
</comment>
365 <required>false
</required>
366 <default>CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
</default>
370 <name>effective_start_date
</name>
371 <title>Effective start date
</title>
372 <uniqueName>action_schedule_effective_start_date
</uniqueName>
373 <type>timestamp
</type>
374 <comment>Earliest date to consider start events from.
</comment>
375 <required>false
</required>
376 <export>true
</export>
380 <name>effective_end_date
</name>
381 <title>Effective end date
</title>
382 <uniqueName>action_schedule_effective_end_date
</uniqueName>
383 <type>timestamp
</type>
384 <comment>Latest date to consider end events from.
</comment>
385 <required>false
</required>
386 <export>true
</export>