ㄴ

Tables (8)

certificate_issues

  • issue_id — BIGINT — 발급ID
  • certificate_id — BIGINT — NOT NULL — 기준ID
  • user_id — BIGINT — NOT NULL — 수령인ID
  • issued_at — TIMESTAMP

certificates

  • certificate_id — BIGINT — 기준ID
  • course_id — BIGINT — NOT NULL — 강의ID
  • title — VARCHAR(100) — NOT NULL — 수료증명
  • required_completion_count — INT — 수료기준

courses

  • course_id — BIGINT — 강의ID
  • instructor_id — BIGINT — NOT NULL — 강사ID
  • course_name — VARCHAR(200) — NOT NULL — 강의명
  • price — DECIMAL(10, 2) — NOT NULL — 가격
  • course_status — VARCHAR(20) — NOT NULL — 상태
  • created_at — TIMESTAMP

enrollments

  • enrollment_id — BIGINT — 수강ID
  • user_id — BIGINT — NOT NULL — 수강생ID
  • course_id — BIGINT — NOT NULL — 강의ID
  • status — VARCHAR(20) — NOT NULL — 수강상태
  • enrolled_at — TIMESTAMP

lesson_progress

  • progress_id — BIGINT — 진도ID
  • enrollment_id — BIGINT — NOT NULL — 수강ID
  • lesson_id — BIGINT — NOT NULL — 레슨ID
  • is_completed — TINYINT(1) — NOT NULL — 완료여부
  • last_played_sec — INT — 이어보기
  • updated_at — TIMESTAMP

lessons

  • lesson_id — BIGINT — 레슨ID
  • course_id — BIGINT — NOT NULL — 강의ID
  • title — VARCHAR(200) — NOT NULL — 레슨명
  • order_no — INT — NOT NULL — 순서
  • duration_sec — INT — NOT NULL — 재생시간

order_items

  • order_item_id — BIGINT — 상세ID
  • order_id — BIGINT — NOT NULL — 주문ID
  • course_id — BIGINT — NOT NULL — 강의ID
  • unit_price — DECIMAL(10, 2) — NOT NULL — 구매가격
  • quantity — INT — NOT NULL

orders

  • order_id — BIGINT — 주문ID
  • user_id — BIGINT — NOT NULL — 구매자ID
  • order_date — TIMESTAMP
  • status — VARCHAR(20) — NOT NULL — 결제상태