Competency Table Schema (competency)


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 10 null
competency_coursecomp.competencyid compcour_com2_fk R
competency_modulecomp.competencyid compmodu_com2_fk R
competency_plancomp.competencyid Implied Constraint R
competency_relatedcomp.competencyid Implied Constraint R
competency_templatecomp.competencyid comptemp_com2_fk R
competency_usercomp.competencyid Implied Constraint R
competency_usercompcourse.competencyid Implied Constraint R
competency_usercompplan.competencyid Implied Constraint R
competency_userevidencecomp.competencyid Implied Constraint R
shortname varchar 100 null

Shortname of a competency

description longtext 2147483647 null

Description of a single competency

descriptionformat smallint 4 0

The format of the description field

idnumber varchar 100 null
competencyframeworkid bigint 10 null

The framework this competency relates to.

parentid bigint 10 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 10 null

Relative sort order within the branch

ruletype varchar 100 null
ruleoutcome tinyint 2 0
ruleconfig longtext 2147483647 null
scaleid bigint 10 null Implied Constraint R
scaleconfiguration longtext 2147483647 null
timecreated bigint 10 null

The time this competency was created.

timemodified bigint 10 null

The time this competency was last modified.

usermodified bigint 10 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