Table stores archived messages.
Field | Description | Comments |
---|---|---|
msg_id |
Database ID of a message |
|
owner_id |
ID of a bare JID of a message owner |
References |
buddy_id |
ID of a bare JID of a message recipient/sender (different than owner) |
References |
buddy_res |
Resource part of a message recipient/sender JID |
|
ts |
Timestamp of a message |
Timestamp of archivization or delayed delivery |
direction |
Direction of message |
0 - sent by owner 1 - received by owner |
type |
Message type |
Value of message |
body |
Body of a message |
|
msg |
Serialized message |
|
stanza_hash |
Hash of message parts |
It is used to make sure that message is stored only once |