0 rows


List of competency frameworks.


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

Short name for the competency framework.

contextid BIGINT 19 null Implied ConstraintR
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 ConstraintR

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


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