Tigase Unified Archive component uses few tables and stored procedures and it shares same tables with Tigase Message Archiving component - in fact it uses same tables with addition of few fields.
Due to that used tables are prefixed with tig_ma_ and tig_ua_, but used stored procedures are prefixed with Tig_UA_.
This table stores all jids related to stored messages and events, 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. (Not exists in 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 events.
| Field | Description | Comments |
|---|---|---|
stable_id | ID of a stored event | Unique with matching |
owner_id | ID of a bare JID of a event owner | References |
buddy_id | ID of a bare JID of a event recipient/sender (different than owner) | References |
ts | Timestamp of a event | Timestamp of archivization or delayed delivery |
body | Body of a message | |
msg | Serialized event | |
stanza_id | ID attribute of archived event | |
is_ref | Marks if message is a reference to other message | |
ref_stable_id |
| |
item-type | Event type | May be one of: |
offline | Marks offline events | 0 - not offline 1 - offline and will be stored after delivery 2 - offline and will be removed after delivery |
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 | ID of a stored event | Unique with matching |
tag_id | Database ID of a tag | References |
Table stores resource of a sender of a message saved to the offline storage.
| Field | Description | Comments |
|---|---|---|
stable_id | ID of a stored event | Unique with matching |
owner_id | ID of a bare JID of a event owner | References |
buddy_res | Resource part of a event recipient/sender JID |
Table stores jingle metadata from a message saved to the storage.
| Field | Description | Comments |
|---|---|---|
stable_id | ID of a stored event | Unique with matching |
owner_id | ID of a bare JID of a event owner | References |
direction | Direction of event | 0 - sent by owner 1 - recevied by owner |
offline | Marks call to offline | 1 if was to offline user |
sid | SID of a Jingle call | |
action | Jingle action | |
reason | Reason of action | Usually for termination/decline events |
Table stores jingle metadata from a message saved to the storage.
| Field | Description | Comments |
|---|---|---|
stable_id | ID of a stored event | Unique with matching |
owner_id | ID of a bare JID of a event owner | References |
url_hash | SHA1 of the URL | |
url | URL to download sent file | |
name | File name | If available |
description | Description of a file | If available |
media_type | Type of a file (MIMETYPE) | If available |
size | File size | If available |