ㅇㅇ

Tables (11)

announcement

  • announcement_id — BIGINT
  • course_id — BIGINT
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • is_important — BOOLEAN
  • is_published — BOOLEAN
  • created_by — BIGINT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

category

  • category_id — BIGINT
  • parent_id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • display_order — INT
  • is_active — BOOLEAN
  • created_at — TIMESTAMP

course

  • course_id — BIGINT
  • instructor_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • thumbnail — VARCHAR(500)
  • category_id — BIGINT
  • level — ENUM('BEGINNER', 'INTERMEDIATE', 'ADVANCED')
  • language — VARCHAR(10)
  • access_type — ENUM('FREE', 'SUBSCRIPTION')
  • subscription_price — DECIMAL(10, 2)
  • is_published — BOOLEAN
  • total_duration — INT
  • total_lessons — INT
  • rating_avg — DECIMAL(3, 2)
  • rating_count — INT
  • view_count — BIGINT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_access_type
  • INDEX — idx_category
  • INDEX — idx_instructor

course_bookmark

  • bookmark_id — BIGINT
  • member_id — BIGINT — NOT NULL
  • course_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP

course_review

  • review_id — BIGINT
  • course_id — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL
  • rating — TINYINT — NOT NULL
  • comment — TEXT — EX
  • is_published — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

course_subscription

  • subscription_id — BIGINT
  • member_id — BIGINT — NOT NULL
  • course_id — BIGINT — NOT NULL
  • start_date — TIMESTAMP
  • end_date — TIMESTAMP
  • status — ENUM('ACTIVE', 'CANCELLED', 'EXPIRED')
  • payment_method — ENUM('CARD', 'BANK_TRANSFER', 'PAYPAL') — NOT NULL
  • amount_paid — DECIMAL(10, 2) — NOT NULL
  • created_at — TIMESTAMP
  • cancelled_at — TIMESTAMP
  • INDEX — idx_member_status
  • INDEX — idx_course_status

instructor_profile

  • instructor_id — BIGINT
  • expertise — TEXT
  • experience — TEXT
  • education — TEXT
  • certifications — TEXT
  • social_links — JSON
  • bank_account — VARCHAR(100)
  • tax_info — JSON

learning_progress

  • progress_id — BIGINT
  • member_id — BIGINT — NOT NULL
  • lesson_id — BIGINT — NOT NULL
  • watched_duration — INT
  • is_completed — BOOLEAN
  • last_watched_at — TIMESTAMP
  • completed_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

lesson

  • lesson_id — BIGINT
  • course_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • video_url — VARCHAR(500)
  • duration — INT — NOT NULL
  • lesson_order — INT — NOT NULL
  • access_type — ENUM('FREE', 'SUBSCRIPTION')
  • thumbnail — VARCHAR(500)
  • is_published — BOOLEAN
  • view_count — BIGINT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_course_order
  • INDEX — idx_access_type

member

  • member_id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • role — ENUM('STUDENT', 'INSTRUCTOR', 'ADMIN')
  • profile_image — VARCHAR(500)
  • bio — TEXT
  • phone — VARCHAR(20)
  • is_active — BOOLEAN
  • email_verified — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

payment_history

  • payment_id — BIGINT
  • subscription_id — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL
  • course_id — BIGINT — NOT NULL
  • amount — DECIMAL(10, 2) — NOT NULL
  • payment_method — ENUM('CARD', 'BANK_TRANSFER', 'PAYPAL') — NOT NULL
  • payment_status — ENUM('PENDING', 'SUCCESS', 'FAILED', 'REFUNDED')
  • transaction_id — VARCHAR(255)
  • paid_at — TIMESTAMP
  • refunded_at — TIMESTAMP
  • created_at — TIMESTAMP
  • INDEX — idx_member_status
  • INDEX — idx_transaction