app_grade_grades_history

0 rows


Description

History table

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_grade_grades_history_id_seq'::regclass)
action int8 19 0
oldid int8 19 null
app_grade_grades.id Defined in XML R
source varchar 255 √ null
timemodified int8 19 √ null
loggeduser int8 19 √ null
app_user.id Defined in XML R
itemid int8 19 null
app_grade_items.id Defined in XML R
userid int8 19 null
app_user.id Defined in XML R
rawgrade numeric 10,5 √ null
rawgrademax numeric 10,5 100
rawgrademin numeric 10,5 0
rawscaleid int8 19 √ null
app_scale.id Defined in XML R
usermodified int8 19 √ null
app_user.id Defined in XML R
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

Indexes

Constraint Name Type Sort Column(s)
app_gradgradhist_id_pk Primary key Asc id
app_gradgradhist_act_ix Performance Asc action
app_gradgradhist_ite_ix Performance Asc itemid
app_gradgradhist_log_ix Performance Asc loggeduser
app_gradgradhist_old_ix Performance Asc oldid
app_gradgradhist_raw_ix Performance Asc rawscaleid
app_gradgradhist_tim_ix Performance Asc timemodified
app_gradgradhist_use2_ix Performance Asc usermodified
app_gradgradhist_use_ix Performance Asc userid
app_gradgradhist_useitetim_ix Performance Asc/Asc/Asc userid + itemid + timemodified

Relationships

Close relationships within degrees of separation