Exploring the role of existing tables
Assuming that most of you are existing WordPress developers, you will have a solid understanding of the existing database table structure. However, I suggest you to continue with this section, as web applications can have a different perspective in using these tables. Based on the functionality, we are going to categorize the existing tables into four sections, named:
User-related tables
Post-related tables
Term-related tables
Other tables
Let's look at how each table fits into these categories and their role in web applications.
User-related tables
This section consists of two tables for maintaining the user-related information of your application. Let's take a look at the relationship between user-related tables before moving on to explanations. The following diagram will give a brief idea on this:
The following is the explanation of these user-related tables:
wp_users
: All the registered users will be stored in this table with their basic details, such as...