The most up-to-date schema for the tables in the database will always be sql/tables.json, which is used by the installation script.

That file has been commented with details of the usage for each table and field.

Historical information and some other notes are available at https://www.mediawiki.org/wiki/Manual:Database_layout.