I searched, without success, a brief description of the database of WordPress 2.7. By using the application MySQL WorkBench, and its famous feature « Reverse Engineering », I got a simple but comprehensive schema, which allows me to see the database at a glance.

• This post is an english translation of the post Schéma de la base de données de WordPress 2.7

I remind that the WordPress developpers advise to don’t query the database directly. WordPress gives access to a number of functions able to get any type of information. But sometime these functions can’t get the data we need.

The database schema is the following:

Good queries !