Merge remote-tracking branch 'upstream/4.5' into 4.5-master-2014-12-16-01-08-03
[civicrm-core.git] / xml / schema / Mailing / Recipients.xml
index 95b143626aea38a8e799a67389b007131a183c5e..188f64dbb1fa9942446e328ce1c57c0559debb19 100644 (file)
@@ -7,60 +7,65 @@
   <comment>Stores information about the recipients of a mailing.</comment>
   <archive>true</archive>
   <field>
-      <name>id</name>
-      <type>int unsigned</type>
-      <required>true</required>
+    <name>id</name>
+    <title>Mailing Recipients ID</title>
+    <type>int unsigned</type>
+    <required>true</required>
   </field>
   <primaryKey>
-      <name>id</name>
-      <autoincrement>true</autoincrement>
+    <name>id</name>
+    <autoincrement>true</autoincrement>
   </primaryKey>
   <field>
-      <name>mailing_id</name>
-      <type>int unsigned</type>
-      <required>true</required>
-      <comment>The ID of the mailing this Job will send.</comment>
+    <name>mailing_id</name>
+    <title>Mailing</title>
+    <type>int unsigned</type>
+    <required>true</required>
+    <comment>The ID of the mailing this Job will send.</comment>
   </field>
   <foreignKey>
-      <name>mailing_id</name>
-      <table>civicrm_mailing</table>
-      <key>id</key>
-      <onDelete>CASCADE</onDelete>
+    <name>mailing_id</name>
+    <table>civicrm_mailing</table>
+    <key>id</key>
+    <onDelete>CASCADE</onDelete>
   </foreignKey>
   <field>
-      <name>contact_id</name>
-      <type>int unsigned</type>
-      <required>true</required>
-      <comment>FK to Contact</comment>
+    <name>contact_id</name>
+    <title>Mailing Recipient</title>
+    <type>int unsigned</type>
+    <required>true</required>
+    <comment>FK to Contact</comment>
   </field>
   <foreignKey>
-      <name>contact_id</name>
-      <table>civicrm_contact</table>
-      <key>id</key>
-      <onDelete>CASCADE</onDelete>
+    <name>contact_id</name>
+    <table>civicrm_contact</table>
+    <key>id</key>
+    <onDelete>CASCADE</onDelete>
   </foreignKey>
   <field>
-      <name>email_id</name>
-      <type>int unsigned</type>
-      <default>NULL</default>
-      <comment>FK to Email</comment>
+    <name>email_id</name>
+    <title>Recipient Email</title>
+    <type>int unsigned</type>
+    <default>NULL</default>
+    <comment>FK to Email</comment>
   </field>
   <foreignKey>
-      <name>email_id</name>
-      <table>civicrm_email</table>
-      <key>id</key>
-      <onDelete>CASCADE</onDelete>
+    <name>email_id</name>
+    <table>civicrm_email</table>
+    <key>id</key>
+    <onDelete>CASCADE</onDelete>
   </foreignKey>
   <field>
-      <name>phone_id</name>
-      <type>int unsigned</type>
-      <default>NULL</default>
-      <comment>FK to Phone</comment>
+    <name>phone_id</name>
+    <title>Recipient Phone</title>
+    <type>int unsigned</type>
+    <default>NULL</default>
+    <comment>FK to Phone</comment>
   </field>
   <foreignKey>
-      <name>phone_id</name>
-      <table>civicrm_phone</table>
-      <key>id</key>
-      <onDelete>CASCADE</onDelete>
+    <name>phone_id</name>
+    <table>civicrm_phone</table>
+    <key>id</key>
+    <onDelete>CASCADE</onDelete>
   </foreignKey>
 </table>