X-Git-Url: https://vcs.fsf.org/?a=blobdiff_plain;f=xml%2Fschema%2FCore%2FEntityTag.xml;h=1f3543dcf0a12ecc31b6cb2d5cd9095c8bee9bae;hb=c90aa71ce88e032a7e769f7a96c9b5ece2d08335;hp=c40a2ebf041eab5e702a2e85690c50c2d1cc244e;hpb=ba4d65467bdf14b7ac4d5efce468f5e4867129f9;p=civicrm-core.git diff --git a/xml/schema/Core/EntityTag.xml b/xml/schema/Core/EntityTag.xml index c40a2ebf04..1f3543dcf0 100644 --- a/xml/schema/Core/EntityTag.xml +++ b/xml/schema/Core/EntityTag.xml @@ -7,83 +7,86 @@ Tag entities (Contacts, Groups, Actions) to categories. true - id - int unsigned - Entity Tag ID - true - primary key - 1.1 + id + int unsigned + Entity Tag ID + true + primary key + 1.1 - id - true + id + true - contact_id - int unsigned - true - FK to contact table. - 2.0 - 3.2 + contact_id + int unsigned + true + FK to contact table. + 2.0 + 3.2 - contact_id - civicrm_contact
- id - 2.0 - 3.2 - CASCADE + contact_id + civicrm_contact
+ id + 2.0 + 3.2 + CASCADE
- entity_table - varchar - Entity Table - 64 - physical tablename for entity being joined to file, e.g. civicrm_contact - 3.2 + entity_table + varchar + Entity Table + 64 + physical tablename for entity being joined to file, e.g. civicrm_contact + + tag_used_for + + 3.2 - entity_id - int unsigned - Entity ID - true - FK to entity table specified in entity_table column. - 3.2 + entity_id + int unsigned + Entity ID + true + FK to entity table specified in entity_table column. + 3.2 - entity_id - entity_table - 3.2 + entity_id + entity_table + 3.2 - index_entity - entity_table - entity_id - 3.2 - 3.4 + index_entity + entity_table + entity_id + 3.2 + 3.4 - tag_id - int unsigned - Tag ID - true - FK to civicrm_tag - 1.1 - - civicrm_tag
- id - name -
- - Select - + tag_id + int unsigned + Tag + true + FK to civicrm_tag + 1.1 + + civicrm_tag
+ id + name +
+ + Select +
- tag_id - civicrm_tag
- id - 1.1 - CASCADE + tag_id + civicrm_tag
+ id + 1.1 + CASCADE
UI_entity_id_entity_table_tag_id