0 rows


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


Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_competency_id_seq'::regclass)
app_competency_coursecomp.competencyid Defined in XMLR
app_competency_modulecomp.competencyid Defined in XMLR
app_competency_templatecomp.competencyid Defined in XMLR
shortname varchar 100 null
description text 2147483647 null
descriptionformat int2 5 0
idnumber varchar 100 null
competencyframeworkid int8 19 null
parentid int8 19 0
path varchar 255 ''::character varying
sortorder int8 19 null
ruletype varchar 100 null
ruleoutcome int2 5 0
ruleconfig text 2147483647 null
scaleid int8 19 null
scaleconfiguration text 2147483647 null
timecreated int8 19 null
timemodified int8 19 null
usermodified int8 19 null


Constraint Name Type Sort Column(s)
app_comp_id_pk Primary key Asc id
app_comp_comidn_uix Must be unique Asc/Asc competencyframeworkid + idnumber
app_comp_rul_ix Performance Asc ruleoutcome