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

Close relationships within degrees of separation