app_prog_completion_history

0 rows


Description

Stores details of user’s program and course set completions history

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_prog_completion_history_id_seq'::regclass)
programid int8 19 0
app_prog.id Defined in XMLR
userid int8 19 0
app_user.id Defined in XMLR
coursesetid int8 19 0
app_prog_courseset.id Defined in XMLR
status int2 5 0
timestarted int8 19 0
timedue int8 19 0
timecompleted int8 19 0
recurringcourseid int8 19 0
app_course.id Defined in XMLR
organisationid int8 19 √ null
positionid int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
app_progcomphist_id_pk Primary key Asc id
app_progcomphist_cou2_ix Performance Asc coursesetid
app_progcomphist_cou_ix Performance Asc coursesetid
app_progcomphist_pro2_ix Performance Asc programid
app_progcomphist_pro_ix Performance Asc programid
app_progcomphist_rec2_ix Performance Asc recurringcourseid
app_progcomphist_rec_ix Performance Asc recurringcourseid
app_progcomphist_use2_ix Performance Asc userid
app_progcomphist_use_ix Performance Asc userid

Relationships

Close relationships within degrees of separation