Assignsubmission File Table Schema (assignsubmission_file)


Description

Info about file submissions for assignments

assignsubmission_file table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
assignment BIGINT 19 0
assign.id assifile_ass4_fk R
submission BIGINT 19 0
assign_submission.id assifile_sub2_fk R
numfiles BIGINT 19 0

The number of files the student submitted.

Table contained -1 rows

assignsubmission_file table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
assifile_ass2_ix Performance Asc assignment
assifile_sub_ix Performance Asc submission

assignsubmission_file table relationships

Close relationships within degrees of separation