<name>civicrm_mailing_recipients</name>
<comment>Stores information about the recipients of a mailing.</comment>
<archive>true</archive>
+ <component>CiviMail</component>
+ <title>Recipient</title>
+ <titlePlural>Recipients</titlePlural>
<field>
<name>id</name>
<title>Mailing Recipients ID</title>
<type>int unsigned</type>
<required>true</required>
+ <html>
+ <type>Number</type>
+ </html>
</field>
<primaryKey>
<name>id</name>
<name>email_id</name>
<table>civicrm_email</table>
<key>id</key>
- <onDelete>CASCADE</onDelete>
+ <onDelete>SET NULL</onDelete>
</foreignKey>
<field>
<name>phone_id</name>
<name>phone_id</name>
<table>civicrm_phone</table>
<key>id</key>
- <onDelete>CASCADE</onDelete>
+ <onDelete>SET NULL</onDelete>
</foreignKey>
</table>