Mokfha - Laravel Schema Designer

users

id increments
username string
password string
code string
name string
job_id ^FK integer
job_title string
team_id ^FK integer
municipal_id ^FK integer
district_id ^FK integer
active tinyInteger
mode string
menu string
timestamps timestamps

jobs

id increments
title json
user_id ^FK integer
timestamps timestamps

municipals

id increments
title json
user_id ^FK integer
timestamps timestamps

districts

id increments
title json
user_id ^FK integer
municipal_id ^FK integer
timestamps timestamps

id increments
timestamps timestamps

days

id increments
title json
timestamps timestamps

worktimes

id increments
municipal_id ^FK integer
district_id ^FK integer
day_id ^FK integer
from time
to time
user_id ^FK integer
timestamps timestamps

teams

id increments
title json
user_id ^FK integer
timestamps timestamps

field_reports

id increments
type string
municipal_id ^FK integer
district_id ^FK integer
latitude double
longitude double
notes text
user_id ^FK integer
timestamps timestamps

place_types

id increments
title json
user_id ^FK integer
timestamps timestamps

focal_types

id increments
title json
user_id ^FK integer
timestamps timestamps

aversion_types

id increments
title json
user_id ^FK integer
timestamps timestamps

aversion_shapes

id increments
title json
user_id ^FK integer
timestamps timestamps

processing_types

id increments
title json
user_id ^FK integer
timestamps timestamps

treatment_methods

id increments
title json
user_id ^FK integer
timestamps timestamps

field_report_place_types

id increments
field_report_id ^FK integer
place_type_id ^FK integer
timestamps timestamps

field_report_focal_types

id increments
field_report_id ^FK integer
focal_type_id ^FK integer
quantity integer
timestamps timestamps

causes

id increments
title json
user_id ^FK integer
timestamps timestamps

field_report_causes

id increments
field_report_id ^FK integer
cause_id ^FK integer
timestamps timestamps

field_report_aversion_types

id increments
field_report_id integer
aversion_type_id ^FK integer
timestamps timestamps

focal_moods

id increments
title json
user_id ^FK integer
timestamps timestamps

field_report_focal_moods

id increments
field_report_id integer
focal_mood_id ^FK integer
timestamps timestamps

field_report_aversion_shapes

id increments
field_report_id ^FK integer
aversion_shape_id ^FK integer
quantity integer
timestamps timestamps

field_report_procedures

id increments
field_report_id ^FK integer
procedure_id ^FK integer
timestamps timestamps

procedures

id increments
title json
user_id ^FK integer
timestamps timestamps

field_report_processing_types

id increments
field_report_id ^FK integer
processing_type_id ^FK integer
timestamps timestamps

field_report_treatment_methods

id increments
field_report_id ^FK integer
treatment_method_id ^FK integer
timestamps timestamps

fighting_materials

id increments
title json
user_id ^FK integer
timestamps timestamps

field_report_fighting_materials

id increments
field_report_id ^FK integer
fighting_material_id ^FK integer
quantity integer
timestamps timestamps

drivers

id increments
user_id ^FK integer
first_name string
second_name string
third_name string
job_number string
phone_number string
national_id_number string
driving_license_expiration_date date
driving_license_number string
municipal_id ^FK integer
timestamps timestamps

workers

id increments
user_id ^FK integer
first_name string
second_name string
third_name string
job_number string
phone string
municipal_id ^FK integer
timestamps timestamps

cars

id increments
user_id ^FK integer
board_number string
type string
model string
color string
form_number string
expiration_date date
counter_number string
driver_id ^FK integer
timestamps timestamps

equipments

id increments
title json
user_id ^FK integer
timestamps timestamps
type string
capacity double
car_id ^FK integer

driver_districts

id increments
driver_id ^FK integer
district_id ^FK integer
timestamps timestamps

worker_districts

id increments
worker_id ^FK integer
district_id ^FK integer
timestamps timestamps