assign_submission

0 rows


Description

This table keeps information about student interactions with

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
assignsubmission_file.submission assifile_sub2_fkR
assignsubmission_onlinetext.submission assionli_sub2_fkR
assignment BIGINT 19 0
assign.id assisubm_ass2_fkR
userid BIGINT 19 0
user.id Implied ConstraintR
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.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
assisubm_ass4_ix Performance Asc assignment
assisubm_assusegroatt2_uix Must be unique Asc/Asc/Asc/Asc assignment + userid + groupid + attemptnumber
assisubm_assusegrolat2_ix Performance Asc/Asc/Asc/Asc assignment + userid + groupid + latest
assisubm_att2_ix Performance Asc attemptnumber
assisubm_use2_ix Performance Asc userid

Relationships