tafweej - Laravel Schema Designer

roles

id increments
timestamps timestamps
softDeletes softDeletes
name string
guard_name string
is_active double (2)

permissions

id increments
timestamps timestamps
softDeletes softDeletes
name string
guard_name string

model_has_permissions

id increments
timestamps timestamps
softDeletes softDeletes
model_type string
model_morph_key bigIncrements

model_has_roles

id increments
timestamps timestamps
softDeletes softDeletes
model_type string
model_morph_key bigIncrements

virtual_locations

id increments
gate smallInteger
street string
label string (20)
capacity integer
walking_time increments
distance_to_jamarat integer
path_id ^FK bigInteger
actual_location_id ^FK bigInteger
is_developed boolean
is_active boolean
timestamps timestamps
softDeletes softDeletes
train_use boolean
year_id ^FK bigInteger

primary_roads

id increments
arabic_name string
english_name string
number smallInteger
timestamps timestamps
softDeletes softDeletes
is_active tinyInteger
year_id ^FK bigInteger

secondary_roads

id increments
arabic_name string
english_name string
number smallInteger
timestamps timestamps
softDeletes softDeletes
is_active tinyInteger
year_id ^FK bigInteger

offices

id increments
arabic_name string
phone string (15)
company_id ^FK bigInteger
number smallInteger
is_active tinyInteger
timestamps timestamps
softDeletes softDeletes
year_id ^FK bigInteger

path_images

id increments
image string
imageable_id bigInteger
imageable_type string
timestamps timestamps
softDeletes softDeletes
is_active tinyInteger
camp_id ^FK bigInteger
year_id ^FK bigInteger

nationalities

id increments
arabic_name string
english_name string
abbreviation string (10)
phone_code smallInteger
timestamps timestamps
softDeletes softDeletes
is_active tinyInteger
year_id ^FK bigInteger

plots

id increments
name string
number smallInteger
timestamps timestamps
softDeletes softDeletes
is_active tinyInteger
year_id ^FK bigInteger

residence_area_typs

id increments
arabic_name string
english_name string
timestamps timestamps
softDeletes softDeletes
is_active tinyInteger
year_id ^FK bigInteger

plot_camps

id increments
actual_location_id ^FK bigInteger
plot_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes
is_active tinyInteger
year_id ^FK bigInteger

platforms

id increments
arabic_name string
english_name string
number smallInteger
timestamps timestamps
softDeletes softDeletes
is_active tinyInteger
year_id ^FK bigInteger

jamarat_levels

id increments
arabic_name string
english_name string
number smallInteger
timestamps timestamps
softDeletes softDeletes
is_active tinyInteger
year_id ^FK bigInteger

companies

id increments
name string (20)
phone string
number smallInteger
timestamps timestamps
softDeletes softDeletes
is_active tinyInteger
year_id ^FK bigInteger

office_camps

id increments
office_id ^FK bigInteger
virtual_location_id ^FK bigInteger
pilgrims smallInteger
timestamps timestamps
softDeletes softDeletes
is_active tinyInteger
year_id ^FK bigInteger

camp_nationalities

id increments
virtual_location_id ^FK bigInteger
office_id ^FK bigInteger
nationality_id ^FK bigInteger
piligrims smallInteger
timestamps timestamps
softDeletes softDeletes
is_active tinyInteger
year_id ^FK bigInteger

groups

id increments
timestamps timestamps
name string
softDeletes softDeletes
year_id ^FK bigInteger
group_type_id ^FK bigInteger

group_types

id increments
timestamps timestamps
softDeletes softDeletes
name string
year_id ^FK bigInteger

group_component_types

id increments
timestamps timestamps
softDeletes softDeletes
name string
year_id ^FK bigInteger

group_items

id increments
timestamps timestamps
softDeletes softDeletes
group_id ^FK bigInteger
group_component_type_id ^FK bigInteger
value_id bigInteger
year_id ^FK bigInteger

qs_questions

id increments
timestamps timestamps
softDeletes softDeletes
qs_question_type_id ^FK bigInteger
name string
year_id ^FK bigInteger

qs_question_types

id increments
timestamps timestamps
softDeletes softDeletes
name string
year_id ^FK bigInteger

qs_exams

id increments
timestamps timestamps
softDeletes softDeletes
name string
qs_type_id ^FK bigInteger
year_id ^FK bigInteger

qs_course_contents

id increments
timestamps timestamps
softDeletes softDeletes
name string
qs_type_id ^FK bigInteger
year_id ^FK bigInteger

qs_user_answers

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
qs_exam_question_id ^FK bigInteger
qs_question_option_id ^FK bigInteger
year_id ^FK bigInteger

qs_exam_questions

id increments
timestamps timestamps
softDeletes softDeletes
qs_exam_id ^FK bigInteger
qs_question_id ^FK bigInteger
year_id ^FK bigInteger

qs_question_options

id increments
timestamps timestamps
softDeletes softDeletes
qs_question_id ^FK bigInteger
name string
is_true boolean
year_id ^FK bigInteger

cms_home_screen_files

id increments
timestamps timestamps
softDeletes softDeletes
name string
version integer
year_id ^FK bigInteger

test

id increments
timestamps timestamps
softDeletes softDeletes

cms_news

id increments
timestamps timestamps
softDeletes softDeletes
title string
details string
cms_news_picture_id ^FK bigInteger
year_id ^FK bigInteger

cms_news_pictures

id increments
timestamps timestamps
softDeletes softDeletes
name string
year_id ^FK bigInteger

pathes

id increments
timestamps timestamps
softDeletes softDeletes
path_type_id ^FK bigInteger
name string
year_id ^FK bigInteger

path_types

id increments
timestamps timestamps
softDeletes softDeletes
name string
year_id ^FK bigInteger

path_points

id increments
timestamps timestamps
softDeletes softDeletes
name string
type string
path_id ^FK bigInteger
path_component_type_id ^FK bigInteger
value_id bigInteger
year_id ^FK bigInteger

notification_type

id increments
arabic_name string
english_name string
content text
timestamps timestamps
softDeletes softDeletes
is_active tinyInteger
year_id ^FK bigInteger

user_notification_types

id increments
arabic_name string
english_name string
notification_type_id ^FK bigInteger
user_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes
is_active tinyInteger
year_id ^FK bigInteger

users

id increments
arabic_name string
english_name string
timestamps timestamps
softDeletes softDeletes
is_active tinyInteger

moraqb_zones

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK bigInteger
group_id ^FK bigInteger
year_id ^FK bigInteger

moraqb_report_questions

id increments
timestamps timestamps
softDeletes softDeletes
moraqb_report_question_type_id ^FK bigInteger
name string
year_id ^FK bigInteger

moraqb_report_question_types

id increments
timestamps timestamps
softDeletes softDeletes
name string
year_id ^FK bigInteger

moraqb_report_answers

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK bigInteger
moraqb_report_question_id ^FK bigInteger
moraqb_report_id ^FK bigInteger
moraqb_zone_id ^FK bigInteger
moraqb_report_image_id ^FK bigInteger
answer string
answer_time timestamps
year_id ^FK bigInteger

moraqb_report_types

id increments
timestamps timestamps
softDeletes softDeletes
name string
year_id ^FK bigInteger

moraqb_reports

id increments
timestamps timestamps
softDeletes softDeletes
name string
year_id ^FK bigInteger

moraqb_report_images

id increments
timestamps timestamps
softDeletes softDeletes
name string
moraqb_report_answer_id ^FK bigInteger
year_id ^FK bigInteger

super_batches

id increments
code string
camp_nationality_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes
is_active tinyInteger
year_id ^FK bigInteger

bus_batches

id bigInteger
code string
super_batch_id ^FK integer
timestamps timestamps
softDeletes softDeletes
is_active tinyInteger
year_id ^FK bigInteger

jamarat_schedule_log

id increments
version smallInteger
jamarat_schedule_id ^FK bigInteger
arabic_name string
english_name string
timestamps timestamps
softDeletes softDeletes
is_active tinyInteger
year_id ^FK bigInteger

bus_schedules

id increments
arabic_name string
english_name string
timestamps timestamps
softDeletes softDeletes
is_active tinyInteger
bus_batch_id ^FK bigInteger
year_id ^FK bigInteger

train_schedules

id increments
arabic_name string
english_name string
timestamps timestamps
softDeletes softDeletes
is_active tinyInteger
year_id ^FK bigInteger

jamarat_schedules

id increments
super_batch_id ^FK bigInteger
arabic_name string
english_name string
timestamps timestamps
softDeletes softDeletes
is_active tinyInteger
year_id ^FK bigInteger

bus_schedule_log

id increments
version smallInteger
bus_schedule ^FK bigInteger
arabic_name string
english_name string
timestamps timestamps
softDeletes softDeletes
is_active tinyInteger
year_id ^FK bigInteger

train_schedule_log

id increments
version smallInteger
train_schedule_id ^FK bigInteger
arabic_name string
english_name string
timestamps timestamps
softDeletes softDeletes
is_active tinyInteger
year_id ^FK bigInteger

activity_log

id increments
timestamps timestamps
softDeletes softDeletes
log_name string
year_id ^FK bigInteger

qs_type

id increments
timestamps timestamps
softDeletes softDeletes
name string
year_id ^FK bigInteger

trips

id increments
timestamps timestamps
softDeletes softDeletes
name string
year_id ^FK bigInteger

path_component_types

id increments
timestamps timestamps
softDeletes softDeletes
name string
year_id ^FK bigInteger

pathes_compinations

id increments
timestamps timestamps
softDeletes softDeletes
path_id ^FK bigInteger
trip_id ^FK bigInteger
year_id ^FK bigInteger

moshref_mahadirs

id increments
timestamps timestamps
softDeletes softDeletes
name string
year_id ^FK bigInteger

moshref_mahadir_question_types

id increments
timestamps timestamps
softDeletes softDeletes
name string
year_id ^FK bigInteger

surveys

id increments
user_role_id ^FK bigInteger
title string
is_active tinyInteger
created_by_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes
year_id ^FK bigInteger

moshref_mahadir_questions

id increments
timestamps timestamps
softDeletes softDeletes
moshref_mahadir_question_type_id ^FK bigInteger
name string
year_id ^FK bigInteger

moshref_reports

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK bigInteger
moraqb_report_answer_id ^FK bigInteger
year_id ^FK bigInteger

compile_moraqb_reports

id increments
timestamps timestamps
softDeletes softDeletes
moraqb_report_question_id ^FK bigInteger
moraqb_report_id ^FK bigInteger
year_id ^FK bigInteger

survey_sections

id increments
survey_id ^FK bigInteger
parent_id bigInteger
title string
ordering integer
is_apply_percentage tinyInteger
is_required tinyInteger
timestamps timestamps
softDeletes softDeletes
year_id ^FK bigInteger

survey_questions

id increments
survey_id ^FK bigInteger
survey_section_id ^FK bigInteger
type string (25)
type_options longText
is_has_notes tinyInteger
title string
timestamps timestamps
softDeletes softDeletes
year_id ^FK bigInteger

survey_question_options

id increments
survey_id ^FK bigInteger
survey_question_id ^FK bigInteger
title string
timestamps timestamps
softDeletes softDeletes
year_id ^FK bigInteger

survey_answers

id increments
user_id ^FK bigInteger
survey_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes
year_id ^FK bigInteger

compile_moshref_mahadirs

id increments
timestamps timestamps
softDeletes softDeletes
moshref_mahadir_question_id ^FK bigInteger
moshref_mahadir_id ^FK bigInteger
year_id ^FK bigInteger

survey_answer_values

id increments
user_id ^FK bigInteger
survey_id ^FK bigInteger
survey_answer_id ^FK bigInteger
survey_question_id ^FK bigInteger
survey_question_option_id ^FK bigInteger
value text
notes text
timestamps timestamps
softDeletes softDeletes
year_id ^FK bigInteger

survey_users

id increments
user_id ^FK bigInteger
survey_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes
year_id ^FK bigInteger

survey_logs

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK bigInteger
survey_id ^FK bigInteger
viewed_at timestamp
started_at timestamp
completion_rate float
completed_at timestamp
last_answer_at timestamp
year_id ^FK bigInteger

moshref_mahadir_answers

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK bigInteger
moshref_mahadir_question_id ^FK bigInteger
moshref_mahadir_id ^FK bigInteger
moshref_report_id ^FK bigInteger
answer string
answer_time timestamps
year_id ^FK bigInteger

moshref_mahadir_images

id increments
timestamps timestamps
softDeletes softDeletes
name string
moshref_mahadir_answer_id ^FK bigInteger
year_id ^FK bigInteger

test22

id increments
timestamps timestamps

stations

id increments
timestamps timestamps
softDeletes softDeletes
arabic_name string
english_name string
is_active tinyInteger
platform_id ^FK bigInteger
year_id ^FK bigInteger

camp_stations

id increments
timestamps timestamps
softDeletes softDeletes
virtual_location_id ^FK bigInteger
station_id ^FK bigInteger
year_id ^FK bigInteger

actual_locations

id increments
timestamps timestamps
softDeletes softDeletes
gate string
street string
label string
capacity integer
residence_area_type_id ^FK bigInteger
walking_time increments
distance_to_jamarat increments
latitude string
longitude string
is_active boolean
year_id ^FK bigInteger

interactive_maps

id increments
timestamps timestamps
softDeletes softDeletes
year_id ^FK bigInteger

drawing_maps

id increments
timestamps timestamps
softDeletes softDeletes
year_id ^FK bigInteger

years

id increments
timestamps timestamps
softDeletes softDeletes
name string

operation_codes

id increments
timestamps timestamps
softDeletes softDeletes
name string
description string

fl_operation_codes

id increments
timestamps timestamps
softDeletes softDeletes