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 3 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