Workshop Submissions Old Table Schema (workshop_submissions_old)


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

workshop_submissions_old table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
workshopid BIGINT 19 0 worksubmold_wor2_fk R
userid BIGINT 19 0 Implied Constraint R
title VARCHAR 100
timecreated BIGINT 19 0
mailed TINYINT 3 0
description LONGTEXT 2147483647 null
gradinggrade SMALLINT 5 0
finalgrade SMALLINT 5 0
late SMALLINT 5 0
nassessments BIGINT 19 0
newplugin VARCHAR 28 null
newid BIGINT 19 null

Table contained -1 rows

workshop_submissions_old table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
worksubmold_mai_ix Performance Asc mailed
worksubmold_use_ix Performance Asc userid
worksubmold_wor_ix Performance Asc workshopid

workshop_submissions_old table relationships