Conference / event management schema template

Tables in this data model

• events — 4 columns
• tracks — 3 columns
• speakers — 4 columns
• sessions — 6 columns
• session_speakers — 3 columns
• attendees — 3 columns
• tickets — 5 columns
• session_checkins — 4 columns

How to use this ER diagram template

1. Click Open in the editor. The ER diagram opens on a new page in FlowDiagram — nothing is uploaded and there is no sign-up.
2. Rename, add or delete shapes and drag them where you want; connectors stay attached as things move.
3. Drop in vendor logos from the library — 1,160 of them, including every AWS, Azure and Google Cloud service icon — or restyle it with the colour and theme controls.
4. Prefer text? Edit the DBML below and paste it in through ☰ → Import diagram; the finished model exports to SQL DDL or back to DBML.
5. Export to PNG, SVG or PDF, or press Ctrl+L for a link that carries the whole diagram.

DBML source

The whole template is the text below. Paste it into FlowDiagram, keep it in Git next to the code it describes, or hand it to an AI assistant to extend.

Table events {
  id integer [pk]
  name varchar
  starts_on date
  venue varchar
}

Table tracks {
  id integer [pk]
  event_id integer [ref: > events.id]
  name varchar
}

Table speakers {
  id integer [pk]
  name varchar
  company varchar
  bio text
}

Table sessions {
  id integer [pk]
  track_id integer [ref: > tracks.id]
  title varchar
  room varchar
  starts_at timestamp
  capacity integer
}

Table session_speakers {
  id integer [pk]
  session_id integer [ref: > sessions.id]
  speaker_id integer [ref: > speakers.id]
}

Table attendees {
  id integer [pk]
  name varchar
  email varchar [unique]
}

Table tickets {
  id integer [pk]
  event_id integer [ref: > events.id]
  attendee_id integer [ref: > attendees.id]
  ticket_type varchar
  price decimal
}

Table session_checkins {
  id integer [pk]
  session_id integer [ref: > sessions.id]
  attendee_id integer [ref: > attendees.id]
  checked_in_at timestamp
}

Related: Database schema diagram tool · All government, non-profit & events templates · All 521 templates