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.
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.
This section will describe table overview of WordPress.
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.
Each comments are stored in the wp_comments table. You can find all comments in this path “Administration => Comments => Comments” in admin panel.
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
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
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
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
The wp_termmeta table stored all information of posts, categories, and data of post tags.
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
The association of categories and tags from the wp_terms table and this association is stored in wp_term_relationships table.
wp_term_taxonomy table describe the taxonomy (tag, link, category ) entries in the wp_terms table.
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 table stored lists of users. You can use this features from WordPress Admin Interface:
1) Administration > Users
Article Tags: Database, Freebies, Technology, Tip and tricks, Tutorials, Web development, wordpress
