Table tig_pubsub_nodes

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 service_id from tig_pubsub_service_jids

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 jid_id from tig_pubsub_jids

creation_date

Timestamp of creation time

  

configuration

Serialized configuration of PubSub node

  

collection_id

Points collection (parent node)

References node_id from tig_pubsub_nodes
Prev  Up  Next
  Home