1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
4 <base>CRM/Mailing
</base>
6 <name>civicrm_mailing
</name>
7 <comment>Stores information about a mailing.
</comment>
8 <archive>true
</archive>
9 <icon>fa-envelope-o
</icon>
10 <component>CiviMail
</component>
12 <add>civicrm/a/#/mailing/new
</add>
13 <update>civicrm/a/#/mailing/[id]
</update>
17 <title>Mailing ID
</title>
18 <type>int unsigned
</type>
19 <required>true
</required>
23 <autoincrement>true
</autoincrement>
26 <name>domain_id
</name>
27 <title>Mailing Domain
</title>
28 <type>int unsigned
</type>
30 <table>civicrm_domain
</table>
31 <keyColumn>id
</keyColumn>
32 <labelColumn>name
</labelColumn>
34 <comment>Which site is this mailing for
</comment>
38 <name>domain_id
</name>
39 <table>civicrm_domain
</table>
41 <onDelete>SET NULL
</onDelete>
45 <name>header_id
</name>
46 <title>Mailing Header
</title>
47 <type>int unsigned
</type>
49 <table>civicrm_mailing_component
</table>
50 <keyColumn>id
</keyColumn>
51 <labelColumn>name
</labelColumn>
52 <condition>component_type =
"Header"</condition>
54 <comment>FK to the header component.
</comment>
57 <name>header_id
</name>
58 <table>civicrm_mailing_component
</table>
60 <onDelete>SET NULL
</onDelete>
63 <name>footer_id
</name>
64 <title>Mailing Footer
</title>
65 <type>int unsigned
</type>
67 <table>civicrm_mailing_component
</table>
68 <keyColumn>id
</keyColumn>
69 <labelColumn>name
</labelColumn>
70 <condition>component_type =
"Footer"</condition>
72 <comment>FK to the footer component.
</comment>
75 <name>footer_id
</name>
76 <table>civicrm_mailing_component
</table>
78 <onDelete>SET NULL
</onDelete>
82 <title>Mailing Reply
</title>
83 <type>int unsigned
</type>
84 <comment>FK to the auto-responder component.
</comment>
88 <table>civicrm_mailing_component
</table>
90 <onDelete>SET NULL
</onDelete>
93 <name>unsubscribe_id
</name>
94 <title>Mailing Unsubscribe
</title>
95 <type>int unsigned
</type>
96 <comment>FK to the unsubscribe component.
</comment>
99 <name>unsubscribe_id
</name>
100 <table>civicrm_mailing_component
</table>
102 <onDelete>SET NULL
</onDelete>
105 <name>resubscribe_id
</name>
106 <title>Mailing Resubscribe
</title>
107 <type>int unsigned
</type>
110 <name>optout_id
</name>
111 <table>civicrm_mailing_component
</table>
113 <onDelete>SET NULL
</onDelete>
116 <name>optout_id
</name>
117 <title>Mailing Opt Out
</title>
118 <type>int unsigned
</type>
119 <comment>FK to the opt-out component.
</comment>
122 <name>optout_id
</name>
123 <table>civicrm_mailing_component
</table>
125 <onDelete>SET NULL
</onDelete>
129 <uniqueName>mailing_name
</uniqueName>
130 <title>Mailing Name
</title>
133 <comment>Mailing Name.
</comment>
139 <name>mailing_type
</name>
141 <title>Mailing Type
</title>
143 <comment>differentiate between standalone mailings, A/B tests, and A/B final-winner
</comment>
145 <callback>CRM_Mailing_PseudoConstant::mailingTypes
</callback>
153 <name>from_name
</name>
154 <title>Mailing From Name
</title>
157 <comment>From Header of mailing
</comment>
163 <name>from_email
</name>
164 <title>Mailing From Email
</title>
167 <comment>From Email of mailing
</comment>
173 <name>replyto_email
</name>
176 <comment>Reply-To Email of mailing
</comment>
182 <name>template_type
</name>
183 <title>Template Type
</title>
186 <default>'traditional'
</default>
187 <required>true
</required>
188 <comment>The language/processing system used for email templates.
</comment>
190 <callback>CRM_Mailing_BAO_Mailing::getTemplateTypeNames
</callback>
194 <name>template_options
</name>
195 <title>Template Options (JSON)
</title>
196 <type>longtext
</type>
197 <comment>Advanced options used by the email templating system. (JSON encoded)
</comment>
203 <comment>Subject of mailing
</comment>
209 <name>body_text
</name>
210 <type>longtext
</type>
211 <comment>Body of the mailing in text format.
</comment>
214 <name>body_html
</name>
215 <type>longtext
</type>
216 <comment>Body of the mailing in html format.
</comment>
219 <name>url_tracking
</name>
221 <comment>Should we track URL click-throughs for this mailing?
</comment>
223 <type>CheckBox
</type>
227 <name>forward_replies
</name>
229 <comment>Should we forward replies back to the author?
</comment>
231 <type>CheckBox
</type>
235 <name>auto_responder
</name>
237 <comment>Should we enable the auto-responder?
</comment>
239 <type>CheckBox
</type>
243 <name>open_tracking
</name>
244 <title>Track Mailing?
</title>
246 <comment>Should we track when recipients open/read this mailing?
</comment>
249 <name>is_completed
</name>
250 <title>Mailing Completed
</title>
252 <comment>Has at least one job associated with this mailing finished?
</comment>
254 <type>CheckBox
</type>
258 <name>msg_template_id
</name>
259 <title>Mailing Message Template
</title>
260 <type>int unsigned
</type>
261 <comment>FK to the message template.
</comment>
264 <name>msg_template_id
</name>
265 <table>civicrm_msg_template
</table>
267 <onDelete>SET NULL
</onDelete>
270 <name>override_verp
</name>
274 <comment>Overwrite the VERP address in Reply-To
</comment>
276 <type>CheckBox
</type>
280 <name>created_id
</name>
281 <title>Mailing Creator
</title>
282 <type>int unsigned
</type>
283 <comment>FK to Contact ID who first created this mailing
</comment>
286 <name>created_id
</name>
287 <table>civicrm_contact
</table>
289 <onDelete>SET NULL
</onDelete>
292 <name>created_date
</name>
293 <type>timestamp
</type>
294 <default>NULL
</default>
295 <required>false
</required>
296 <title>Mailing Created Date
</title>
297 <comment>Date and time this mailing was created.
</comment>
300 <type>Select Date
</type>
301 <formatType>activityDateTime
</formatType>
305 <name>modified_date
</name>
306 <uniqueName>mailing_modified_date
</uniqueName>
307 <type>timestamp
</type>
308 <comment>When the mailing (or closely related entity) was created or modified or deleted.
</comment>
309 <required>false
</required>
310 <export>true
</export>
311 <default>CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
</default>
315 <name>scheduled_id
</name>
316 <title>Scheduled By
</title>
317 <type>int unsigned
</type>
318 <comment>FK to Contact ID who scheduled this mailing
</comment>
321 <name>scheduled_id
</name>
322 <table>civicrm_contact
</table>
324 <onDelete>SET NULL
</onDelete>
327 <name>scheduled_date
</name>
328 <type>timestamp
</type>
329 <default>NULL
</default>
330 <required>false
</required>
331 <title>Mailing Scheduled Date
</title>
332 <comment>Date and time this mailing was scheduled.
</comment>
335 <type>Select Date
</type>
336 <formatType>activityDateTime
</formatType>
340 <name>approver_id
</name>
341 <title>Approved By
</title>
342 <type>int unsigned
</type>
343 <comment>FK to Contact ID who approved this mailing
</comment>
346 <name>approver_id
</name>
347 <table>civicrm_contact
</table>
349 <onDelete>SET NULL
</onDelete>
352 <name>approval_date
</name>
353 <type>timestamp
</type>
354 <default>NULL
</default>
355 <required>false
</required>
356 <title>Mailing Approved Date
</title>
357 <comment>Date and time this mailing was approved.
</comment>
360 <type>Select Date
</type>
361 <formatType>activityDateTime
</formatType>
365 <name>approval_status_id
</name>
366 <type>int unsigned
</type>
367 <title>Approval Status
</title>
368 <comment>The status of this mailing. Values: none, approved, rejected
</comment>
370 <optionGroupName>mail_approval_status
</optionGroupName>
378 <name>approval_note
</name>
379 <type>longtext
</type>
380 <title>Approval Note
</title>
381 <comment>Note behind the decision.
</comment>
384 <type>TextArea
</type>
388 <name>is_archived
</name>
390 <title>Is Mailing Archived?
</title>
392 <comment>Is this mailing archived?
</comment>
394 <type>CheckBox
</type>
399 <name>visibility
</name>
401 <title>Mailing Visibility
</title>
403 <default>'Public Pages'
</default>
404 <comment>In what context(s) is the mailing contents visible (online viewing)
</comment>
406 <callback>CRM_Core_SelectValues::groupVisibility
</callback>
414 <name>campaign_id
</name>
415 <type>int unsigned
</type>
416 <title>Mailing Campaign
</title>
417 <comment>The campaign for which this mailing has been initiated.
</comment>
419 <table>civicrm_campaign
</table>
420 <keyColumn>id
</keyColumn>
421 <labelColumn>title
</labelColumn>
429 <name>campaign_id
</name>
430 <table>civicrm_campaign
</table>
432 <onDelete>SET NULL
</onDelete>
435 <name>dedupe_email
</name>
437 <title>No Duplicate emails?
</title>
440 <comment>Remove duplicate emails?
</comment>
442 <type>CheckBox
</type>
446 <name>sms_provider_id
</name>
447 <title>Mailing SMS Provider
</title>
448 <type>int unsigned
</type>
455 <name>sms_provider_id
</name>
456 <table>civicrm_sms_provider
</table>
458 <onDelete>SET NULL
</onDelete>
463 <title>Mailing Hash
</title>
466 <comment>Key for validating requests related to this mailing.
</comment>
470 <name>index_hash
</name>
471 <fieldName>hash
</fieldName>
475 <name>location_type_id
</name>
476 <title>Location Type
</title>
477 <type>int unsigned
</type>
478 <comment>With email_selection_method, determines which email address to use
</comment>
480 <table>civicrm_location_type
</table>
481 <keyColumn>id
</keyColumn>
482 <labelColumn>display_name
</labelColumn>
487 <name>location_type_id
</name>
488 <table>civicrm_location_type
</table>
490 <onDelete>SET NULL
</onDelete>
494 <name>email_selection_method
</name>
497 <default>'automatic'
</default>
498 <comment>With location_type_id, determine how to choose the email address to use.
</comment>
500 <callback>CRM_Core_SelectValues::emailSelectMethods
</callback>
505 <name>language
</name>
506 <title>Mailing Language
</title>
509 <comment>Language of the content of the mailing. Useful for tokens.
</comment>
512 <optionGroupName>languages
</optionGroupName>
513 <keyColumn>name
</keyColumn>