1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
4 <base>CRM/Mailing/Event
</base>
6 <name>civicrm_mailing_event_queue
</name>
7 <comment>A collection of all intended recipients of a job
</comment>
8 <archive>true
</archive>
11 <type>int unsigned
</type>
12 <title>Mailing Event Queue ID
</title>
13 <required>true
</required>
17 <autoincrement>true
</autoincrement>
21 <type>int unsigned
</type>
22 <required>true
</required>
24 <comment>FK to Job
</comment>
28 <table>civicrm_mailing_job
</table>
30 <onDelete>CASCADE
</onDelete>
34 <type>int unsigned
</type>
35 <default>NULL
</default>
36 <title>Email ID
</title>
37 <comment>FK to Email
</comment>
41 <table>civicrm_email
</table>
43 <onDelete>CASCADE
</onDelete>
46 <name>contact_id
</name>
47 <type>int unsigned
</type>
48 <required>true
</required>
49 <title>Contact ID
</title>
50 <comment>FK to Contact
</comment>
53 <name>contact_id
</name>
54 <table>civicrm_contact
</table>
56 <onDelete>CASCADE
</onDelete>
62 <required>true
</required>
63 <title>Security Hash
</title>
64 <comment>Security hash
</comment>
68 <type>int unsigned
</type>
69 <default>NULL
</default>
70 <title>Phone ID
</title>
71 <comment>FK to Phone
</comment>
75 <table>civicrm_phone
</table>
77 <onDelete>CASCADE
</onDelete>