DBML examples

DBML reads like simplified DDL, which is exactly why it stays honest: it is close enough to the real schema to check against it.

Three complete schemas, each exercising a different modelling problem.

#Every example here is real

Each page holds a diagram that is stored, rendered and editable exactly like one you drew yourself. Open any of them, change something, and see what happens. Nothing here is a screenshot.

#In this set

eCommerce database (DBML)Orders, products and customers written in DBML and rendered as an ER diagram.Inventory management (DBML)A stock, warehouse and movement schema in DBML kept next to the design docs.Social media database (DBML)Users, posts, follows and likes modelled in DBML as a relationship diagram.

Reference

The language reference behind these.

Diagram types

Grouped by what you want to draw.

Examples

Every other set.

Close enough to the schema to stay true.