Totara Learn 12
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
Prog Completion History Table Schema (prog_completion_history)
Description
Stores details of user's program and course set completions history
prog_completion_history table columns
Related columns
Constraint
Comments
Search:
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
id
BIGINT
19
√
null
programid
BIGINT
19
0
prog
.id
progcomphist_pro3_fk
R
userid
BIGINT
19
0
user
.id
progcomphist_use3_fk
R
coursesetid
BIGINT
19
0
prog_courseset
.id
progcomphist_cou3_fk
R
status
SMALLINT
5
0
timestarted
BIGINT
19
0
timedue
BIGINT
19
0
timecompleted
BIGINT
19
0
recurringcourseid
BIGINT
19
0
course
.id
progcomphist_rec3_fk
R
organisationid
BIGINT
19
√
null
org
.id
Implied Constraint
R
positionid
BIGINT
19
√
null
pos
.id
Implied Constraint
R
Showing 1 to 11 of 11 entries
Table contained
-1
rows
prog_completion_history table indexes
Search:
Constraint Name
Type
Sort
Column(s)
PRIMARY
Primary key
Asc
id
progcomphist_cou2_ix
Performance
Asc
coursesetid
progcomphist_cou_ix
Performance
Asc
coursesetid
progcomphist_pro2_ix
Performance
Asc
programid
progcomphist_pro_ix
Performance
Asc
programid
progcomphist_rec2_ix
Performance
Asc
recurringcourseid
progcomphist_rec_ix
Performance
Asc
recurringcourseid
progcomphist_use2_ix
Performance
Asc
userid
progcomphist_use_ix
Performance
Asc
userid
Showing 1 to 9 of 9 entries
prog_completion_history table relationships
Close relationships within degrees of separation
One
Two degrees
One implied
Two implied