kher - Laravel Schema Designer

users

id increments
timestamps timestamps
name string (255)
email string (255)
password string (255)
role integer
roleIds integer
status integer
fcm_token integer

profiles

id increments
timestamps timestamps
address string (255)
phone string (255)
image string (255)
birthday string (255)
user_id integer
id_student integer

students

id increments
timestamps timestamps
name_en string (255)
name_ar string (255)
username string (255)
email string (255)
password string (255)
is_confirmed integer
status integer
fcm_token string (255)
certificate integer

settings

id increments
timestamps timestamps
about_desc string (255)
address string (255)
video string
goals string (255)
site_map string (255)

contacts

id increments
timestamps timestamps
whats_phone string (255)
email string (255)
mobile_phones string (255)
land_phones string (255)
whats_link string (255)
insta_link string (255)
facebook_link string (255)
twitter_link string (255)
linkedin_link string (255)
telegram_link string (255)

certificates

id increments
timestamps timestamps
name_en string (255)
name_ar string (255)

blogs

id increments
timestamps timestamps
title string (255)
desc string (255)
status integer
is_reject integer
image string (255)
id_user string

courses

id increments
timestamps timestamps
title string (255)
desc string (255)
image string (255)
testPercentage string (255)
homeworkPercentage string (255)
presencePercentage string (255)
is_finished integer
diploma_id integer

course_students

id increments
timestamps timestamps
rating string (255)
resultant string (255)
status integer
course_id integer
student_id integer

course_users

id increments
timestamps timestamps
user_id integer
course_id integer

diplomas

timestamps timestamps
title string (255)
id increments
title_en string (255)
desc string (255)
image string (255)

homework

id increments
timestamps timestamps
title string (255)
desc string (255)
mark string (255)
date date
status integer
user_id integer
lecture_id integer
course_id integer

files

timestamps timestamps
name string (255)
path string (255)
type integer
homework_id integer
id increments
lecture_id integer

homework_students

id increments
timestamps timestamps
homework_id integer
student_id integer

lectures

timestamps timestamps
id increments
type integer
title string (255)
desc string (255)
link string (255)
start_date date
end_date date
course_id integer

lecture_students

id increments
timestamps timestamps
lecture_id integer
student_id integer

libraries

id increments
name string (255)
timestamps timestamps
link string (255)
image string (255)

model_has_permissions

id increments
timestamps timestamps
permission_id integer
model_type string (255)
model_id integer

model_has_roles

id increments
timestamps timestamps
role_id integer
model_type string (255)
model_id integer

notifications

id increments
timestamps timestamps
user_type string (255)
type integer
fcm_message_en string (255)
fcm_title_en string (255)
fcm_message_ar string (255)
fcm_title_ar string (255)
fcm_data string (255)
status integer
user_id integer
student_id integer

options

id increments
timestamps timestamps
desc string (255)
question_id integer

answers

id increments
timestamps timestamps
desc string (255)
bool integer
options string (255)
mark float
question_id integer
student_id integer

permissions

id increments
timestamps timestamps
name string (255)
guard_name string (255)

progress

id increments
timestamps timestamps
mark string (255)
pass_status integer
course_id bigInteger
student_id integer

questions

id increments
timestamps timestamps
desc string (255)
title string (255)
image string (255)
mark string (255)
question_type_id integer
test_id integer

question_types

id increments
timestamps timestamps
type integer

request_certificate

id increments
timestamps timestamps
status integer
path string (255)
student_id integer
diploma_id integer
course_id integer

setting_images

id increments
timestamps timestamps
type string (255)
name string (255)
path string (255)
caption string (255)

student_course_registration_requests

id increments
timestamps timestamps
status integer
student_id integer
course_id integer

student_files

id increments
timestamps timestamps
path string (255)
mark string (255)
homework_id integer
student_id integer

student_surveys

id increments
timestamps timestamps
survey_id integer
student_id integer

student_tests

id increments
timestamps timestamps
total_mark string
test_id integer
student_id integer

surveys

id increments
timestamps timestamps
title string (255)
desc string (255)
status integer
course_id integer
user_id integer

survey_answers

id increments
timestamps timestamps
desc string (255)
bool integer
options string (255)
survey_question_id integer
student_id integer

survey_options

id increments
timestamps timestamps
desc string (255)
survey_question_id integer

survey_questions

id increments
timestamps timestamps
desc string (255)
question_type_id integer
survey_id integer

tests

id increments
timestamps timestamps
title string (255)
desc string (255)
date date
duration string (255)
status string (255)
weight string (255)
course_id integer
user_id integer

users_verification_codes

id increments
timestamps timestamps
user_id integer
code string (255)

comments

id increments
timestamps timestamps
desc string (255)
parent_id integer
user_id integer
student_id integer
blog_id integer