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.