# competency

0 rows

### Description

This table contains the master record of each competency in a framework

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | BIGINT | 19 |  | √ | null |
competency_coursecomp.competencyid | compcour_com2_fkR
competency_modulecomp.competencyid | compmodu_com2_fkR
competency_plancomp.competencyid | competency_plancomp_erd_competencyR
competency_relatedcomp.competencyid | comprela_com2_fkR
competency_relatedcomp.relatedcompetencyid | comprela_rel2_fkR
competency_templatecomp.competencyid | comptemp_com2_fkR
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 |  |  | Shortname of a competency
description | LONGTEXT | 2147483647 | √ |  | null |  |  | Description of a single competency
descriptionformat | SMALLINT | 5 |  |  | 0 |  |  | The format of the description field
idnumber | VARCHAR | 100 | √ |  | null |  |  |
competencyframeworkid | BIGINT | 19 |  |  | null |  |
competency_framework.id | competency_erd_competency_frameworkR
| The framework this competency relates to.
parentid | BIGINT | 19 |  |  | 0 |  |  | The parent competency.
path | VARCHAR | 255 |  |  |  |  |  | Used to speed up queries that use an entire branch of the tree. Looks like /5/34/54.
sortorder | BIGINT | 19 |  |  | null |  |  | Relative sort order within the branch
ruletype | VARCHAR | 100 | √ |  | null |  |  |
ruleoutcome | TINYINT | 3 |  |  | 0 |  |  |
ruleconfig | LONGTEXT | 2147483647 | √ |  | null |  |  |
scaleid | BIGINT | 19 | √ |  | null |  |
scale.id | comp_sca2_fkR
scaleconfiguration | LONGTEXT | 2147483647 | √ |  | null |  |  |
timecreated | BIGINT | 19 |  |  | null |  |  | The time this competency was created.
timemodified | BIGINT | 19 |  |  | null |  |  | The time this competency was last modified.
usermodified | BIGINT | 19 | √ |  | null |  |
user.id | comp_use2_fkR
| The user who last modified this competency

### Indexes

Constraint Name | Type | Sort | Column(s)
--- | --- | --- | ---
PRIMARY | Primary key | Asc | id
comp_comidn_uix | Must be unique | Asc/Asc | competencyframeworkid + idnumber
comp_rul_ix | Performance | Asc | ruleoutcome
comp_sca_ix | Performance | Asc | scaleid
comp_use_ix | Performance | Asc | usermodified

### Relationships