app_totara_competency_pathway_achievement

0 rows


Description

Record of scale value achieved by a user via a pathway

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_totara_competency_pathway_achievement_id_seq'::regclass)
app_totara_competency_achievement_via.pathway_achievement_id Defined in XMLR
pathway_id int8 19 null
app_totara_competency_pathway.id Defined in XMLR
user_id int8 19 null
app_user.id Defined in XMLR
scale_value_id int8 19 √ null
app_comp_scale_values.id Defined in XMLR
date_achieved int8 19 √ null
last_aggregated int8 19 √ null
status int2 5 0
related_info text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
app_totacomppathachi_id_pk Primary key Asc id
app_totacomppathachi_pat_ix Performance Asc pathway_id
app_totacomppathachi_patuse_ix Performance Asc/Asc/Asc pathway_id + user_id + status
app_totacomppathachi_sca_ix Performance Asc scale_value_id
app_totacomppathachi_use_ix Performance Asc user_id

Relationships

Close relationships within degrees of separation