maintenance - Laravel Schema Designer

maintenance_order

id increments
timestamps timestamps
softDeletes softDeletes
region_id integer
date datetime
site_id integer
details text
status string
type_id string

region

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
officer_id integer
employee_id integer

site

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
responsible_name string
responsible_mobile string

user

id increments
timestamps timestamps
softDeletes softDeletes

unit

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

maintenance_history

id increments
timestamps timestamps
softDeletes softDeletes
order_id integer
date datetime
details text
user_id integer

spare_order

id increments
timestamps timestamps
softDeletes softDeletes
order_id integer
date datetime
status string
quotation_id integer

spare_item

id increments
timestamps timestamps
softDeletes softDeletes
order_id integer
item_name string
amount integer
unit_id integer
notes text

quotation

id increments
timestamps timestamps
softDeletes softDeletes
order_id integer
date datetime
status string
total double
tax double
total_with_tax double

quotation_item

id increments
timestamps timestamps
softDeletes softDeletes
quotation_id integer
item_name string
amount integer
unit_id integer
unit_price double
total_price double
notes text

achievement_certificate

id increments
timestamps timestamps
softDeletes softDeletes
region_id integer
date_from datetime
date_to datetime
total integer
date datetime
status string

achievement_value

id increments
timestamps timestamps
softDeletes softDeletes
item_id integer
percentage integer
notes text
achievement_id integer

achievement_item

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
percentage integer

inventory

id increments
timestamps timestamps
softDeletes softDeletes
region_id integer
item_id integer
quantity integer
notes text
site_id integer

inventory_item

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
type string

inventory_record

id increments
timestamps timestamps
softDeletes softDeletes
date datetime
region_id integer
site_id integer

inventory_history

id increments
timestamps timestamps
softDeletes softDeletes
inventory_id integer
item_id integer
quantity integer
notes text
type string
process_type string
date datetime

inventory_record_item

id increments
timestamps timestamps
softDeletes softDeletes
record_id integer
item_id integer
quantity integer
type string
notes text

file_category

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

file

id increments
timestamps timestamps
softDeletes softDeletes
category_id integer
title_en string
title_ar string

periodic_maintenance

id increments
timestamps timestamps
softDeletes softDeletes
date datetime
region_id integer
site_id integer
status string

periodic_item

id increments
timestamps timestamps
softDeletes softDeletes
periodic_id integer
item_id integer
progress integer
notes text

periodic_item_data

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

maintenance_type

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

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01