0 rows


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


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 competency_relatedcomp_erd_competencyR
competency_relatedcomp.relatedcompetencyid comprela_rel2_fkR
competency_templatecomp.competencyid competency_templatecomp_erd_competencyR
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_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 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 comp_use2_fkR

The user who last modified this competency


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