WordPress Database Architecture Design With Descriptions

| Last Updated: | In: Wordpress, WordPress Beginners


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

Tags: , , , , , ,


About: Prem Tiwari

Prem Tiwari is founder of freewebmentor.com and Software developer from New Delhi (India). Follow Prem's development codes on facebook, and make sure you check out freewebmentor.com for the latest in web development related Tips with the complete code.


You may also like:

Follow us!

Get Free Access of 350+ Scripts

Don't worry you'll not be spammed!

Featured eBook

WordPress Security Guide

Learn how to implement security guideline in your WordPress site...

DOWNLOAD

Pincode Finder

pincode-finder tool

Online Pincode Finder

Best tool to locate post Office address and pincodes of all india...

SEARCH NOW