xml/schema/Mailing/Mailing.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4   <base>CRM/Mailing</base>
   5   <class>Mailing</class>
   6   <name>civicrm_mailing</name>
   7   <comment>Stores information about a mailing.</comment>
   8   <archive>true</archive>
   9   <field>
  10     <name>id</name>
  11     <title>Mailing ID</title>
  12     <type>int unsigned</type>
  13     <required>true</required>
  14   </field>
  15   <primaryKey>
  16     <name>id</name>
  17     <autoincrement>true</autoincrement>
  18   </primaryKey>
  19   <field>
  20     <name>domain_id</name>
  21     <title>Mailing Domain</title>
  22     <type>int unsigned</type>
  23     <pseudoconstant>
  24       <table>civicrm_domain</table>
  25       <keyColumn>id</keyColumn>
  26       <labelColumn>name</labelColumn>
  27     </pseudoconstant>
  28     <comment>Which site is this mailing for</comment>
  29     <add>3.4</add>
  30   </field>
  31   <foreignKey>
  32     <name>domain_id</name>
  33     <table>civicrm_domain</table>
  34     <key>id</key>
  35     <onDelete>SET NULL</onDelete>
  36     <add>3.4</add>
  37   </foreignKey>
  38   <field>
  39     <name>header_id</name>
  40     <title>Mailing Header</title>
  41     <type>int unsigned</type>
  42     <comment>FK to the header component.</comment>
  43   </field>
  44   <foreignKey>
  45     <name>header_id</name>
  46     <table>civicrm_mailing_component</table>
  47     <key>id</key>
  48     <onDelete>SET NULL</onDelete>
  49   </foreignKey>
  50   <field>
  51     <name>footer_id</name>
  52     <title>Mailing Footer</title>
  53     <type>int unsigned</type>
  54     <comment>FK to the footer component.</comment>
  55   </field>
  56   <foreignKey>
  57     <name>footer_id</name>
  58     <table>civicrm_mailing_component</table>
  59     <key>id</key>
  60     <onDelete>SET NULL</onDelete>
  61   </foreignKey>
  62   <field>
  63     <name>reply_id</name>
  64     <title>Mailing Reply</title>
  65     <type>int unsigned</type>
  66     <comment>FK to the auto-responder component.</comment>
  67   </field>
  68   <foreignKey>
  69     <name>reply_id</name>
  70     <table>civicrm_mailing_component</table>
  71     <key>id</key>
  72     <onDelete>SET NULL</onDelete>
  73   </foreignKey>
  74   <field>
  75     <name>unsubscribe_id</name>
  76     <title>Mailing Unsubscribe</title>
  77     <type>int unsigned</type>
  78     <comment>FK to the unsubscribe component.</comment>
  79   </field>
  80   <foreignKey>
  81     <name>unsubscribe_id</name>
  82     <table>civicrm_mailing_component</table>
  83     <key>id</key>
  84     <onDelete>SET NULL</onDelete>
  85   </foreignKey>
  86   <field>
  87     <name>resubscribe_id</name>
  88     <title>Mailing Resubscribe</title>
  89     <type>int unsigned</type>
  90   </field>
  91   <foreignKey>
  92     <name>optout_id</name>
  93     <table>civicrm_mailing_component</table>
  94     <key>id</key>
  95     <onDelete>SET NULL</onDelete>
  96   </foreignKey>
  97   <field>
  98     <name>optout_id</name>
  99     <title>Mailing Opt Out</title>
 100     <type>int unsigned</type>
 101     <comment>FK to the opt-out component.</comment>
 102   </field>
 103   <foreignKey>
 104     <name>optout_id</name>
 105     <table>civicrm_mailing_component</table>
 106     <key>id</key>
 107     <onDelete>SET NULL</onDelete>
 108   </foreignKey>
 109   <field>
 110     <name>name</name>
 111     <title>Mailing Name</title>
 112     <type>varchar</type>
 113     <length>128</length>
 114     <comment>Mailing Name.</comment>
 115     <html>
 116       <type>Text</type>
 117     </html>
 118   </field>
 119   <field>
 120     <name>from_name</name>
 121     <title>Mailing From Name</title>
 122     <type>varchar</type>
 123     <length>128</length>
 124     <comment>From Header of mailing</comment>
 125     <html>
 126       <type>Text</type>
 127     </html>
 128   </field>
 129   <field>
 130     <name>from_email</name>
 131     <title>Mailing From Email</title>
 132     <type>varchar</type>
 133     <length>128</length>
 134     <comment>From Email of mailing</comment>
 135     <html>
 136       <type>Text</type>
 137     </html>
 138   </field>
 139   <field>
 140     <name>replyto_email</name>
 141     <type>varchar</type>
 142     <length>128</length>
 143     <comment>Reply-To Email of mailing</comment>
 144     <html>
 145       <type>Text</type>
 146     </html>
 147   </field>
 148   <field>
 149     <name>subject</name>
 150     <type>varchar</type>
 151     <length>128</length>
 152     <comment>Subject of mailing</comment>
 153     <html>
 154       <type>Text</type>
 155     </html>
 156   </field>
 157   <field>
 158     <name>body_text</name>
 159     <type>longtext</type>
 160     <comment>Body of the mailing in text format.</comment>
 161   </field>
 162   <field>
 163     <name>body_html</name>
 164     <type>longtext</type>
 165     <comment>Body of the mailing in html format.</comment>
 166   </field>
 167   <field>
 168     <name>url_tracking</name>
 169     <type>boolean</type>
 170     <comment>Should we track URL click-throughs for this mailing?</comment>
 171     <html>
 172       <type>CheckBox</type>
 173     </html>
 174   </field>
 175   <field>
 176     <name>forward_replies</name>
 177     <type>boolean</type>
 178     <comment>Should we forward replies back to the author?</comment>
 179     <html>
 180       <type>CheckBox</type>
 181     </html>
 182   </field>
 183   <field>
 184     <name>auto_responder</name>
 185     <type>boolean</type>
 186     <comment>Should we enable the auto-responder?</comment>
 187     <html>
 188       <type>CheckBox</type>
 189     </html>
 190   </field>
 191   <field>
 192     <name>open_tracking</name>
 193     <type>boolean</type>
 194     <comment>Should we track when recipients open/read this mailing?</comment>
 195   </field>
 196   <field>
 197     <name>is_completed</name>
 198     <type>boolean</type>
 199     <comment>Has at least one job associated with this mailing finished?</comment>
 200     <html>
 201       <type>CheckBox</type>
 202     </html>
 203   </field>
 204   <field>
 205     <name>msg_template_id</name>
 206     <type>int unsigned</type>
 207     <comment>FK to the message template.</comment>
 208   </field>
 209   <foreignKey>
 210     <name>msg_template_id</name>
 211     <table>civicrm_msg_template</table>
 212     <key>id</key>
 213     <onDelete>SET NULL</onDelete>
 214   </foreignKey>
 215   <field>
 216     <name>override_verp</name>
 217     <type>boolean</type>
 218     <default>0</default>
 219     <add>2.2</add>
 220     <comment>Should we overrite VERP address in Reply-To</comment>
 221     <html>
 222       <type>CheckBox</type>
 223     </html>
 224   </field>
 225   <field>
 226     <name>created_id</name>
 227     <type>int unsigned</type>
 228     <comment>FK to Contact ID who first created this mailing</comment>
 229   </field>
 230   <foreignKey>
 231     <name>created_id</name>
 232     <table>civicrm_contact</table>
 233     <key>id</key>
 234     <onDelete>SET NULL</onDelete>
 235   </foreignKey>
 236   <field>
 237     <name>created_date</name>
 238     <type>datetime</type>
 239     <title>Mailing Created Date</title>
 240     <comment>Date and time this mailing was created.</comment>
 241     <add>3.0</add>
 242     <html>
 243       <type>Select Date</type>
 244     </html>
 245   </field>
 246   <field>
 247     <name>scheduled_id</name>
 248     <type>int unsigned</type>
 249     <comment>FK to Contact ID who scheduled this mailing</comment>
 250   </field>
 251   <foreignKey>
 252     <name>scheduled_id</name>
 253     <table>civicrm_contact</table>
 254     <key>id</key>
 255     <onDelete>SET NULL</onDelete>
 256   </foreignKey>
 257   <field>
 258     <name>scheduled_date</name>
 259     <type>datetime</type>
 260     <title>Mailing Scheduled Date</title>
 261     <comment>Date and time this mailing was scheduled.</comment>
 262     <add>3.3</add>
 263   </field>
 264   <field>
 265     <name>approver_id</name>
 266     <type>int unsigned</type>
 267     <comment>FK to Contact ID who approved this mailing</comment>
 268   </field>
 269   <foreignKey>
 270     <name>approver_id</name>
 271     <table>civicrm_contact</table>
 272     <key>id</key>
 273     <onDelete>SET NULL</onDelete>
 274   </foreignKey>
 275   <field>
 276     <name>approval_date</name>
 277     <type>datetime</type>
 278     <title>Mailing Approved Date</title>
 279     <comment>Date and time this mailing was approved.</comment>
 280     <add>3.3</add>
 281   </field>
 282   <field>
 283     <name>approval_status_id</name>
 284     <type>int unsigned</type>
 285     <title>Approval Status</title>
 286     <comment>The status of this mailing. Values: none, approved, rejected</comment>
 287     <pseudoconstant>
 288       <optionGroupName>mail_approval_status</optionGroupName>
 289     </pseudoconstant>
 290     <html>
 291       <type>Select</type>
 292     </html>
 293     <add>3.3</add>
 294   </field>
 295   <field>
 296     <name>approval_note</name>
 297     <type>longtext</type>
 298     <title>Approval Note</title>
 299     <comment>Note behind the decision.</comment>
 300     <add>3.3</add>
 301     <html>
 302       <type>TextArea</type>
 303     </html>
 304   </field>
 305   <field>
 306     <name>is_archived</name>
 307     <type>boolean</type>
 308     <default>0</default>
 309     <comment>Is this mailing archived?</comment>
 310     <html>
 311       <type>CheckBox</type>
 312     </html>
 313     <add>2.2</add>
 314   </field>
 315   <field>
 316     <name>visibility</name>
 317     <type>varchar</type>
 318     <length>40</length>
 319     <default>'Public Pages'</default>
 320     <comment>In what context(s) is the mailing contents visible (online viewing)</comment>
 321     <pseudoconstant>
 322       <callback>CRM_Core_SelectValues::groupVisibility</callback>
 323     </pseudoconstant>
 324     <add>3.3</add>
 325     <html>
 326       <type>Select</type>
 327     </html>
 328   </field>
 329   <field>
 330     <name>campaign_id</name>
 331     <type>int unsigned</type>
 332     <comment>The campaign for which this mailing has been initiated.</comment>
 333     <pseudoconstant>
 334       <table>civicrm_campaign</table>
 335       <keyColumn>id</keyColumn>
 336       <labelColumn>title</labelColumn>
 337     </pseudoconstant>
 338     <add>3.4</add>
 339     <html>
 340       <type>Select</type>
 341     </html>
 342   </field>
 343   <foreignKey>
 344     <name>campaign_id</name>
 345     <table>civicrm_campaign</table>
 346     <key>id</key>
 347     <onDelete>SET NULL</onDelete>
 348   </foreignKey>
 349   <field>
 350     <name>dedupe_email</name>
 351     <type>boolean</type>
 352     <default>0</default>
 353     <add>4.1</add>
 354     <comment>Remove duplicate emails?</comment>
 355     <html>
 356       <type>CheckBox</type>
 357     </html>
 358   </field>
 359   <field>
 360     <name>sms_provider_id</name>
 361     <title>Mailing SMS Provider</title>
 362     <type>int unsigned</type>
 363     <add>4.2</add>
 364     <html>
 365       <type>Select</type>
 366     </html>
 367   </field>
 368   <foreignKey>
 369     <name>sms_provider_id</name>
 370     <table>civicrm_sms_provider</table>
 371     <key>id</key>
 372     <onDelete>SET NULL</onDelete>
 373     <add>4.2</add>
 374   </foreignKey>
 375   <field>
 376     <name>hash</name>
 377     <title>Mailing Hash</title>
 378     <type>varchar</type>
 379     <length>16</length>
 380     <comment>Key for validating requests related to this mailing.</comment>
 381     <add>4.5</add>
 382   </field>
 383   <index>
 384     <name>index_hash</name>
 385     <fieldName>hash</fieldName>
 386     <add>4.5</add>
 387   </index>
 388 </table>