Assignment Submission Details data set: columns, keys and joins
Checked against D2L on October 31, 2026
Back to the mapColumns
| Column | Type | Size | Key |
|---|---|---|---|
SubmissionId | bigint | 8 | PK |
DropboxId | bigint | 8 | FK |
UserId | bigint | 8 | FK |
GroupId | bigint | 8 | |
NumberOfFilesSubmitted | int | 4 | |
TotalFileSize | bigint | 8 | |
SubmittedByUserId | int | 4 | FK |
DateSubmitted | datetime2 | 8 | |
Comments | nvarchar | 1000 | |
IsTurnItInExempt | bit | 1 | |
IsDeleted | bit | 1 | |
IsPreview | bit | 1 | |
Version | bigint | 8 |
Joins to (2)
- Assignment Summary
DropboxId→DropboxId - Users
UserId→UserId
Joined from (1)
- TurnItIn Submissions
SubmissionId→SubmissionId
Edit history links
None
Foreign keys without a stated target
SubmittedByUserId: Marked as a foreign key by D2L, without a stated target data set.