candly - Laravel Schema Designer

pages

id increments
title string (255)
description text
softDeletes softDeletes
timestamps timestamps

sections

id increments
title string (255)
description text
page_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

section_items

id increments
section_id ^FK bigInteger
icon string
icon_color string
icon_background_color string
title string
description text
timestamps timestamps
softDeletes softDeletes

setting

id increments
logo string
address string
social json
email string
phone integer
policy text
terms text
softDeletes softDeletes
timestamps timestamps

admins

id increments
name string
email string
password string
softDeletes softDeletes
timestamps timestamps

students

id increments
timestamps timestamps
softDeletes softDeletes
full_name string
email string
password string
phone string
is_active integer
last_name datetime
streak integer
total_medal integer

courses

id increments
title string
code string
icon string
background_color string
type enum
price double
discount double
status integer
softDeletes softDeletes
timestamps timestamps

course_features

id increments
course_id ^FK bigInteger
feature string
status integer
softDeletes softDeletes
timestamps timestamps

course_goals

id increments
course_id ^FK bigInteger
goal string
status integer
softDeletes softDeletes
timestamps timestamps

levels

id increments
course_id ^FK bigInteger
number string
type enum
price double
discount double
status integer
active integer
softDeletes softDeletes
timestamps timestamps

units

id increments
timestamps timestamps
softDeletes softDeletes
level_id ^FK bigInteger
number integer
status integer
active integer

lessons

id increments
timestamps timestamps
softDeletes softDeletes
unit_id ^FK bigInteger
number integer
title string
description text
Complete integer
notes string
active integer

course_users

id increments
timestamps timestamps
softDeletes softDeletes
course_id ^FK bigInteger
student_id ^FK bigInteger
enroll_date datetime

flashcards

id increments
timestamps timestamps
softDeletes softDeletes
lesson_id ^FK bigInteger
english_word string
arabic_word string
pronuciation string
status integer

lesson_faqs

id increments
timestamps timestamps
softDeletes softDeletes
lesson_id ^FK bigInteger
question string
answer string
student_id ^FK bigInteger
answerd_by string
status integer

lesson_reviews

id increments
timestamps timestamps
softDeletes softDeletes
lesson_id ^FK bigInteger
rate integer
comment text
student_id ^FK bigInteger

contact

id increments
name string
email string
phone string
subject string
message text
softDeletes softDeletes
status integer
timestamps timestamps

slider_images

id increments
image string
page_id ^FK bigInteger
status integer
softDeletes softDeletes
timestamps timestamps

favourites

id increments
student_id ^FK bigInteger
favouritable_id bigInteger
favouritable_type string
softDeletes softDeletes
timestamps timestamps

faqs

id increments
timestamps timestamps
softDeletes softDeletes
question text
answer text
faq_category_id ^FK bigInteger

student_lessons

id increments
timestamps timestamps
softDeletes softDeletes
lesson_id ^FK bigInteger
student_id ^FK bigInteger
start_date datetime
status integer

quiz

id increments
timestamps timestamps
softDeletes softDeletes
degree string
lesson_id ^FK bigInteger
status integer

quiz_question

id increments
timestamps timestamps
softDeletes softDeletes
quiz_id ^FK bigInteger
question text
status integer
type enum

quiz_answers

id increments
timestamps timestamps
softDeletes softDeletes
question_id ^FK bigInteger
answer text
correct integer
type enum

quiz_students

id increments
timestamps timestamps
softDeletes softDeletes
student_id ^FK bigInteger
quiz_id ^FK bigInteger
start datetime
end datetime
degree integer
status integer
medal integer

quiz_student_question

id increments
timestamps timestamps
softDeletes softDeletes
quiz_student_id ^FK bigInteger
question_id ^FK bigInteger
status integer
is_correct integer
answer_id ^FK bigInteger

faq_categories

id increments
title string
softDeletes softDeletes
timestamps timestamps

testmonials

id increments
timestamps timestamps
softDeletes softDeletes

reviews

id increments
rate integer
comment text
reviewable_id bigInteger
reviewable_type string
status integer
softDeletes softDeletes
timestamps timestamps

blogs

id increments
title string
sub_title text
description text
image string
by string
softDeletes softDeletes
timestamps timestamps

register_videos

id increments
video string
status integer
softDeletes softDeletes
timestamps timestamps

videos

id increments
videoable_id bigInteger
videoable_type string
video string
status integer
softDeletes softDeletes
timestamps timestamps

audios

id increments
audioable_id bigInteger
audioable_type string
audio string
status integer
softDeletes softDeletes
timestamps timestamps

downloads

id increments
title string
course_id ^FK bigInteger
softDeletes softDeletes
timestamps timestamps

download_attachements

id increments
download_id ^FK bigInteger
title string
link string
format string
status integer
softDeletes softDeletes
timestamps timestamps

orders

id increments
timestamps timestamps
softDeletes softDeletes
code string
total_price integer
student_id ^FK bigInteger
status integer

order_items

id increments
timestamps timestamps
softDeletes softDeletes
order_id ^FK bigInteger
course_id ^FK bigInteger
level_id ^FK bigInteger
sale_price integer
status integer

images

id increments
imageable_id bigInteger
imageable_type string
image string
status integer
softDeletes softDeletes
timestamps timestamps

placement_tests

id increments
timestamps timestamps