Competency Table Schema (competency)


Description

This table contains the master record of each competency in a framework

competency table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
competency_coursecomp.competencyid compcour_com2_fk R
competency_modulecomp.competencyid compmodu_com2_fk R
competency_plancomp.competencyid compplan_com_fk R
competency_relatedcomp.competencyid comprela_com_fk R
competency_templatecomp.competencyid comptemp_com2_fk R
competency_usercomp.competencyid compuser_com_fk R
competency_usercompcourse.competencyid compuser_com2_fk R
competency_usercompplan.competencyid compuser_com3_fk R
competency_userevidencecomp.competencyid compuser_com4_fk R
shortname VARCHAR 100 √ null

Shortname of a competency
description LONGTEXT 2147483647 √ null

Description of a single competency
descriptionformat SMALLINT 5 0

The format of the description field
idnumber VARCHAR 100 √ null
competencyframeworkid BIGINT 19 null
competency_framework.id comp_com_fk R

The framework this competency relates to.
parentid BIGINT 19 0

The parent competency.
path VARCHAR 255

Used to speed up queries that use an entire branch of the tree. Looks like /5/34/54.
sortorder BIGINT 19 null

Relative sort order within the branch
ruletype VARCHAR 100 √ null
ruleoutcome TINYINT 3 0
ruleconfig LONGTEXT 2147483647 √ null
scaleid BIGINT 19 √ null
scale.id Implied Constraint R
scaleconfiguration LONGTEXT 2147483647 √ null
timecreated BIGINT 19 null

The time this competency was created.
timemodified BIGINT 19 null

The time this competency was last modified.
usermodified BIGINT 19 √ null

The user who last modified this competency

Table contained -1 rows

competency table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
comp_comidn_uix Must be unique Asc/Asc competencyframeworkid + idnumber
comp_rul_ix Performance Asc ruleoutcome

competency table relationships

Close relationships within degrees of separation