Message Table Schema (message)


Stores all unread messages

message table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
message_metadata.messageid Implied Constraint R
message_metadata.messagereadid Implied Constraint R
message_popup.messageid Implied Constraint R
reminder_sent.messageid Implied Constraint R
useridfrom BIGINT 19 0
useridto BIGINT 19 0
subject LONGTEXT 2147483647 null

The message subject

fullmessage LONGTEXT 2147483647 null
fullmessageformat SMALLINT 5 0

The format of the full message

fullmessagehtml LONGTEXT 2147483647 null

html format of message

smallmessage LONGTEXT 2147483647 null

Smal version of message (eg sms)

notification BIT 1 0
contexturl LONGTEXT 2147483647 null

If this message is a notification of an event contexturl should contain a link to view this event. For example if its a notification of a forum post contexturl should contain a link to the forum post.

contexturlname LONGTEXT 2147483647 null

Display text for the contexturl

timecreated BIGINT 19 0
timeuserfromdeleted BIGINT 19 0
timeusertodeleted BIGINT 19 0
component VARCHAR 100 null
eventtype VARCHAR 100 null

Table contained -1 rows

message table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
mess_usetimnot2_ix Performance Asc/Asc/Asc useridto + timeusertodeleted + notification
mess_usetimnot_ix Performance Asc/Asc/Asc useridfrom + timeuserfromdeleted + notification
mess_useusetimtim_ix Performance Asc/Asc/Asc/Asc useridfrom + useridto + timeuserfromdeleted + timeusertodeleted

message table relationships