Diagramly

Templates

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

  1. Press Use this template. It opens on the canvas in your browser, free, with no sign-up.
  2. Double-click any shape to rename it, or press / and type a line such as Client -> API -> DB to add to it.
  3. Share it as a link, present it with Shift+P, or export PNG, SVG or PDF.

In this diagram

  • users
  • id
  • email
  • name
  • created_at
  • products
  • sku
  • price
  • orders
  • user_id
  • total
  • status
  • order_items
  • order_id
  • product_id
  • qty
  • places
  • contains
  • in

More templates