{"id":170,"date":"2025-06-27T06:12:23","date_gmt":"2025-06-27T06:12:23","guid":{"rendered":"https:\/\/mitalgoswami.in\/?p=170"},"modified":"2025-07-31T03:33:15","modified_gmt":"2025-07-31T03:33:15","slug":"wordpress-database-tables-list","status":"publish","type":"post","link":"https:\/\/mitalgoswami.in\/?p=170","title":{"rendered":"WordPress database tables list"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">WordPress database tablesFrom sources across the web<\/h2>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<div class=\"wp-block-group is-layout-grid wp-container-core-group-is-layout-478b6e6b wp-block-group-is-layout-grid\">\n<p>Wp_commentmeta<\/p>\n\n\n\n<p>Wp_comments<\/p>\n\n\n\n<p>Wp_links<\/p>\n\n\n\n<p>Wp_options<\/p>\n\n\n\n<p>Wp_postmeta<\/p>\n\n\n\n<p>Wp_posts<\/p>\n\n\n\n<p>Wp_term_relationships<\/p>\n\n\n\n<p>Wp_term_taxonomy<\/p>\n\n\n\n<p>Wp_termmeta<\/p>\n\n\n\n<p>Wp_terms<\/p>\n\n\n\n<p>Wp_usermeta<\/p>\n\n\n\n<p>Wp_users<\/p>\n<\/div>\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"> WordPress Default Database Tables<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Table Name<\/th><th>Description<\/th><\/tr><\/thead><tbody><tr><td><code>wp_posts<\/code><\/td><td>Stores <strong>all content types<\/strong> \u2014 posts, pages, custom post types (products, attachments, etc.).<\/td><\/tr><tr><td><code>wp_postmeta<\/code><\/td><td>Stores <strong>custom fields (metadata)<\/strong> for posts and pages.<\/td><\/tr><tr><td><code>wp_users<\/code><\/td><td>Stores user account information (username, password, email).<\/td><\/tr><tr><td><code>wp_usermeta<\/code><\/td><td>Stores metadata (roles, capabilities) about users.<\/td><\/tr><tr><td><code>wp_terms<\/code><\/td><td>Stores individual <strong>terms<\/strong> (categories, tags, custom taxonomies).<\/td><\/tr><tr><td><code>wp_term_taxonomy<\/code><\/td><td>Defines whether a term is a category, tag, or custom taxonomy.<\/td><\/tr><tr><td><code>wp_term_relationships<\/code><\/td><td>Links posts to their categories, tags, or custom taxonomies.<\/td><\/tr><tr><td><code>wp_options<\/code><\/td><td>Stores <strong>site settings<\/strong>, theme options, plugin settings, etc.<\/td><\/tr><tr><td><code>wp_comments<\/code><\/td><td>Stores comments left by users.<\/td><\/tr><tr><td><code>wp_commentmeta<\/code><\/td><td>Stores metadata for comments.<\/td><\/tr><tr><td><code>wp_links<\/code><\/td><td>Legacy table for blogrolls; rarely used today.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>WordPress database tablesFrom sources across the web Wp_commentmeta Wp_comments Wp_links Wp_options Wp_postmeta Wp_posts Wp_term_relationships Wp_term_taxonomy Wp_termmeta Wp_terms Wp_usermeta Wp_users WordPress Default Database Tables Table Name Description wp_posts Stores all content types \u2014 posts, pages, custom post types (products, attachments, etc.). wp_postmeta Stores custom fields (metadata) for posts and pages. wp_users Stores user account information (username, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,2],"tags":[],"class_list":["post-170","post","type-post","status-publish","format-standard","hentry","category-unit-1","category-wordpress"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=\/wp\/v2\/posts\/170","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=170"}],"version-history":[{"count":2,"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=\/wp\/v2\/posts\/170\/revisions"}],"predecessor-version":[{"id":175,"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=\/wp\/v2\/posts\/170\/revisions\/175"}],"wp:attachment":[{"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=170"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=170"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mitalgoswami.in\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=170"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}