Logistics - Laravel Schema Designer

Facilities

id increments
name string
address1 string
address2 string
city string
state string
zip integer
phone integer
timestamps timestamps
softDeletes softDeletes

Guestomers

id increments
name string
address1 string
address2 string
city string
state string (2)
zip integer
phone integer
mobile_phone integer
text boolean
timestamps timestamps
softDeletes softDeletes

StockBook-Vehicles

id increments
location ^FK integer
new boolean
key1_loc string
key2_loc string
key3_loc string
sold boolean
available_pickup boolean

Trips

id increments
stock_num string
from ^FK integer
to integer
eta datetime
dispatcher integer
driver integer
mgr_requested integer
pickup datetime
delivered datetime
waiter boolean
timestamps timestamps

StockBook-Roles

driver string
dispatcher string

Trip_Notes

id increments
stock_num string
note text
user_id integer
timestamps timestamps

Guestomers_Notes

id increments
note text
user_id integer
timestamps timestamps

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