Forum Grades Table Schema (forum_grades)


Grading data for forum instances

forum_grades table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
forum BIGINT 19 null forugrad_for2_fk R

The ID of the forum that this grade relates to

itemnumber BIGINT 19 null

The grade itemnumber

userid BIGINT 19 null Implied Constraint R

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

Table contained -1 rows

forum_grades table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
forugrad_for_ix Performance Asc forum
forugrad_foriteuse_uix Must be unique Asc/Asc/Asc forum + itemnumber + userid
forugrad_use_ix Performance Asc userid

forum_grades table relationships