home_mead - Laravel Schema Designer

contacts

id increments
timestamps timestamps
name string (199)
phone string (11)
email string (199)
message text

terms_conditions

id increments
timestamps timestamps
title string (199)
content text
about_us text

users

id increments
timestamps timestamps
name string (199)
phone string (11)
email string (199)
image string (199)
address string (199)
identity string (199)
license string (199)
vehicle_registration_number string (199)
bank_number string (11)
insurance_number string (199)
type enum
driver_type enum
password string (199)
active integer
latitude decimal (10,8)
longitude decimal (10,8)
city_id integer
api_token string (199)

shifts

id increments
timestamps timestamps
from timestamp
to timestamp
user_id ^FK integer

regions

id increments
timestamps timestamps
name string (199)

cities

id increments
timestamps timestamps
name string (199)
region_id ^FK integer

categories

id increments
timestamps timestamps
name string (199)
image string (255)

additions

id increments
timestamps timestamps
type integer
name string (199)
price decimal (10,2)
user_id ^FK integer

products

id increments
timestamps timestamps
name string (199)
category_id ^FK integer
price decimal (10,2)
description string (255)
type enum
viewer integer
time string (199)
user_id ^FK integer

images

id increments
timestamps timestamps
image string (255)
product_id ^FK integer

addition_product

id increments
timestamps timestamps
product_id ^FK integer
addition_id ^FK integer

offers

id increments
timestamps timestamps
details string (255)
state integer
order_id ^FK integer
driver_id ^FK integer
user_id ^FK integer
price decimal (10,2)

payments

id increments
timestamps timestamps
status integer
invoice integer
user_id ^FK integer

rates

id increments
timestamps timestamps
rate integer
family_id ^FK integer
driver_id ^FK integer
user_id ^FK integer

addresses

id increments
timestamps timestamps
name string (199)
city_id ^FK integer
latitude decimal (10,8)
longitude decimal (10,8)
user_id ^FK integer

chats

id increments
timestamps timestamps
user_id ^FK integer
second_user_id ^FK integer
photo string (255)
name string (199)
file string (255)
voice string (255)
message text
latitude decimal (10,8)
longitude string
order_id ^FK integer

verification_numbers

id increments
timestamps timestamps
code string (199)
phone string (20)

sliders

id increments
timestamps timestamps
name string (199)
image string (199)
user_id ^FK integer

coupons

id increments
timestamps timestamps
code string (199)
count_usage integer
discount integer
user_id ^FK integer

services

id increments
timestamps timestamps
name string (199)
description text
price decimal (10,2)

devices

id increments
timestamps timestamps
device_token string (199)
user_id ^FK integer

notifications

id increments
timestamps timestamps
order_id ^FK integer
title string (199)
client_id ^FK integer
family_id ^FK integer
driver_id ^FK integer
type integer

wallets

id increments
timestamps timestamps
cash decimal (10,2)
user_id ^FK integer

histories

id increments
timestamps timestamps
pull_request decimal (10,2)
mainPrice decimal (10,2)
net decimal (10,2)
user_id ^FK integer
title string (199)
order_id ^FK integer
family_id ^FK integer
driver_id ^FK integer

carts

id increments
timestamps timestamps
product_id ^FK integer
quantity integer
note text
order_id ^FK integer

addition_cart

id increments
timestamps timestamps
cart_id ^FK integer
addition_id ^FK integer

orders

id increments
timestamps timestamps
client_id ^FK integer
family_id ^FK integer
total_price decimal (10,2)
tax decimal (10,2)
net decimal (10,2)
status enum
delivery_type enum
note text

order_product

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

addition_order

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