Cohort Msg Queue Table Schema (cohort_msg_queue)


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 cohomsgqueu_coh2_fk R
userid BIGINT 19 null cohomsgqueu_use2_fk R
action VARCHAR 255
processed BIGINT 19 0
timecreated BIGINT 19 null
timemodified BIGINT 19 null
modifierid BIGINT 19 null 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