Tigase Message Archiving component uses few tables and stored procedures. To make it easier to find them on database level they are prefixed with tig_ma_.
This table stores all jids related to stored messages, ie. from to and from attributes of archived stanzas.
| Field | Description | Comments |
|---|---|---|
jid_id | Database ID of a JID | |
jid | Value of a bare JID | |
jid_sha1 | SHA1 value of lowercased bare JID | Used for proper bare JID comparison during lookup. (N/A to PostgreSQL schema) |
domain | Domain part of a bare JID | Stored for easier lookup of messages owned by users of a particular domain |
Table stores archived messages.
| Field | Description | Comments |
|---|---|---|
stable_id | Database ID of a message | Unique with matching |
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 |
ts | Timestamp of a message | Timestamp of archivization or delayed delivery |
body | Body of a message | |
msg | Serialized message | |
stanza_id | ID attribute of archived message | |
is_ref | Marks if message is a reference to other message | |
ref_stable_id |
|
Table stores tags of archived messages. It stores one tag for many messages using tig_ma_msgs_tags to store relation between tag and a message.
| Field | Description | Comments |
|---|---|---|
tag_id | Database ID of a tag | |
owner_id | ID of a bare JID of a tag owner | ID of bare JID of owner for which messages with this tag were archived |
tag | Actual tag value |
Table stores relations between tags and archived messages with this tags.
| Field | Description | Comments |
|---|---|---|
msg_owner_id | ID of a bare JID of a tag owner | ID of bare JID of owner for which messages with this tag were archived |
msg_stable_id | Database ID of a message | Unique with matching |
tag_id | Database ID of a tag | References |