TagCategories


Description

Tagging and categorization system that provides flexible labeling and organization capabilities across the system. Tags enable users to categorize, filter, and organize various entities for improved data management and reporting.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
CreatedBy Unknown 0 null

Created by - User who created this tag

CreatedDate Unknown 0 null

Creation date - When this tag was first created in the system

IsActive Unknown 0 null

Active status - Whether this tag is currently available for use

pkTagID int 4 null

Primary key - TagCategories unique identifier for each record

TagColor Unknown 0 null

Display color - Color code for visual representation of the tag in user interfaces

TagDescription Unknown 0 null

Tag description - Detailed explanation of the tag’s purpose and usage

TagName nvarchar 400 null

Tag name - Descriptive name or label for the tag

TagCategory nvarchar 400 null

Tag category - Higher-level grouping for organizing related tags

Indexes

Constraint Name Type Sort Column(s)
PK_TagCategories Primary key Asc pkTagID

Relationships