Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each tag association, auto-incrementing integer |
|
| fkTagID | int | 4 | √ | null |
|
|
Tag reference - Foreign key linking to Tag.TagId for the tag being applied |
|
| TableField | nvarchar | 100 | √ | null |
|
|
Entity table - Name of the database table containing the entity being tagged |
|
| FieldID | int | 4 | √ | null |
|
|
Entity ID - Primary key value of the entity being tagged |
|
| Comments | nvarchar | 1073741823 | √ | null |
|
|
Tag comments - Additional comments or context about this tag association |
|
| CreatedBy | int | 4 | √ | null |
|
|
Creator user ID - Reference to user who created this tag association |
|
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation timestamp - When this tag association was first created |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Last modifier - User ID who made the most recent update to this tag association |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Last modification timestamp - When this tag association was most recently updated |
|
| Deleted | bit | 1 | null |
|
|
Soft delete flag - Boolean indicating if this tag association is logically deleted (required field) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Tags | Primary key | Asc | pkID |