TicketingService

Tables (3)

Reservation (reservation)

  • 아이디 (id) — bigint — Primary key — NOT NULL
  • 티켓아이디 (ticketId) — bigint — Foreign key → Ticket.아이디 — NOT NULL

Ticket (ticket)

  • 아이디 (id) — bigint — Primary key — NOT NULL
  • 예약상태 (reservationStatus) — Enum

TicketReservationAmount (ticketReservationAmount)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (totalAmount) — int
  • Field2 (reservedAmount) — int