grade_items_history

0 rows


Description

History of grade_items

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
action BIGINT 19 0
oldid BIGINT 19 null
grade_items.id graditemhist_old2_fkR
source VARCHAR 255 √ null
timemodified BIGINT 19 √ null
loggeduser BIGINT 19 √ null
user.id graditemhist_log2_fkR
courseid BIGINT 19 √ null
course.id graditemhist_cou2_fkR
categoryid BIGINT 19 √ null
grade_categories.id graditemhist_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 graditemhist_sca2_fkR
outcomeid BIGINT 19 √ null
grade_outcomes.id graditemhist_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
hidden BIGINT 19 0
locked BIGINT 19 0
locktime BIGINT 19 0
needsupdate BIGINT 19 0
display BIGINT 19 0
decimals BIT 1 √ null
weightoverride BIT 1 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
graditemhist_act2_ix Performance Asc action
graditemhist_cat4_ix Performance Asc categoryid
graditemhist_cou4_ix Performance Asc courseid
graditemhist_log4_ix Performance Asc loggeduser
graditemhist_old4_ix Performance Asc oldid
graditemhist_out4_ix Performance Asc outcomeid
graditemhist_sca4_ix Performance Asc scaleid
graditemhist_tim2_ix Performance Asc timemodified

Relationships

Close relationships within degrees of separation