Overview of WordPress 2.8 Database Tables
October 24th, 2009
1 comment
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. |
|
| wp_options | The Options set under the Administration > Settings panel are stored in the wp_options table. |
|
| 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. |
|
| wp_posts | The core of the WordPress data is the posts. It is stored in the wp_posts table. |
|
| wp_terms | The categories for both posts and links and the tags for posts are found within the wp_terms table. |
|
| 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. |
|
| wp_users | The list of users is maintained in table wp_users. |
|
Recent Comments