drawDB blog
Guides to database schema design, data modeling and SQL for PostgreSQL, MySQL, SQLite, SQL Server and Oracle. Every post is built on real schemas from the drawDB schema gallery, so you can open what you read in the editor and export the SQL. Also available as an RSS feed.
· 8 min read
Database schema design best practices, measured across 100 schemas and 1,232 tables
We audited all 1,232 tables in the drawDB schema gallery: primary keys, naming, timestamps, money, ON DELETE rules and foreign key indexes, with fixes.
schema-designpostgresqldata-modelingindexes