tsre 5 track section will not link to database

In the images below you can see two different post_types, revision and attachment which are stored in the same wp_posts table:

post_type is the most important column in this table. In wp_posts is a table column post_type which segments that kind of different data so that specific types of data can be requested by a database query. This table also contains navigation menu items, media files and attachments like images and content data that are used by plugins. It might be confusing but WordPress stores much more into that table. All posts, pages, their revisions are available in the wp_posts table. Wp_posts table stores all content related data of a WordPress website.

Plugins can store custom data in wp_usermeta by just adding new meta_key values. There are two important fields in this table. For example, the first name of a user is stored in the table wp_usermeta instead of the table wp_users. It extends the table wp_users with more data. Wp_usermeta stores the metadata (‘additional data‘) of the users. It contains basic information of a user like a username and encrypted password, email, time of registration, display name, status, and a few more fields.

Wp_users stores all the registered users on a WordPress site. Most of the plugins store settings in this table as well.Īll the settings that you see in the WordPress dashboard are stored in this table. The table wp_options is one of the most important WordPress database table and stores all the settings of a WordPress site like the URL, the title, installed plugins, etc. Other tables in a WordPress database are created by other plugins and are not necessarily needed to run successfully the website.

8 Graphical Structure of WordPress Database.

Tsre 5 track section will not link to database