app_grade_outcomes_history

0 rows


Description

History table

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_grade_outcomes_history_id_seq'::regclass)
action int8 19 0
oldid int8 19 null
app_grade_outcomes.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
shortname varchar 255 ''::character varying
fullname text 2147483647 null
scaleid int8 19 null
app_scale.id Defined in XMLR
description text 2147483647 null
descriptionformat int2 5 0

Indexes

Constraint Name Type Sort Column(s)
app_gradoutchist_id_pk Primary key Asc id
app_gradoutchist_act_ix Performance Asc action
app_gradoutchist_cou_ix Performance Asc courseid
app_gradoutchist_log_ix Performance Asc loggeduser
app_gradoutchist_old_ix Performance Asc oldid
app_gradoutchist_sca_ix Performance Asc scaleid
app_gradoutchist_tim_ix Performance Asc timemodified

Relationships