WordPress Database Architecture

To help you understand how exactly WordPress works with MySQL, let’s run through the tables WordPress stores in a typical database.
WordPress Database Architecture

WordPress has a fairly straightforward and uncomplicated database schema. It consists of 11 tables, which are used by core components of WordPress and cannot by deleted or removed.
wp_commentmeta – Stores the metadata from all comments left on your WordPress posts and pages, including custom post types.
wp_comments – Stores all comments made on your site, including published, draft, pending and spam comments.
wp_links – Holds all information entered into the links manager feature of WordPress, this is rarely used nowadays, with the link feature itself becoming deprecated from WordPress 3.5 and hidden by default on new installs.
wp_options – Not only are all WordPress options stored in this table, such as your reading and discussion settings, but it’s more common now for plugins to use wp_options for storing saved settings as opposed to a custom table.
wp_postsmeta – As you’ve most probably guessed this table stores all metadata associated with your posts and pages.
wp_posts – Stores all your posts, as well as your pages and also your navigation/menu items.
wp_terms – This table stores the categories for posts, links, and the tags.
wp_term_relationships – Posts are associated with categories and tags from the wp_terms table, and this association is maintained in the wp_term_relationships table. The association of links to their respective categories is also kept in this table.
wp_term_taxonomy – Describes the taxonomy such as a category, link, or tag for the entries in the wp_terms_table.
wp_usermeta – Stores the metadata of all the users from the wp_userstable.
wp_users – All your users are stored within this table. Remember, data such as passwords are serialized.

Share on Google Plus
    Blogger Comment

6 comments:

  1. Hey, Wow all the posts are very informative for the people who visit this site. Good work! We also have a Website. Please feel free to visit our site. Thank you for sharing.
    Website Development
    Keep Posting:)

    ReplyDelete
  2. it is a beautiful post, and I want to say thank you so much for sharing this information.
    digital marketing services in india

    ReplyDelete
  3. People who were making exactly $0/month were now beginning to see REAL profit from their business...

    Why?

    Because they were at the right place, at the right time, in the right mindset.

    And everybody who ignored the plugin... well, they just kept on making that $0/month...

    Now, the reason that I am teaching you this today is because InstaBuilder is opening its doors again!

    After two years of development, tweaking, and testing with their 6000+ customer base, the owners of InstaBuilder have decided to "go public"...

    For the first time EVER you can get access to the NEW AND IMPROVED version of the plugin that completely transformed the sales funnel creation industry...

    Check It Out Here >>> http://instabuilder.com?nc8w65682g

    Now, here is your chance to be in the right place, at the right time, in the right mindset.

    ReplyDelete
  4. Really good research very informative post on list of digital marketing blogs
    jrelectronicsonline

    ReplyDelete

Web services and Internet Markeitng Services