Forum Grades table / forum_grades - Moodle LMS 3.9 Database schema / Zoola Analytics

forum_grades table columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

BIGINT

19

√

null

forum

BIGINT

19

null

forum.id

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

user.id

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

Showing 1 to 7 of 7 entries

Table contained -1 rows

forum_grades table indexes

Search:

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

Showing 1 to 4 of 4 entries

Forum Grades Table Schema (forum_grades)

Description

forum_grades table columns

forum_grades table indexes

forum_grades table relationships

Close relationships within degrees of separation