app_grade_grades

0 rows


Description

grade_grades This table keeps individual grades for each user and each item, exactly as imported or submitted by modules. The rawgrademax/min and rawscaleid are stored here to record the values at the time the grade was stored, because teachers migh

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_grade_grades_id_seq'::regclass)
app_grade_grades_history.oldid Defined in XMLR
itemid int8 19 null
app_grade_items.id Defined in XMLR
userid int8 19 null
app_user.id Defined in XMLR
rawgrade numeric 10,5 √ null
rawgrademax numeric 10,5 100
rawgrademin numeric 10,5 0
rawscaleid int8 19 √ null
app_scale.id Defined in XMLR
usermodified int8 19 √ null
app_user.id Defined in XMLR
finalgrade numeric 10,5 √ null
hidden int8 19 0
locked int8 19 0
locktime int8 19 0
exported int8 19 0
overridden int8 19 0
excluded int8 19 0
feedback text 2147483647 √ null
feedbackformat int8 19 0
information text 2147483647 √ null
informationformat int8 19 0
timecreated int8 19 √ null
timemodified int8 19 √ null
aggregationstatus varchar 10 'unknown'::character varying
aggregationweight numeric 10,5 √ null

Indexes

Constraint Name Type Sort Column(s)
app_gradgrad_id_pk Primary key Asc id
app_gradgrad_ite_ix Performance Asc itemid
app_gradgrad_locloc_ix Performance Asc/Asc locked + locktime
app_gradgrad_raw_ix Performance Asc rawscaleid
app_gradgrad_use2_ix Performance Asc usermodified
app_gradgrad_use_ix Performance Asc userid
app_gradgrad_useite_uix Must be unique Asc/Asc userid + itemid

Relationships

Close relationships within degrees of separation