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
contextid BIGINT 19 null
context.id Implied ConstraintR
idnumber VARCHAR 100 null
description LONGTEXT 2147483647 null
descriptionformat SMALLINT 5 0
scaleid BIGINT 19 null
scale.id Implied ConstraintR
scaleconfiguration LONGTEXT 2147483647 null
visible TINYINT 3 1
taxonomies VARCHAR 255
timecreated BIGINT 19 null
timemodified BIGINT 19 null
usermodified BIGINT 19 null

Indexes

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

Relationships