buffalo - Laravel Schema Designer

orders

id increments
customer_id bigInteger
delivery_option tinyInteger
total decimal (10,2)
status tinyInteger
shipping_address_id bigInteger
branch_id bigInteger
is_open tinyInteger
is_new tinyInteger
assigned_to_agent_id bigInteger
timestamps timestamps
softDeletes softDeletes

customers

id increments
name string
email string
mobile string
is_active tinyInteger
timestamps timestamps
softDeletes softDeletes

addresses

id increments
street text
city string
state string
lat float (10,6)
lng float (10,6)
is_main tinyInteger
land_line string
details text
customer_id bigInteger
timestamps timestamps
softDeletes softDeletes

categories

id increments
name string
description text
is_active tinyInteger
parent_id bigInteger
timestamps timestamps
softDeletes softDeletes

items

id increments
name string
price decimal (10,2)
image string
description text
is_active tinyInteger
timestamps timestamps
softDeletes softDeletes

item_categories

id increments
item_id bigInteger
category_id bigInteger

order_items

id increments
order_id bigInteger
item_id bigInteger
quantity smallInteger
price decimal (10,2)
subtotal decimal (10,2)
timestamps timestamps
softDeletes softDeletes

branches

id increments
name string
address string
city string
state string
lat float (10,6)
lng float (10,6)
mobile string
delivery_method tinyInteger
is_active tinyInteger
status tinyInteger
timestamps timestamps
softDeletes softDeletes

order_logs

id increments
timestamps timestamps
message text
user_id bigInteger
type tinyInteger
comment text

branch_items_unavailable

id increments
branch_id bigInteger
item_id bigInteger

media

id increments
title string
ext string
type string
description string
is_active tinyInteger
path string
timestamps timestamps

mediaables

id increments
media_id bigInteger
mediaable_id bigInteger
mediaable_type string

zones

id increments
name string
is_active tinyInteger
timestamps timestamps
softDeletes softDeletes
city string

areas

id increments
name string
zone_id bigInteger
branch_id bigInteger
lat float (10,6)
lng float (10,6)
is_active tinyInteger
timestamps timestamps
softDeletes softDeletes

work_hours

id increments
day tinyInteger
start string
end string
delivery_option tinyInteger
area_id bigInteger
branch_id bigInteger

extra_items

id increments
item_id bigInteger
extra_id bigInteger

item_sizes

id increments
size string
price decimal (10,2)
item_id bigInteger
branch_id bigInteger
is_available boolean

branch_items_customize

id increments
customize nullableMorphs
price decimal (10,2)
is_available boolean
branch_id bigInteger

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