Sofra - Laravel Schema Designer

restaurants

id increments
timestamps timestamps
name string
email string
phone string (11)
password string
is_opened boolean
image string
neighborhood_id ^FK integer
minimum_charge decimal
delivery_price decimal
contact_phone string (11)
contact_whatsapp string (11)
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

meals

id increments
timestamps timestamps
name string
price decimal
description text
price_in_offer decimal
preparation_time string
image string
restaurant_id ^FK integer

categories

id increments
timestamps timestamps
name string

offers

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

orders

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

notifications

id increments
timestamps timestamps
title string
content string
order_id ^FK integer
notificationable morphs

settings

id increments
timestamps timestamps
about_app text
commission_app decimal
email string
facebook_link string
twitter_link string

clients

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

contact_us

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

reviews

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

category_restaurant

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

meal_order

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

tokens

id increments
timestamps timestamps
token string
tokenable morphs
type enum

payments

id increments
timestamps timestamps
restaurant_id ^FK integer
amount decimal
notes string

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