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

4 Comments

  1. Pingback: My Homepage
  2. Hello there, just became aware of your blog through Google,
    and found that it’s really informative. I’m gonna watch out
    for brussels. I will be grateful if you continue this in future.
    Lots of people will be benefited from your writing. Cheers!

  3. Woah! I’m really loving the template/theme of this
    blog. It’s simple, yet effective. A lot of times it’s very difficult to
    get that “perfect balance” between usability and appearance.

    I must say that you’ve done a amazing job with this.
    Additionally, the blog loads super quick for me
    on Safari. Superb Blog!

Leave a Reply

Your email address will not be published.