Notifications Table Schema (notifications)


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