app_totara_competency_achievement

0 rows


Description

Record of competency proficiency of a user

Columns

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
app_comp.id Defined in XMLR
user_id int8 19 null
app_user.id Defined in XMLR
assignment_id int8 19 null
app_totara_competency_assignments.id Defined in XMLR
scale_value_id int8 19 √ null
app_comp_scale_values.id 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

Indexes

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

Relationships

Close relationships within degrees of separation