Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Id | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each tag assignment, auto-incrementing integer |
||||
| TagId | int | 4 | √ | null |
|
|
Tag reference - Foreign key linking to Tag.TagId for the tag being assigned |
||||
| AssignedId | int | 4 | √ | null |
|
|
Entity identifier - ID of the entity being tagged (could reference tickets, apps, users, etc.) |
||||
| AssignedType | int | 4 | √ | null |
|
|
Entity type - Numeric code indicating the type of entity being tagged (e.g., 1=Ticket, 2=App, 3=User) for polymorphic relationships |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_TagAssigned | Primary key | Asc | Id |