ticketing

Tables (18)

artist (배우)

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR — NOT NULL
  • profile_img — VARCHAR

payment (결제)

  • id — BIGINT — Primary key — NOT NULL
  • order_id — VARCHAR
  • payment_key — VARCHAR
  • amount — BIGINT
  • method — VARCHAR
  • status — VARCHAR
  • cancelable_amount — INT
  • card_company — VARCHAR
  • number — VARCHAR
  • installment_plan_months — VARCHAR
  • provider — VARCHAR
  • discount_amount — BIGINT
  • fail_reason — VARCHAR
  • account_number — VARCHAR
  • bank — VARCHAR
  • customer_name — VARCHAR
  • due_date — TIMESTAMP
  • requested_at — TIMESTAMP
  • approved_at — TIMESTAMP

payment_cancel (결제 취소)

  • id — BIGINT — Primary key — NOT NULL
  • payment_id — BIGINT — Foreign key → payment.id — NOT NULL
  • provider — VARCHAR
  • discount_amount — BIGINT
  • refund_fee — BIGINT
  • refund_amount — BIGINT
  • cancel_reason — VARCHAR
  • canceled_at — TIMESTAMP
  • transaction_key — VARCHAR
  • cancel_status — VARCHAR

reservation (예약)

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT
  • number — VARCHAR
  • total_amount — BIGINT
  • status — VARCHAR
  • created_at — TIMESTAMP
  • paid_at — TIMESTAMP
  • grade_summary — VARCHAR

review (리뷰)

  • id — BIGINT — Primary key — NOT NULL
  • show_id — BIGINT — Foreign key → show.show_id — NOT NULL
  • Field

scheduled_seat (회차별 좌석 상태)

  • show_schedule_seat_id — BIGINT — Primary key — NOT NULL
  • seat_id — BIGINT — Foreign key → seat.seat_id — NOT NULL
  • show_scheduled_id — BIGINT
  • scheduled_seat_status — VARCHAR — NOT NULL

seat (좌석)

  • seat_id — BIGINT — Primary key — NOT NULL
  • seat_section_id — BIGINT — Foreign key → seat_section.seat_section_id — NOT NULL
  • seat_row — VARCHAR — NOT NULL
  • seat_number — BIGINT — NOT NULL

seat_section (섹션 및 등급/가격)

  • seat_section_id — BIGINT — Primary key — NOT NULL
  • venue_id — BIGINT
  • name — VARCHAR — NOT NULL
  • floor — BIGINT
  • grade_name — VARCHAR
  • price — BIGINT

show

  • show_id — BIGINT — Primary key — NOT NULL
  • venue_id — BIGINT
  • title — VARCHAR — NOT NULL
  • description — TEXT
  • runtime_min — INT
  • age_limit — INT
  • poster_img — VARCHAR
  • start_time — TIMESTAMP
  • end_time — TIMESTAMP
  • notice_img — VARCHAR

show_casting (공연별 캐스팅)

  • id — BIGINT — Primary key — NOT NULL
  • show_id — BIGINT — Foreign key → show.show_id — NOT NULL
  • artist_id — BIGINT — Foreign key → artist.id — NOT NULL
  • role_name — VARCHAR
  • order — VARCHAR

show_schedule

  • show_schedule_id — BIGINT — Primary key — NOT NULL
  • show_id — BIGINT — Foreign key → show.show_id — NOT NULL
  • starts_at — TIMESTAMP — NOT NULL
  • status — VARCHAR — NOT NULL
  • date — TIMESTAMP

show_schedule_casting (공연 회차별 캐스팅 매핑)

  • id — BIGINT — Primary key — NOT NULL
  • show_casting_id — BIGINT — Foreign key → show_casting.id — NOT NULL
  • show_schedule_id — BIGINT — Foreign key → show_schedule.show_schedule_id — NOT NULL

show_scheduled (회차별 공연 정보)

  • id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR
  • venue_name (veneu_name) — VARCHAR
  • start_at (Field) — TIMESTAMP

show_section_grade (공연별 좌석 등급)

  • id — BIGINT — Primary key — NOT NULL
  • show_id — BIGINT — Foreign key → show.show_id — NOT NULL
  • grade_name — VARCHAR
  • color_code — VARCHAR
  • price — BIGINT

show_section_grade

  • id — BIGINT — Primary key — NOT NULL
  • show_id (show_id2) — BIGINT — Foreign key → show.show_id — NOT NULL
  • grade_name — VARCHAR
  • price — BIGINT

ticket (티켓)

  • id — BIGINT — Primary key — NOT NULL
  • reservation_id — BIGINT — Foreign key → reservation.id — NOT NULL
  • number — VARCHAR
  • price_snapshot — BIGINT
  • status — VARCHAR
  • used_at — TIMESTAMP
  • seat_detail — VARCHAR

users (유저)

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR
  • password — VARCHAR
  • provider — TIMESTAMP
  • role — VARCHAR
  • oauth_user_id (Field) — VARCHAR
  • oauth_access_token — VARCHAR
  • oauth_refresh_token — VARCHAR

venue

  • venue_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR — NOT NULL
  • address — VARCHAR
  • created_at — TIMESTAMP — NOT NULL