Home > WP Older > Overview of WordPress 2.8 Database Tables

Overview of WordPress 2.8 Database Tables

October 24th, 2009 Leave a comment Go to comments

Note: The following is made available under GPL from http://codex.wordpress.org/GPL. It may be edited a little from its original form, but probably not a lot. There is no guarantee this information is accurate…use at your own risk.
—————————————————–

WordPress 2.8 Database Table Overview

WordPress 2.8 Tables (10)
Table Name Description Relevant Area(s) of WordPress User Interface
wp_comments The comments within WordPress are stored in the wp_comments table. Comments are created by readers as responses to posts. Comments are managed by administrator via Administration > Comments > Comments
wp_links The wp_links holds information related to the links entered into the Links feature of WordPress.
  • Administration > Links > Add New
  • Administration > Links > Edit
wp_options The Options set under the Administration > Settings panel are stored in the wp_options table.
  • Administration > Settings > General
  • Administration > Settings > Writing
  • Administration > Settings > Reading
  • Administration > Settings > Discussion
  • Administration > Settings > Privacy
  • Administration > Settings > Permalinks
  • Administration > Settings > Miscellaneous
  • Administration > Appearance > Widgets
wp_postmeta Each post features information called the meta data and it is stored in the wp_postmeta. Some plugins may add their own information to this table.
  • Administration > Posts > Add New
  • Administration > Pages > Add New
wp_posts The core of the WordPress data is the posts. It is stored in the wp_posts table.
  • Administration > Posts > Add New
  • Administration > Posts > Edit
  • Administration > Pages > Add New
  • Administration > Page > Edit
  • Administration > Media > Add New
  • Administration > Media > Library
wp_terms The categories for both posts and links and the tags for posts are found within the wp_terms table.
  • Administration > Posts > Tags
  • Administration > Posts > Categories
  • Administration > Links > Link Categories
  • Administration > Posts > Add New
  • Administration > Posts > Edit
  • Administration > Pages > Add New
  • Administration > Page > Edit
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 are also kept in this table.
wp_term_taxonomy This table describes the taxonomy (category, link, or tag) for the entries in the wp_terms table.
wp_usermeta Each user features information called the meta data and it is stored in wp_usermeta.
  • Administration > Users
wp_users The list of users is maintained in table wp_users.
  • Administration > Users
Get Noticed with a $7.99 .CO!
  1. October 26th, 2009 at 20:24 | #1

    Good posting, i looking for this topic.

  1. No trackbacks yet.
*