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 19 null
assignment BIGINT 19 0
assignment.id assisubm_ass4_fk R
userid BIGINT 19 0
user.id Implied Constraint R
timecreated BIGINT 19 0
timemodified BIGINT 19 0
numfiles BIGINT 19 0
data1 LONGTEXT 2147483647 null
data2 LONGTEXT 2147483647 null
grade BIGINT 19 0
submissioncomment LONGTEXT 2147483647 null
format SMALLINT 5 0
teacher BIGINT 19 0
timemarked BIGINT 19 0
mailed BIT 0 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