1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
4 <base>CRM/Mailing
</base>
5 <class>Recipients
</class>
6 <name>civicrm_mailing_recipients
</name>
7 <comment>Stores information about the recipients of a mailing.
</comment>
8 <archive>true
</archive>
9 <component>CiviMail
</component>
12 <title>Mailing Recipients ID
</title>
13 <type>int unsigned
</type>
14 <required>true
</required>
18 <autoincrement>true
</autoincrement>
21 <name>mailing_id
</name>
22 <title>Mailing
</title>
23 <type>int unsigned
</type>
24 <required>true
</required>
25 <comment>The ID of the mailing this Job will send.
</comment>
28 <name>mailing_id
</name>
29 <table>civicrm_mailing
</table>
31 <onDelete>CASCADE
</onDelete>
34 <name>contact_id
</name>
35 <title>Mailing Recipient
</title>
36 <type>int unsigned
</type>
37 <required>true
</required>
38 <comment>FK to Contact
</comment>
41 <name>contact_id
</name>
42 <table>civicrm_contact
</table>
44 <onDelete>CASCADE
</onDelete>
48 <title>Recipient Email
</title>
49 <type>int unsigned
</type>
50 <default>NULL
</default>
51 <comment>FK to Email
</comment>
55 <table>civicrm_email
</table>
57 <onDelete>SET NULL
</onDelete>
61 <title>Recipient Phone
</title>
62 <type>int unsigned
</type>
63 <default>NULL
</default>
64 <comment>FK to Phone
</comment>
68 <table>civicrm_phone
</table>
70 <onDelete>SET NULL
</onDelete>