Home EducationOnline Course Marketplace

Online Course Marketplace

Online learning platform with video courses, progress tracking, quizzes, certificates, and instructor payouts like Udemy

SchemaVerse

EducationPostgreSQLEducationNormalizedREST API

online-courses.dbml

12 tables|15 relations

instructors

idinteger

emailvarchar(255)

*UQ

password_hashvarchar(255)

first_namevarchar(100)

last_namevarchar(100)

biotext

profile_image_urlvarchar(500)

websitevarchar(255)

total_studentsinteger

avg_ratingdecimal(3,2)

is_verifiedboolean

created_attimestamp

updated_attimestamp

categories

idinteger

namevarchar(100)

slugvarchar(100)

*UQ

parent_idinteger

descriptiontext

created_attimestamp

courses

idinteger

instructor_idinteger

FK*

titlevarchar(255)

slugvarchar(255)

*UQ

subtitlevarchar(500)

descriptiontext

pricedecimal(10,2)

levelvarchar(20)

languagevarchar(50)

thumbnail_urlvarchar(500)

promo_video_urlvarchar(500)

total_duration_minutesinteger

enrollment_countinteger

avg_ratingdecimal(3,2)

statusvarchar(20)

published_attimestamp

created_attimestamp

updated_attimestamp

course_categories

course_idinteger

category_idinteger

sections

idinteger

course_idinteger

FK*

titlevarchar(255)

descriptiontext

display_orderinteger

created_attimestamp

updated_attimestamp

lessons

idinteger

section_idinteger

FK*

titlevarchar(255)

descriptiontext

content_typevarchar(20)

duration_minutesinteger

display_orderinteger

is_previewboolean

created_attimestamp

updated_attimestamp

lesson_content

idinteger

lesson_idinteger

FK*UQ

video_urlvarchar(500)

article_contenttext

attachments_urlvarchar(500)

created_attimestamp

updated_attimestamp

enrollments

idinteger

course_idinteger

FK*

user_emailvarchar(255)

user_namevarchar(200)

amount_paiddecimal(10,2)

coupon_codevarchar(50)

enrolled_attimestamp

completed_attimestamp

certificate_issuedboolean

progress

idinteger

enrollment_idinteger

FK*

lesson_idinteger

FK*

completedboolean

completed_attimestamp

last_position_secondsinteger

created_attimestamp

updated_attimestamp

reviews

idinteger

course_idinteger

FK*

enrollment_idinteger

FK*

ratinginteger

commenttext

created_attimestamp

updated_attimestamp

certificates

idinteger

enrollment_idinteger

FK*UQ

course_idinteger

FK*

student_namevarchar(200)

certificate_numbervarchar(50)

*UQ

issued_attimestamp

pdf_urlvarchar(500)

coupons

idinteger

codevarchar(50)

*UQ

discount_typevarchar(20)

discount_valuedecimal(10,2)

max_usesinteger

current_usesinteger

valid_fromtimestamp

valid_untiltimestamp

course_idinteger

is_activeboolean

created_attimestamp

React Flow

About this Schema

Overview

Online course marketplace schema similar to Udemy or Teachable. Instructors create video courses, students enroll and track progress, quizzes test knowledge, and certificates validate completion.

Key Design Decisions

Video Lessons: Track watch progress and completion
Quiz System: Multiple-choice assessments with instant feedback
Certificates: Auto-generated upon course completion
Instructor Payouts: Revenue sharing with course creators

Tables

12 tables covering courses, lessons, enrollments, progress, quizzes, certificates, reviews, and instructor earnings. Designed for marketplace-style online education.

Comments

Loading comments...