WordPress Database – WordPress Default Tables

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

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

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.
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 (wordpress default tables) if you like this post please shares with your friends.


Related Post

WordPress developer interview questions and answers – Top Interview Questions for WordPress

WordPress Default Tables topic will cover the details about WordPress Default Tables WordPress Database IntroductionWordPress 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_commentmetawp_commentswp_linkswp_optionswp_postmetawp_postswp_termswp_termmetawp_term_relationshipswp_terms_taxonomywp_usermetawp_users You can change the wp_ prefix during the installation time. WordPress One of the mostly […]
Read More

WordPress Database – WordPress Default Tables

WordPress Default Tables topic will cover the details about WordPress Default Tables WordPress Database IntroductionWordPress 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_commentmetawp_commentswp_linkswp_optionswp_postmetawp_postswp_termswp_termmetawp_term_relationshipswp_terms_taxonomywp_usermetawp_users You can change the wp_ prefix during the installation time. WordPress One of the mostly […]
Read More
wordpress org vs com

What is the difference between wordpress org vs com

WordPress Default Tables topic will cover the details about WordPress Default Tables WordPress Database IntroductionWordPress 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_commentmetawp_commentswp_linkswp_optionswp_postmetawp_postswp_termswp_termmetawp_term_relationshipswp_terms_taxonomywp_usermetawp_users You can change the wp_ prefix during the installation time. WordPress One of the mostly […]
Read More

Upload an Image file to the server using Angular and PHP

WordPress Default Tables topic will cover the details about WordPress Default Tables WordPress Database IntroductionWordPress 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_commentmetawp_commentswp_linkswp_optionswp_postmetawp_postswp_termswp_termmetawp_term_relationshipswp_terms_taxonomywp_usermetawp_users You can change the wp_ prefix during the installation time. WordPress One of the mostly […]
Read More

2 Comments

  1. Pingback: My Homepage

Leave a Reply

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