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 1
evidencecount int8 19 0
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
totarasync int2 5 0

Indexes

Constraint Name Type Sort Column(s)
app_comp_id3_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

Close relationships within degrees of separation