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
WordPress 2.7 Database Schema

Download the file directly:

WordPress 2.7 Database Schema
Titre: WordPress 2.7 Database Schema (445 clics)
Légende: WordPress 2.7 Database Schema
Nom du fichier: wp270_database_schema.png
Taille: 87 KB

Titre: wp270_database_schema_logo (375 clics)
Nom du fichier: wp270_database_schema_logo.png
Taille: 10 KB

Good queries !