Table stores room messages history.
Field | Description | Comments |
---|---|---|
room_jid |
Room JID |
|
room_jid_sha1 |
SHA1 value of lowercased room JID |
Used for proper bare JID comparison during lookup. (Not exists in PostgreSQL schema) |
event_type |
For future use, if we decide to store other events as well. |
|
ts |
Timestamp of a message |
|
sender_jid |
JID of a sender |
|
sender_nickname |
Nickname of a message sender |
|
body |
Body of a message |
|
public_event |
Mark public events |
|
msg |
Serialized message |