grade_items

0 rows


Description

This table keeps information about gradeable items (ie colum

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
grade_grades.itemid gradgrad_ite2_fkR
grade_grades_history.itemid gradgradhist_ite2_fkR
grade_import_values.itemid gradimpovalu_ite2_fkR
grade_items_history.oldid graditemhist_old2_fkR
courseid BIGINT 19 √ null
course.id graditem_cou2_fkR
categoryid BIGINT 19 √ null
grade_categories.id graditem_cat2_fkR
itemname VARCHAR 255 √ null
itemtype VARCHAR 30
itemmodule VARCHAR 30 √ null
iteminstance BIGINT 19 √ null
itemnumber BIGINT 19 √ null
iteminfo LONGTEXT 2147483647 √ null
idnumber VARCHAR 255 √ null
calculation LONGTEXT 2147483647 √ null
gradetype SMALLINT 5 1
grademax DECIMAL 10,5 100.00000
grademin DECIMAL 10,5 0.00000
scaleid BIGINT 19 √ null
scale.id graditem_sca2_fkR
outcomeid BIGINT 19 √ null
grade_outcomes.id graditem_out2_fkR
gradepass DECIMAL 10,5 0.00000
multfactor DECIMAL 10,5 1.00000
plusfactor DECIMAL 10,5 0.00000
aggregationcoef DECIMAL 10,5 0.00000
aggregationcoef2 DECIMAL 10,5 0.00000
sortorder BIGINT 19 0
display BIGINT 19 0
decimals BIT 1 √ null
hidden BIGINT 19 0
locked BIGINT 19 0
locktime BIGINT 19 0
needsupdate BIGINT 19 0
weightoverride BIT 1 0
timecreated BIGINT 19 √ null
timemodified BIGINT 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
graditem_cat4_ix Performance Asc categoryid
graditem_cou4_ix Performance Asc courseid
graditem_gra2_ix Performance Asc gradetype
graditem_idncou2_ix Performance Asc/Asc idnumber + courseid
graditem_itenee2_ix Performance Asc/Asc itemtype + needsupdate
graditem_locloc2_ix Performance Asc/Asc locked + locktime
graditem_out4_ix Performance Asc outcomeid
graditem_sca4_ix Performance Asc scaleid

Relationships

Close relationships within degrees of separation