forum_grades

0 rows


Description

Grading data for forum instances

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
forum BIGINT 19 null
forum.id forugrad_for2_fkR

The ID of the forum that this grade relates to

itemnumber BIGINT 19 null

The grade itemnumber

userid BIGINT 19 null
user.id Implied ConstraintR

The user who was graded

grade DECIMAL 10,5 null

The numerical grade for this user’s forum assessment. Can be determined by scales/advancedgradingforms etc but will always be converted back to a floating point number.

timecreated BIGINT 19 null
timemodified BIGINT 19 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
forugrad_for2_ix Performance Asc forum
forugrad_foriteuse2_uix Must be unique Asc/Asc/Asc forum + itemnumber + userid
forugrad_use2_ix Performance Asc userid

Relationships