WordPress 2.7 database schema

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.

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:

WordPress 2.7 Database Schema

Good queries !