Tigase database structure (1), tigase database structure

Tigase database structure (1), tigase database structure

There are many tables in the Tigase database. The most important tables are three: tig_users, tig_nodes, and tig_pairs.

1. tig_users

Tig_users stores user information, including uid (primary key, user ID), user_id (user name), usr_pw (User Password), and other fields.

2. tig_nodes

Tig_nodes is used to store node information (used to express data in layers), including nid (primary key, node ID), parent_nid (parent node ID), uid (User ID ), node (node type) five fields. Each uid corresponds to five nodes: root, offline, privacy, invisible, and msgoffline. The following are the five nodes corresponding to the user whose uid is 14.

Its structure is as follows:

Root -- privacy -- offline

|

Invisible msgoffline

3. tig_pairs

Tig_pairs does not have a primary key and stores the specific data of a node in the form of (key, value. User Data in tig_pairs of uid 14 is as follows:

The pval field is stored in XML format. The meaning of each row is as follows:

(1) Row 1st is privacy-list, which corresponds to the invisible node in tig_nodes. What does it mean;

(2) Row 3 is roster, which corresponds to the root node in tig_nodes and stores the user's friend list;

(3) Line 3-5 is messages, which corresponds to the msgoffline node in tig_nodes, that is, offline information. This indicates that the user has three offline messages not received.

 

This article references: http://www.tigase.org/content/tigase-db-schema-explained

1. The database system is a computer system that uses the database technology. The database system consists of a database, and ().

C A D B C B

1. From the user's perspective, what architecture does the database system have?

From the perspective of database end users, the structure of the database system is divided into single-user structure, master-slave structure, distributed structure, customer/Server, Browser/Application Server/Database Server multi-layer structure. This is the external database architecture.
The physical storage structure, logical storage structure, memory structure, and instance process structure. This is an internal architecture.