ticket-reservation-db

Tables (3)

performances (Untitled)

  • id (PK) — bigint generated by default — Primary key — NOT NULL
  • title (Field) — text
  • venue (Field2) — text
  • starts_at (Field3) — timestamptz
  • price (Field4) — integer

reservations

  • id (PK) — bigint generated by default — Primary key — NOT NULL
  • seat_id (FK)
  • customer_name (Field2) — text
  • customer_email (Field3) — text
  • reserved_at (Field4) — timestamptz

seats (Untitled2)

  • id (PK) — bigint generated by default — Primary key — NOT NULL
  • performance_id (FK) — bigint generated by default — Foreign key → performances.id — NOT NULL
  • row_label (Field2) — text
  • seat_number (Field3) — integer
  • is_available (Field4) — boolean