app_grade_items

0 rows


Description

This table keeps information about gradeable items (ie columns). If an activity (eg an assignment or quiz) has multiple grade_items associated with it (eg several outcomes or numerical grades), then there will be a corresponding multiple number of ro

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_grade_items_id_seq'::regclass)
app_grade_grades.itemid Defined in XMLR
app_grade_grades_history.itemid Defined in XMLR
app_grade_import_values.itemid Defined in XMLR
app_grade_items_history.oldid Defined in XMLR
app_ltiservice_gradebookservices.gradeitemid Defined in XMLR
courseid int8 19 √ null
app_course.id Defined in XMLR
categoryid int8 19 √ null
app_grade_categories.id Defined in XMLR
itemname varchar 255 √ null
itemtype varchar 30 ''::character varying
itemmodule varchar 30 √ null
iteminstance int8 19 √ null
itemnumber int8 19 √ null
iteminfo text 2147483647 √ null
idnumber varchar 255 √ null
calculation text 2147483647 √ null
gradetype int2 5 1
grademax numeric 10,5 100
grademin numeric 10,5 0
scaleid int8 19 √ null
app_scale.id Defined in XMLR
outcomeid int8 19 √ null
app_grade_outcomes.id Defined in XMLR
gradepass numeric 10,5 0
multfactor numeric 10,5 1.0
plusfactor numeric 10,5 0
aggregationcoef numeric 10,5 0
aggregationcoef2 numeric 10,5 0
sortorder int8 19 0
display int8 19 0
decimals int2 5 √ null
hidden int8 19 0
locked int8 19 0
locktime int8 19 0
needsupdate int8 19 0
weightoverride int2 5 0
timecreated int8 19 √ null
timemodified int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
app_graditem_id_pk Primary key Asc id
app_graditem_cat_ix Performance Asc categoryid
app_graditem_cou_ix Performance Asc courseid
app_graditem_gra_ix Performance Asc gradetype
app_graditem_idncou_ix Performance Asc/Asc idnumber + courseid
app_graditem_itenee_ix Performance Asc/Asc itemtype + needsupdate
app_graditem_locloc_ix Performance Asc/Asc locked + locktime
app_graditem_out_ix Performance Asc outcomeid
app_graditem_sca_ix Performance Asc scaleid

Relationships

Close relationships within degrees of separation