Just before I wanted to figure out the database structure of WordPress myself, I found this page with visual overview of the database and the relations between the tables (WP Version 2.5+):
http://codex.wordpress.org/Database_Description
WordPress 2.5+ Database Diagram
