SofraWorkFlow - Laravel Schema Designer

contact_us

id increments
timestamps timestamps
fullname string
email string
phone string
message longText
type enum

settings

id increments
about_us longText
rajhe_account string
alahly_account string
title string
favicon string
commision decimal (10,2)
timestamps timestamps

restaurants

id increments
restaurant_name string
email string
phone string
neighborhood_id ^FK integer
password string
minimum_order decimal (10,2)
delivery_fees decimal (10,2)
delivery_phone string
delivery_watsapp_number string
rating integer
image string
status enum
timestamps timestamps

cities

id increments
name string
timestamps timestamps

neighborhoods

id increments
name string
city_id ^FK integer
timestamps timestamps

clients

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

classifications

id increments
name string
timestamps timestamps

classification_restaurant

id increments
restaurant_id ^FK integer
classification_id ^FK integer
timestamps timestamps

offers

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

products

id increments
name string
description longText
price decimal (10,2)
offer_price decimal (10,2)
has_offer enum
order_preparation_time string
restaurant_id ^FK integer
image string
timestamps timestamps

reviews

id increments
client_id ^FK integer
restaurant_id ^FK integer
coment longText
emoji enum
timestamps timestamps

orders

id increments
client_id ^FK integer
restaurant_id ^FK integer
app_commission decimal (10,2)
price decimal (10,2)
total_price decimal (10,2)
delivery_fees decimal (10,2)
status enum
payment_method enum
notes longText
timestamps timestamps
address string

notifications

id increments
title string
content longText
user morphs
timestamps timestamps

fees_paid

id increments
app_fees decimal
fees_paid decimal
remaining_fees decimal
payment_method enum
payment_date datetime
status enum
notes longText
timestamps timestamps

order_product

id increments
order_id ^FK integer
product_id ^FK integer
quantity integer
price decimal (10,2)
timestamps timestamps

tokens

id increments
user morphs
token string
type string
timestamps timestamps

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