Post-related tables

This section consists of two tables that contain website posts and page-related information. Let's take a look at the relationship between post-related tables before moving onto the explanation:

The tables shown in the diagram are as follows:

  • wp_posts: This table contains all the posts and pages of your website with details such as post name, author, content, status, and post type.
  • wp_postmeta: This table contains all the additional details for each post as key-value pairs. By default, it will contain details such as page template, attachments, and edit locks. Also, we can store any post-related information as new key-value pairs.