competency

0 rows


Description

This table contains the master record of each competency in

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
competency_coursecomp.competencyid compcour_com2_fkR
competency_modulecomp.competencyid competency_modulecomp_erd_competencyR
competency_plancomp.competencyid competency_plancomp_erd_competencyR
competency_relatedcomp.competencyid competency_relatedcomp_erd_competencyR
competency_templatecomp.competencyid competency_templatecomp_erd_competencyR
competency_usercomp.competencyid competency_usercomp_erd_competencyR
competency_usercompcourse.competencyid competency_usercompcourse_erd_competencyR
competency_usercompplan.competencyid competency_usercompplan_erd_competencyR
competency_userevidencecomp.competencyid competency_userevidencecomp_erd_competencyR
shortname VARCHAR 100 null
description LONGTEXT 2147483647 null
descriptionformat SMALLINT 5 0
idnumber VARCHAR 100 null
competencyframeworkid BIGINT 19 null
competency_framework.id competency_erd_competency_frameworkR
parentid BIGINT 19 0
path VARCHAR 255
sortorder BIGINT 19 null
ruletype VARCHAR 100 null
ruleoutcome TINYINT 3 0
ruleconfig LONGTEXT 2147483647 null
scaleid BIGINT 19 null
scale.id Implied ConstraintR
scaleconfiguration LONGTEXT 2147483647 null
timecreated BIGINT 19 null
timemodified BIGINT 19 null
usermodified BIGINT 19 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
comp_comidn2_uix Must be unique Asc/Asc competencyframeworkid + idnumber
comp_rul2_ix Performance Asc ruleoutcome

Relationships