grade_grades

0 rows


Description

grade_grades This table keeps individual grades for each us

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
grade_grades_history.oldid gradgradhist_old2_fkR
itemid BIGINT 19 null
grade_items.id gradgrad_ite2_fkR
userid BIGINT 19 null
user.id gradgrad_use3_fkR
rawgrade DECIMAL 10,5 √ null
rawgrademax DECIMAL 10,5 100.00000
rawgrademin DECIMAL 10,5 0.00000
rawscaleid BIGINT 19 √ null
scale.id gradgrad_raw2_fkR
usermodified BIGINT 19 √ null
user.id gradgrad_use4_fkR
finalgrade DECIMAL 10,5 √ null
hidden BIGINT 19 0
locked BIGINT 19 0
locktime BIGINT 19 0
exported BIGINT 19 0
overridden BIGINT 19 0
excluded BIGINT 19 0
feedback LONGTEXT 2147483647 √ null
feedbackformat BIGINT 19 0
information LONGTEXT 2147483647 √ null
informationformat BIGINT 19 0
timecreated BIGINT 19 √ null
timemodified BIGINT 19 √ null
aggregationstatus VARCHAR 10 unknown
aggregationweight DECIMAL 10,5 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
gradgrad_ite4_ix Performance Asc itemid
gradgrad_locloc2_ix Performance Asc/Asc locked + locktime
gradgrad_raw4_ix Performance Asc rawscaleid
gradgrad_use6_ix Performance Asc userid
gradgrad_use8_ix Performance Asc usermodified
gradgrad_useite2_uix Must be unique Asc/Asc userid + itemid

Relationships

Close relationships within degrees of separation