Table d45civi_b72v5.civicrm_tag Generated by
SchemaSpy
Legend: SourceForge.net
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
civicrm_tag.id 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
civicrm_contact.id 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 Wed Nov 11 17:12 EST 2015

Indexes:
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: