Notifications Table Schema (notifications)


Description

Stores all notifications

notifications table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
message_popup_notifications.notificationid messpopunoti_not2_fk R
useridfrom BIGINT 19 null
useridto BIGINT 19 null
user.id noti_use3_fk R
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()

Table contained -1 rows

notifications table indexes

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

notifications table relationships

Close relationships within degrees of separation