message_user_actions

0 rows

Description

Stores all per-user actions on individual messages

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

BIGINT

19

√

null

userid

BIGINT

19

null

messuseracti_use2_fkR

messageid

BIGINT

19

null

messuseracti_mes2_fkR

action

BIGINT

19

null

timecreated

BIGINT

19

null

Showing 1 to 5 of 5 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
messuseracti_mes4_ix	Performance	Asc	messageid
messuseracti_use4_ix	Performance	Asc	userid
messuseracti_usemesact2_uix	Must be unique	Asc/Asc/Asc	userid + messageid + action

Showing 1 to 4 of 4 entries

Relationships

Close relationships within degrees of separation

One
Two degrees