summer training - Laravel Schema Designer

users

id increments
name string (150)
type_id ^FK integer
email string (100)
password string (200)
gender enum
mobile bigInteger
is_active tinyInteger
timestamps timestamps
softDeletes softDeletes

user_types

id increments
name string (150)
timestamps timestamps
softDeletes softDeletes

regions

id increments
name string (150)
timestamps timestamps
softDeletes softDeletes

cities

id increments
name string (150)
region_id ^FK integer
timestamps timestamps
softDeletes softDeletes

user_trainees

id increments
user_id ^FK integer
region_id ^FK integer
city_id ^FK integer
university_id ^FK integer
department_id ^FK integer
major string (150)
student_number bigInteger
gpa float
gpa_type enum
training_date enum
training_hours integer
graduation_year integer
academic_degree enum
graduation_certificate string (200)
academic_transaction string (200)
cv string (200)
is_graduate tinyInteger
timestamps timestamps
softDeletes softDeletes

universites

id increments
name string (150)
timestamps timestamps
softDeletes softDeletes

departments

id increments
name string (150)
university_id ^FK integer
timestamps timestamps
softDeletes softDeletes

training_requests

id increments
user_id ^FK integer
created_by ^FK integer
plan_id ^FK integer
status enum
notes string (200)
timestamps timestamps
softDeletes softDeletes

plans

id increments
name string (150)
created_by ^FK integer
supervisor_id ^FK integer
description text
department string
training_type enum
training_method enum
students_number integer
starting_time datetime
certificate_id ^FK integer
ending_date datetime
timestamps timestamps
softDeletes softDeletes

certificates

id increments
name string (150)
release_time datetime
created_by ^FK integer
image string
timestamps timestamps
softDeletes softDeletes

daily_reports

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
plan_id ^FK integer
title string (200)
notes text
date date

final_reports

id increments
user_id ^FK integer
plan_id ^FK integer
report_file string (200)
timestamps timestamps
softDeletes softDeletes

daily_reports_tasks

id increments
daily_report_id ^FK integer
task_id ^FK integer
timestamps timestamps
softDeletes softDeletes

tasks

id increments
created_by ^FK integer
name string (200)
description text
deadline datetime
status enum
plan_id ^FK integer
timestamps timestamps
softDeletes softDeletes

attendances

id increments
user_id ^FK integer
date datetime
status enum
plan_id ^FK integer
timestamps timestamps
softDeletes softDeletes

training_letters

id increments
user_id ^FK integer
file string (200)
status enum
timestamps timestamps
softDeletes softDeletes

user_companies

id increments
logo string (200)
header string (200)
description text
domain string (150)
city_id ^FK integer
region_id ^FK integer
facility_size integer
timestamps timestamps
softDeletes softDeletes

user_employees

id increments
user_id ^FK integer
department string (200)
job_title string (150)
nationality string (150)
birth_date date
qualification string (150)
timestamps timestamps
softDeletes softDeletes

users_tasks

id increments
targeted_user_id ^FK integer
targeted_user_type ^FK integer
task_id ^FK integer
timestamps timestamps
softDeletes softDeletes

comments

id increments
text text
created_by ^FK integer
model_id integer
model_name string (200)
timestamps timestamps
softDeletes softDeletes

attachments

id increments
name string (150)
type string (150)
link string (200)
model_id integer
model_name string (150)
timestamps timestamps
softDeletes softDeletes

training_controls

id increments
company_id ^FK integer
attachment_id ^FK integer
description text
gpa float
timestamps timestamps
softDeletes softDeletes

communications

id increments
targeted_user_type ^FK integer
sender_id ^FK integer
receiver_id ^FK integer
reply_to ^FK integer
text text
subject string (200)
is_read datetime
timestamps timestamps
softDeletes softDeletes

user_academics

id increments
user_id ^FK integer
university_id ^FK integer
department_id ^FK integer
timestamps timestamps
softDeletes softDeletes

sections

id increments
timestamps timestamps
softDeletes softDeletes
section_number integer
user_id ^FK integer
semester integer

students_sections

id increments
user_id ^FK integer
section_id ^FK integer
timestamps timestamps
softDeletes softDeletes

users_certificates

id increments
user_id ^FK integer
certificate_id ^FK integer
timestamps timestamps
softDeletes softDeletes