Sofra - Laravel Schema Designer

restaurants

id increments
timestamps timestamps
name string
image string
delivery float
min_charge integer
status boolean
email string
phone string
password string
api_token string (60)
pin_code string
neighborhood_id ^FK integer

products

id increments
timestamps timestamps
name string
ingredients string
image string
price float
time string
offered_price string
restaurant_id ^FK integer

reviews

id increments
timestamps timestamps
content string
restaurant_id ^FK integer
rate enum
client_id ^FK integer

neighborhoods

id increments
timestamps timestamps
name string
city_id ^FK integer

cities

id increments
timestamps timestamps
name string

orders

id increments
timestamps timestamps
restaurant_id ^FK integer
payment_method_id ^FK integer
order_state enum
client_id ^FK integer
notes string
address string
price float
total_price float
delivery float
commission float
special_order text

clients

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

notifications

id increments
timestamps timestamps
title string
notificationable_id integer
notificationable_type string
is_read boolean
content text
order_id ^FK integer

contacts

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

settings

id increments
timestamps timestamps
about_us longText
content text
text text
phone string
email string
fb_link string
youtube_link string
insta_link string
twitter_link string
whatsapp string

offers

id increments
timestamps timestamps
name string
description text
image string
start datetime
end datetime

categories

id increments
timestamps timestamps
type string

commissions

id increments
timestamps timestamps
paid string
payment_date date
restaurant_id ^FK integer
notes text

payment_methods

id increments
timestamps timestamps
type string

order_product

id increments
timestamps timestamps
order_id ^FK integer
product_id ^FK integer
price float
quantity integer

tokens

id increments
timestamps timestamps
token string
type enum
tokenable_id integer
tokenable_type integer

category_restaurant

id increments
timestamps timestamps
category_id ^FK integer

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