| id |
BIGINT |
19 |
|
√ |
null |
|
|
|
| useridfrom |
BIGINT |
19 |
|
|
0 |
|
|
user.id
|
messread_use_fk R
|
|
|
| useridto |
BIGINT |
19 |
|
|
0 |
|
|
user.id
|
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 |
|
|
|
