Comp Table Schema (comp)


Description

Totara competencies

comp table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
comp.parentid comp_par2_fk R
comp_criteria.competencyid compcrit_com2_fk R
comp_criteria_record.competencyid compcritreco_com2_fk R
comp_record.competencyid compreco_com2_fk R
comp_record_history.competencyid comprecohist_com2_fk R
comp_template_assignment.instanceid comptempassi_ins2_fk R
comp_type_info_data.competencyid comptypeinfodata_com2_fk R
dp_plan_competency_assign.competencyid dpplancompassi_com2_fk R
org_competencies.competencyid orgcomp_com2_fk R
pos_competencies.competencyid poscomp_com2_fk R
shortname VARCHAR 100 √ null
description LONGTEXT 2147483647 √ null
idnumber VARCHAR 100 √ null
frameworkid BIGINT 19 null
comp_framework.id comp_fra2_fk R
path VARCHAR 255 √ null
parentid BIGINT 19 null
comp.id comp_par2_fk R
visible TINYINT 3 null
aggregationmethod TINYINT 3 null
proficiencyexpected BIGINT 19 null
evidencecount BIGINT 19 null
timecreated BIGINT 19 null
timemodified BIGINT 19 null
usermodified BIGINT 19 null
fullname VARCHAR 1024 √ null
depthlevel BIGINT 19 √ null
typeid BIGINT 19 0
comp_type.id comp_typ2_fk R
sortthread VARCHAR 255 √ null
totarasync BIT 1 0

Totara sync flag from totara_sync

Table contained -1 rows

comp table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
comp_fra_ix Performance Asc frameworkid
comp_par_ix Performance Asc parentid
comp_typ_ix Performance Asc typeid

comp table relationships

Close relationships within degrees of separation