Shops - Laravel Schema Designer

shops

id increments
timestamps timestamps
name string (100)
is_business boolean
email string
latitude double
longitude double
postocde string (7)
house_number integer
house_extension string (2)
street string (100)
city string (100)
image_path string (255)
user_id integer

menus

id increments
timestamps timestamps
shop_id integer
user_id integer
name string (100)

shop_working_hours

id increments
timestamps timestamps
shop_id integer
week_day tinyInteger
time_from time
time_to time
user_id integer

users

id increments
timestamps timestamps

menu_items

id increments
timestamps timestamps
menu_id integer
name string (255)
description string (255)
user_id integer
category_id integer
price integer
order smallInteger
max_free_extras tinyInteger
max_paid_extras tinyInteger

categories

id increments
timestamps timestamps
parent_id integer
name string (200)
slug string (200)
user_id integer
is_global boolean
children json

menu_item_variants

id increments
timestamps timestamps
menu_item_id integer
price integer
user_id integer
name string (200)
slug string (200)

menu_item_free_extras

id increments
timestamps timestamps
name string (255)
user_id integer

order_menu_items

id increments
timestamps timestamps
order_id integer
menu_item_id integer
variant_id integer
free_extras json
paid_extras json
deselect_items json
amount smallInteger
total integer
menu_item json

orders

id increments
timestamps timestamps

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