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)