app_grade_items_history

0 rows


Description

History of grade_items

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_grade_items_history_id_seq'::regclass)
action int8 19 0
oldid int8 19 null
app_grade_items.id Defined in XMLR
source varchar 255 null
timemodified int8 19 null
loggeduser int8 19 null
app_user.id 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
hidden int8 19 0
locked int8 19 0
locktime int8 19 0
needsupdate int8 19 0
display int8 19 0
decimals int2 5 null
weightoverride int2 5 0

Indexes

Constraint Name Type Sort Column(s)
app_graditemhist_id_pk Primary key Asc id
app_graditemhist_act_ix Performance Asc action
app_graditemhist_cat_ix Performance Asc categoryid
app_graditemhist_cou_ix Performance Asc courseid
app_graditemhist_log_ix Performance Asc loggeduser
app_graditemhist_old_ix Performance Asc oldid
app_graditemhist_out_ix Performance Asc outcomeid
app_graditemhist_sca_ix Performance Asc scaleid
app_graditemhist_tim_ix Performance Asc timemodified

Relationships