ㄴ

Tables (8)

certificate_issues

  • issue_id — BIGINT
  • certificate_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL

certificates

  • certificate_id — BIGINT
  • course_id — BIGINT — NOT NULL
  • title — VARCHAR(100) — NOT NULL

courses

  • course_id — BIGINT — 강의ID
  • instructor_id — BIGINT — NOT NULL
  • course_name — VARCHAR(200) — NOT NULL

enrollments

  • enrollment_id — BIGINT — 수강ID
  • user_id — BIGINT — NOT NULL
  • course_id — BIGINT — NOT NULL

lesson_progress

  • progress_id — BIGINT
  • enrollment_id — BIGINT — NOT NULL
  • lesson_id — BIGINT — NOT NULL
  • is_completed — TINYINT(1)

lessons

  • lesson_id — BIGINT — 레슨ID
  • course_id — BIGINT — NOT NULL
  • title — VARCHAR(200) — NOT NULL

order_items

  • order_item_id — BIGINT
  • order_id — BIGINT — NOT NULL
  • course_id — BIGINT — NOT NULL

orders

  • order_id — BIGINT — 주문ID
  • user_id — BIGINT — NOT NULL