Table d47civi_0z3xa.civicrm_tag Generated by
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √ 
civicrm_entity_tag.tag_id FK_civicrm_entity_tag_tag_id C
civicrm_tag.parent_id FK_civicrm_tag_parent_id R
Tag ID
name varchar 64 Name of Tag.
description varchar 255  √  null Optional verbose description of the tag.
parent_id int unsigned 10  √  null FK_civicrm_tag_parent_id R
Optional parent id for this tag.
is_selectable tinyint 3  √  1 Is this tag selectable / displayed
is_reserved tinyint 3  √  0
is_tagset tinyint 3  √  0
used_for varchar 64  √  null
created_id int unsigned 10  √  null FK_civicrm_tag_created_id N
FK to civicrm_contact, who created this tag
created_date datetime 19  √  null Date and time that tag was created.

Table contained 5 rows at mer. avr. 13 16:52 EDT 2016

Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
created_id Performance Asc FK_civicrm_tag_created_id
parent_id Performance Asc FK_civicrm_tag_parent_id
name Must be unique Asc UI_name

Close relationships  within of separation: