Manual:Database layout

The current schema for any version - with copious comments - can be found in the maintenance/tables.sql file. See the latest version from SVN. If using Postgres, the file maintenance/postgres/tables.sql should be viewed instead.

Proposed schema changes page contains the discussion for possible improvements to the database schema.