multicket
Tables (27)
amount_change
- id — BIGINT — Primary key — NOT NULL
- performance_id — BIGINT — Foreign key → performance.id — NOT NULL
- amount — BIGINT — NOT NULL
- effective_from — DATETIME — NOT NULL
- applied — TINYINT(1) — NOT NULL
- create_date — DATETIME
- update_date — DATETIME
business_auth
- id — BIGINT — Primary key — NOT NULL
- b_no — VARCHAR(10) — NOT NULL
- start_dt — VARCHAR(8) — NOT NULL
- p_nm — VARCHAR(100) — NOT NULL
- admin_checked — TINYINT(1) — NOT NULL
- deleted — TINYINT(1) — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- create_date — DATETIME
- update_date — DATETIME
crew_info
- id — BIGINT — Primary key — NOT NULL
- performance_id — BIGINT — Foreign key → performance.id
- name — VARCHAR(255)
- profile_image — VARCHAR(255)
- cast_staff — VARCHAR(30)
discount
- id — BIGINT — Primary key — NOT NULL
- performance_id — BIGINT — Foreign key → performance.id
- discount_type — VARCHAR(30)
- discount_value — VARCHAR(255)
- deleted — TINYINT(1) — NOT NULL
discount_change
- id — BIGINT — Primary key — NOT NULL
- performance_id — BIGINT — Foreign key → performance.id — NOT NULL
- discount_type — VARCHAR(30)
- discount_value — VARCHAR(255)
- effective_from — DATETIME — NOT NULL
- applied — TINYINT(1) — NOT NULL
- create_date — DATETIME
- update_date — DATETIME
failed_event
- id — BIGINT — Primary key — NOT NULL
- event_type — VARCHAR(50) — NOT NULL
- target — VARCHAR(255)
- description — VARCHAR(500)
- origin_queue — VARCHAR(100) — NOT NULL
- failure_reason — TEXT
- payload — TEXT
- occurred_at — DATETIME — NOT NULL
- status — VARCHAR(20) — NOT NULL
- create_date — DATETIME
- update_date — DATETIME
favorite
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key — NOT NULL
- ref_id — BIGINT — NOT NULL
- performance_type — VARCHAR(20) — NOT NULL
- deleted — TINYINT(1) — NOT NULL
- create_date — DATETIME
- update_date — DATETIME
fcm_token
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key — NOT NULL
- token — VARCHAR(255) — NOT NULL
- platform — VARCHAR(20) — NOT NULL
- deleted — TINYINT(1) — NOT NULL
- create_date — DATETIME
- update_date — DATETIME
genre
- id — BIGINT — Primary key — NOT NULL
- genre_type — VARCHAR(50) — NOT NULL
genre_association
- id — BIGINT — Primary key — NOT NULL
- genre_id — BIGINT — Foreign key → genre.id — NOT NULL
- performance_id — BIGINT — Foreign key → performance.id
- member_id — BIGINT — Foreign key → member.id
inquiry
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT — NOT NULL
- inquiry_status — VARCHAR(20) — NOT NULL
- inquiry_type — VARCHAR(30) — NOT NULL
- inquiry_ref_id — BIGINT
- create_date — DATETIME
- update_date — DATETIME
member
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255)
- password — VARCHAR(255)
- nick_name — VARCHAR(255)
- profile_url — VARCHAR(255)
- gender — VARCHAR(20)
- login_type — VARCHAR(20)
- member_type — VARCHAR(20)
- year — INT
- month — INT
- day — INT
- deleted — TINYINT(1) — NOT NULL
- last_login_at — DATETIME
- provider_id — VARCHAR(255)
- email_white_list — VARCHAR(30)
- member_status — VARCHAR(20)
- area — VARCHAR(50)
- auth_check — TINYINT(1) — NOT NULL
- auth_check_at — DATETIME
- phone_number — VARCHAR(20)
- ci_hash — VARCHAR(64)
- create_date — DATETIME
- update_date — DATETIME
notice
- id — BIGINT — Primary key — NOT NULL
- type — VARCHAR(50) — NOT NULL
- content — TEXT — NOT NULL
- create_date — DATETIME
- update_date — DATETIME
open_run_schedule
- id — BIGINT — Primary key — NOT NULL
- performance_id — BIGINT — Foreign key → performance.id — NOT NULL
- day_mask — INT — NOT NULL
- time — TIME — NOT NULL
open_run_schedule_change
- id — BIGINT — Primary key — NOT NULL
- performance_id — BIGINT — Foreign key → performance.id — NOT NULL
- day_mask — INT — NOT NULL
- start_time — TIME — NOT NULL
- effective_from — DATETIME — NOT NULL
- applied — TINYINT(1) — NOT NULL
- create_date — DATETIME
- update_date — DATETIME
order_member_snapshot
- id — BIGINT — Primary key — NOT NULL
- order_id — BIGINT — Foreign key → orders.order_id — NOT NULL
- age — BIGINT
- gender — VARCHAR(20)
- area — VARCHAR(50)
- genres — JSON
orders
- order_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id
- performance_id — BIGINT — Foreign key → performance.id
- payment_key — VARCHAR(255)
- ticket_date_id — BIGINT — Foreign key → ticket_date.id
- ticket_order_status — VARCHAR(20)
- paid_at — DATETIME
- cancel_at — DATETIME
- paid_amount — BIGINT
- applied_discount_type — VARCHAR(30)
- applied_discount_value — VARCHAR(255)
- create_date — DATETIME
- update_date — DATETIME
oversea_performance
- id — BIGINT — Primary key — NOT NULL
- ticketmaster_id — VARCHAR(255) — NOT NULL
- name — VARCHAR(255)
- segment_id — VARCHAR(255)
- genre_id — VARCHAR(255)
- url — VARCHAR(1000)
- image_url — VARCHAR(1000)
- please_note — TEXT
- price_min — DOUBLE
- price_max — DOUBLE
- price_currency — VARCHAR(10)
- city — VARCHAR(255)
- country — VARCHAR(50)
- country_tag — VARCHAR(20)
- address — VARCHAR(255)
- start_date — DATE
- end_date — DATE
- detail_synced_at — DATETIME
- create_date — DATETIME
- update_date — DATETIME
performance
- id — BIGINT — Primary key — NOT NULL
- kopis_id — VARCHAR(255)
- title — VARCHAR(255)
- venue_name — VARCHAR(255)
- start_date — DATETIME
- end_date — DATETIME
- run_time — VARCHAR(255)
- age_limit — INT
- poster_url — VARCHAR(255)
- synopsis — TEXT
- area — VARCHAR(50)
- is_open_run — TINYINT(1) — NOT NULL
- is_dae_hak_ro — TINYINT(1) — NOT NULL
- synced_at — DATETIME
- ticket_link — VARCHAR(255)
- price — BIGINT
- member_id — BIGINT — Foreign key → member.id
- deleted — TINYINT(1) — NOT NULL
- limit_time — INT
- ticket_amount — BIGINT
- performance_days — INT
- inquiry_number — VARCHAR(255)
- max_reservation_per_person — INT
- is_affiliated — TINYINT(1) — NOT NULL
- create_date — DATETIME
- update_date — DATETIME
s3_file
- id — BIGINT — Primary key — NOT NULL
- ref_type — VARCHAR(50)
- key — VARCHAR(255)
- is_updated — TINYINT(1) — NOT NULL
- deleted — TINYINT(1) — NOT NULL
search_keyword
- id — BIGINT — Primary key — NOT NULL
- keyword_type — VARCHAR(30)
- keyword — VARCHAR(255)
- deleted — TINYINT(1) — NOT NULL
settlement
- id — BIGINT — Primary key — NOT NULL
- performance_id — BIGINT — Foreign key — NOT NULL
- enable_date — DATETIME — NOT NULL
- member_id — BIGINT — Foreign key — NOT NULL
- settlement_amount — BIGINT — NOT NULL
- settlement_date — DATE — NOT NULL
- total_success_amount — BIGINT
- total_cancel_amount — BIGINT
- fee_rate_percent — INT
- final_amount — BIGINT
- portone_transfer_id — VARCHAR(100)
- create_date — DATETIME
- update_date — DATETIME
ticket_date
- id — BIGINT — Primary key — NOT NULL
- performance_id — BIGINT — Foreign key → performance.id
- enable_date — DATETIME
- amount_left — BIGINT
ticket_info
- id — BIGINT — Primary key — NOT NULL
- performance_id — BIGINT — Foreign key → performance.id
- ticket_type — VARCHAR(30)
- price — BIGINT
ticket_info_change
- id — BIGINT — Primary key — NOT NULL
- performance_id — BIGINT — Foreign key → performance.id — NOT NULL
- ticket_type — VARCHAR(30)
- price — BIGINT
- effective_from — DATETIME — NOT NULL
- applied — TINYINT(1) — NOT NULL
- create_date — DATETIME
- update_date — DATETIME
ticket_pur_chase_log
- id — BIGINT — Primary key — NOT NULL
- order_order_id — BIGINT — Foreign key → orders.order_id
- ticket_type — VARCHAR(30)
- count — BIGINT
- unit_price — BIGINT
user_log
- id — BIGINT — Primary key — NOT NULL
- age — BIGINT
- gender — VARCHAR(20)
- area — VARCHAR(50)
- genres — JSON
- device_type — VARCHAR(20)
- ref_type — VARCHAR(50)
- ref_id — BIGINT
- act_at — DATETIME
- action_type — VARCHAR(50)
- meta_data — JSON