<class>EntityTag</class>
<name>civicrm_entity_tag</name>
<comment>Tag entities (Contacts, Groups, Actions) to categories.</comment>
+ <add>1.1</add>
<log>true</log>
<field>
<name>id</name>
<title>Entity Tag ID</title>
<required>true</required>
<comment>primary key</comment>
+ <html>
+ <type>Number</type>
+ </html>
<add>1.1</add>
</field>
<primaryKey>
<name>id</name>
<autoincrement>true</autoincrement>
</primaryKey>
- <field>
- <name>contact_id</name>
- <type>int unsigned</type>
- <required>true</required>
- <comment>FK to contact table.</comment>
- <add>2.0</add>
- <drop>3.2</drop>
- </field>
- <foreignKey>
- <name>contact_id</name>
- <table>civicrm_contact</table>
- <key>id</key>
- <add>2.0</add>
- <drop>3.2</drop>
- <onDelete>CASCADE</onDelete>
- </foreignKey>
<field>
<name>entity_table</name>
<type>varchar</type>
<title>Entity Table</title>
<length>64</length>
<comment>physical tablename for entity being joined to file, e.g. civicrm_contact</comment>
+ <pseudoconstant>
+ <optionGroupName>tag_used_for</optionGroupName>
+ </pseudoconstant>
<add>3.2</add>
</field>
<field>
<typeColumn>entity_table</typeColumn>
<add>3.2</add>
</dynamicForeignKey>
- <index>
- <name>index_entity</name>
- <fieldName>entity_table</fieldName>
- <fieldName>entity_id</fieldName>
- <add>3.2</add>
- <drop>3.4</drop>
- </index>
<field>
<name>tag_id</name>
<type>int unsigned</type>
- <title>Tag ID</title>
+ <title>Tag</title>
<required>true</required>
<comment>FK to civicrm_tag</comment>
<add>1.1</add>