ERD examples

The ERD format is small and focused, and the markers are the whole notation. Four examples cover all of it.

Compare the commerce schema here against the DBML version to see which format suits which purpose.

#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

Entity relationship diagram (ERD)A worked ER diagram in the ERD text syntax, with primary and foreign key markers.eCommerce database (ERD)An online store schema in ERD: customers, orders, line items and products.Many-to-many (ERD)Model a many-to-many relationship through a join entity in ERD.Attribute styling (ERD)Style entity headers, labels and attributes using the ERD directive block.

Reference

The language reference behind these.

Diagram types

Grouped by what you want to draw.

Examples

Every other set.

Four symbols, and that is the language.