app_cohort_msg_queue

0 rows


Description

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

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_cohort_msg_queue_id_seq'::regclass)
cohortid int8 19 null
app_cohort.id Defined in XML R
userid int8 19 null
app_user.id Defined in XML R
action varchar 255 ''::character varying
processed int8 19 0
timecreated int8 19 √ null
timemodified int8 19 √ null
modifierid int8 19 √ null
app_user.id Defined in XML R

Indexes

Constraint Name Type Sort Column(s)
app_cohomsgqueu_id_pk Primary key Asc id
app_cohomsgqueu_coh_ix Performance Asc cohortid
app_cohomsgqueu_cohact_ix Performance Asc/Asc cohortid + action
app_cohomsgqueu_mod_ix Performance Asc modifierid
app_cohomsgqueu_use_ix Performance Asc userid

Relationships

Close relationships within degrees of separation