WordPress installation has 11 default tables in the database. Each database table contains data for different sections, features, and functionality of WordPress.
WordPress installation creates the following tables:
- wp_commentmeta :
wp_commentmeta table contains meta information about comments posted on a WordPress website. Table has four fields’ meta_id, comment_id, meta_key, and meta_value. Each meta_id is related with a comment_id. One example of comment Meta information stored is the status of comment.
- wp_comments :
Table contains your WordPress comments. It contains comment author name, url, email, comment, etc.
- wp_links :
To manage blogrolls create by earlier versions of .
- wp_options :
This table contains most of your WordPress site wide settings such as: site url, admin email, default category, posts per page, time format, and much much more. The options table is also used by numerous WordPress plugins to store plugin settings.
- wp_postmeta :
This table contains Meta information about your WordPress posts, pages, and custom post types. Example of post meta information would be which template to use to display a page, custom, etc. Some plugins would also use this table to store plugin data such as WordPress SEO information.
- wp_posts :
The name says posts but actually this table contains all post types or should we say content types. This table contains all your posts, pages, revisions, and custom post types.
- wp_terms :
WordPress has a powerful taxonomy system that allows you to organize your content. Individual taxonomy items are called terms and they are stored in this table. Example, your WordPress categories and tags are taxonomies, and each category and tag inside them is a term.
- wp_term_relationships :
wp_term_relationships wordpress database table manages relationship of WordPress post types with terms in wp_terms table.
- wp_term_taxonomy :
This table defines taxonomies for terms defined in wp_terms table. In short this table has the data that helps WordPress differentiate between which term is a category, which is a tag, etc.
It contains Meta information about Users on your website.
It Contains User information like username, password etc.