Sofra - Laravel Schema Designer

restaurants

id increments
timestamps timestamps
name string
email string
phone string (11)
city_id ^FK integer
neighborhood_id ^FK integer
password string
food_category_id integer
min_charge integer
delivery_price decimal
contact_phone string (11)
contact_whatsapp string
restaurant_image string
is_opened boolean
api_token string (60)
pin_code string

cities

id increments
timestamps timestamps
name string

neighborhoods

id increments
timestamps timestamps
name string
city_id ^FK integer

food_categories

id increments
timestamps timestamps
name string

meals

id increments
timestamps timestamps
name string
content string
price decimal
restaurant_id ^FK integer
preparation_time string
meal_image string
price-in-offer decimal

orders

id increments
timestamps timestamps
client_id ^FK integer
restaurant_id ^FK integer
price decimal
delivery_price decimal
total_price decimal
status enum
commission decimal
net decimal
address text

offers

id increments
timestamps timestamps
name string
description string
start_date date
end_date date
restaurant_id ^FK integer

meal_order

id increments
timestamps timestamps
order_id ^FK integer
meal_id ^FK integer
note string
meal_price decimal
quantity integer

settings

id increments
timestamps timestamps
email string
phone string (11)
whatsapp string
fb_link string
insta_link string
tw_link string
about text
commission decimal
commission_text text

comments

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

clients

id increments
timestamps timestamps
name string
email string
phone string (11)
city_id ^FK integer
neighborhood_id ^FK integer
password string
api_token string (60)
pin_code string

tokens

id increments
timestamps timestamps
token string
tokenable morphs
type enum

notifications

id increments
timestamps timestamps
title string
body string
notificationable morphs
is_read boolean

contacts

id increments
timestamps timestamps
message_title string
message text
client_id ^FK integer

food_category_restaurant

id increments
timestamps timestamps
food_category_id ^FK integer
restaurant_id ^FK integer

payments

id increments
timestamps timestamps
restaurant_id ^FK integer
amount decimal

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