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>
11 <type>int unsigned
</type>
12 <required>true
</required>
16 <autoincrement>true
</autoincrement>
19 <name>mailing_id
</name>
20 <type>int unsigned
</type>
21 <required>true
</required>
22 <comment>The ID of the mailing this Job will send.
</comment>
25 <name>mailing_id
</name>
26 <table>civicrm_mailing
</table>
28 <onDelete>CASCADE
</onDelete>
31 <name>contact_id
</name>
32 <type>int unsigned
</type>
33 <required>true
</required>
34 <comment>FK to Contact
</comment>
37 <name>contact_id
</name>
38 <table>civicrm_contact
</table>
40 <onDelete>CASCADE
</onDelete>
44 <type>int unsigned
</type>
45 <default>NULL
</default>
46 <comment>FK to Email
</comment>
50 <table>civicrm_email
</table>
52 <onDelete>CASCADE
</onDelete>
56 <type>int unsigned
</type>
57 <default>NULL
</default>
58 <comment>FK to Phone
</comment>
62 <table>civicrm_phone
</table>
64 <onDelete>CASCADE
</onDelete>