hhplus-concert-server-java

Tables (9)

Concert (Untitled5)

  • id — int — Primary key — NOT NULL
  • title — varchar
  • status — int
  • createdAt — datetime
  • updatedAt — datetime

ConcertSeat (Untitled7)

  • id — int — Primary key — NOT NULL
  • concet_time_id (concert_time_id) — int — Foreign key → ConcertTime.id — NOT NULL
  • status — int
  • createdAt — datetime
  • updatedAt — datetime

ConcertTime (Untitled6)

  • id — int — Primary key — NOT NULL
  • concert_id — int — Foreign key → Concert.id — NOT NULL
  • start_time — datetime
  • end_time — datetime
  • max_cnt — int
  • left_cnt — int
  • price (Field) — int
  • Field2

Point (Untitled3)

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → User.id — NOT NULL
  • balance — int

PointHistory (Untitled4)

  • id — int — Primary key — NOT NULL
  • point_id — int — Foreign key → Point.id — NOT NULL
  • status — int
  • createdAt — int
  • updatedAt — int

User (Untitled)

  • id — int — Primary key — NOT NULL
  • name — int

WaitQueue (Untitled2)

  • id — int — Primary key — NOT NULL
  • uuid (Field) — string
  • status — int
  • createdAt — datetime
  • updatedAt — datetime

payment (Untitled9)

  • id (Key) — 결제ID — Primary key — NOT NULL
  • reservation_id (id) — int — Foreign key → reservation.id — NOT NULL
  • status (Field) — String
  • use_point (Field2)
  • pointHistory (id2) — int — Foreign key → PointHistory.id — NOT NULL

reservation (Untitled8)

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → User.id — NOT NULL
  • Field
  • concet_seat_id (id2) — int — Foreign key → ConcertSeat.id — NOT NULL