competency_framework

0 rows


Description

List of competency frameworks.

Columns

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
context.id compfram_con2_fkR
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
scale.id compfram_sca2_fkR

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
user.id compfram_use2_fkR

The user who last modified this framework

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
compfram_con_ix Performance Asc contextid
compfram_idn_uix Must be unique Asc idnumber
compfram_sca_ix Performance Asc scaleid
compfram_use_ix Performance Asc usermodified

Relationships