xml/schema/Mailing/Event/Bounce.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4     <base>CRM/Mailing/Event</base>
   5     <class>Bounce</class>
   6     <name>civicrm_mailing_event_bounce</name>
   7     <comment>Tracks when and why an email bounced.</comment>
   8     <archive>true</archive>
   9     <field>
  10         <name>id</name>
  11         <type>int unsigned</type>
  12         <required>true</required>
  13     </field>
  14     <primaryKey>
  15         <name>id</name>
  16         <autoincrement>true</autoincrement>
  17     </primaryKey>
  18     <field>
  19         <name>event_queue_id</name>
  20         <type>int unsigned</type>
  21         <required>true</required>
  22         <comment>FK to EventQueue</comment>
  23     </field>
  24     <foreignKey>
  25         <name>event_queue_id</name>
  26         <table>civicrm_mailing_event_queue</table>
  27         <key>id</key>
  28         <onDelete>CASCADE</onDelete>
  29     </foreignKey>
  30     <field>
  31       <name>bounce_type_id</name>
  32       <type>int unsigned</type>
  33       <comment>What type of bounce was it?</comment>
  34       <pseudoconstant>
  35         <table>civicrm_mailing_bounce_type</table>
  36         <keyColumn>id</keyColumn>
  37         <labelColumn>name</labelColumn>
  38       </pseudoconstant>
  39       <html>
  40         <type>Select</type>
  41       </html>
  42     </field>
  43     <field>
  44         <name>bounce_reason</name>
  45         <type>varchar</type>
  46         <length>255</length>
  47         <comment>The reason the email bounced.</comment>
  48     </field>
  49     <field>
  50         <name>time_stamp</name>
  51         <type>datetime</type>
  52         <required>true</required>
  53         <comment>When this bounce event occurred.</comment>
  54     </field>
  55 </table>