Event Management Database Schema

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
  }