WordPress stores all the data in mysql database.We all know about it. But have you ever tried to understand the usage of different tables of that database.
In this article, we’ll discuss the basic structure of WordPress Database.
You’ll need this knowledge in future when editing database manually or in troubleshooting.
WordPress database comprises of following tables:
This section is the overview of all the tables created during the WordPress standard installation. It is followed by specific information of what is in each table.
|WordPress 3.8 Tables (11)|
|Table Name||Description||Relevant Area(s) of WordPress User Interface|
|wp_commentmeta||Each comment features information called the meta data and it is stored in the wp_commentmeta.||
|wp_comments||The comments within WordPress are stored in the wp_comments table.||
|wp_links||The wp_links holds information related to the links entered into the Links feature of WordPress. (This feature has been deprecated, but can be re-enabled with the Links Manager plugin.)||
|wp_options||The Options set under the Administration > Settings panel are stored in the wp_options table. See Option Reference for
|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. Also Pages and navigation menu items are stored in this 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.||