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 |