Totara Learn 11
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
Org Competencies Table Schema (org_competencies)
Description
Track competencies assigned to a particular organisation
org_competencies table columns
Related columns
Constraint
Comments
Search:
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
id
BIGINT
19
√
null
organisationid
BIGINT
19
null
org
.id
orgcomp_org2_fk
R
competencyid
BIGINT
19
√
null
comp
.id
orgcomp_com2_fk
R
templateid
BIGINT
19
√
null
timecreated
BIGINT
19
null
usermodified
BIGINT
19
null
linktype
TINYINT
3
0
Showing 1 to 7 of 7 entries
Table contained
-1
rows
org_competencies table indexes
Search:
Constraint Name
Type
Sort
Column(s)
PRIMARY
Primary key
Asc
id
orgcomp_com_ix
Performance
Asc
competencyid
orgcomp_org_ix
Performance
Asc
organisationid
Showing 1 to 3 of 3 entries
org_competencies table relationships
Close relationships within degrees of separation
One
Two degrees
One implied
Two implied