Wp_terms classification info table-Wordpress database (2.6.2) #8

This is the eighth article in WordPress database research (2.6.2 ).ArticleThis article gives a detailed introduction to the wp_terms classification information table in the WordPress database, including the meanings of each field in the wp_terms classification information table, the associations with other data tables, and the index information. If you are not clear about the total relationship between the 10 data tables in the Wordpress blog system, please return to the first WordPress database introduction in this series of articles.

The wp_terms category table is one of the basic data tables of the Wordpress blog system. It stores the category information in the blog system, including the document category information, link category information, and tag information. For details about how to query the corresponding category information from the database, see "Introduction to database operations of classification information". The following describes the meaning of each field in the wp_terms category table, as shown in (this figure is from the Northwest University WordPress source code interpretation team:

Wp_terms classification table-Wordpress Database

In the Wordpress blog system, all the classification information "document classification, link classification, and tags" are stored in the above data tables. But how can we determine the type of the classification information? This is determined by the wp_term_taxonomy Category Table associated with the wp_terms category table. How is classification information associated with specific articles, links, and tags? For more information about this issue, see database operations for classified information.

Associations between wp_terms classification tables and other data tables:

The classification table and wp_term_taxonomy category table and wp_term_relationships category Association Table constitute the classification information storage carrier of the Wordpress blog system.

That is to say, in the Wordpress blog system, the wp_terms Category Table stores the category information. The wp_term_taxonomy category type table stores the category information, which determines that the classification Type in the wp_terms category table is the document category, it is also a link category, or a label. The wp_term_relationships category Association Table stores the association relationship between the category information and articles and links. For database operations on classification information between these data tables, see database operations on classification information.

Index information of wp_terms classification table:

Wp_terms-Wordpress Database

The purpose of listing the index information of the wp_terms classification table is to optimize your SQL statements based on the above index information when you develop the WordPress plug-in or compile a special function interface.

The above is a detailed description of the wp_terms classification table on the Jianfeng blog. If you have different opinions or do not understand anything, please leave a message for me. You are welcome to continue reading the next article in WordPress database research (2.6.2): wp_term_relationships Classification Association data table Introduction