wordpress数据表说明

- 日理万妓 2023-01-07 13:24 150阅读 0赞

`wp_commentmeta`: 用于保存评论的元信息，在将评论放入回收站等操作时会将数据放入此表，Akismet等插件也会生成此表的数据。此表不太重要  
`wp_comments`: 用于保存评论信息的表  
`wp_links`: 用于保存用户输入到Wordpress中的链接(通过Link Manager)的表  
`wp_options`: 用于保存Wordpress相关设置、参数的表，里面包括了大量的重要信息  
`wp_postmeta`: 用于保存文章的元信息(meta)的表  
`wp_posts`: 用于保存你所有的文章相关信息的表，非常的重要。一般它存储的数据是最多的  
`wp_terms`: 文章和链接分类以及文章的tag分类可以在表里找到  
`wp_term_relationships`: 日志与wp\_terms中的类别与标签联合起来共同存储在wp\_terms\_relationships表中。类别相关链接也存储在wp\_terms\_relationships中  
`wp_term_taxonomy`: 该表格对wp\_terms表中的条目分类（类别、链接以及标签）进行说明  
`wp_usermeta` : 用于保存用户元信息(meta)的表  
`wp_users`:用于保存Wordpress使用者的相关信息的表

wp\_commentmeta

<table> 
 <thead> 
  <tr> 
   <th>键</th> 
   <th>值</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>meta_id</td> 
   <td>自增唯一ID</td> 
  </tr> 
  <tr> 
   <td>comment_id</td> 
   <td>对应评论ID</td> 
  </tr> 
  <tr> 
   <td>meta_key</td> 
   <td>键名</td> 
  </tr> 
  <tr> 
   <td>meta_value</td> 
   <td>键值</td> 
  </tr> 
 </tbody> 
</table>

wp\_comments

<table> 
 <thead> 
  <tr> 
   <th>键</th> 
   <th>值</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>comment_ID</td> 
   <td>自增唯一ID</td> 
  </tr> 
  <tr> 
   <td>comment_post_ID</td> 
   <td>对应文章ID</td> 
  </tr> 
  <tr> 
   <td>comment_author</td> 
   <td>评论者</td> 
  </tr> 
  <tr> 
   <td>comment_author_email</td> 
   <td>评论者邮箱</td> 
  </tr> 
  <tr> 
   <td>comment_author_url</td> 
   <td>评论者网址</td> 
  </tr> 
  <tr> 
   <td>comment_author_IP</td> 
   <td>评论者IP</td> 
  </tr> 
  <tr> 
   <td>comment_date</td> 
   <td>评论时间</td> 
  </tr> 
  <tr> 
   <td>comment_date_gmt</td> 
   <td>评论时间（GMT+0时间）</td> 
  </tr> 
  <tr> 
   <td>comment_content</td> 
   <td>评论正文</td> 
  </tr> 
  <tr> 
   <td>comment_karma</td> 
   <td>未知</td> 
  </tr> 
  <tr> 
   <td>comment_approved</td> 
   <td>评论是否被批准</td> 
  </tr> 
  <tr> 
   <td>comment_agent</td> 
   <td>评论者的USER AGENT</td> 
  </tr> 
  <tr> 
   <td>comment_type</td> 
   <td>评论类型(pingback/普通)</td> 
  </tr> 
  <tr> 
   <td>comment_parent</td> 
   <td>父评论ID</td> 
  </tr> 
  <tr> 
   <td>user_id</td> 
   <td>评论者用户ID（不一定存在）</td> 
  </tr> 
 </tbody> 
</table>

wp\_links

<table> 
 <thead> 
  <tr> 
   <th>键</th> 
   <th>值</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>link_id</td> 
   <td>自增唯一ID</td> 
  </tr> 
  <tr> 
   <td>link_url</td> 
   <td>链接URL</td> 
  </tr> 
  <tr> 
   <td>link_name</td> 
   <td>链接标题</td> 
  </tr> 
  <tr> 
   <td>link_image</td> 
   <td>链接图片</td> 
  </tr> 
  <tr> 
   <td>link_target</td> 
   <td>链接打开方式</td> 
  </tr> 
  <tr> 
   <td>link_description</td> 
   <td>链接描述</td> 
  </tr> 
  <tr> 
   <td>link_visible</td> 
   <td>是否可见（Y/N）</td> 
  </tr> 
  <tr> 
   <td>link_owner</td> 
   <td>添加者用户ID</td> 
  </tr> 
  <tr> 
   <td>link_rating</td> 
   <td>评分等级</td> 
  </tr> 
  <tr> 
   <td>link_updated</td> 
   <td>未知</td> 
  </tr> 
  <tr> 
   <td>link_rel</td> 
   <td>XFN关系</td> 
  </tr> 
  <tr> 
   <td>link_notes</td> 
   <td>XFN注释</td> 
  </tr> 
  <tr> 
   <td>link_rss</td> 
   <td>链接RSS地址</td> 
  </tr> 
 </tbody> 
</table>

wp\_options

<table> 
 <thead> 
  <tr> 
   <th>键</th> 
   <th>值</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>option_id</td> 
   <td>自增唯一ID</td> 
  </tr> 
  <tr> 
   <td>blog_id</td> 
   <td>博客ID，用于多用户博客，默认0</td> 
  </tr> 
  <tr> 
   <td>option_name</td> 
   <td>键名</td> 
  </tr> 
  <tr> 
   <td>option_value</td> 
   <td>键值</td> 
  </tr> 
  <tr> 
   <td>autoload</td> 
   <td>在WordPress载入时自动载入（yes/no）</td> 
  </tr> 
 </tbody> 
</table>

wp\_postmeta

<table> 
 <thead> 
  <tr> 
   <th>键</th> 
   <th>值</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>meta_id</td> 
   <td>自增唯一ID</td> 
  </tr> 
  <tr> 
   <td>post_id</td> 
   <td>对应文章ID</td> 
  </tr> 
  <tr> 
   <td>meta_key</td> 
   <td>键名</td> 
  </tr> 
  <tr> 
   <td>meta_value</td> 
   <td>键值</td> 
  </tr> 
 </tbody> 
</table>

wp\_posts

<table> 
 <thead> 
  <tr> 
   <th>键</th> 
   <th>值</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>ID</td> 
   <td>自增唯一ID</td> 
  </tr> 
  <tr> 
   <td>post_author</td> 
   <td>对应作者ID</td> 
  </tr> 
  <tr> 
   <td>post_date</td> 
   <td>发布时间</td> 
  </tr> 
  <tr> 
   <td>post_date_gmt</td> 
   <td>发布时间（GMT+0时间）</td> 
  </tr> 
  <tr> 
   <td>post_content</td> 
   <td>正文</td> 
  </tr> 
  <tr> 
   <td>post_title</td> 
   <td>标题</td> 
  </tr> 
  <tr> 
   <td>post_excerpt</td> 
   <td>摘录</td> 
  </tr> 
  <tr> 
   <td>post_status</td> 
   <td>文章状态（publish/auto-draft/inherit等）</td> 
  </tr> 
  <tr> 
   <td>comment_status</td> 
   <td>评论状态（open/closed）</td> 
  </tr> 
  <tr> 
   <td>ping_status</td> 
   <td>PING状态（open/closed）</td> 
  </tr> 
  <tr> 
   <td>post_password</td> 
   <td>文章密码</td> 
  </tr> 
  <tr> 
   <td>post_name</td> 
   <td>文章缩略名</td> 
  </tr> 
  <tr> 
   <td>to_ping</td> 
   <td>未知</td> 
  </tr> 
  <tr> 
   <td>pinged</td> 
   <td>已经PING过的链接</td> 
  </tr> 
  <tr> 
   <td>post_modified</td> 
   <td>修改时间</td> 
  </tr> 
  <tr> 
   <td>post_modified_gmt</td> 
   <td>修改时间（GMT+0时间）</td> 
  </tr> 
  <tr> 
   <td>post_content_filtered</td> 
   <td>未知</td> 
  </tr> 
  <tr> 
   <td>post_parent</td> 
   <td>父文章，主要用于PAGE</td> 
  </tr> 
  <tr> 
   <td>guid</td> 
   <td>未知</td> 
  </tr> 
  <tr> 
   <td>menu_order</td> 
   <td>排序ID</td> 
  </tr> 
  <tr> 
   <td>post_type</td> 
   <td>文章类型（post/page等）</td> 
  </tr> 
  <tr> 
   <td>post_mime_type</td> 
   <td>MIME类型</td> 
  </tr> 
  <tr> 
   <td>comment_count</td> 
   <td>评论总数</td> 
  </tr> 
 </tbody> 
</table>

wp\_terms

<table> 
 <thead> 
  <tr> 
   <th>键</th> 
   <th>值</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>term_id</td> 
   <td>分类ID</td> 
  </tr> 
  <tr> 
   <td>name</td> 
   <td>分类名</td> 
  </tr> 
  <tr> 
   <td>slug</td> 
   <td>缩略名</td> 
  </tr> 
  <tr> 
   <td>term_group</td> 
   <td>未知</td> 
  </tr> 
 </tbody> 
</table>

wp\_term\_relationships

<table> 
 <thead> 
  <tr> 
   <th>键</th> 
   <th>值</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>object_id</td> 
   <td>对应文章ID/链接ID</td> 
  </tr> 
  <tr> 
   <td>term_taxonomy_id</td> 
   <td>对应分类方法ID</td> 
  </tr> 
  <tr> 
   <td>term_order</td> 
   <td>排序</td> 
  </tr> 
 </tbody> 
</table>

wp\_term\_taxonomy

<table> 
 <thead> 
  <tr> 
   <th>键</th> 
   <th>值</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>term_taxonomy_id</td> 
   <td>分类方法ID</td> 
  </tr> 
  <tr> 
   <td>term_id</td> 
   <td>taxonomy</td> 
  </tr> 
  <tr> 
   <td>description</td> 
   <td>未知</td> 
  </tr> 
  <tr> 
   <td>parent</td> 
   <td>所属父分类方法ID</td> 
  </tr> 
  <tr> 
   <td>count</td> 
   <td>文章数统计</td> 
  </tr> 
 </tbody> 
</table>

wp\_usermeta

<table> 
 <thead> 
  <tr> 
   <th>键</th> 
   <th>值</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>umeta_id</td> 
   <td>自增唯一ID</td> 
  </tr> 
  <tr> 
   <td>user_id</td> 
   <td>对应用户ID</td> 
  </tr> 
  <tr> 
   <td>meta_key</td> 
   <td>键名</td> 
  </tr> 
  <tr> 
   <td>meta_value</td> 
   <td>键值</td> 
  </tr> 
 </tbody> 
</table>

wp\_users

<table> 
 <thead> 
  <tr> 
   <th>键</th> 
   <th>值</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>ID</td> 
   <td>自增唯一ID</td> 
  </tr> 
  <tr> 
   <td>user_login</td> 
   <td>登录名</td> 
  </tr> 
  <tr> 
   <td>user_pass</td> 
   <td>密码</td> 
  </tr> 
  <tr> 
   <td>user_nicename</td> 
   <td>昵称</td> 
  </tr> 
  <tr> 
   <td>user_email</td> 
   <td>Email</td> 
  </tr> 
  <tr> 
   <td>user_url</td> 
   <td>网址</td> 
  </tr> 
  <tr> 
   <td>user_registered</td> 
   <td>注册时间</td> 
  </tr> 
  <tr> 
   <td>user_activation_key</td> 
   <td>激活码</td> 
  </tr> 
  <tr> 
   <td>user_status</td> 
   <td>用户状态</td> 
  </tr> 
  <tr> 
   <td>display_name</td> 
   <td>显示名称</td> 
  </tr> 
 </tbody> 
</table>