CloudSketch AI Logo
FeaturesTemplatesPricingEnterpriseAboutContactLog in
🌙☀️
Log inStart free
Home/Templates/Events, Ticketing & Creators

🎟️ Events, Ticketing & Creators · Database ERD

Event Management Database Schema

Tables for an event platform: organisers, events, venues, ticket types, orders, tickets and check-ins.

More Events, Ticketing & Creators templates

Opening a template is free and never counts toward your daily diagrams. Asking the AI to change it counts as one.

Drawing diagram…

What this diagram shows

  • Each event has several ticket types with their own limits
  • One order can contain several tickets
  • Check-ins are stored per ticket

Prompt used

Event platform database: organisers create events at venues; events have ticket types (early bird, VIP) with price and quantity; attendees place orders containing tickets of a ticket type; each ticket has a unique code and can have one check-in.

Mermaid code
erDiagram
  ORGANISER ||--o{ EVENT : creates
  VENUE ||--o{ EVENT : hosts
  EVENT ||--|{ TICKET_TYPE : offers
  ATTENDEE ||--o{ TICKET_ORDER : places
  TICKET_ORDER ||--|{ TICKET : contains
  TICKET_TYPE ||--o{ TICKET : "issued as"
  TICKET ||--o| CHECKIN : "scanned in"
  ORGANISER {
    int id PK
    string name
    string gstin
  }
  VENUE {
    int id PK
    string name
    string city
    int capacity
  }
  EVENT {
    int id PK
    int organiser_id FK
    int venue_id FK
    string title
    datetime starts_at
  }
  TICKET_TYPE {
    int id PK
    int event_id FK
    string name
    decimal price
    int quantity
  }
  ATTENDEE {
    int id PK
    string name
    string email
  }
  TICKET_ORDER {
    int id PK
    int attendee_id FK
    decimal total
    string status
  }
  TICKET {
    int id PK
    int order_id FK
    int ticket_type_id FK
    string code
  }
  CHECKIN {
    int id PK
    int ticket_id FK
    string gate
    datetime scanned_at
  }

Inside this diagram

An entity relationship diagram with 8 tables, 32 columns and 7 relationships.

Tables and their columns

  • ORGANISER: id (PK), name, gstin
  • EVENT: id (PK), organiser_id (FK), venue_id (FK), title, starts_at
  • VENUE: id (PK), name, city, capacity
  • TICKET_TYPE: id (PK), event_id (FK), name, price, quantity
  • ATTENDEE: id (PK), name, email
  • TICKET_ORDER: id (PK), attendee_id (FK), total, status
  • TICKET: id (PK), order_id (FK), ticket_type_id (FK), code
  • CHECKIN: id (PK), ticket_id (FK), gate, scanned_at

Relationships

  • ORGANISER creates EVENT: each ORGANISER has zero or more EVENT, each EVENT belongs to exactly one ORGANISER
  • VENUE hosts EVENT: each VENUE has zero or more EVENT, each EVENT belongs to exactly one VENUE
  • EVENT offers TICKET_TYPE: each EVENT has one or more TICKET_TYPE, each TICKET_TYPE belongs to exactly one EVENT
  • ATTENDEE places TICKET_ORDER: each ATTENDEE has zero or more TICKET_ORDER, each TICKET_ORDER belongs to exactly one ATTENDEE
  • TICKET_ORDER contains TICKET: each TICKET_ORDER has one or more TICKET, each TICKET belongs to exactly one TICKET_ORDER
  • TICKET_TYPE issued as TICKET: each TICKET_TYPE has zero or more TICKET, each TICKET belongs to exactly one TICKET_TYPE
  • TICKET scanned in CHECKIN: each TICKET has zero or one CHECKIN, each CHECKIN belongs to exactly one TICKET

Make your own diagram like this

Describe your own system in plain English and the AI ER diagram generator draws it in seconds, in the same style as this template.

Related templates

C4 ArchitectureProEvents, Ticketing & Creators

Concert Ticketing Platform

A ticketing platform built for big on-sales: a virtual waiting room, seat holds, anti-bot checks, payments and mobile tickets with rotating QR codes.

SequenceEvents, Ticketing & Creators

Event Entry Check-in Sequence

How attendees get into an event quickly: QR scan at the gate, validity check that works even if the internet drops, and a live attendance count.

C4 ArchitectureProEvents, Ticketing & Creators

Creator Membership Platform

A platform where creators sell monthly memberships with exclusive posts, videos and community chat, and get paid out monthly.

FlowchartEvents, Ticketing & Creators

Social Content Moderation

How user posts on a social or creator platform are moderated: automatic checks, human review of doubtful content, and appeals.

State MachineEvents, Ticketing & Creators

Ticket Order States

The states of a ticket order, from seat hold through payment to use at the event, including refunds when an event is cancelled.

SankeyEvents, Ticketing & Creators

Creator Monthly Revenue Mix

Where a mid-sized creator's monthly income comes from and where it goes, in thousands of rupees, to plan a sustainable creator business.