WordPress.org

Codex

Database Description/2.3

This article, written to accord with WordPress 2.3, is now obsolete. Please take caution when following its contents, as many things may have changed.

Contents

The following is an outline and description of the database tables created during the standard installation of WordPress at Version 2.3.

Because WordPress interfaces with this database by itself, you as an end user, shouldn't have to worry much about its structure. If you're Writing a Plugin, however, you may be interested in learning how to interface with the database directly. WordPress provides the wpdb Class to make this task easy.

Table Overview

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 2.3 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 Panels >> Manage >> Comments
wp_links The wp_links holds information related to the links entered into the Blogroll Manager feature of WordPress. Administration Panels >> Blogroll >> Manage Blogroll
Administration Panels >> Blogroll >> Add Links
Administration Panels >> Blogroll >> Import Links
wp_options The Options set under the Administration > Options panel are stored in the wp_options table. Administration Panels >> Options > > General
Administration Panels >> Options > >Writing
Administration Panels >> Options > >Reading
Administration Panels >> Options > >Discussion
Administration Panels >> Options > >Permalinks
Administration Panels >> Options > >Miscellaneous
wp_postmeta Each post features information called the meta data and it is stored in the wp_postmeta. Some tag plugins, and other plugins may add their own information to this table. Administration Panels >> Write >> Write a Post
wp_posts The core of the WordPress data is the posts. It is stored in the wp_posts table. Administration Panels >> Write >> Write a Post
wp_terms The categories for both posts and links and the tags for posts are found within the wp_terms table. Administration Panels >> Manage >> Categories
Administration Panels >> Write >> Write Post
Administration Panels >> Manage >> Posts >> Edit
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. Administration Panels >> Manage >> Categories
Administration Panels >> Write >> Write Post
Administration Panels >> Manage >> Posts >> Edit
wp_term_taxonomy This table describes the taxonomy (category, link, or tag) for the entries in the wp_terms table. Administration Panels >> Manage >> Categories
Administration Panels >> Write >> Write Post
Administration Panels >> Manage >> Posts >> Edit
wp_usermeta Each user features information called the meta data and it is stored in wp_usermeta. Administration Panels >> Users
wp_users The list of users is maintained in table wp_users. Administration Panels >> Users


Table Details

The following are the specific fields in each of the tables created during the standard WordPress installation.

Table: wp_comments

FieldTypeNullKeyDefaultExtra
comment_IDbigint(20) unsigned PRINULLauto_increment
comment_post_IDint(11) IND0FK->wp_posts.ID
comment_authortinytext    
comment_author_emailvarchar(100)    
comment_author_urlvarchar(200)    
comment_author_IPvarchar(100)    
comment_datedatetime  0000-00-00 00:00:00 
comment_date_gmtdatetime  0000-00-00 00:00:00 
comment_contenttext    
comment_karmaint(11)  0 
comment_approvedenum('0','1','spam') IND1 
comment_agentvarchar(255)    
comment_typevarchar(20)    
comment_parentbigint(20)  0FK->wp_comment.ID
user_idbigint(20)  0FK->wp_users.ID

Table: wp_links

FieldTypeNullKeyDefaultExtra
link_idbigint(20) PRINULLauto_increment
link_urlvarchar(255)    
link_namevarchar(255)    
link_imagevarchar(255)    
link_targetvarchar(25)    
link_categorybigint(20) IND0FK->wp_categories.cat_ID
link_descriptionvarchar(255)    
link_visibleenum('Y','N') INDY 
link_ownerint(11)  1 
link_ratingint(11)  0 
link_updateddatetime  0000-00-00 00:00:00 
link_relvarchar(255)    
link_notesmediumtext    
link_rssvarchar(255)    


Table: wp_options

FieldTypeNullKeyDefaultExtra
option_idbigint(20) PRINULLauto_increment
blog_idint(11) PRI0 
option_namevarchar(64) PRI&IND  
option_can_overrideenum('Y','N')  Y 
option_typeint(11)  1 
option_valuelongtext   
option_widthint(11)  20 
option_heightint(11)  8 
option_descriptiontinytext   
option_admin_levelint(11)  1 
autoloadenum('yes','no')  yes 


Table: wp_postmeta

FieldTypeNullKeyDefaultExtra
meta_idbigint(20) PRINULLauto_increment
post_idbigint(20) IND0FK->wp_posts.ID
meta_keyvarchar(255)YESINDNULL 
meta_valuelongtextYES NULL 


Table: wp_posts

FieldTypeNullKeyDefaultExtra
IDbigint(20) unsigned PRINULLauto_increment
post_authorbigint(20)  0FK->wp_users.ID
post_datedatetime  0000-00-00 00:00:00 
post_date_gmtdatetime  0000-00-00 00:00:00 
post_contentlongtext    
post_titletext    
post_categoryint(4)  0FK->wp_categories.cat_ID
post_excerpttext    
post_statusenum('publish','draft','private','static','object','attachment','inherit','future') INDpublish 
comment_statusenum('open','closed','registered_only')  open 
ping_statusenum('open','closed')  open 
post_passwordvarchar(20)    
post_namevarchar(200) IND  
to_pingtext    
pingedtext    
post_modifieddatetime  0000-00-00 00:00:00 
post_modified_gmtdatetime  0000-00-00 00:00:00 
post_content_filteredtext   
post_parentbigint(20)  0FK->wp_posts.ID
guidvarchar(255)    
menu_orderint(11)  0 
post_typevarchar(20)  post 
post_mime_typevarchar(100)    
comment_countbigint(20)  0 

Table: wp_terms

FieldTypeNullKeyDefaultExtra
term_idbigint(20) PRI auto_increment
namevarchar(55)     
slugvarchar(200) UNI IND  
term_groupbigint(10)  0 

Table: wp_term_relationships

FieldTypeNullKeyDefaultExtra
object_idbigint(20) PRI Pt10 
term_taxonomy_idbigint(20) PRI Pt2, IND0FK->wp_term_taxonomy.term_taxonomy_id

Table: wp_term_taxonomy

FieldTypeNullKeyDefaultExtra
term_taxonomy_idbigint(20) PRI auto_increment
term_idbigint(20) UNI IND Pt10 FK->wp_terms.term_id
taxonomyvarchar(32) UNI IND Pt2  
descriptionlongtext    
parentbigint(20)  0 
countbigint(20)  0 

Table: wp_usermeta

FieldTypeNullKeyDefaultExtra
umeta_idbigint(20) PRINULLauto_increment
user_idbigint(20)  '0'FK->wp_users.ID
meta_keyvarchar(255) INDNULL 
meta_valuelongtext INDNULL 


Table: wp_users

FieldTypeNullKeyDefaultExtra
IDbigint(20) unsigned PRINULLauto_increment
user_loginvarchar(60) UNI & IND  
user_passvarchar(64)    
user_nicenamevarchar(50)    
user_emailvarchar(100)    
user_urlvarchar(100)    
user_registereddatetime  0000-00-00 00:00:00 
user_levelint(2) unsigned  0 
user_activation_keyvarchar(60)   
user_statusint(11)  0 
display_namevarchar(250)     

Resources