ER diagram template
A shop’s data model in four tables: users, products, orders and order_items. Each table lists its columns and keys, and crow’s-foot links show which side of a relationship is many.
Good for
- Designing a database schema before the first migration
- Explaining how tables relate in a design doc
- Teaching one-to-many and many-to-many relationships
How to use it
- Press Use this template. It opens on the canvas in your browser, free, with no sign-up.
- Double-click any shape to rename it, or press / and type a line such as
Client -> API -> DBto add to it. - Share it as a link, present it with Shift+P, or export PNG, SVG or PDF.
In this diagram
- users
- id
- name
- created_at
- products
- sku
- price
- orders
- user_id
- total
- status
- order_items
- order_id
- product_id
- qty
- places
- contains
- in