In today’s post I will explain very useful thing. If you want to start working on WordPress OR you are a WordPress beginners, then it is very important for you to understand the wordpress database architecture design.

I am going to explain WordPress database architecture design with description of each tables which generate during your fresh wordpress installations. Before WordPress 3.8 version wordpress uses only (11) Tables, but now wordpress uses (12) tables.

Database Architecture Diagram

Below database architecture diagram will describe a visual overview of WordPress database tables. It will also describe tables relation overview which is created during wordpress standard installation.

wordpress-database-architecture-erd

WordPress Tables Overview

This section will describe table overview of WordPress.

wp_commentmeta

Each user’s comments features information stored in wp_commentmeta table. You can find all comments in this path “Administration => Comments => Comments” in admin panel.

wp_comments

Each comments are stored in the wp_comments table. You can find all comments in this path “Administration => Comments => Comments” in admin panel.

wp_links

This wp_links table stored all information which entered into links feature of WordPress.
Please note that this features has been deprecated in latest WordPress version, but if you want to use this feature you need to install Links Manager plugin. You can use this features from WordPress Admin Interface:

1) Administration > Links > Add New
2) Administration > Links > Links

wp_options

All your websites configurations and settings are stored in wp_options table. You can use this features from WordPress Admin Interface:

1) Administration > Settings > General
2) Administration > Settings > Writing
3) Administration > Settings > Reading
4) Administration > Settings > Discussion
5) Administration > Settings > Privacy
6) Administration > Settings > Permalinks
7) Administration > Appearance > Widgets

wp_postmeta

This table holds each posts features informations. You can use this features from WordPress Admin Interface:

1) Administration > Posts > Add New
2) Administration > Pages > Add New

wp_posts

This wp_posts table is most important table in WordPress which holds posts, pages, navigation menu and custom post types data. You can use this features from WordPress Admin Interface:

1) Administration > Posts > Add New
2) Administration > Posts > Posts
3) Administration > Pages > Add New
4) Administration > Pages > Pages
5) Administration > Media > Add New
6) Administration > Media > Library
7) Administration > Appearance > Menus

wp_termmeta

The wp_termmeta table stored all information of posts, categories, and data of post tags.

wp_terms

This wp_terms table holds posts, categories, links and post’s tags data. You can use this features from WordPress Admin Interface:

1) Administration > Posts > Post Tags
2) Administration > Posts > Categories
3) Administration > Posts > Add New
4) Administration > Posts > Posts
5) Administration > Pages > Add New
6) Administration > Page > Pages

wp_term_relationships

The association of categories and tags from the wp_terms table and this association is stored in wp_term_relationships table.

wp_term_taxonomy

wp_term_taxonomy table describe the taxonomy (tag, link, category ) entries in the wp_terms table.

wp_usermeta

wp_usermeta table stored all the users feature information like nickname, first_name, last_name, description, wp_user_level, wp_capabilities, etc. You can use this features from WordPress Admin Interface:

1) Administration > Users

wp_users

wp_users table stored lists of users. You can use this features from WordPress Admin Interface:

1) Administration > Users