Elmullim - Laravel Schema Designer

teachers

id increments
name string (255)
email string
password string
phone string (255)
address string (255)
profile_image string (255)
longitude string (255)
latitude string (255)
experince integer
qualification string (255)
cv string (255)
lesson_type integer
timestamps timestamps

files

id increments
type tinyInteger
file string (255)
fileable_id integer
fileable_type string (255)
timestamps timestamps

academic_years

id increments
name string (255)
education_system_id ^FK integer
timestamps timestamps

subjects

id increments
name string (255)
academic_year_id ^FK integer
timestamps timestamps

education_systems

id increments
name string (255)
country_id ^FK integer
timestamps timestamps

countries

id increments
name string
timestamps timestamps

teacher_subject

id increments
teacher_id ^FK integer
subject_id ^FK integer
timestamps timestamps

lessons_times

id increments
teacher_id ^FK integer
day string (255)
date timestamp
timestamps timestamps
lesson_id ^FK integer

lessons

id increments
timestamps timestamps
teacher_id ^FK integer
price decimal
name string (255)
type integer
description string (255)

students

id increments
timestamps timestamps
name string (255)
email string
password string (255)
phone string (255)
address string (255)
longitude string (255)
latitude string (255)
academic_year_id ^FK integer
profile_image string (255)

ratings

id increments
timestamps timestamps
student_id ^FK integer
teacher_id ^FK integer

student_subject

id increments
timestamps timestamps
student_id ^FK integer
subject_id ^FK integer

student_lesson

id increments
timestamps timestamps
student_id ^FK integer
lesson_id ^FK integer

categories

id increments
timestamps timestamps
name string (255)
description text
image string (255)

sub_categories

id increments
timestamps timestamps
category_id integer
name string (255)
description text
image string (255)

courses

id increments
timestamps timestamps
sub_category_id ^FK integer
name string (255)
description text

student_progress

id increments
timestamps timestamps
student_id ^FK integer
teacher_id ^FK integer
dscription text
rate integer

parents

id increments
timestamps timestamps
name string (255)
password string
email string
phone string
education_system_id ^FK integer
profile_image string

student_parent

id increments
timestamps timestamps
student_id ^FK integer
parent_id ^FK integer

presence_absence

id increments
timestamps timestamps
student_id ^FK integer
teacher_id ^FK integer
date timestamp
type integer
description text

settings

id increments
timestamps timestamps
name string
logo string (255)
description text
facebook_link integer
whatsapp_link string
twitter_link string
youtube_link tinyInteger
tiktok_link string
hero_file string (255)

contacts

id increments
timestamps timestamps
email string
name string
description text

blogs

id increments
timestamps timestamps
name string (255)
description string
blog_category_id ^FK integer

blog_categories

id increments
timestamps timestamps
name string
image string (255)

advantages

id increments
timestamps timestamps
description text

posts

id increments
timestamps timestamps
title string (255)
description text

views

id increments
timestamps timestamps
post_id ^FK integer
viewable_id integer
viewable_type string (255)

comments

id increments
timestamps timestamps
post_id ^FK integer
commentable_id integer
commentable_type string
comment text

post_favourites

id increments
timestamps timestamps
post_id ^FK integer
favouriteable_id integer
favouriteable_type string (255)