app_totara_competency_assignment_user_logs

0 rows


Description

Keep a history of all changes regarding assigned users to competencies to be able to refer to it later, not meant to be cleared while related assignments exist

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_totara_competency_assignment_user_logs_id_seq'::regclass)
assignment_id int8 19 null
app_totara_competency_assignments.id Defined in XML R
user_id int8 19 null
app_user.id Defined in XML R
action int2 5 null
created_at int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_totacompassiuserlogs_id_pk Primary key Asc id
app_totacompassiuserlogs_ac_ix Performance Asc action
app_totacompassiuserlogs_as_ix Performance Asc assignment_id
app_totacompassiuserlogs_cr_ix Performance Asc created_at
app_totacompassiuserlogs_us_ix Performance Asc user_id

Relationships

Close relationships within degrees of separation