Translations:Manual:Database layout/1/en

The current $mysql diagram for any MediaWiki version—with extensive comments—can be found in the $tables source file. The most important tables are probably page, revision and text.