WordPress Default Tables topic will cover the details about

WordPress Default Tables

WordPress Database Introduction

WordPress Default Tables Description.

WordPress Default Tables

When you install the WordPress 12 WordPress default tables are created in the database. They are

WordPress default Tables

wp_commentmeta

wp_comments

wp_links

wp_options

wp_postmeta

wp_posts

wp_terms

wp_termmeta

wp_term_relationships

wp_terms_taxonomy

wp_usermeta

wp_users

You can change the wp_ prefix during the installation time.

One of the mostly used CMS is WordPress in the world. Near 30% of website in the world are build using WordPress.

WordPress improving day by day now Gutenberg is used for visual editor. WordPress using the database MySQL to store and maintain the data in a organized ways.

Database

Database is an organized set of data to store and maintain for the users. MySQL is very popular software to create databases and store the data in it.

MySQL is free and open source like WordPress and also best work with other open source software like PHP, Apache web server etc..,

Now you will see the details about each of these tables below.

wp_commentmeta

In this table, Comment features stored. These features are called as Meta data.

The below diagram will show the fields, type,Indexes about this table.

wp_commentmeta table

wp_comments

Comments store in this table.

The below diagram will show the fields, type, Indexes about this table.

wp_comments table

wp_links

In this table, Information related to the links entered in the link features are stored here.

The below diagram will show the fields, type, Indexes about this table.

wp_links table

wp_options

Setting panel values stored in this table.

Such as general, writing, reading, discussion, privacy and permalink also widget details are stores here.

The below diagram will show the fields, type, indexes about this table.

wp_options table

wp_postmeta

In this table, Post features details stored.

This features value also called as Meta data.

Some addition plugins are also stores their value in this table.

The below diagram will show the fields, type, Indexes about this table.

wp-postmeta table

wp_posts

This table is very important in WordPress because core of the WordPress is post.

The post are stored in this table and menu, pages, addition plugin post are store here only.

The below diagram will show the fields, type,Indexes about this table.

wp-posts table

wp_terms

The categories and tags for the post and the category for the link are stored in this table.

The below diagram will show the fields, type, Indexes about this table.

wp-terms table

wp_termmeta

The term features stored in this table.

These features called as Meta data.

The below diagram will show the fields, type, Indexes about this table.

wp_termmeta table

wp_term_relationships

The relationship between post and category, post and tags maintained in this table.

The relationship between link and category also maintained here only.

The below diagram will show the fields, type, Indexes about this table.

wp_term_relationships table

wp_terms_taxonomy

This table describes category, link and tags for the entries in the wp_terms table.

The below diagram will show the fields, type, Indexes about this table.

wp_terms_taxonomy table

wp_usermeta

The user features details stored in this table and also that features are called Meta data.

The below diagram will show the fields, type, Indexes about this table.

wp_usermeta table

wp_users

All users stored in this table only.

The below diagram will show the fields, type, Indexes about this table.

wp-users table

Thank you for reading this post (wordpress default tables) if you like this post please shares with your friends.

Related Post