sufra - Laravel Schema Designer

cities

id increments
timestamps timestamps
name string

regions

id increments
timestamps timestamps
name string
city_id ^FK integer

clients

id increments
timestamps timestamps
name string
email string
phone string
image string
password string
region_id ^FK integer
is_active boolean
api_token string (60)

restaurants

id increments
timestamps timestamps
name string
email string
phone string
password string
image string
contact_phone string
contact_whats_app string
status boolean
minimum_charge float
delivery_fee float
region_id ^FK integer
is_active boolean
api_token string (60)

categories

id increments
timestamps timestamps
name string

products

id increments
timestamps timestamps
name string
image string
details text
price float
offer_price float
restaurant_id ^FK integer
category_id ^FK integer

category_restaurant

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

offers

id increments
timestamps timestamps
name string
details string
image string
start_date datetime
end_date datetime
restaurant_id ^FK integer

reviwes

id increments
timestamps timestamps
comment text
rate_value enum
client_id ^FK integer
restaurant_id ^FK integer

orders

id increments
timestamps timestamps
cost float
note text
status enum
region_id ^FK integer
address string
delivery_fee float
commission_fee float
total float
net float
client_id ^FK integer
restaurant_id ^FK integer

order_product

id increments
timestamps timestamps
note text
quntity integer
price float
order_id ^FK integer
product_id ^FK integer

settings

id increments
timestamps timestamps
about_us text
commission_fee float
commission_text text
bank_accounts string

contacts

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

payments

id increments
timestamps timestamps
commission_paid float
payment_date datetime
note text
restaurant_id ^FK integer

tokens

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

notifications

id increments
timestamps timestamps
notifable_id integer
notifable_type string
order_id ^FK integer
title string
body text
is_read boolean

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