WordPress 数据库探究

WordPress官方资料

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.

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.

参考资料

 WordPress 数据库探究#1 — 介绍
 WordPress 数据库探究#2 — wp_posts
 WordPress 数据库探究#3 — wp_postmeta
 WordPress 数据库探究#4 — wp_users和wp_usermeta
 WordPress 数据库探究#5 — wp_comments
 WordPress 数据库探究#6 — wp_options
 WordPress 数据库探究#7 — wp_categories和wp_post2cat
 WordPress 数据库探究#8 — wp_links和wp_link2cat