Diagram playground

Write a diagram as text and it renders here as you type. Canvas editing for six of ten notations. Nothing leaves your browser. Syntax reference ·

Source text

archlab 1.0 er
title "Course catalogue"
description "A join table whose key is entirely foreign, a course that requires another course, and enrolments that outlive a term."

@er
  entity student "Student" [PostgreSQL]
    desc "Anyone who has ever enrolled, including alumni."
    attr id uuid pk
    attr email string uk
    attr full_name string
  entity course "Course"
    attr id uuid pk
    attr code string uk
      desc "The printed code, e.g. CS101 — unique, but never the primary key, because codes get reused across faculties."
    attr title string
    attr prerequisite_id uuid fk
  entity term "Term"
    attr id uuid pk
    attr name string
    attr starts_on date
  entity enrolment "Enrolment"
    desc "A join table: its primary key is the three foreign keys together, so a student can take a course once per term and no more."
    attr student_id uuid pk fk
    attr course_id uuid pk fk
    attr term_id uuid pk fk
    attr grade string

student ||--o{ enrolment : takes
  course ||--o{ enrolment : "is taken as"
  term ||--o{ enrolment : "runs in"
  course |o--o{ course : requires

Tab indents · Esc then Tab leaves the editor · worked examples

Read-only