app_totara_competency_aggregation_queue

0 rows


Description

Queuing table to hold aggregations to process

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_totara_competency_aggregation_queue_id_seq'::regclass)
user_id int8 19 null
app_user.id Defined in XMLR
competency_id int8 19 null
app_comp.id Defined in XMLR
has_changed int2 5 0
process_key varchar 255 null
update_operation_name varchar 255 null

Indexes

Constraint Name Type Sort Column(s)
app_totacompaggrqueu_id_pk Primary key Asc id
app_totacompaggrqueu_com_ix Performance Asc competency_id
app_totacompaggrqueu_pro_ix Performance Asc process_key
app_totacompaggrqueu_use_ix Performance Asc user_id
app_totacompaggrqueu_usecom_ix Performance Asc/Asc user_id + competency_id

Relationships