sofra-11-2020 - Laravel Schema Designer

products

id increments
timestamps timestamps
name string
description text
price decimal (8,2)
offer_price decimal (8,2)
image string
preparation_time timestamps
restaurant_id ^FK integer

restaurants

id increments
timestamps timestamps
name string
email string
password string
phone string
whatsapp string
image string
status enum
minimum_order integer
delivery_cost decimal (8,2)
activated boolean
pin_code string (6)
api_token string (60)
region_id ^FK integer

reviews

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

orders

id increments
timestamps timestamps
address text
notes text
payment_method enum
status enum
cost decimal (8,2)
net decimal (8,2)
delivery_cost decimal (8,2)
total_cost decimal (8,2)
commission decimal (8,2)
client_id ^FK integer
restaurant_id ^FK integer

cities

id increments
timestamps timestamps
name string

offers

id increments
timestamps timestamps
name string
description string
price decimal (8,2)
image string
start_date datetime
end_date datetime
restaurant_id ^FK integer

notifications

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

regions

id increments
timestamps timestamps
name string
city_id ^FK integer

categories

id increments
timestamps timestamps
name string

contactes

id increments
timestamps timestamps
name string
email string
phone string
massage string
type enum

settings

id increments
timestamps timestamps
about string
phone string
facebook_link string
instagram_link string
twitter_link string
youtube_link string
whatsapp_link string
android_link string
ios_link string
terms string
about_commission string
id_bank string
commission decimal

tokens

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

clients

id increments
timestamps timestamps
name string
email string
phone string
password string
address text
pin_code string (6)
api_token string (60)
region_id ^FK integer

category_restaurant

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

payments

id increments
timestamps timestamps
amount decimal (8,2)
date date
note text
restaurant_id ^FK integer

order_product

id increments
timestamps timestamps
quantity integer
price decimal
special_order text
order_id ^FK integer
product_id ^FK integer

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