xml/schema/Mailing/Event/Opened.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4     <base>CRM/Mailing/Event</base>
   5     <class>Opened</class>
   6     <name>civicrm_mailing_event_opened</name>
   7     <comment>Tracks when a delivered email is opened by the recipient</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>time_stamp</name>
  32         <type>datetime</type>
  33         <required>true</required>
  34         <comment>When this open event occurred.</comment>
  35     </field>
  36 </table>