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