Table: wp_commentmeta
|
Field |
Type |
Null |
Key |
Default |
Extra |
|
meta_id |
bigint(20) unsigned |
PRI |
NULL |
auto_increment |
|
|
comment_id |
bigint(20) unsigned |
IND |
0 |
FK->wp_comments.comment_id |
|
|
meta_key |
varchar(255) |
YES |
IND |
NULL |
|
|
meta_value |
longtext |
YES |
NULL |
Indexes
|
Keyname |
Type |
Cardinality |
Field |
|
PRIMARY |
PRIMARY |
0 |
meta_ID |
|
comment_id |
INDEX |
none |
comment_id |
|
meta_key |
INDEX |
none |
meta_key |
Table: wp_comments
|
Field |
Type |
Null |
Key |
Default |
Extra |
|
comment_ID |
bigint(20) unsigned |
PRI |
NULL |
auto_increment |
|
|
comment_post_ID |
bigint(20) unsigned |
IND |
0 |
FK->wp_posts.ID |
|
|
comment_author |
tinytext |
||||
|
comment_author_email |
varchar(100) |
||||
|
comment_author_url |
varchar(200) |
||||
|
comment_author_IP |
varchar(100) |
||||
|
comment_date |
datetime |
0000-00-00 00:00:00 |
|||
|
comment_date_gmt |
datetime |
IND & IND Pt2 |
0000-00-00 00:00:00 |
||
|
comment_content |
text |
||||
|
comment_karma |
int(11) |
0 |
|||
|
comment_approved |
varchar(20) |
IND & Ind Pt1 |
1 |
||
|
comment_agent |
varchar(255) |
||||
|
comment_type |
varchar(20) |
||||
|
comment_parent |
bigint(20) unsigned |
0 |
FK->wp_comments.ID |
||
|
user_id |
bigint(20) unsigned |
0 |
FK->wp_users.ID |
Indexes
|
Keyname |
Type |
Cardinality |
Field |
|
PRIMARY |
PRIMARY |
1 |
comment_ID |
|
comment_post_ID |
INDEX |
None |
comment_post_ID |
|
comment_approved_date_gmt |
INDEX |
None |
comment_approved |
|
comment_date_gmt |
INDEX |
None |
comment_date_gmt |
|
comment_parent |
INDEX |
None |
comment_parent |
Table: wp_links
|
Field |
Type |
Null |
Key |
Default |
Extra |
|
link_id |
bigint(20) unsigned |
PRI |
NULL |
auto_increment |
|
|
link_url |
varchar(255) |
||||
|
link_name |
varchar(255) |
||||
|
link_image |
varchar(255) |
||||
|
link_target |
varchar(25) |
||||
|
link_description |
varchar(255) |
||||
|
link_visible |
varchar(20) |
IND |
Y |
||
|
link_owner |
bigint(20) unsigned |
1 |
|||
|
link_rating |
int(11) |
0 |
|||
|
link_updated |
datetime |
0000-00-00 00:00:00 |
|||
|
link_rel |
varchar(255) |
||||
|
link_notes |
mediumtext |
||||
|
link_rss |
varchar(255) |
Indexes
|
Keyname |
Type |
Cardinality |
Field |
|
PRIMARY |
PRIMARY |
7 |
link_ID |
|
link_visible |
INDEX |
None |
link_visible |
Table: wp_options
|
Field |
Type |
Null |
Key |
Default |
Extra |
|
option_id |
bigint(20) unsigned |
PRI |
NULL |
auto_increment |
|
|
option_name |
varchar(64) |
||||
|
option_value |
longtext |
||||
|
autoload |
varchar(20) |
yes |
Indexes
|
Keyname |
Type |
Cardinality |
Field |
|
PRIMARY |
PRIMARY |
184 |
option_id |
|
option_name |
UNIQUE |
184 |
option_name |
Table: wp_postmeta
|
Field |
Type |
Null |
Key |
Default |
Extra |
|
meta_id |
bigint(20) unsigned |
PRI |
NULL |
auto_increment |
|
|
post_id |
bigint(20) unsigned |
IND |
0 |
FK->wp_posts.ID |
|
|
meta_key |
varchar(255) |
YES |
IND |
NULL |
|
|
meta_value |
longtext |
YES |
NULL |
Indexes
|
Keyname |
Type |
Cardinality |
Field |
|
PRIMARY |
PRIMARY |
13 |
meta_ID |
|
post_id |
INDEX |
15 |
post_id |
|
meta_key |
INDEX |
7 |
meta_key |
Table: wp_posts
|
FieldDes |
Field |
Type |
Null |
Key |
Default |
Extra |
|
文章ID |
ID |
bigint(20) unsigned |
PRI & IND Pt4 |
auto_increment |
||
|
文章作者 |
post_author |
bigint(20) unsigned |
0 |
FK->wp_users.ID |
||
|
发布日期 |
post_date |
datetime |
IND Pt3 |
0000-00-00 00:00:00 |
||
|
发布日期gmt |
post_date_gmt |
datetime |
0000-00-00 00:00:00 |
|||
|
文章内容 |
post_content |
longtext |
||||
|
文章标题 |
post_title |
text |
||||
|
文章摘要 |
post_excerpt |
text |
||||
|
文章状态 |
post_status |
varchar(20) |
IND PT2 |
publish |
||
|
评论状态 |
comment_status |
varchar(20) |
open |
|||
|
PING状态 |
ping_status |
varchar(20) |
open |
|||
|
文章密码 |
post_password |
varchar(20) |
||||
|
文章缩略名 |
post_name |
varchar(200) |
IND |
|||
|
to_ping |
text |
|||||
|
已经ping过的连接 |
pinged |
text |
||||
|
修改时间 |
post_modified |
datetime |
0000-00-00 00:00:00 |
|||
|
修改时间gmt |
post_modified_gmt |
datetime |
0000-00-00 00:00:00 |
|||
|
post_content_filtered |
longtext |
|||||
|
父文章，主要用于PAGE |
post_parent |
bigint(20) unsigned |
0 |
FK->wp_posts.ID |
||
|
guid |
varchar(255) |
|||||
|
菜单排序ID |
menu_order |
int(11) |
0 |
|||
|
文章类型 |
post_type |
varchar(20) |
IND Pt1 |
post |
||
|
MIME类型 |
post_mime_type |
varchar(100) |
||||
|
评论总数 |
comment_count |
bigint(20) |
0 |
Indexes
|
Keyname |
Type |
Cardinality |
Field |
|
PRIMARY |
PRIMARY |
2 |
ID |
|
post_name |
INDEX |
None |
post_name |
|
type_status_date |
INDEX |
None |
post_type |
|
post_parent |
INDEX |
None |
post_parent |
|
post_author |
INDEX |
None |
post_author |
Table: wp_terms
|
FieldDes |
Field |
Type |
Null |
Key |
Default |
Extra |
|
分类ID |
term_id |
bigint(20) unsigned |
PRI |
auto_increment |
||
|
分类名 |
name |
varchar(200) |
||||
|
缩略名 |
slug |
varchar(200) |
UNI |
|||
|
term_group |
bigint(10) |
0 |
Indexes
|
Keyname |
Type |
Cardinality |
Field |
|
PRIMARY |
PRIMARY |
2 |
term_ID |
|
slug |
UNIQUE |
2 |
slug |
|
name |
Index |
none |
name |
Table: wp_term_relationships
|
FieldDes |
Field |
Type |
Null |
Key |
Default |
Extra |
|
文章ID |
object_id |
bigint(20) unsigned |
PRI Pt1 |
0 |
||
|
分类方法ID |
term_taxonomy_id |
bigint(20) unsigned |
PRI Pt2 & IND |
0 |
FK->wp_term_taxonomy.term_taxonomy_id |
|
|
排序 |
term_order |
int(11) |
0 |
Indexes
|
Keyname |
Type |
Cardinality |
Field |
|
PRIMARY |
PRIMARY |
8 |
object_id |
|
term_taxonomy_id |
INDEX |
None |
term_taxonomy_id |
Table: wp_term_taxonomy
|
FieldDes |
Field |
Type |
Null |
Key |
Default |
Extra |
|
分类方法ID |
term_taxonomy_id |
bigint(20) unsigned |
PRI |
auto_increment |
||
|
分类条目ID |
term_id |
bigint(20) unsigned |
UNI Pt1 |
0 |
FK->wp_terms.term_id |
|
|
分类方法 |
taxonomy |
varchar(32) |
UNI Pt2 |
|||
|
描述 |
description |
longtext |
||||
|
所属父分类方法 |
parent |
bigint(20) unsigned |
0 |
|||
|
文章数统计 |
count |
bigint(20) |
0 |
Indexes
|
Keyname |
Type |
Cardinality |
Field |
|
PRIMARY |
PRIMARY |
2 |
term_taxonomy_id |
|
term_id_taxonomy |
UNIQUE |
2 |
term_id |
|
taxonomy |
INDEX |
None |
taxonomy |
Table: wp_usermeta
|
Field |
Type |
Null |
Key |
Default |
Extra |
|
umeta_id |
bigint(20) unsigned |
PRI |
NULL |
auto_increment |
|
|
user_id |
bigint(20) unsigned |
'0' |
FK->wp_users.ID |
||
|
meta_key |
varchar(255) |
Yes |
IND |
NULL |
|
|
meta_value |
longtext |
Yes |
IND |
NULL |
Indexes
|
Keyname |
Type |
Cardinality |
Field |
|
PRIMARY |
PRIMARY |
9 |
umeta_id |
|
user_id |
INDEX |
None |
user_id |
|
meta_key |
INDEX |
None |
meta_key |
Table: wp_users
|
FieldDes |
Field |
Type |
Null |
Key |
Default |
Extra |
|
主键ID |
ID |
bigint(20) unsigned |
PRI |
NULL |
auto_increment |
|
|
用户名 |
user_login |
varchar(60) |
IND |
|||
|
密码 |
user_pass |
varchar(64) |
||||
|
昵称 |
user_nicename |
varchar(50) |
IND |
|||
|
电子邮件 |
user_email |
varchar(100) |
||||
|
用户url |
user_url |
varchar(100) |
||||
|
注册时间 |
user_registered |
datetime |
0000-00-00 00:00:00 |
|||
|
注册码 |
user_activation_key |
varchar(60) |
||||
|
状态 |
user_status |
int(11) |
0 |
|||
|
名称描述 |
display_name |
varchar(250) |
Indexes
|
Keyname |
Type |
Cardinality |
Field |
|
PRIMARY |
PRIMARY |
1 |
ID |
|
user_login_key |
INDEX |
None |
user_login |
|
user_nicename |
INDEX |
None |
user_nicename |