Cohort Msg Queue Table Schema (cohort_msg_queue)


Description

A table to store cohort member join/delete notifications, to be sent at the next cron run.

cohort_msg_queue table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
cohortid BIGINT 19 null
cohort.id cohomsgqueu_coh2_fk R
userid BIGINT 19 null
user.id cohomsgqueu_use2_fk R
action VARCHAR 255
processed BIGINT 19 0
timecreated BIGINT 19 √ null
timemodified BIGINT 19 √ null
modifierid BIGINT 19 √ null
user.id cohomsgqueu_mod2_fk R

Table contained -1 rows

cohort_msg_queue table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
cohomsgqueu_coh_ix Performance Asc cohortid
cohomsgqueu_cohact_ix Performance Asc/Asc cohortid + action
cohomsgqueu_mod_ix Performance Asc modifierid
cohomsgqueu_use_ix Performance Asc userid

cohort_msg_queue table relationships

Close relationships within degrees of separation