Totara Learn 12
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
Comp Template Assignment Table Schema (comp_template_assignment)
Description
Track competencies belonging to a template
comp_template_assignment table columns
Related columns
Constraint
Comments
Search:
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
id
BIGINT
19
√
null
templateid
BIGINT
19
null
comp_template
.id
comptempassi_tem2_fk
R
type
TINYINT
3
null
instanceid
BIGINT
19
null
comp
.id
comptempassi_ins2_fk
R
timecreated
BIGINT
19
null
usermodified
BIGINT
19
null
user
.id
comptempassi_use2_fk
R
Showing 1 to 6 of 6 entries
Table contained
-1
rows
comp_template_assignment table indexes
Search:
Constraint Name
Type
Sort
Column(s)
PRIMARY
Primary key
Asc
id
comptempassi_ins_ix
Performance
Asc
instanceid
comptempassi_tem_ix
Performance
Asc
templateid
comptempassi_use_ix
Performance
Asc
usermodified
Showing 1 to 4 of 4 entries
comp_template_assignment table relationships
Close relationships within degrees of separation
One
Two degrees
One implied
Two implied