Wp_term_relationships classification relational table-Wordpress database (2.6.2) #9

This is the ninth article in WordPress database research (2.6.2 ).ArticleThis article provides a detailed description of the wp_term_relationships Classification Association information table in the WordPress database, including the meanings of fields in the wp_term_relationships Classification Association 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.

Wp_term_relationships is a data table in the wodpress system that stores the associations between categories and specific articles or links. This table serves as a bridge between the three classification data tables, wp_posts Article table, and wp_links link table. For more information, see wp_terms category table-Wordpress database, wp_term_taxonomy category type table, and introduction to category information database operations.

Next, let's take a look at the meaning of each field in the wp_term_relationships classification relationship table, as shown in (this figure is from the Northwestern University WordPress source code interpretation team:

Wp_term_relationships classification relational table -- WordPress Database

The association between the wp_term_relationships classification table and other data tables:

The wp_term_relationships classification relation table is associated with the ID of the wp_posts Article table through the foreign key object_id, or the foreign key object_id is associated with the link_id of the wp_links link table.

The object_id of a given record in the wp_term_relationships classification relational table is wp_posts-> ID Association, the association with wp_links-> link_id also depends on the specific type of the term_taxonomy_id corresponding to the record object_id in the wp_term_taxonomy category type table.

Here, we only need to know That wp_term_relationships is a bridge between classification information and specific articles or links. Further, we can determine whether a classification information is document classification, link classification, or tag information, see wp_term_taxonomy classification Type table and classification information database operation introduction.

Wp_term_relationships:

Wp_term_relationships classification relational table index information-Wordpress Database

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

The above is a detailed description of the wp_term_relationship classification relation 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_taxonomy Category Table introduction