WordPress Database

In this post we will see the topics WordPress database. In WordPress database topic we will cover the details about WordPress, database, WordPress default table and it description. Let we move the topics one by one.

WordPress

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..,

WordPress default tables

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

WordPress Database
WordPress Database 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. Now we 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.

WordPress Database
wp_commentmeta table

wp_comments

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

WordPress Database
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.

WordPress Database
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.

WordPress Database
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.

WordPress Database
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.

WordPress Database
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.

WordPress Database
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.

WordPress Database
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.

WordPress Database
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.

WordPress Database
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.

WordPress Database
wp_usermeta table

wp_users

All users stored in this table only. The below diagram will show the fields, type, Indexes about this table.

WordPress Database
wp-users table

Thank you for reading this post if you like this post please shares with your friends.

1 Comment

Leave a Reply

Your email address will not be published. Required fields are marked *

Subscribe For Latest Updates

You have successfully subscribed to the newsletter

There was an error while trying to send your request. Please try again.

Sutrula Thalangal will use the information you provide on this form to be in touch with you and to provide updates and marketing.