competency

0 rows


Description

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

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
competency_coursecomp.competencyid compcour_com2_fkR
competency_modulecomp.competencyid competency_modulecomp_erd_competencyR
competency_plancomp.competencyid competency_plancomp_erd_competencyR
competency_relatedcomp.competencyid comprela_com2_fkR
competency_relatedcomp.relatedcompetencyid comprela_rel2_fkR
competency_templatecomp.competencyid comptemp_com2_fkR
competency_usercomp.competencyid competency_usercomp_erd_competencyR
competency_usercompcourse.competencyid competency_usercompcourse_erd_competencyR
competency_usercompplan.competencyid competency_usercompplan_erd_competencyR
competency_userevidencecomp.competencyid competency_userevidencecomp_erd_competencyR
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 competency_erd_competency_frameworkR

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 comp_sca2_fkR
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
user.id comp_use2_fkR

The user who last modified this competency

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
comp_sca_ix Performance Asc scaleid
comp_use_ix Performance Asc usermodified

Relationships

Close relationships within degrees of separation