Sofra - Laravel Schema Designer

restaurants

id increments
timestamps timestamps
status boolean
name string
email string
phone string
contact_num string
watts_num string
min_order_price decimal
password string
delivery_price decimal
avg_rate decimal
image string
reset_code string
district_id ^FK integer

cites

id increments
timestamps timestamps
name string

districts

id increments
timestamps timestamps
name string
city_id ^FK integer

reviews

id increments
timestamps timestamps
content text
rate tinyInteger
restaurant_id ^FK integer
client_id ^FK integer

meals

id increments
timestamps timestamps
name string
price decimal
offer_price decimal
ready_time integer
description text
restaurant_id ^FK integer
image string

clients

id increments
timestamps timestamps
name string
email string
phone string
district_id ^FK integer
password string
reset_code string

orders

id increments
timestamps timestamps
cost decimal
commission_price decimal
delivery_price decimal
total_price decimal
payment_method_id ^FK integer
note text
address text
status tinyInteger
restaurant_id ^FK integer
client_id ^FK integer
net decimal

meal_order

id increments
timestamps timestamps
quantity integer
meal_id ^FK integer
order_id ^FK integer
note text
price decimal

categories

id increments
timestamps timestamps
name string

category_restaurant

id increments
timestamps timestamps
category_id ^FK integer
restaurant_id ^FK integer

commission

id increments
timestamps timestamps
resturant_id ^FK integer
amount decimal
details text

offers

id increments
timestamps timestamps
image string
name string
description text
start_date datetime
end_date datetime
restaurant_id integer

payment_methods

id increments
timestamps timestamps
name string

contacts

id increments
timestamps timestamps
full_name string
email string
phone string
message text
type enum

settings

id increments
timestamps timestamps
about text
commission decimal

notifications

id increments
timestamps timestamps
title string
body text
is_read boolean

notifyables

id increments
timestamps timestamps
notification_id integer
notifyable morphs

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