speed_delivery - Laravel Schema Designer

clients

id increments
name string
timestamps timestamps
softDeletes softDeletes

client_phones

id increments
client_id ^FK bigInteger
phone string
timestamps timestamps

states

id increments
city_id ^FK bigInteger
title string
timestamps timestamps

order_statuses

id increments
action enum
timestamps timestamps

orders

id increments
client_id ^FK bigInteger
delivery_id ^FK bigInteger
address_id ^FK bigInteger
order_status_id ^FK bigInteger
description string
price string
delivery_price string
notes string
timestamps timestamps
shop_id ^FK bigInteger

delivery_prices

id increments
backup_id ^FK bigInteger
address_id ^FK bigInteger
price float
timestamps timestamps

addresses

id increments
client_id ^FK bigInteger
state_id ^FK bigInteger
description string
timestamps timestamps

deliveries

id increments
vehicle_id ^FK bigInteger
name string
phone string
password string
timestamps timestamps
softDeletes softDeletes

vehicles

id increments
name string
type string
timestamps timestamps

shops

id increments
state_id ^FK bigInteger
name string
phone string
password string
timestamps timestamps
softDeletes softDeletes

cities

id increments
title string
timestamps timestamps

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