Sofra - Laravel Schema Designer

restaurants

id increments
timestamps timestamps
status boolean
name string
district_id ^FK integer
min_order_price decimal (10,8)
delivery_price decimal (10,8)
avg_rate decimal (10,8)
mobile string
watts_number string
image string

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

meals

id increments
timestamps timestamps
name string
price decimal (10,8)
offer_price decimal (10,8)
ready_time integer
description text
restaurant_id ^FK integer
image string

clients

timestamps timestamps
id increments
name string
email string
phone string
distric_id ^FK integer
password string

orders

id increments
timestamps timestamps
total_meals_price decimal (10,8)
commission_price decimal (10,8)
delivery_price decimal (10,8)
total_price decimal (10,8)
payment_method_id ^FK integer
note text
address text
state enum

meal_order

id increments
timestamps timestamps
quantity integer
meal_id ^FK integer
order_id ^FK integer
special_note text
meal_price decimal (10,8)

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
total decimal (10,8)
payed decimal (10,8)
details text

offers

id increments
timestamps timestamps
image string
name string
description text
start_date date
end_date date
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

notificatinos

id increments
timestamps timestamps
title string
body text

client_notification

id increments
timestamps timestamps
notification_id ^FK integer
client_id ^FK integer

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