Table tig_ma_msgs

Table stores archived messages.

Field Description Comments

stable_id

Database ID of a message

Unique with matching owner_id

owner_id

ID of a bare JID of a message owner

References jid_id from tig_ma_jids

buddy_id

ID of a bare JID of a message recipient/sender (different than owner)

References jid_id from tig_ma_jids

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

stable_id of referenced message