Workshop Comments Old Table Schema (workshop_comments_old)


Description

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

workshop_comments_old table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
workshopid BIGINT 19 0
workshop.id workcommold_wor2_fk R
assessmentid BIGINT 19 0
workshop_assessments.id workcommold_ass2_fk R
userid BIGINT 19 0
user.id Implied Constraint R
timecreated BIGINT 19 0
mailed TINYINT 3 0
comments LONGTEXT 2147483647 null
newplugin VARCHAR 28 √ null
newid BIGINT 19 √ null

Table contained -1 rows

workshop_comments_old table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
workcommold_ass_ix Performance Asc assessmentid
workcommold_mai_ix Performance Asc mailed
workcommold_use_ix Performance Asc userid
workcommold_wor_ix Performance Asc workshopid

workshop_comments_old table relationships

Close relationships within degrees of separation