Workshop Assessments Old Table Schema (workshop_assessments_old)


Description

Legacy workshop_assessments table to be dropped later in Moodle 2.x

workshop_assessments_old table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
workshopid BIGINT 19 0
workshop.id workasseold_wor2_fk R
submissionid BIGINT 19 0
workshop_submissions.id workasseold_sub2_fk R
userid BIGINT 19 0
user.id Implied Constraint R
timecreated BIGINT 19 0
timegraded BIGINT 19 0
timeagreed BIGINT 19 0
grade DOUBLE 22 0
gradinggrade SMALLINT 5 0
teachergraded SMALLINT 5 0
mailed SMALLINT 5 0
resubmission SMALLINT 5 0
donotuse SMALLINT 5 0
generalcomment LONGTEXT 2147483647 null
teachercomment LONGTEXT 2147483647 null
newplugin VARCHAR 28 null
newid BIGINT 19 null

Table contained -1 rows

workshop_assessments_old table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
workasseold_mai_ix Performance Asc mailed
workasseold_sub_ix Performance Asc submissionid
workasseold_use_ix Performance Asc userid
workasseold_wor_ix Performance Asc workshopid

workshop_assessments_old table relationships