EduPro schema

All tables live in the edupro schema, so write edupro.students in your queries.

edupro.students

Registered learners.

• student_id (INT) — PK
• full_name (VARCHAR(80))
• email (VARCHAR(120))
• country (VARCHAR(40))
• signup_date (DATE)
• acquisition_channel (VARCHAR(20)) — 'organic', 'paid_search', 'referral', 'social'

edupro.instructors

Course instructors.

• instructor_id (INT) — PK
• full_name (VARCHAR(80))
• expertise (VARCHAR(40))

edupro.courses

The course catalogue.

• course_id (INT) — PK
• title (VARCHAR(120))
• category (VARCHAR(20)) — 'Data', 'Programming', 'Marketing', 'Design', 'Business'
• difficulty (VARCHAR(12)) — 'beginner', 'intermediate', 'advanced'
• instructor_id (INT) — FK → instructors.instructor_id
• price (DECIMAL(8,2)) — list price in INR
• created_at (DATE)
• is_published (BOOLEAN)

edupro.lessons

Lessons in each course, in order.

• lesson_id (INT) — PK
• course_id (INT) — FK → courses.course_id
• lesson_order (INT) — 1 = first lesson
• title (VARCHAR(120))
• duration_minutes (INT)

edupro.enrollments

One row per student per course.

• enrollment_id (INT) — PK
• student_id (INT) — FK → students.student_id
• course_id (INT) — FK → courses.course_id
• enrolled_at (DATE)
• status (VARCHAR(10)) — 'ACTIVE', 'DROPPED', 'COMPLETED'
• price_paid (DECIMAL(8,2)) — after coupons; can be below the list price
• completed_at (DATE) — nullable; set when status is COMPLETED

edupro.lesson_progress

One row each time a student finishes a lesson.

• progress_id (INT) — PK
• enrollment_id (INT) — FK → enrollments.enrollment_id
• lesson_id (INT) — FK → lessons.lesson_id
• completed_at (TIMESTAMP)

edupro.assessments

Final assessment attempts.

• assessment_id (INT) — PK
• course_id (INT) — FK → courses.course_id
• student_id (INT) — FK → students.student_id
• attempt_number (INT)
• score (INT)
• max_score (INT)
• submitted_at (TIMESTAMP)

edupro.certificates

Certificates issued on completion.

• certificate_id (INT) — PK
• student_id (INT) — FK → students.student_id
• course_id (INT) — FK → courses.course_id
• issued_at (DATE)

edupro.course_reviews

Star ratings left by learners.

• review_id (INT) — PK
• enrollment_id (INT) — FK → enrollments.enrollment_id
• rating (INT) — 1 to 5
• created_at (DATE)