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