sofra - Laravel Schema Designer

clients

id increments
email string (255)
phone string (255)
password string (255)
name string (255)
area_id ^FK bigInteger
timestamps timestamps

areas

id increments
name string
city_Id ^FK bigInteger
timestamps timestamps

cities

id increments
name string
timestamps timestamps

restaurants

id increments
name string (255)
email string
phone string
password string
logo string (255)
area_id ^FK bigInteger
min_order decimal (10,2)
delivery_fee decimal (10,2)
status string (255)
avg_rate integer
contact_phone string
whatsapp_number string
timestamps timestamps

meals

id increments
name string (255)
description text
price decimal (6,2)
offer_price decimal
image string
restaurant_id ^FK bigInteger
preparation_time timestamps
timestamps timestamps

reviews

id increments
comment string (255)
review string
rate integer
client_id ^FK bigInteger
restaurant_id ^FK bigInteger
timestamps timestamps

meal_order

meal_id ^FK bigInteger
order_id ^FK bigInteger
quantity bigInteger
special_request string
total_amount decimal

orders

id increments
number string
address string
payment_method string
status string
notes text
commission decimal
price decimal
delivery_fee integer
total_amount decimal
client_id ^FK bigInteger
restaurant_id ^FK bigInteger
timestamps timestamps

contacts

id increments
name string
email string
phone string
message text
status string
timestamps timestamps

settings

id increments
key string
value string
timestamps timestamps

offers

id increments
name string
description longText
logo string
from date
to date
restaurant_id ^FK bigInteger
timestamps timestamps

categories

id increments
name string
timestamps timestamps

notifications

id increments
notificationable_id bigInteger
notificationable_type string
read_at timestamps
timestamps timestamps
content string

commissions

id increments
paid decimal
date date
notes longText
timestamps timestamps
restaurant_Id ^FK bigInteger

category_restaurant

restaurant_id ^FK bigInteger
category_id ^FK bigInteger

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