app_grade_categories_history

0 rows


Description

History of grade_categories

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_grade_categories_history_id_seq'::regclass)
action int8 19 0
oldid int8 19 null
app_grade_categories.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
parent int8 19 null
app_grade_categories.id Defined in XMLR
depth int8 19 0
path varchar 255 null
fullname varchar 255 ''::character varying
aggregation int8 19 0
keephigh int8 19 0
droplow int8 19 0
aggregateonlygraded int2 5 0
aggregateoutcomes int2 5 0
aggregatesubcats int2 5 0
hidden int2 5 0

Indexes

Constraint Name Type Sort Column(s)
app_gradcatehist_id_pk Primary key Asc id
app_gradcatehist_act_ix Performance Asc action
app_gradcatehist_cou_ix Performance Asc courseid
app_gradcatehist_log_ix Performance Asc loggeduser
app_gradcatehist_old_ix Performance Asc oldid
app_gradcatehist_par_ix Performance Asc parent
app_gradcatehist_tim_ix Performance Asc timemodified

Relationships