Assignment Special Access data set: columns, keys and joins
Checked against D2L on October 31, 2026
Back to the mapColumns
| Column | Type | Size | Key |
|---|---|---|---|
DropboxId | bigint | 8 | PK, FK |
UserId | int | 4 | PK, FK |
StartDate | datetime2 | 8 | |
EndDate | datetime2 | 8 | |
DueDate | datetime2 | 8 | |
ModifiedBy | int | 4 | FK |
LastModified | datetime2 | 8 | |
IsDeleted | bit | 1 | |
StartDateAvailabilityType | smallint | 2 | |
EndDateAvailabilityType | smallint | 2 |
Joins to (2)
- Assignment Summary
DropboxId→DropboxId - Users
UserId→UserId
Joined from (0)
None
Edit history links
- Users
ModifiedBy→UserId