WordPress Database Tables

PRIMER: The WordPress Database Tables

By The WordPress Helpers 5 Comments

WordPress Database Tables

Working on WordPress? Ready to take our advice that the WordPress Database is something you really need to understand a little bit about? Let’s move onto what’s in the WordPress Database Tables.

It isn’t possible to give you a complete tutorial on what tables make up the WordPress database. Why? Plug-ins often add extra tables to it, so the WordPress Database Tables is a moving target. How big a target? At the moment, the WordPress database running this web site has 73 tables in it.

That’s pretty complex, and for good reason; The WordPress Helpers has a lot going on behind the scenes. But a clean install of WordPress starts out with exactly eleven tables. Here they are:

Welcome to The WordPress Helpers’ default database table schematic
This table stores additional information related to the comments
This table stores the information for each individual comment. Data like the comment’s author, email, URL, IP address, data, and the comment itself are included.

This table holds links to your blogroll. This was a popular feature in the past for users to post a list of blogs they followed or recommended. No longer as popular, this table remains in the WordPress Database primarily for backward compatibility.

The options table is where all the settings for your site are stored, like the configuration of theme, plugins, widget data and temporary cached data. Plugin and theme settings are normally stored here too, if they aren’t in their own table.
As with the commentmeta table, postmeta holds any extra information about individual posts. Items like images attached to a post or custom fields information is stored in this database table. 
 This table is where all of your posts, pages, attachments, revisions, menu items, and custom post types are stored. Discount the connections to “other stuff” and the posts table IS your WordPress data. 
This table connects WordPress terms with taxonomies. 
WordPress terms live in this table. The structure of this table allows you to use the same term across different taxonomies. 
Terms are items of a taxonomy that classify objects. Both ‘Category’ and ‘Tags’ are examples of taxonomies. Taxonomies can also be created for custom post types. All the WordPress taxonomies are stored in this table. 
This table stores extra information about each user. It includes some of the user profile fields as well as each user’s privileges for the site. 
WordPress’ basic user management information is here. Information like user login, user password, and display name are stored in this table. 

Even if you perform manual maintenance on your WordPress database, you may well never look at the content of many of the WordPress database tables. In fact, several are comprised of nothing besides codes pointing the database from one location to another. But WordPress database tables are a starting point for all kinds of things you can manage in a pinch. We wrote today, for example, about manually tweaking a WordPress password.

Still there? Stick around. Want to make sure we keep you up to date on WordPress database tables and all kinds of other important WordPress topics? Sign up below!

Source: yourwebsiteengineer.com 
Primer: The WordPress Database Tables”
The WordPress Helpers: Making WordPress Work
The WordPress Database Tables
Article Title:
The WordPress Database Tables
Subject:
Is there a drier topic than WordPress database tables? We've never seen one. But learning your way around the WordPress database tables could save your life
Author:
Free Stuff!
No charge. No SPAM. Unsubscribe any time.

We'll send a weekly email with the latest information, recommendations, quick WordPress tips and more. We're serious about privacy and won't spam you or sell your information.

Or if you prefer, subscribe to our RSS feed. Stay up to date, live!