ㅇ
Tables (9)
Certifications
- certificate_id — INT
- user_id — INT — NOT NULL
- course_id — INT — NOT NULL
- issued_at — DATE
- certificate_url — VARCHAR(255)
Course
- course_id — INT
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- instructor_id — INT — NOT NULL
- category — VARCHAR(100)
- price — DECIMAL(10, 2)
- created_at — DATETIME
CourseContent
- content_id — INT
- course_id — INT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- type — ENUM('video', 'pdf', 'quiz', 'assignment') — NOT NULL
- order_index — INT — NOT NULL
- content_url — VARCHAR(255)
Enrollment
- enrollment_id — INT
- user_id — INT — NOT NULL
- course_id — INT — NOT NULL
- enrolled_at — DATETIME
- status — ENUM('active', 'completed', 'dropped')
Instructors
- instructor_id — INT
- user_id — INT — NOT NULL
- bio — TEXT
- expertise — VARCHAR(100)
Payments
- payment_id — INT
- user_id — INT — NOT NULL
- course_id — INT — NOT NULL
- amount — DECIMAL(10, 2) — NOT NULL
- payment_date — DATETIME
- payment_method — VARCHAR(50)
QuizSubmissions
- submission_id — INT
- quiz_id — INT — NOT NULL
- user_id — INT — NOT NULL
- score — INT
- submitted_at — DATETIME
Quizzes
- quiz_id — INT
- content_id — INT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- total_marks — INT
Users
- user_id — INT
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- role — ENUM('student', 'instructor', 'admin')
- created_at — DATETIME