dallah - Laravel Schema Designer

admins

id increments
role_id ^FK bigInteger
department_id ^FK bigInteger
name string (200)
email string (255)
phone string (200)
password string (255)
birth_date timestamp
join_date timestamp
address longText
salary double (8.2)
status boolean
timestamps timestamps
softDeletes softDeletes

roles

id increments
timestamps timestamps
softDeletes softDeletes

permissions

id increments
timestamps timestamps
softDeletes softDeletes

departments

id increments
parent_id ^FK bigInteger
name_ar string (255)
name_en string
description_ar longText
description_en longText
status boolean
timestamps timestamps
softDeletes softDeletes

users

id increments
department_id ^FK bigInteger
name string (255)
phone string (255)
email string (255)
type integer
password string (255)
timestamps timestamps
softDeletes softDeletes

user_details

id increments
user_id ^FK bigInteger
id_number integer
gender boolean
qualifications longText
age integer
description longText
status boolean
employee_number integer
timestamps timestamps
softDeletes softDeletes

course_chapters

id increments
course_id ^FK bigInteger
chapter_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

course_sections

id increments
course_id ^FK bigInteger
section_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

sections

id increments
parent_id ^FK bigInteger
name_ar string (255)
name_en string (255)
description_ar longText
description_en longText
status boolean
timestamps timestamps
softDeletes softDeletes

lessons

id increments
name_ar string (255)
name_en string (255)
video_hosting integer
video_url string (255)
video_file string (255)
description_ar string (255)
description_en string
resources string (255)
status boolean
timestamps timestamps
softDeletes softDeletes

chapters

id increments
name_ar string (255)
name_en string (255)
status boolean
timestamps timestamps
softDeletes softDeletes

course_reviews

id increments
rate integer
comment longText
user_id ^FK bigInteger
course_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

courses

id increments
main_section_id ^FK bigInteger
sub_section_id ^FK bigInteger
user_id ^FK bigInteger
name string (255)
video_hosting boolean
intro_video_url string (255)
intro_video_file string (255)
description longText
requirements longText
type boolean
content_type string (255)
language boolean
location longText
is_free boolean
price double
discount_price double
level integer
duration string (255)
keywords string (255)
meta_description longText
status integer
timestamps timestamps
softDeletes softDeletes

course_lessons

id increments
course_id ^FK bigInteger
chapter_id ^FK bigInteger
lesson_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

exams

id increments
course_id ^FK bigInteger
name_ar string (255)
name_en string (255)
instructions text
min_passing_grade double
random_questions boolean
num_random_questions integer
status boolean
timestamps timestamps
softDeletes softDeletes

questions

id increments
exam_id string (255)
question_type integer
question_text longText
answer_text longText
explanation longText
correct_order integer
timestamps timestamps
softDeletes softDeletes

answers

id increments
question_id ^FK bigInteger
answer_text longText
explanation longText
is_correct boolean
timestamps timestamps
softDeletes softDeletes

certificates

id increments
course_id ^FK bigInteger
status boolean
timestamps timestamps
softDeletes softDeletes

user_certificates

id increments
course_id ^FK bigInteger
exam_id ^FK bigInteger
user_id ^FK bigInteger
issue_date date
instructor_name string
timestamps timestamps
softDeletes softDeletes

training_needs

id increments
course_id ^FK bigInteger
department_id ^FK bigInteger
status integer
date_sent timestamp
timestamps timestamps
softDeletes softDeletes

training_plans

id increments
course_id ^FK bigInteger
date timestamp
type integer
status integer
location text
required_employees integer
date_sent timestamp
timestamps timestamps
softDeletes softDeletes

nominations

id increments
course_id ^FK bigInteger
user_id ^FK bigInteger
department_id ^FK bigInteger
status integer
date_sent timestamp
timestamps timestamps
softDeletes softDeletes

external_trainings

id increments
user_id ^FK bigInteger
department_id ^FK bigInteger
course_name string (255)
training_type string (255)
status integer
date_sent timestamp
start_date timestamp
end_date timestamp
last_training_date timestamp
timestamps timestamps
softDeletes softDeletes

mandatory_lectures

id increments
lecture_name string
user_id ^FK bigInteger
training_type integer
department_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

lecture_schedules

id increments
mandatory_lecture_id ^FK bigInteger
date timestamp
time timestamp
location text
date_sent timestamp
timestamps timestamps
softDeletes softDeletes

cooperative_trainings

id increments
department_id ^FK bigInteger
available_seats integer
date_sent timestamp
timestamps timestamps
softDeletes softDeletes

cooperative_training_requests

id increments
user_id ^FK bigInteger
cooperative_training_id ^FK bigInteger
status integer
start_date timestamp
end_date timestamp
timestamps timestamps
softDeletes softDeletes

enrollments

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK bigInteger

carts

id increments
timestamps timestamps
softDeletes softDeletes

orders

id increments
timestamps timestamps
softDeletes softDeletes

order_details

id increments
timestamps timestamps
softDeletes softDeletes

favorites

id increments
timestamps timestamps
softDeletes softDeletes

transactions

id increments
timestamps timestamps
softDeletes softDeletes