Maintenance - Laravel Schema Designer

employees

id increments
department_id ^FK integer
timestamps timestamps

departments

id increments
timestamps timestamps

mnt_types

id increments
name string
logo string
timestamps timestamps

mnt_properties

id increments
type_id ^FK integer
title string
timestamps timestamps

mnt_orders

id increments
type_id ^FK integer
employee_id ^FK integer
status tinyInteger
timestamps timestamps

mnt_cancelled_orders

id increments
order_id ^FK integer
description text
timestamps timestamps

mnt_order_histories

id increments
order_id ^FK integer
status string (30)
timestamps timestamps

mnt_suppliers

id increments
type_id ^FK integer
name string
address string
timestamps timestamps

mnt_items

id increments
type_id ^FK integer
name string
timestamps timestamps

order_property

id increments
order_id ^FK integer
property_id ^FK integer
value text
timestamps timestamps

item_supplier

id increments
import_unique_id string
item_id ^FK integer
supplier_id ^FK integer
quantity integer
timestamps timestamps

supplier_items

id increments
supplier_id ^FK integer
item_id ^FK integer
quantity integer
timestamps timestamps

checkups

id increments
order_id ^FK integer
title string
description text
date datetime
timestamps timestamps

checkup_parts

id increments
checkup_id ^FK integer
part string
timestamps timestamps

item_order

id increments
order_id ^FK integer
supplier_id ^FK integer
item_id ^FK integer
quantity integer
timestamps timestamps

type_validations

id increments
type_id ^FK integer
validation string
value string
timestamps timestamps

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