wp_posts 

This is the primary data storage location of many WordPress sites and applications. This table consists of the main data for posts, pages, and custom post types. This table consists of twenty-three columns. Let's identify some of the most important columns in this table:

post_author This is where you find the ID of the user who created the post or page. This column is used to form the relationship with the wp_users table.
post_content The complete content of the post/page is stored in this column. So, the data in this column can range from a few words to thousands of words and images.
post_title The title of the post/page is stored in this column. It's used to identify the page in the backend as well as highlight the title ...

Get WordPress Development Quick Start Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.