{"id":1033,"date":"2012-06-14T10:06:06","date_gmt":"2012-06-14T02:06:06","guid":{"rendered":"https:\/\/blog.rexdf.org\/?p=1033"},"modified":"2012-06-14T10:06:06","modified_gmt":"2012-06-14T02:06:06","slug":"wordpress-3-4-tables-11","status":"publish","type":"post","link":"https:\/\/blog.rexdf.org\/en\/2012\/06\/wordpress-3-4-tables-11\/","title":{"rendered":"WordPress 3.4 Tables (11)"},"content":{"rendered":"
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
WordPress 3.4 Tables (11)<\/span><\/strong><\/th>\n<\/tr>\n
Table Name<\/th>\nDescription<\/th>\nRelevant Area(s) of WordPress User Interface<\/th>\n<\/tr>\n
wp_commentmeta<\/span><\/a><\/th>\nEach <\/span>comment<\/strong><\/span> <\/span>features information called the<\/span> <\/span>meta data<\/strong><\/span> <\/span>and it is stored in the<\/span> <\/span><\/span>wp_commentmeta<\/span><\/tt>.<\/td>\n\n
wp_comments<\/span><\/a><\/th>\nThe <\/span>comments<\/strong><\/span> <\/span>within WordPress are stored in the<\/span> <\/span><\/span>wp_comments<\/span><\/tt> <\/span><\/span>table.<\/td>\n\n
wp_links<\/span><\/a><\/th>\nThe <\/span><\/span>wp_links<\/span><\/tt> <\/span>holds information related to the<\/span> <\/span>links<\/strong><\/span> <\/span>entered into the<\/span> <\/span><\/span>Links<\/a> <\/span><\/span>feature of WordPress.<\/td>\n\n
wp_options<\/span><\/a><\/th>\nThe <\/span><\/span>Options<\/a><\/strong> <\/span>set under the<\/span>Administration > <\/span><\/span>Settings<\/a><\/strong> <\/span>panel are stored in the<\/span> <\/span><\/span>wp_options<\/span><\/tt> <\/span>table. See<\/span> <\/span><\/span>Option Reference<\/a> <\/span>for<\/span> <\/span>option_name<\/code><\/span>and default values.<\/td>\n\n
wp_postmeta<\/span><\/a><\/th>\nEach <\/span>post<\/strong><\/span> <\/span>features information called the<\/span> <\/span>meta data<\/strong><\/span> <\/span>and it is stored in the<\/span> <\/span><\/span>wp_postmeta<\/span><\/tt>. Some plugins may add their own information to this table.<\/td>\n\n
wp_posts<\/span><\/a><\/th>\nThe core of the WordPress data is the <\/span><\/span>posts<\/span><\/strong><\/a>. It is stored in thewp_posts<\/span><\/tt> <\/span>table. Also<\/span> <\/span><\/span>Pages<\/a> <\/span><\/span>and navigation menu items are stored in this table.<\/td>\n\n
wp_terms<\/span><\/a><\/th>\nThe <\/span>categories<\/strong><\/span> <\/span>for both posts and links and the<\/span> <\/span>tags<\/strong><\/span> <\/span>for posts are found within the<\/span> <\/span><\/span>wp_terms<\/span><\/tt> <\/span><\/span>table.<\/td>\n\n
wp_term_relationships<\/span><\/a><\/th>\nPosts<\/strong> <\/span>are associated with categories and tags from the<\/span> <\/span><\/span>wp_terms<\/span><\/tt> <\/span>table and this association is maintained in the<\/span> <\/span><\/span>wp_term_relationships<\/span><\/tt> <\/span>table. The association of<\/span> <\/span>links<\/strong><\/span> <\/span><\/span>to their respective categories are also kept in this table.<\/td>\n<\/tr>\n
wp_term_taxonomy<\/span><\/a><\/th>\nThis table describes the taxonomy (category<\/strong>, <\/span>link<\/strong><\/span>, or <\/span>tag<\/strong><\/span>) for the entries in the <\/span><\/span>wp_terms<\/span><\/tt> <\/span><\/span>table.<\/td>\n<\/tr>\n
wp_usermeta<\/span><\/a><\/th>\nEach <\/span>user<\/strong><\/span> <\/span>features information called the<\/span> <\/span>meta data<\/strong><\/span> <\/span>and it is stored in<\/span> <\/span><\/span>wp_usermeta<\/span><\/tt>.<\/td>\n\n
wp_users<\/span><\/a><\/th>\nThe list of <\/span>users<\/strong><\/span> <\/span>is maintained in table<\/span> <\/span><\/span>wp_users<\/span><\/tt>.<\/td>\n\n