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)