{"id":37827,"date":"2010-08-29T15:06:01","date_gmt":"2010-08-29T19:06:01","guid":{"rendered":"http:\/\/wpmu.org\/?p=37827"},"modified":"2012-10-12T16:18:38","modified_gmt":"2012-10-12T20:18:38","slug":"daily-tip-the-anatomy-of-a-wordpress-database","status":"publish","type":"post","link":"https:\/\/vvpmudev.com\/blog\/daily-tip-the-anatomy-of-a-wordpress-database\/","title":{"rendered":"The Anatomy of a WordPress Database"},"content":{"rendered":"<p><a rel=\"lightbox[37827]\" class=\"blog-thumbnail\" href=\"https:\/\/vvpmudev.com\/blog\/wp-content\/uploads\/2010\/08\/diagram.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-37828\" title=\"diagram\" src=\"https:\/\/vvpmudev.com\/blog\/wp-content\/uploads\/2010\/08\/diagram.png\" alt=\"Post image\" aria-hidden=\"true\" width=\"260\" height=\"173\" \/><\/a>If you&#8217;re new to WordPress and want to familiarize yourself with how the database is structured for a standard 3.0 installation, check out the codex <a href=\"http:\/\/codex.wordpress.org\/Database_Description\" rel=\"noopener\" target=\"_blank\">database description<\/a>.<\/p>\n<p>This is very helpful if you&#8217;re planning to <a rel=\"noopener\" class=\"blog-thumbnail\" href=\"http:\/\/codex.wordpress.org\/Writing_a_Plugin\" target=\"_blank\">write a plugin<\/a>. Scroll down for a <a href=\"http:\/\/codex.wordpress.org\/File:WP3.0-ERD.png\" rel=\"noopener\" target=\"_blank\">visual overview<\/a> of the WordPress database and you&#8217;ll be able to see how the tables are related to one another. The table overview section gives a description of each of the tables and lists the relevant areas of WordPress user interface.<\/p>\n<p>Scroll further down and you will find an overview of all the multisite global tables that are created when you enable Multisite. This is one page you&#8217;ll want to bookmark for future reference.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you&#8217;re new to WordPress and want to familiarize yourself with how the database is structured for a standard 3.0 installation, check out the codex database description. This is very helpful if you&#8217;re planning to write a plugin. Scroll down for a visual overview of the WordPress database and you&#8217;ll be able to see how [&hellip;]<\/p>\n","protected":false},"author":4099,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"blog_reading_time":"","wds_primary_category":0,"wds_primary_tutorials_categories":0,"footnotes":""},"categories":[1,557,235,1117],"tags":[1004,131],"tutorials_categories":[],"class_list":["post-37827","post","type-post","status-publish","format-standard","hentry","category-news-community","category-development","category-misc","category-multisite","tag-database","tag-developers"],"_links":{"self":[{"href":"https:\/\/vvpmudev.com\/blog\/wp-json\/wp\/v2\/posts\/37827","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vvpmudev.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vvpmudev.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vvpmudev.com\/blog\/wp-json\/wp\/v2\/users\/4099"}],"replies":[{"embeddable":true,"href":"https:\/\/vvpmudev.com\/blog\/wp-json\/wp\/v2\/comments?post=37827"}],"version-history":[{"count":3,"href":"https:\/\/vvpmudev.com\/blog\/wp-json\/wp\/v2\/posts\/37827\/revisions"}],"predecessor-version":[{"id":183137,"href":"https:\/\/vvpmudev.com\/blog\/wp-json\/wp\/v2\/posts\/37827\/revisions\/183137"}],"wp:attachment":[{"href":"https:\/\/vvpmudev.com\/blog\/wp-json\/wp\/v2\/media?parent=37827"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vvpmudev.com\/blog\/wp-json\/wp\/v2\/categories?post=37827"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vvpmudev.com\/blog\/wp-json\/wp\/v2\/tags?post=37827"},{"taxonomy":"tutorials_categories","embeddable":true,"href":"https:\/\/vvpmudev.com\/blog\/wp-json\/wp\/v2\/tutorials_categories?post=37827"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}