app_message_user_actions

0 rows


Description

Stores all per-user actions on individual messages

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_message_user_actions_id_seq'::regclass)
userid int8 19 null
app_user.id Defined in XMLR
messageid int8 19 null
app_messages.id Defined in XMLR
action int8 19 null
timecreated int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_messuseracti_id_pk Primary key Asc id
app_messuseracti_mes_ix Performance Asc messageid
app_messuseracti_use_ix Performance Asc userid
app_messuseracti_usemesact_uix Must be unique Asc/Asc/Asc userid + messageid + action

Relationships