Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkChecklistItemAssignmentID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each assignment |
|
| fkChecklistItemID | int | 4 | null |
|
|
Checklist item reference - Links to CheckListItems for the assigned item |
||
| fkUserID | int | 4 | √ | null |
|
|
User reference - Links to AccessUser table for the assigned user |
|
| fkChecklistAssignmentTypeID | int | 4 | √ | null |
|
|
Assignment type reference - Links to ChecklistAssignmentTypes for assignment classification |
|
| Deleted | bit | 1 | √ | null |
|
|
Deleted flag - Soft delete flag for audit trail |
|
| DateCreated | smalldatetime | 16 | √ | null |
|
|
Creation date - Date when the assignment was created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created the assignment |
|
| DateUpdated | smalldatetime | 16 | √ | null |
|
|
Update date - Date of the last modification |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last modified the assignment |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ChecklistAssignment | Primary key | Asc | pkChecklistItemAssignmentID |
Relationships
Close relationships within degrees of separation
