ER diagram (database schema) template

Entities as tables with columns, types and keys, joined by one-to-many relationships — sketch a schema before the migration.

Use this templateFree, opens in your browser. No sign-up.

ER diagram (database schema) template
users
type
key
id
uuid
PK
email
text
unique
name
text
created_at
timestamptz
orders
type
key
id
uuid
PK
user_id
uuid
FK → users
status
enum
total_cents
int
placed_at
timestamptz
order_items
type
key
id
uuid
PK
order_id
uuid
FK → orders
product_id
uuid
FK → products
quantity
int
price_cents
int
products
type
key
id
uuid
PK
sku
text
unique
name
text
price_cents
int
1 : N
1 : N
1 : N
PK = primary key
FK = foreign key
Arrows point from the one side to the many side
ER diagram
The ER diagram (database schema) template as it opens in Kelvo: 1 sticky note and 4 tables.

What's on the board

Table 1 columns: users, type, key.

Table 2 columns: orders, type, key.

Table 3 columns: order_items, type, key.

Table 4 columns: products, type, key.

  • 1 : N
  • PK = primary key FK = foreign key Arrows point from the one side to the many side

How to use this template

  1. Click Use this template. It opens in the Kelvo app as a new board, saved in your browser.
  2. Double-click any box to change its text. Replace the examples with your own content.
  3. Paste a table. Paste comma- or tab-separated text and it becomes a table. Tab moves to the next cell and adds rows as you go.
  4. Paste code as code. Paste a snippet and it becomes a code block with syntax colouring; Tab indents inside it.
  5. Link by dragging. Hover a box and drag one of its dots onto another box. The whole box is the target, and links stay attached when you move things.

Good for

  • database
  • erd
  • schema
  • sql
  • engineer
  • Designing a schema or an API before writing it
  • Explaining a tricky flow in a code review or design doc
  • Agreeing on team conventions such as branching and reviews

Related templates

  • Zero-downtime schema migration template previewZero-downtime schema migration

    Expand and contract: change a live database schema in small, reversible deploys, with the table before, during and after.

  • UML class diagram template previewUML class diagram

    Classes with fields and methods, associations with multiplicity, and an interface with two implementations.

  • State machine template previewState machine

    Every state an order can be in and the events that move it — the source of truth for status logic and tests.

  • Sequence diagram (request flow) template previewSequence diagram (request flow)

    Numbered steps across Client, API gateway, service, database and a third party — how one checkout request really travels.

  • Git branching strategy template previewGit branching strategy

    Trunk-based development with short-lived feature branches, pull requests, release branches and a cherry-picked hotfix.

  • Code review checklist template previewCode review checklist

    What to look for in a pull request, from correctness to security, so reviews are fast and consistent.

All software engineering diagram templates · All templates

Use the ER diagram (database schema) template