Tag


Description

Flexible labeling and categorization system providing a centralized taxonomy for organizing and classifying tickets, applications, content, and other system entities. Tags enable dynamic categorization, filtering, search enhancement, and business intelligence across the platform. The system supports hierarchical tagging, tag relationships, and automated tag assignment for comprehensive content organization and discovery.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
TagId int identity 4 √ null
TagAssigned.TagId FK_TagAssigned_Tag R

Primary key - Unique identifier for each tag in the system, auto-incrementing integer used for tag references
TagName nvarchar 510 √ null

Tag display name - Human-readable name of the tag for display in user interfaces and filtering options

Indexes

Constraint Name Type Sort Column(s)
PK_Tag Primary key Asc TagId

Relationships

Close relationships within degrees of separation