Totara Learn 11
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
Comp Template Table Schema (comp_template)
Description
A template is used to group competencies
comp_template table columns
Related columns
Constraint
Comments
Search:
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
id
BIGINT
19
√
null
comp_template_assignment
.templateid
comptempassi_tem2_fk
R
frameworkid
BIGINT
19
null
comp_framework
.id
comptemp_fra2_fk
R
fullname
LONGTEXT
2147483647
null
shortname
VARCHAR
100
√
null
description
LONGTEXT
2147483647
√
null
visible
TINYINT
3
null
competencycount
BIGINT
19
null
timecreated
BIGINT
19
null
timemodified
BIGINT
19
null
usermodified
BIGINT
19
null
Showing 1 to 10 of 10 entries
Table contained
-1
rows
comp_template table indexes
Search:
Constraint Name
Type
Sort
Column(s)
PRIMARY
Primary key
Asc
id
comptemp_fra_ix
Performance
Asc
frameworkid
Showing 1 to 2 of 2 entries
comp_template table relationships
Close relationships within degrees of separation
One
Two degrees
