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


  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:)

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

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


    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.

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

  5. This information you provided in the blog that is really unique I love it!! Affordable digital marketing services Company


  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

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

  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.

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

  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

  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

  12. Hello, I am thomus jons thank you for this informative post. That is a great job. Wish you more success.Thank you so much and for you all the best. Takes Down

  13. I am really impressed with your blog article, such great & useful knowledge you mentioned here. Your post is very informative. I have read all your posts and all are

    very informative. Thanks for sharing and keep it up like this.
    Digital Marketing Company In Nashik
    Social Media Marketing in Nashik
    SEO In Nashik
    SEO Experts in Nashik

  14. Fantastic blog! Do you have any tips and hints for aspiring writers? I’m planning to start my own website soon but I’m a little lost on everything. Would you propose starting with a free platform like WordPress or go for a paid option? There are so many options out there that I’m completely overwhelmed .. Any suggestions? Many thanks!
    free wordpress course

  15. Hello,
    This article is very great. Thank you sharing such a great article. Visit; Cariva Technologies

  16. Web Solution Centre is a Best Website Development Company In Delhi, We are Offers the best Seo, web design Development, Mobile App Design, Online Marketing, Service in Delhi, India and across the globe.

  17. Lovely blog with much more interesting article, I will keep on reading your update. Thanks for the share this Blog.
    Web Development in Chakwal

  18. The exclusive Jaipuri necklace comes up in different designs and you can browse the options that help you to find the best one. You can opt for the multi-colored necklace and the handmade designs reveal the story of Jaipur.

  19. Do you need Finance? Are you looking for Finance? Are you looking for finance to enlarge your business? We help individuals and companies to obtain finance for business expanding and to setup a new business ranging any amount. Get finance at affordable interest rate of 3%, Do you need this finance for business and to clear your bills? Then send us an email now for more information contact us now via (financialserviceoffer876@gmail.com) whats-App +918929509036 Dr James Eric Finance Pvt Ltd Thanks


Web services and Internet Markeitng Services