Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| TagGroupId | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each tag group |
|
| TagGroupName | nvarchar | 400 | null |
|
|
Group name - Name of the tag group for organizational purposes |
||
| TagGroupOrder | int | 4 | √ | null |
|
|
Display order - Order in which tag groups are displayed in the user interface |
|
| TagGroupBackgroundColor | nvarchar | 20 | √ | null |
|
|
Background color - Background color for visual identification of the tag group |
|
| TagGroupTextColor | nvarchar | 20 | √ | null |
|
|
Text color - Text color for optimal contrast and readability |
|
| TagGroupIsOn | bit | 1 | ((1)) |
|
|
Active status - Boolean indicating if the tag group is currently active and available for use |
||
| CreateBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created the tag group |
|
| CreateDate | datetime | 16,3 | √ | null |
|
|
Creation date - Date when the tag group was created |
|
| UpdateBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated the tag group |
|
| UpdateDate | datetime | 16,3 | √ | null |
|
|
Last update date - Date when the tag group was last modified |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_TagGroup | Primary key | Asc | TagGroupId |
Relationships
Close relationships within degrees of separation
