# message_read

0 rows

### Description

Stores all messages that have been read

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | BIGINT | 19 |  | √ | null |  |  |
useridfrom | BIGINT | 19 |  |  | 0 |  |
user.id | message_read_erd_from_user_idR
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 |  |  |
timeread | BIGINT | 19 |  |  | 0 |  |  |
timeuserfromdeleted | BIGINT | 19 |  |  | 0 |  |  |
timeusertodeleted | BIGINT | 19 |  |  | 0 |  |  |
component | VARCHAR | 100 | √ |  | null |  |  |
eventtype | VARCHAR | 100 | √ |  | null |  |  |

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

### Relationships