Competency Framework Table Schema (competency_framework)


List of competency frameworks.

competency_framework table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
competency.competencyframeworkid comp_com_fk R
shortname VARCHAR 100 null

Short name for the competency framework.

contextid BIGINT 19 null Implied Constraint R
idnumber VARCHAR 100 null

Unique idnumber for this competency framework.

description LONGTEXT 2147483647 null

Description of this competency framework

descriptionformat SMALLINT 5 0

The format of the description field

scaleid BIGINT 19 null Implied Constraint R

Scale used to define competency.

scaleconfiguration LONGTEXT 2147483647 null

Scale information.

visible TINYINT 3 1

Used to show/hide this competency framework.

taxonomies VARCHAR 255

Sequence of terms to use for each competency level.

timecreated BIGINT 19 null

The time this competency framework was created.

timemodified BIGINT 19 null

The time this competency framework was last modified.

usermodified BIGINT 19 null

The user who last modified this framework

Table contained -1 rows

competency_framework table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
compfram_idn_uix Must be unique Asc idnumber

competency_framework table relationships