WordPress database | 12 tables

12 tables inside the database

1. wp_termmeta
2. wp_users
3. wp_usermeta
4. wp_terms
5. wp_term_taxonomy
6. wp_term_relationships
7. wp_posts
8. wp_users
9. wp_comments
10. wp_commentmeta
11. wp_links
12. wp_postmeta

From version 4.4.2 onwards, WordPress has 12 tables inside the database. These tables are used to perform various default functionalities of WordPress. However, this number can vary depending upon the number of themes and plugins installed in your WordPress.

Each plugin and theme create its own tables and it won’t be wrong to say that more the plugins you install the more tables you will have in your database. Let’s see the WordPress Database Diagram, so we can have a basic understanding of how a database works in WordPress.

Let’s take a look at what each database table stores:

1. wp_users: Whenever you create a user is stored in this table along with its details and status.
2. wp_usermeta: Stores meta information of users.
3. wp_posts: Custom post types, pages data, and post data are stored in this table.
4. wp_postmeta: Post meta information store here.
5. wp_comments: This table stores comments placed on your site.
6. wp_commentmeta: Meta information for comments stored here.
7. wp_terms: Tags and categories for both posts and links are stored here.
8. wp_termmeta: Meta information for terms stored here.
9. wp_term_relationships: This stores the relationship between the members of wp_terms.
10. wp_term_texonomy: Description of a category, link, or tag used in a wp_term table stored here.
11. wp_links: This stores blogroll links that are depreciated but can be activated using Link Manager.
12. wp_options: Options set in admin are stored here.