Sofra - Laravel Schema Designer

clients

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

cities

id increments
timestamps timestamps
name string

regions

id increments
timestamps timestamps
name string
city_id ^FK integer

categories

id increments
timestamps timestamps
name string

restaurants

id increments
timestamps timestamps
category_id ^FK integer
minimum_order decimal
delivery_charge decimal
phone string
whats_app string
image string
region_id ^FK integer
name string
email string
password string
phone_owner string
is_active enum

products

id increments
timestamps timestamps
name string
description longText
image string
price decimal
price_of_sale decimal
preparation_time string
restaurant_id ^FK integer

orders

id increments
timestamps timestamps
client_id ^FK integer
notes longText
total_price decimal
status enum
restaurant_id ^FK integer
delivery_charge decimal
commission decimal

contacts

id increments
timestamps timestamps
name string
email string
title string
message longText
type enum

reviews

id increments
timestamps timestamps
client_id ^FK integer
restaurant_id ^FK integer
stars string
comment longText

order_products

id increments
timestamps timestamps
order_id ^FK integer
product_id ^FK integer
price decimal
quantity integer
special string

offers

id increments
timestamps timestamps
restaurant_id ^FK integer
name string
description longText
image string
start_from datetime
end_to datetime

payment_receives

id increments
timestamps timestamps
restaurant_id ^FK integer
amount string

category_restaurants

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

notifications

id increments
timestamps timestamps
title string
content longText
client_id ^FK integer
order_id ^FK integer
restaurant_id ^FK integer

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