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