Admin Teacher Student Course Chapter

0..1 0..1 0..1 0..1 0..10..1

admin_id int teacher_id int student_id int course_id int chapter_id int

name varchar(100) profile_picture varchar(255) profile_picture varchar(255) title varchar(255) title varchar(255)

email varchar(100) first_name varchar(100) first_name varchar(100) short_description text content text
*
password varchar(255) last_name varchar(100) last_name varchar(100) course_level varchar(50) course_id int

username varchar(100) username varchar(100) is_featured boolean

email varchar(100) email varchar(100) course_time varchar(50)

Exercise Commission
phone_number varchar(20) phone_number varchar(20) total_lectures int
exercise_id int commission_id int
location varchar(100) location varchar(100) price decimal(10,2)
*
title varchar(255) payment_id int
about_me text about_me text discount_price decimal(10,2)
description text admin_commission decimal(10,2)
diplomas text social_media text is_discount_enabled boolean
*
chapter_id int teacher_payout decimal(10,2)
social_media text password varchar(255) full_description text
payout_date date
password varchar(255) course_media text

validation_status boolean video_url varchar(255)

Forum
Transaction
lecture_files text
forum_message_id int CourseLanguage
transaction_id int
* faqs text *
student_id int * course_id int
Certification student_id int
* tags text *
course_id int * language_id int
certification_id int course_id int
reviewer_message text
content text *
student_id int amount decimal(10,2)
is_sale_allowed boolean
message_date datetime *
course_id int transaction_date date
Quiz
is_free boolean
issue_date date 0..1
* quiz_id int
teacher_id int
is_issued boolean *
CourseCategory course_id int
validation_status boolean
Language
*
course_id int total_points int
0..1
language_id int
*
category_id int
Chat name varchar(100)
Payment
chat_message_id int 0..1 StudentPoints
payment_id int
QuizQuestion sender_id int * points_id int
student_id int
Favorite
0..1 *
question_id int sender_type varchar(50) * student_id int
course_id int
favorite_id int
* *
quiz_id int receiver_id int course_id int
* amount decimal(10,2)
student_id int
question_text text receiver_type varchar(50) total_points int
* payment_date date
course_id int
correct_answer text content text
status varchar(50)
added_date date
points int message_date datetime

QuizResult Category
PaymentMethod Rating
0..1
result_id int category_id int
payment_method_id int rating_id int
*
student_id int name varchar(100)
* *
student_id int student_id int
*
quiz_id int
*
method_type varchar(50) course_id int
total_points_obtained int
details text rating_value int Preview
result_date date
comment text preview_id int
*
rating_date date course_id int

is_approved boolean BillingHistory preview_content text

billing_history_id int
*
student_id int
QuizAnswer StudentProgress
*
course_id int
answer_id int progress_id int
amount decimal(10,2)
* *
student_id int student_id int
payment_date date
* *
question_id int course_id int
invoice_number varchar(100)
answer_text text completion_percentage int

is_correct boolean

BillingAddress

billing_address_id int
*
student_id int

address_line1 varchar(255)

address_line2 varchar(255)

city varchar(100)

state varchar(100)

postal_code varchar(20)

country varchar(100)
Admin Teacher Student Course Chapter
0..1 0..1 0..1 0..1 0..10..1
admin_id int teacher_id int student_id int course_id int chapter_id int

name varchar(100) profile_picture varchar(255) profile_picture varchar(255) title varchar(255) title varchar(255)

email varchar(100) first_name varchar(100) first_name varchar(100) short_description text content text
*
password varchar(255) last_name varchar(100) last_name varchar(100) course_level varchar(50) course_id int

username varchar(100) username varchar(100) is_featured boolean

email varchar(100) email varchar(100) course_time varchar(50)

Exercise Commission
phone_number varchar(20) phone_number varchar(20) total_lectures int
exercise_id int commission_id int
location varchar(100) location varchar(100) price decimal(10,2)
*
title varchar(255) payment_id int
about_me text about_me text discount_price decimal(10,2)
description text admin_commission decimal(10,2)
diplomas text social_media text is_discount_enabled boolean
*
chapter_id int teacher_payout decimal(10,2)
social_media text password varchar(255) full_description text
payout_date date
password varchar(255) course_media text

validation_status boolean video_url varchar(255)

Forum
Transaction
lecture_files text
forum_message_id int CourseLanguage
transaction_id int
* faqs text *
student_id int * course_id int
Certification student_id int
* tags text *
course_id int * language_id int
certification_id int course_id int
reviewer_message text
content text *
student_id int amount decimal(10,2)
is_sale_allowed boolean
message_date datetime *
course_id int transaction_date date
Quiz
is_free boolean
issue_date date 0..1
* quiz_id int
teacher_id int
is_issued boolean *
CourseCategory course_id int
validation_status boolean
Language
*
course_id int total_points int
0..1
language_id int
*
category_id int
Chat name varchar(100)
Payment
chat_message_id int 0..1 StudentPoints
payment_id int
QuizQuestion sender_id int * points_id int
student_id int
Favorite
0..1 *
question_id int sender_type varchar(50) * student_id int
course_id int
favorite_id int
* *
quiz_id int receiver_id int course_id int
* amount decimal(10,2)
student_id int
question_text text receiver_type varchar(50) total_points int
* payment_date date
course_id int
correct_answer text content text
status varchar(50)
added_date date
points int message_date datetime

QuizResult Category
PaymentMethod Rating
0..1
result_id int category_id int
payment_method_id int rating_id int
*
student_id int name varchar(100)
* *
student_id int student_id int
*
quiz_id int
*
method_type varchar(50) course_id int
total_points_obtained int
details text rating_value int Preview
result_date date
comment text preview_id int
*
rating_date date course_id int

is_approved boolean BillingHistory preview_content text

billing_history_id int
*
student_id int
QuizAnswer StudentProgress
*
course_id int
answer_id int progress_id int
amount decimal(10,2)
* *
student_id int student_id int
payment_date date
* *
question_id int course_id int
invoice_number varchar(100)
answer_text text completion_percentage int

is_correct boolean

BillingAddress

billing_address_id int
*
student_id int

address_line1 varchar(255)

address_line2 varchar(255)

city varchar(100)

state varchar(100)

postal_code varchar(20)

country varchar(100)