app_course_completions

0 rows


Description

Course completion records

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_course_completions_id_seq'::regclass)
app_dp_plan_course_assign.completionstatus Defined in XMLR
userid int8 19 0
course int8 19 0
organisationid int8 19 null
positionid int8 19 null
timeenrolled int8 19 0
timestarted int8 19 0
timecompleted int8 19 null
reaggregate int8 19 0
rpl varchar 255 null
rplgrade numeric 10,5 null
invalidatecache int2 5 0
status int2 5 0
renewalstatus int2 5 0

Indexes

Constraint Name Type Sort Column(s)
app_courcomp_id_pk Primary key Asc id
app_courcomp_cou_ix Performance Asc course
app_courcomp_sta_ix Performance Asc status
app_courcomp_tim_ix Performance Asc timecompleted
app_courcomp_use_ix Performance Asc userid
app_courcomp_usecou_uix Must be unique Asc/Asc userid + course

Relationships