Message Read Table Schema (message_read)


Stores all messages that have been read

message_read table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
useridfrom BIGINT 19 0 messread_use_fk R
useridto BIGINT 19 0 messread_use2_fk R
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
timeread BIGINT 19 0
timeuserfromdeleted BIGINT 19 0
timeusertodeleted BIGINT 19 0
component VARCHAR 100 null
eventtype VARCHAR 100 null

Table contained -1 rows

message_read table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
messread_nottim_ix Performance Asc/Asc notification + timeread
messread_usetimnot2_ix Performance Asc/Asc/Asc useridto + timeusertodeleted + notification
messread_usetimnot_ix Performance Asc/Asc/Asc useridfrom + timeuserfromdeleted + notification
messread_useusetimtim_ix Performance Asc/Asc/Asc/Asc useridfrom + useridto + timeuserfromdeleted + timeusertodeleted

message_read table relationships