Assignment Submissions Table Schema (assignment_submissions)


Description

Info about submitted assignments

assignment_submissions table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
assignment bigint 10 0
assignment.id assisubm_ass4_fk R
userid bigint 10 0
user.id Implied Constraint R
timecreated bigint 10 0
timemodified bigint 10 0
numfiles bigint 10 0
data1 longtext 2147483647 null
data2 longtext 2147483647 null
grade bigint 11 0
submissioncomment longtext 2147483647 null
format smallint 4 0
teacher bigint 10 0
timemarked bigint 10 0
mailed BIT 1 0

Table contained -1 rows

assignment_submissions table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
assisubm_ass2_ix Performance Asc assignment
assisubm_mai_ix Performance Asc mailed
assisubm_tim_ix Performance Asc timemarked
assisubm_use2_ix Performance Asc userid

assignment_submissions table relationships