Checklist Completions data set: columns, keys and joins
Checked against D2L on October 31, 2026
Back to the mapColumns
| Column | Type | Size | Key |
|---|---|---|---|
UserId | int | 4 | PK, FK |
DateCompleted | datetime2 | 8 | |
ItemId | bigint | 8 | PK, FK |
LastModified | datetime2 | 8 | |
IsCompleted | bit | 1 | |
DateDeleted | datetime2 | 8 | |
DeletedBy | int | 4 | FK |
Version | bigint | 8 |
Joins to (2)
- Checklist Item Details
ItemId→ItemId - Users
UserId→UserId
Joined from (0)
None
Edit history links
- Users
DeletedBy→UserId