hhplus_ticket

Tables (6)

Concert (공연)

  • id (PK) — Primary key — NOT NULL
  • subject (Field)
  • singer (Field2)

ConcertOption (공연 정보)

  • id (PK) — Primary key — NOT NULL
  • concertId (FK) — Foreign key → Concert.id — NOT NULL
  • location (Field)
  • date (Field2)

Seat (좌석)

  • id (PK) — Primary key — NOT NULL
  • status (Field)
  • price (Field2)
  • seatNumber (Field3)
  • concertOptionId (FK) — Foreign key → ConcertOption.id — NOT NULL

Ticket (티켓)

  • id (PK) — Primary key — NOT NULL
  • userId (FK1) — Foreign key → User.id — NOT NULL
  • seatId (FK2) — Foreign key → Seat.id — NOT NULL
  • status (Field)

User (사용자)

  • id (PK) — Primary key — NOT NULL
  • point (Field)

Waitlist (대기열)

  • id (PK) — Primary key — NOT NULL
  • userId (FK) — Foreign key → User.id — NOT NULL
  • number (Field2)
  • status (Field)
  • statusUpdatedAt (Field3)