Ticketing

Tables (6)

concert (콘서트 정보)

  • id (concert_id) — long — Primary key — NOT NULL
  • title (Field) — archar
  • description (Field2) — TEXT
  • created_at (Field3) — datetime
  • updated_at (Field4) — datetime

concert_schedule (콘서트_스케줄(날짜, 회차))

  • id (concert_schedule_id) — long — Primary key — NOT NULL
  • id (concert_id) — long — Foreign key → concert.id — NOT NULL
  • concert_date (Field) — datetime
  • total_seats (Field2) — int
  • created_at (Field3) — datetime
  • updated_at (Field4) — datetime

payment (결제 정보(PG사, 금액, 상태))

  • id (payment_id) — long — Primary key — NOT NULL
  • id (reservation_id) — long — Foreign key → reservation.id — NOT NULL
  • amount (Field) — decimal
  • payment_key (Field2) — varchar
  • status (Field3) — enum
  • created_at (Field4) — datetime
  • updated_at (Field5) — datetime

reservation (예약 정보(누가, 언제, 어떤 좌석을 찜했나))

  • id (reservation_id) — long — Primary key — NOT NULL
  • id (user_id) — Long — Foreign key → user.id — NOT NULL
  • id (seat_id) — long — Foreign key → seat.id — NOT NULL
  • expired_at (Field) — datetime
  • created_at (Field2) — datetime
  • updated_at (Field3) — datetime

seat (좌석 정보(번호, 가격, 등급, 상태, 버전))

  • id (seat_id) — long — Primary key — NOT NULL
  • id (concert_schedule_id) — long — Foreign key → concert_schedule.id — NOT NULL
  • seat_no (Field) — int
  • price (Field2) — decimal(10,2)
  • status (Field3) — varchar
  • version (Field4) — big int
  • created_at (Field5) — datetime
  • updated_at (Field6) — date_time

user (사용자)

  • id (user_id) — Long — Primary key — NOT NULL
  • email (Field) — varchar
  • password (Field2) — varchar
  • name (Field3) — varchar
  • created_at (Field4) — timestamp
  • updated_at (Field5)