app_course_completion_history

0 rows


Description

Course completion history archive

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_course_completion_history_id_seq'::regclass)
courseid int8 19 null
app_course.id Defined in XML R
userid int8 19 null
app_user.id Defined in XML R
timecompleted int8 19 null
grade numeric 10,5 null
grademax numeric 10,5 null
grademin numeric 10,5 null

Indexes

Constraint Name Type Sort Column(s)
app_courcomphist_id_pk Primary key Asc id
app_courcomphist_cou_ix Performance Asc courseid
app_courcomphist_use_ix Performance Asc userid
app_courcomphist_usecou_ix Performance Asc/Asc userid + courseid

Relationships