Exploring the role of existing tables

Assuming that most of you are existing WordPress developers, you will have a solid understanding of an existing database table structure. However, I suggest that you continue with this section, as web applications can present a different perspective on using these tables. Based on the functionality, we will categorize the existing tables into four sections, as follows:

• User-related tables
• Post-related tables
• Term-related tables
• Other tables

Let's look at how each table fits into these categories, and look at their roles in web applications.

User-related tables

This category consists of two tables that contain the user-related information of your application. Let's take a look at the relationship between user-related tables before moving onto the explanation:

The two tables shown in the preceding diagram are as follows:

• wp_users: All the registered users will be stored in this table with their basic details, such as name, e-mail, username, and password.
• wp-usermeta...