app_comp

0 rows


Description

Totara competencies

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_comp_id_seq'::regclass)
app_comp.parentid Defined in XMLR
app_comp_criteria.competencyid Defined in XMLR
app_comp_criteria_record.competencyid Defined in XMLR
app_comp_record.competencyid Defined in XMLR
app_comp_record_history.competencyid Defined in XMLR
app_comp_template_assignment.instanceid Defined in XMLR
app_comp_type_info_data.competencyid Defined in XMLR
app_dp_plan_competency_assign.competencyid Defined in XMLR
app_org_competencies.competencyid Defined in XMLR
app_pos_competencies.competencyid Defined in XMLR
shortname varchar 100 null
description text 2147483647 null
idnumber varchar 100 null
frameworkid int8 19 null
app_comp_framework.id Defined in XMLR
path varchar 255 null
parentid int8 19 null
app_comp.id Defined in XMLR
visible int2 5 null
aggregationmethod int2 5 null
proficiencyexpected int8 19 null
evidencecount int8 19 null
timecreated int8 19 null
timemodified int8 19 null
usermodified int8 19 null
fullname varchar 1024 null
depthlevel int8 19 null
typeid int8 19 0
app_comp_type.id Defined in XMLR
sortthread varchar 255 null

Indexes

Constraint Name Type Sort Column(s)
app_comp_id_pk Primary key Asc id
app_comp_fra_ix Performance Asc frameworkid
app_comp_par_ix Performance Asc parentid
app_comp_typ_ix Performance Asc typeid

Relationships