xml/schema/Core/ActionLog.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4   <base>CRM/Core</base>
   5   <class>ActionLog</class>
   6   <name>civicrm_action_log</name>
   7   <comment>Table to store log for the reminder.</comment>
   8   <add>3.4</add>
   9   <field>
  10       <name>id</name>
  11       <type>int unsigned</type>
  12       <required>true</required>
  13       <add>3.4</add>
  14   </field>
  15   <primaryKey>
  16        <name>id</name>
  17        <autoincrement>true</autoincrement>
  18   </primaryKey>
  19   <field>
  20       <name>contact_id</name>
  21       <type>int unsigned</type>
  22       <comment>FK to Contact ID</comment>
  23       <add>3.4</add>
  24   </field>
  25   <foreignKey>
  26        <name>contact_id</name>
  27        <table>civicrm_contact</table>
  28        <key>id</key>
  29        <add>3.4</add>
  30        <onDelete>CASCADE</onDelete>
  31   </foreignKey>
  32   <field>
  33       <name>entity_id</name>
  34       <type>int unsigned</type>
  35       <required>true</required>
  36       <comment>FK to id of the entity that the action was performed on. Pseudo - FK.</comment>
  37       <add>3.4</add>
  38   </field>
  39   <field>
  40        <name>entity_table</name>
  41        <type>varchar</type>
  42        <length>255</length>
  43        <comment>name of the entity table for the above id, e.g. civicrm_activity, civicrm_participant</comment>
  44        <add>3.4</add>
  45   </field>
  46   <field>
  47       <name>action_schedule_id</name>
  48       <type>int unsigned</type>
  49       <required>true</required>
  50       <comment>FK to the action schedule that this action originated from.</comment>
  51       <add>3.4</add>
  52   </field>
  53   <foreignKey>
  54        <name>action_schedule_id</name>
  55        <table>civicrm_action_schedule</table>
  56        <key>id</key>
  57        <add>3.4</add>
  58        <onDelete>CASCADE</onDelete>
  59   </foreignKey>
  60   <field>
  61       <name>action_date_time</name>
  62       <type>datetime</type>
  63       <comment>date time that the action was performed on.</comment>
  64       <add>3.4</add>
  65   </field>
  66   <field>
  67       <name>is_error</name>
  68       <type>boolean</type>
  69       <default>0</default>
  70       <comment>Was there any error sending the reminder?</comment>
  71       <add>3.4</add>
  72   </field>
  73   <field>
  74      <name>message</name>
  75      <type>text</type>
  76      <comment>Description / text in case there was an error encountered.</comment>
  77      <add>3.4</add>
  78   </field>
  79   <field>
  80       <name>repetition_number</name>
  81       <type>int unsigned</type>
  82       <comment>Keeps track of the sequence number of this repetition.</comment>
  83       <add>3.4</add>
  84   </field>
  85 </table>