0 rows


Record of competency proficiency of a user


Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_totara_competency_achievement_id_seq'::regclass)
app_totara_competency_achievement_via.comp_achievement_id Defined in XMLR
competency_id int8 19 null Defined in XMLR
user_id int8 19 null Defined in XMLR
assignment_id int8 19 null Defined in XMLR
scale_value_id int8 19 null Defined in XMLR
proficient int2 5 null
status int2 5 null
time_created int8 19 null
time_status int8 19 null
time_proficient int8 19 null
time_scale_value int8 19 null
last_aggregated int8 19 null


Constraint Name Type Sort Column(s)
app_totacompachi_id_pk Primary key Asc id
app_totacompachi_ass_ix Performance Asc assignment_id
app_totacompachi_com_ix Performance Asc competency_id
app_totacompachi_comuse_ix Performance Asc/Asc competency_id + user_id
app_totacompachi_sca_ix Performance Asc scale_value_id
app_totacompachi_use_ix Performance Asc user_id