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>
10 <title>Recipient
</title>
11 <titlePlural>Recipients
</titlePlural>
14 <title>Mailing Recipients ID
</title>
15 <type>int unsigned
</type>
16 <required>true
</required>
23 <autoincrement>true
</autoincrement>
26 <name>mailing_id
</name>
27 <title>Mailing ID
</title>
28 <type>int unsigned
</type>
29 <required>true
</required>
31 <label>Mailing
</label>
33 <comment>The ID of the mailing this Job will send.
</comment>
36 <name>mailing_id
</name>
37 <table>civicrm_mailing
</table>
39 <onDelete>CASCADE
</onDelete>
42 <name>contact_id
</name>
43 <title>Recipient ID
</title>
44 <type>int unsigned
</type>
45 <required>true
</required>
46 <comment>FK to Contact
</comment>
48 <label>Recipient
</label>
52 <name>contact_id
</name>
53 <table>civicrm_contact
</table>
55 <onDelete>CASCADE
</onDelete>
59 <title>Email ID
</title>
60 <type>int unsigned
</type>
61 <default>NULL
</default>
62 <comment>FK to Email
</comment>
69 <table>civicrm_email
</table>
71 <onDelete>SET NULL
</onDelete>
75 <title>Phone ID
</title>
76 <type>int unsigned
</type>
77 <default>NULL
</default>
78 <comment>FK to Phone
</comment>
85 <table>civicrm_phone
</table>
87 <onDelete>SET NULL
</onDelete>