assignment_submissions

0 rows


Description

Info about submitted assignments

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
assignment BIGINT 19 0
assignment.id assisubm_ass5_fkR
userid BIGINT 19 0
user.id Implied ConstraintR
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 1 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
assisubm_ass_ix Performance Asc assignment
assisubm_mai2_ix Performance Asc mailed
assisubm_tim2_ix Performance Asc timemarked
assisubm_use_ix Performance Asc userid

Relationships