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

13 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
  5. This information you provided in the blog that is really unique I love it!! Affordable digital marketing services Company

    ReplyDelete

  6. Health Is God aims to deliver the best possible health reviews of the supplement collections and other wellness production that range from skincare to brain, muscle, male enhancement and brain health conditions. You, the user are of utmost importance to us, and we are committed to being the portal that sustains your healthy lifestyle. Visit for more- Health is God

    ReplyDelete
  7. I think this is a real great article post.Really looking forward to read more. Visit at
    Crazy Video Hub

    ReplyDelete
  8. Fantastic article to go through,I would appreciate the writer's mind and the skills he has presented this great article to get its look in better style.
    Fmovies

    ReplyDelete
  9. Hi, I am muskaan sharma thank you for this informative post.Fantastic article to go through,I would appreciate the writer's
    123movies

    ReplyDelete
  10. It is a great job, I like your posts and wish you all the best. and I hope you continue this job well.
    NutraT line

    ReplyDelete
  11. Your post will be rather good and I'm sure some will find it interesting because it's about a topic that's as widely discussed as others. Some may even find it useful.Thanks so much for your post:
    kim kardashian sex tape
    porn sex video hd
    mia khalifa sex video
    sunny leone sexy movie

    ReplyDelete

Web services and Internet Markeitng Services