app_comp_scale_values

3 rows


Description

The individual values that make up a competency scale

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_comp_scale_values_id_seq'::regclass)
app_comp_record.proficiency Defined in XMLR
app_comp_record_history.proficiency Defined in XMLR
app_comp_scale.defaultid Defined in XMLR
app_comp_scale.minproficiencyid Defined in XMLR
app_dp_plan_competency_assign.scalevalueid Defined in XMLR
app_dp_plan_competency_value.scale_value_id Defined in XMLR
app_pathway_criteria_group.scale_value_id Defined in XMLR
app_pathway_manual_rating.scale_value_id Defined in XMLR
app_pathway_perform_rating.scale_value_id Defined in XMLR
app_totara_competency_achievement.scale_value_id Defined in XMLR
app_totara_competency_assignments.minproficiencyid Defined in XMLR
app_totara_competency_pathway_achievement.scale_value_id Defined in XMLR
name text 2147483647 null
idnumber varchar 100 √ null
description text 2147483647 √ null
scaleid int8 19 null
app_comp_scale.id Defined in XMLR
numericscore numeric 10,5 √ null
sortorder int8 19 null
timemodified int8 19 null
usermodified int8 19 null
proficient int2 5 0

Indexes

Constraint Name Type Sort Column(s)
app_compscalvalu_id_pk Primary key Asc id
app_compscalvalu_sca_ix Performance Asc scaleid

Relationships

Close relationships within degrees of separation