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 XML R
app_comp_criteria.competencyid Defined in XML R
app_comp_criteria_record.competencyid Defined in XML R
app_comp_record.competencyid Defined in XML R
app_comp_record_history.competencyid Defined in XML R
app_comp_template_assignment.instanceid Defined in XML R
app_comp_type_info_data.competencyid Defined in XML R
app_dp_plan_competency_assign.competencyid Defined in XML R
app_dp_plan_competency_value.competency_id Defined in XML R
app_org_competencies.competencyid Defined in XML R
app_pathway_manual_rating.competency_id Defined in XML R
app_pathway_perform_rating.competency_id Defined in XML R
app_pos_competencies.competencyid Defined in XML R
app_totara_competency_achievement.competency_id Defined in XML R
app_totara_competency_aggregation_queue.competency_id Defined in XML R
app_totara_competency_assignment_users.competency_id Defined in XML R
app_totara_competency_assignments.competency_id Defined in XML R
app_totara_competency_configuration_change.competency_id Defined in XML R
app_totara_competency_configuration_history.competency_id Defined in XML R
app_totara_competency_pathway.competency_id Defined in XML R
app_totara_competency_scale_aggregation.competency_id Defined in XML R
shortname varchar 100 √ null
description text 2147483647 √ null
idnumber varchar 100 √ null
frameworkid int8 19 null
app_comp_framework.id Defined in XML R
path varchar 255 √ null
parentid int8 19 null
app_comp.id Defined in XML R
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 XML R
sortthread varchar 255 √ null
totarasync int2 5 0
copy_op_id int8 19 0

Indexes

Constraint Name Type Sort Column(s)
app_comp_id2_pk Primary key Asc id
app_comp_cop_ix Performance Asc copy_op_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