assign_submission

0 rows


Description

This table keeps information about student interactions with the mod/assign. This is limited to metadata about a student submission but does not include the submission itself which is stored by plugins.

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
assignfeedback_editpdf_queue.submissionid Defined in XMLR
assignment BIGINT 19 0
assign.id assisubm_ass2_fkR
userid BIGINT 19 0
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.

timestarted BIGINT 19 null

The time when the student stared the submission.

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_ass_ix Performance Asc assignment
assisubm_assusegroatt_uix Must be unique Asc/Asc/Asc/Asc assignment + userid + groupid + attemptnumber
assisubm_assusegrolat_ix Performance Asc/Asc/Asc/Asc assignment + userid + groupid + latest
assisubm_att_ix Performance Asc attemptnumber
assisubm_use_ix Performance Asc userid

Relationships