Skip to content
umlimator
Main Navigation GuideAPIExamples
Changelog
npm
Releases

Appearance

Sidebar Navigation

Examples

All examples

Maps

Map

UML structure

Class

Object

Package

Composite structure

Component

Deployment

Profile

UML behaviour

Use case

Activity

State machine

Sequence

Communication

Interaction overview

Timing

Information flow

SysML

Requirement

Block definition

Internal block

Parametric

Architecture, data and process

C4

Entity-relationship

Data flow

Flowchart

BPMN

Mindmap

Cloud architecture

AWS

Google Cloud

Azure

Atlas

The Umlimator Atlas

The Bookshop Atlas

Entity-relationship diagram ​

A bookshop's database: customers, their orders and order lines, the books and their authors, and payments, as seven tables related by their foreign keys, in crow's foot notation. The page below opens on it, A bookshop's database, live: pan, zoom, select and go into the cards that stack.

Open full screen (Entity-relationship)Conformance (Entity-relationship)PDF (Entity-relationship)Model (Entity-relationship)

What it shows ​

In the order you find them in the picture:

  1. Tables as boxes, the name in a header, the key columns above a divider and the rest below it
  2. Column marks: PK, FK, UK and ? for a nullable column (customer's referred_by is FK ?)
  3. A composite primary key whose part is also a foreign key (order_line: order_id PK FK, line_no PK)
  4. A table cut to 3 rows a section then "+2 more" (customer, present rows)
  5. A section collapsed: book shows its keys only (present collapsed columns)
  6. A self-reference: customer referred customer, zero or one to zero or more
  7. Relationship labels on the lines: places, contains, sold as, paid by, referred
  8. Identifying relationships drawn solid (order contains order_line, book and author to book_author)
  9. Non-identifying relationships drawn dashed (customer places order, book sold as order_line)
  10. Crow's foot's exactly one end, two bars (the 1 end of every relationship)
  11. Crow's foot's zero or more end, a ring and a crow's foot (customer places orders 0..*)
  12. Crow's foot's one or more end, a bar and a crow's foot (order contains order_line 1..*)
  13. Crow's foot's zero or one end, a ring and a bar (order paid by payment 0..1)
  14. A many-to-many relationship resolved by a junction table (book_author between book and author)
  15. A note linked to order_line by a dashed line

In another setting ​

The same example, where a setting cannot share the picture above:

The same database in IDEF1X

In IDEF1X (notation idef1x) instead of crow's foot: the same tables and lines, a dot at the child end with P or Z, a hollow diamond at an optional parent, and dependent tables with rounded corners.

Edit this page on GitHub
Pager
Previous pageC4
Next pageData flow