sofra-1 - Laravel Schema Designer

clients

id increments
district_id integer
name string
email string
password string
phone string
timestamps timestamps
api_token string

restaurants

id increments
district_id integer
category_id integer
image string
name string
minimum_charge decimal (8,2)
delivery decimal (8,2)
phone string
whatsapp string
email string
password string
timestamps timestamps
status enum
activated tinyInteger
api_token string

cities

id increments
name string
timestamps timestamps

notifications

id increments
timestamps timestamps
title string
body string
notifiable_id integer
notifiable_type string

districts

id increments
city_id integer
name string
timestamps timestamps

orders

id increments
client_id integer
address string
special_order string
notes string
total_price decimal (8,2)
additional_cost decimal (8,2)
payment enum
status enum
commission decimal (8,2)
timestamps timestamps

settings

id increments
about string
elahly_bank string
alrajhi_bank string
commission_details string
email string
phone string
facebook string
instagram string
twitter string
linkedin string
youtube string
google string
whatsapp string
timestamps timestamps

products

id increments
restaurant_id integer
image string
name string
description string
prep_time time
price decimal (8,2)
discount_price decimal (8,2)
timestamps timestamps

client_restaurant

id increments
client_id integer
restaurant_id integer
rate enum
comment string
timestamps timestamps

offers

id increments
timestamps timestamps
restaurant_id integer
image string
name string
description string
start date
end date

contacts

id increments
name string
email string
phone string
message string
type enum
timestamps timestamps
contactable_type string
contactable_id integer

payments

id increments
restaurant_id integer
paid decimal (8,2)
remaining decimal (8,2)
commissions decimal (8,2)
timestamps timestamps

order_product

id increments
order_id integer
product_id integer
quantity integer
price decimal (8,2)
notes string
timestamps timestamps

categories

id increments
timestamps timestamps
name string

tokens

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

category_restaurant

id increments
timestamps timestamps
category_id integer
restaurant_id string

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