ㄴ
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