xml/schema/Core/Log.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4   <base>CRM/Core</base>
   5   <class>Log</class>
   6   <name>civicrm_log</name>
   7   <comment>Log can be linked to any object in the application.</comment>
   8   <add>1.5</add>
   9   <field>
  10       <name>id</name>
  11       <type>int unsigned</type>
  12       <required>true</required>
  13       <comment>Log ID</comment>
  14        <add>1.5</add>
  15   </field>
  16   <primaryKey>
  17        <name>id</name>
  18        <autoincrement>true</autoincrement>
  19   </primaryKey>
  20   <field>
  21        <name>entity_table</name>
  22        <type>varchar</type>
  23        <length>64</length>
  24        <required>true</required>
  25        <comment>Name of table where item being referenced is stored.</comment>
  26        <add>1.5</add>
  27   </field>
  28   <field>
  29        <name>entity_id</name>
  30        <type>int unsigned</type>
  31        <required>true</required>
  32        <comment>Foreign key to the referenced item.</comment>
  33        <add>1.5</add>
  34   </field>
  35   <index>
  36        <name>index_entity</name>
  37        <add>1.5</add>
  38        <fieldName>entity_table</fieldName>
  39        <fieldName>entity_id</fieldName>
  40        <add>1.5</add>
  41   </index>
  42   <field>
  43       <name>data</name>
  44        <type>text</type>
  45        <comment>Updates does to this object if any.</comment>
  46        <add>1.5</add>
  47   </field>
  48   <field>
  49        <name>modified_id</name>
  50        <type>int unsigned</type>
  51        <comment>FK to Contact ID of person under whose credentials this data modification was made.</comment>
  52        <add>1.5</add>
  53   </field>
  54   <foreignKey>
  55        <name>modified_id</name>
  56        <table>civicrm_contact</table>
  57        <key>id</key>
  58        <add>1.5</add>
  59        <onDelete>CASCADE</onDelete>
  60   </foreignKey>
  61   <field>
  62        <name>modified_date</name>
  63        <type>datetime</type>
  64        <comment>When was the referenced entity created or modified or deleted.</comment>
  65        <add>1.5</add>
  66   </field>
  67 </table>