notifications

0 rows


Description

Stores all notifications

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
message_popup_notifications.notificationid messpopunoti_not2_fkR
useridfrom BIGINT 19 null
useridto BIGINT 19 null
user.id noti_use2_fkR
subject LONGTEXT 2147483647 null

The message subject

fullmessage LONGTEXT 2147483647 null
fullmessageformat BIT 1 0
fullmessagehtml LONGTEXT 2147483647 null
smallmessage LONGTEXT 2147483647 null
component VARCHAR 100 null
eventtype VARCHAR 100 null
contexturl LONGTEXT 2147483647 null
contexturlname LONGTEXT 2147483647 null
timeread BIGINT 19 null
timecreated BIGINT 19 null
customdata LONGTEXT 2147483647 null

Custom data to be passed to the message processor. Must be serialisable using json_encode()

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
noti_tim2_ix Performance Asc timeread
noti_tim_ix Performance Asc timecreated
noti_use2_ix Performance Asc useridto
noti_use_ix Performance Asc useridfrom

Relationships