ss

Tables (27)

course_badges

  • course_id — BIGINT — NOT NULL
  • badge — VARCHAR(50) — NOT NULL

course_interviews

  • id — BIGINT — Primary key — NOT NULL
  • course_id — BIGINT — NOT NULL
  • question — VARCHAR(255)
  • answer — LONGTEXT
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

course_likes

  • id — BIGINT — Primary key — NOT NULL
  • course_id — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

course_marketing_urls

  • course_id — BIGINT — Primary key — NOT NULL
  • marketing_url — VARCHAR(255) — Primary key — NOT NULL

course_tags

  • id — BIGINT — Primary key — NOT NULL
  • course_id — BIGINT — NOT NULL
  • main_category_id — BIGINT — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

courses

  • id — BIGINT — Primary key — NOT NULL
  • course_type — VARCHAR(255)
  • course_status — VARCHAR(255)
  • like_count — INTEGER — NOT NULL
  • main_title — VARCHAR(255)
  • sub_title — VARCHAR(255)
  • description — VARCHAR(255)
  • reason — VARCHAR(255)
  • benefit — VARCHAR(255)
  • price — INTEGER
  • preview — VARCHAR(255)
  • main — VARCHAR(255)
  • sub — VARCHAR(255)
  • introductions — VARCHAR(1000)
  • interviews — VARCHAR(255)
  • marketing_urls — VARCHAR(255)
  • creator_id — BIGINT — NOT NULL
  • main_category_id — BIGINT — NOT NULL
  • sub_category_id — BIGINT
  • course_difficulty — VARCHAR(255)
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

creator_descriptions

  • id — BIGINT — Primary key — NOT NULL
  • creator_id — BIGINT — NOT NULL
  • title — VARCHAR(255)
  • message — VARCHAR(255)
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

creators

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT
  • name — VARCHAR(255)
  • job — VARCHAR(255)
  • introduction — VARCHAR(255)
  • image — VARCHAR(255)
  • phone_number — VARCHAR(255)
  • email — VARCHAR(255)
  • profile — VARCHAR(255)
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

episodes

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255)
  • sequence — INTEGER — NOT NULL
  • course_id — BIGINT — NOT NULL
  • is_prologue — BIGINT — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

file_resources

  • id — BIGINT — Primary key — NOT NULL
  • unit_id — BIGINT — NOT NULL
  • course_id — BIGINT — NOT NULL
  • loc_key — VARCHAR(255)
  • file_name — VARCHAR(255)
  • file_type — VARCHAR(255)
  • content_length — BIGINT
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

main_category

  • id — BIGINT — Primary key — NOT NULL
  • image — VARCHAR(255)
  • name — VARCHAR(255)
  • sequence — INTEGER — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

member_cancellation

  • id — BIGINT
  • member_id — BIGINT — NOT NULL
  • reason — VARCHAR(50)
  • reason_detail — VARCHAR(255)
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

member_preference

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • sub_category_id — BIGINT — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

member_tokens

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • expired_at — DATETIME(6)
  • login_device_id — VARCHAR(255) — NOT NULL
  • login_device_os — VARCHAR(255) — NOT NULL
  • login_device_type — VARCHAR(255) — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

members

  • id — BIGINT — Primary key — NOT NULL
  • social_login_type — VARCHAR(255)
  • provider_id — VARCHAR(255)
  • login_id — VARCHAR(255)
  • password — VARCHAR(255)
  • email — VARCHAR(255)
  • nickname — VARCHAR(255)
  • profile_image_url — VARCHAR(255)
  • role — VARCHAR(255)
  • is_remove — BIT — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

notification

  • id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME(6)
  • member_id — BIGINT — NOT NULL
  • updated_at — DATETIME(6)
  • device_id — VARCHAR(255)
  • provider_id — VARCHAR(255)

order_courses

  • id — BIGINT
  • current_price — NUMERIC(38, 2) — NOT NULL
  • discount_amount — NUMERIC(38, 2) — NOT NULL
  • final_price — NUMERIC(38, 2) — NOT NULL
  • vat_rate — NUMERIC(38, 2) — NOT NULL
  • coupon_id — BIGINT
  • course_id — BIGINT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • member_id — BIGINT — NOT NULL
  • order_id — BIGINT — NOT NULL
  • updated_at — DATETIME(6)

orders

  • id — BIGINT
  • discount_amount — NUMERIC(38, 2) — NOT NULL
  • final_price — NUMERIC(38, 2) — NOT NULL
  • original_amount — NUMERIC(38, 2) — NOT NULL
  • vat_amount — NUMERIC(38, 2) — NOT NULL
  • cancelled_at — DATETIME(6)
  • completed_at — DATETIME(6)
  • created_at — DATETIME(6)
  • failed_at — DATETIME(6)
  • member_id — BIGINT — NOT NULL
  • pending_at — DATETIME(6)
  • refunded_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • code — VARCHAR(255) — NOT NULL
  • memo — VARCHAR(255)
  • status — VARCHAR(255) — NOT NULL

paid_courses

  • id — BIGINT — Primary key — NOT NULL
  • course_id — BIGINT — NOT NULL
  • created_at — DATETIME(6)
  • member_id — BIGINT — NOT NULL
  • receipt_id — BIGINT — NOT NULL
  • unit_watching_history_id — BIGINT
  • updated_at — DATETIME(6)

payments

  • id — BIGINT
  • order_id — BIGINT — Foreign key → orders.id
  • payment_key — VARCHAR(255)
  • payment_order_id — VARCHAR(255)
  • order_name — VARCHAR(255)
  • currency — VARCHAR(255)
  • method — VARCHAR(255)
  • total_amount — BIGINT
  • balance_amount — BIGINT
  • status — VARCHAR(255)
  • payment_method — VARCHAR(255)
  • requested_at — DATETIME(6)
  • approved_at — DATETIME(6)
  • receipt_url — VARCHAR(255)
  • fail_reason — VARCHAR(255)
  • last_transaction_key — VARCHAR(255)
  • last_transaction_type — VARCHAR(255)
  • issuer_code — VARCHAR(255)
  • acquirer_code — VARCHAR(255)
  • number — VARCHAR(255)
  • installment_plan_months — INT
  • is_interest_free — BIT(1)
  • approve_no — VARCHAR(255)
  • use_card_point — BIT(1) — NOT NULL
  • card_type — VARCHAR(255)
  • owner_type — VARCHAR(255)
  • acquire_status — VARCHAR(255)
  • interest_payer — VARCHAR(255)
  • cancel_amount — BIGINT
  • cancel_reason — VARCHAR(255)
  • tax_free_amount — BIGINT
  • tax_exempted_amount — BIGINT
  • refundable_amount — BIGINT
  • transfer_discounted_amount — BIGINT
  • easy_pay_discounted_amount — BIGINT
  • canceled_at — DATETIME(6)
  • transaction_key — VARCHAR(255)
  • receipt_key — VARCHAR(255)
  • cancel_status — VARCHAR(255)
  • cancel_request_id — VARCHAR(255)

pre_reservation

  • id — BIGINT — Primary key — NOT NULL
  • course_id — BIGINT — NOT NULL
  • created_at — DATETIME(6)
  • member_id — BIGINT — NOT NULL

receipts

  • id — BIGINT — Primary key — NOT NULL
  • price — INTEGER — NOT NULL
  • course_id — BIGINT — NOT NULL
  • created_at — DATETIME(6)
  • member_id — BIGINT — NOT NULL
  • updated_at — DATETIME(6)

sub_category

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255)
  • sequence — INTEGER — NOT NULL
  • main_category_id — BIGINT
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

subscriptions

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT
  • creator_id — BIGINT
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

terms

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • service_consent — BIT — NOT NULL
  • private_policy_consent — BIT — NOT NULL
  • age_over14 — BIT — NOT NULL
  • service_notification — BIT — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

unit_watching_history

  • id — BIGINT — Primary key — NOT NULL
  • seconds — INTEGER
  • course_id — BIGINT
  • created_at — DATETIME(6)
  • member_id — BIGINT
  • unit_id — BIGINT
  • updated_at — DATETIME(6)

units

  • id — BIGINT — Primary key — NOT NULL
  • course_id — BIGINT — NOT NULL
  • episode_id — BIGINT — NOT NULL
  • title — VARCHAR(255)
  • sequence — INTEGER
  • vod_id — VARCHAR(255)
  • running_time — INTEGER
  • process_type — VARCHAR(255)
  • is_preview — BIT — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • file_type — VARCHAR(255)