ㄴ
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 — 결제상태