Merge pull request #16714 from christianwach/lab-1638
[civicrm-core.git] / xml / schema / Core / ActionLog.xml
index f0faf45bbbce32160eed12137cb11bab65280d75..7c3e7a439b6253437f38c5cc7cd3230b59048b67 100644 (file)
@@ -8,6 +8,7 @@
   <add>3.4</add>
   <field>
     <name>id</name>
+    <title>Action Schedule ID</title>
     <type>int unsigned</type>
     <required>true</required>
     <add>3.4</add>
@@ -18,6 +19,7 @@
   </primaryKey>
   <field>
     <name>contact_id</name>
+    <title>Action Schedule Contact ID</title>
     <type>int unsigned</type>
     <comment>FK to Contact ID</comment>
     <add>3.4</add>
@@ -31,6 +33,7 @@
   </foreignKey>
   <field>
     <name>entity_id</name>
+    <title>Entity ID</title>
     <type>int unsigned</type>
     <required>true</required>
     <comment>FK to id of the entity that the action was performed on. Pseudo - FK.</comment>
@@ -39,6 +42,7 @@
   <field>
     <name>entity_table</name>
     <type>varchar</type>
+    <title>Entity Table</title>
     <length>255</length>
     <comment>name of the entity table for the above id, e.g. civicrm_activity, civicrm_participant</comment>
     <add>3.4</add>
@@ -50,6 +54,7 @@
   </dynamicForeignKey>
   <field>
     <name>action_schedule_id</name>
+    <title>Schedule</title>
     <type>int unsigned</type>
     <required>true</required>
     <comment>FK to the action schedule that this action originated from.</comment>
   </foreignKey>
   <field>
     <name>action_date_time</name>
+    <title>Action Date And Time</title>
     <type>datetime</type>
     <comment>date time that the action was performed on.</comment>
     <add>3.4</add>
   </field>
   <field>
     <name>is_error</name>
+    <title>Error?</title>
     <type>boolean</type>
     <default>0</default>
     <comment>Was there any error sending the reminder?</comment>
   </field>
   <field>
     <name>message</name>
+    <title>Message</title>
     <type>text</type>
     <comment>Description / text in case there was an error encountered.</comment>
     <add>3.4</add>
   </field>
   <field>
     <name>repetition_number</name>
+    <title>Repetition Number</title>
     <type>int unsigned</type>
     <comment>Keeps track of the sequence number of this repetition.</comment>
     <add>3.4</add>
   </field>
   <field>
     <name>reference_date</name>
-    <type>date</type>
+    <title>Reference Date</title>
+    <type>datetime</type>
     <default>NULL</default>
     <comment>Stores the date from the entity which triggered this reminder action (e.g. membership.end_date for most membership renewal reminders)</comment>
     <add>4.6</add>
+    <change>5.17</change>
   </field>
 </table>