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

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

    ReplyDelete
  3. 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

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

    ReplyDelete
  5. 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.

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

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

    ReplyDelete
  8. DO YOU NEED A LOAN? patialalegitimate515@gmail.com
    We give out loans with an affordable interest rate of 2% Captain One provide Excellent and Professional Financial Services and we are known and genuine money lenders across the globe
    Our services include the following:
    *Student Loans
    Truck Loan
    Personal Loan
    Debt consolidation loan
    Car Loans
    Business Loan
    Student Loan
    Mortgage Loan
    Refinancing Loan
    Home Loan
    Improvement loan
    Construction Loan
    Looking forward to receive your reply and I will advise you on how to get the fund to your bank account no matter your location no collateral for more information on how to get started: (Whats App) number: +919394133968 patialalegitimate515@gmail.com Mr Jeffery

    ReplyDelete

Web services and Internet Markeitng Services