Tigase PubSub component uses few tables and stored procedures. To make it easier to identify tables and stored procedures
used by PubSub component they are prefixed with tig_pubsub_
.
This table stores all jids for which PubSub component contains nodes.
Field | Description | Comments |
---|---|---|
service_id |
Database ID of a service JID |
|
service_jid |
Value of a service JID |
|
service_jid_sha1 |
SHA1 value of lowercased service JID |
Used for proper bare JID comparison during lookup. (N/A to PostgreSQL schema) |
This table stores all jids related to PubSub nodes, ie. subscriber, affiliates, creators, publishers, etc.
Field | Description | Comments |
---|---|---|
jid_id |
Database ID of a bare 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) |
Table stores nodes tree structure and node configuration.
Field | Description | Comments |
---|---|---|
node_id |
Database ID of a node |
|
service_id |
ID of service JID |
References |
name |
Name of PubSub node |
|
name_sha1 |
SHA1 of PubSub node name |
Used for indexing and faster lookup. (N/A to PostgreSQL schema) |
type |
Type of PubSub node |
0 - collection 1 - leaf |
title |
Title of PubSub node |
|
description |
Description of a node |
|
creator_id |
ID of JID of creator |
References |
creation_date |
Timestamp of creation time |
|
configuration |
Serialized configuration of PubSub node |
|
collection_id |
Points collection (parent node) |
References |
Table stores affiliations between PubSub nodes and jids.
Field | Description | Comments |
---|---|---|
node_id |
ID of a node |
References |
jid_id |
ID of a user JID |
References |
affiliation |
Affiliation value |
Table stores subscriptions of jids to PubSub nodes.
Field | Description | Comments |
---|---|---|
node_id |
ID of a node |
References |
jid_id |
ID of a user JID |
References |
subscription |
Subscription value |
|
subscription_id |
Id of a subscription |
Table stores items of PubSub nodes.
Field |
Description |
Comments |
node_id |
ID of a node |
References |
id |
Id of an items |
|
id_sha1 |
SHA1 of item id |
Indexed and used for faster lookup (N/A to PostgreSQL schema) |
creation_date |
Creation date |
|
publisher_id |
ID of publisher JID |
References |
update_date |
Timestamp of last item modification |
|
data |
Item payload |