resturant - Laravel Schema Designer

customers

id increments
timestamps timestamps
softDeletes softDeletes
name string
email string
password string
phone_number string
address string
provider_id string
provider string
is_active_phone integer
latitude text
longitude text

menu_sections

id increments
timestamps timestamps
name string
resturant_id ^FK integer

menu_items

id increments
timestamps timestamps
menu_section_id ^FK integer
name string
description text
price decimal
resturant_id ^FK integer

orders

id increments
timestamps timestamps
customer_id ^FK integer
order_status integer
notes text
total_cost decimal
resturant_id ^FK integer
payment_way_id ^FK integer
pick_time time
coupon_code string

resturant_tables

id increments
timestamps timestamps
table_number integer
size integer
table_status integer
region_id ^FK integer
resturant_id ^FK integer

resturant_regions

id increments
timestamps timestamps
name string

order_item

id increments
timestamps timestamps
menu_item_id ^FK integer
order_id ^FK integer
quantity integer
price decimal
size json
type json
saus json

resturants

id increments
timestamps timestamps
name string
address text
work_hours string
vat integer
type integer
delivery_fee decimal
minimum_order decimal
delivery_time string
latitude text
longitude text
country_id ^FK integer
city_id ^FK integer

reservations

id increments
timestamps timestamps
customer_id ^FK integer
resturant_table_id ^FK integer
reservation_status integer

employees

id increments
timestamps timestamps
name string
email string
phone_number string
password string
national_number string
region_id ^FK integer
resturant_section_id ^FK integer
resturant_id ^FK integer

resturant_sections

id increments
timestamps timestamps
name string
resturant_id ^FK integer

shifts

id increments
timestamps timestamps
from_time time
to_time time
resturant_id ^FK integer

employee_shift

id increments
timestamps timestamps
employee_id ^FK integer
shift_id ^FK integer

admins

id increments
timestamps timestamps
name string
password string
resturant_id ^FK integer

attendances

id increments
timestamps timestamps
employee_id ^FK integer
attendance_time time
checkout_time time
resturant_id ^FK integer

reviews

id increments
timestamps timestamps
resturant_customer_id ^FK integer
comment text
rate integer
type integer
resturant_id ^FK integer

employee_performances

id increments
timestamps timestamps
employee_id ^FK integer
notes string
evaluation_date date
rate decimal
evaluation_type integer
resturant_id ^FK integer

payment_ways

id increments
timestamps timestamps
name string
resturant_id ^FK integer

payment_transactions

id increments
payment_way_id ^FK integer
customer_id ^FK integer
timestamps timestamps
order_id ^FK integer
amount decimal
resturant_id ^FK integer

coupons

id increments
timestamps timestamps
code string
discount decimal
expire_in date
active_in date

promotions

id increments
timestamps timestamps
title string
description text
menu_item_id ^FK integer
active_in date
expire_in date
discount integer
resturant_id ^FK integer

delivery_reviews

id increments
timestamps timestamps
customer_id ^FK integer
order_id ^FK integer
comment text
rate integer

deliveries

id increments
timestamps timestamps
start_at timestamp
end_at timestamp
delivery_status integer
employee_id ^FK integer
employee_latitude text
employee_longitude text
order_id ^FK integer
resturant_id ^FK integer

delivery_routes

id increments
timestamps timestamps
delivery_id ^FK integer
delivery_fee decimal
start_latitude text
start_longitude text
end_latitude text
end_longitude text
duration string

order_invoices

id increments
timestamps timestamps
softDeletes softDeletes
order_id ^FK integer
total_cost decimal
delivery_fee decimal
resturant_vat integer
resturant_id ^FK integer

activation_processes

id increments
timestamps timestamps
phone_number string
code string
status integer

carts

id increments
timestamps timestamps
total_price decimal
customer_id ^FK integer
notes longText
resturant_id ^FK integer
service integer

cart_menu_item

id increments
timestamps timestamps
cart_id ^FK integer
menu_item_id ^FK integer
quantity integer
price decimal
special_instructions text
saus json
size json
type json

meal_attributes

id increments
timestamps timestamps
resturant_id ^FK integer
menu_item_id ^FK integer
type integer
price decimal
offer_price decimal
name string

countries

id increments
timestamps timestamps
name string

cities

id increments
timestamps timestamps
name string

customer_resturant

id increments
timestamps timestamps
customer_id ^FK integer
resturant_id ^FK integer

delivery_addresses

id increments
timestamps timestamps
house_number string
postcode string
city string
company_name string
notes text
order_id ^FK integer