xml/schema/Core/Tag.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4   <base>CRM/Core</base>
   5   <class>Tag</class>
   6   <name>civicrm_tag</name>
   7   <comment>Provides support for flat or hierarchical classification of various types of entities (contacts, groups, actions...).</comment>
   8   <add>1.1</add>
   9   <log>true</log>
  10   <field>
  11       <name>id</name>
  12       <type>int unsigned</type>
  13       <required>true</required>
  14       <comment>Tag ID</comment>
  15       <add>1.1</add>
  16   </field>
  17   <primaryKey>
  18        <name>id</name>
  19        <autoincrement>true</autoincrement>
  20   </primaryKey>
  21   <field>
  22        <name>name</name>
  23        <type>varchar</type>
  24        <required>true</required>
  25        <length>64</length>
  26        <comment>Name of Tag.</comment>
  27        <add>1.1</add>
  28   </field>
  29   <field>
  30        <name>description</name>
  31        <type>varchar</type>
  32        <length>255</length>
  33        <comment>Optional verbose description of the tag.</comment>
  34        <add>1.1</add>
  35   </field>
  36   <field>
  37        <name>parent_id</name>
  38        <type>int unsigned</type>
  39        <default>NULL</default>
  40        <comment>Optional parent id for this tag.</comment>
  41        <add>1.1</add>
  42   </field>
  43   <field>
  44        <name>is_selectable</name>
  45        <type>boolean</type>
  46        <default>1</default>
  47        <comment>Is this tag selectable / displayed</comment>
  48        <add>2.1</add>
  49   </field>
  50   <foreignKey>
  51        <name>parent_id</name>
  52        <table>civicrm_tag</table>
  53        <key>id</key>
  54        <add>1.1</add>
  55   </foreignKey>
  56   <index>
  57     <name>UI_name</name>
  58     <fieldName>name</fieldName>
  59     <unique>true</unique>
  60     <add>2.1</add>
  61   </index>
  62   <field>
  63     <name>is_reserved</name>
  64     <type>boolean</type>
  65     <default>0</default>
  66     <add>3.2</add>
  67   </field>
  68   <field>
  69     <name>is_tagset</name>
  70     <type>boolean</type>
  71     <default>0</default>
  72     <add>3.2</add>
  73   </field>
  74   <field>
  75     <name>used_for</name>
  76     <type>varchar</type>
  77     <length>64</length>
  78     <default>NULL</default>
  79     <add>3.2</add>
  80   </field>
  81   <field>
  82       <name>created_id</name>
  83       <type>int unsigned</type>
  84       <comment>FK to civicrm_contact, who created this tag</comment>
  85       <add>3.4</add>
  86   </field>
  87   <foreignKey>
  88       <name>created_id</name>
  89       <table>civicrm_contact</table>
  90       <key>id</key>
  91       <add>3.4</add>
  92       <onDelete>SET NULL</onDelete>
  93   </foreignKey>
  94   <field>
  95       <name>created_date</name>
  96       <type>datetime</type>
  97       <title>Tag Created Date</title>
  98       <comment>Date and time that tag was created.</comment>
  99       <add>3.4</add>
 100   </field>
 101 </table>