TurnItIn Submissions data set: columns, keys and joins
Checked against D2L on October 31, 2026
Back to the mapColumns
| Column | Type | Size | Key |
|---|---|---|---|
DropboxId | bigint | 8 | FK |
SubmissionId | bigint | 8 | PK, FK |
FileId | bigint | 8 | PK |
LastSubmissionDate | datetime2 | 8 | |
SubmissionStatus | smallint | 2 | |
SubmissionErrorType | smallint | 2 | |
ErrorMessage | nvarchar | 255 | |
SubmittedBy | int | 4 | FK |
LastRefreshDate | datetime2 | 8 | |
LastModified | datetime2 | 8 |
Joins to (2)
- Assignment Summary
DropboxId→DropboxId - Assignment Submission Details
SubmissionId→SubmissionId
Joined from (0)
None
Edit history links
None
Foreign keys without a stated target
SubmittedBy: Marked as a foreign key by D2L, without a stated target data set.