id |
BIGINT |
19 |
|
√ |
null |
|
|
|
assignment |
BIGINT |
19 |
|
|
0 |
|
|
|
userid |
BIGINT |
19 |
|
|
0 |
|
user.id
|
Implied Constraint R
|
|
|
timecreated |
BIGINT |
19 |
|
|
0 |
|
|
The time of the first student submission to this assignment. |
timemodified |
BIGINT |
19 |
|
|
0 |
|
|
The last time this assignment submission was modified by a student. |
status |
VARCHAR |
10 |
√ |
|
null |
|
|
The status of this assignment submission. The current statuses are DRAFT and SUBMITTED. |
groupid |
BIGINT |
19 |
|
|
0 |
|
|
The group id for team submissions |
attemptnumber |
BIGINT |
19 |
|
|
0 |
|
|
Used to track attempts for an assignment |
latest |
TINYINT |
3 |
|
|
0 |
|
|
Greatly simplifies queries wanting to know information about only the latest attempt. |