food_families - Laravel Schema Designer

admins

id increments
name string (191)
email string (191)
password string (191)
status enum
timestamps timestamps

users

id increments
name string (191)
mobile string (191)
city_id integer
type enum
password string (191)
status enum
code string (191)
email string (191)
image string (191)
wallet integer
total_commission string (191)
timestamps timestamps

device_tokens

id increments
user_id ^FK integer
token string (191)
status enum
device_lang enum
device_type enum
timestamps timestamps

cities

id increments
name json
timestamps timestamps

categories

id increments
name json
image string (191)
timestamps timestamps

families

id increments
user_id ^FK integer
family_name string (191)
commercial_name string (191)
lat string (191)
lng string (191)
address string (191)
id_number string (191)
id_image string (191)
bank_name string (191)
bank_number string (191)
iban_number string (191)
tax_number string (191)
health_image string (191)
marketer_code string (191)
online enum
delivery enum
timestamps timestamps

drivers

id increments
user_id ^FK integer
lat string (191)
lng string (191)
address string (191)
id_number string (191)
license_image string (191)
license_number string (191)
bank_name string (191)
bank_number string (191)
iban_number string (191)
online enum
timestamps timestamps

views

id increments
visitor_id ^FK integer
family_id ^FK integer
timestamps timestamps

favorites

id increments
timestamps timestamps
user_id ^FK integer
product_id integer

family_categories

id increments
family_id ^FK integer
category_id ^FK integer
timestamps timestamps

followers

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

driver_categories

id increments
driver_id ^FK integer
category_id ^FK integer
timestamps timestamps

products

id increments
family_id ^FK integer
name string (191)
category_id ^FK integer
price string (191)
description text
timestamps timestamps

product_images

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

family_rates

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

notifications

id increments
title json
body json
user_id ^FK integer
type enum
seen enum
timestamps timestamps

settings

id increments
mobile string (191)
terms json
about json
email string (191)
app_commission string (191)
marketer_commission string (191)
delivery_cost string (191)
tax string (191)
timestamps timestamps

contacts

id increments
name string (191)
email string (191)
message text
timestamps timestamps

addresses

id increments
user_id ^FK integer
lat string (191)
lng string (191)
address text
title string (191)
timestamps timestamps

carts

id increments
user_id ^FK integer
family_id ^FK integer
product_id ^FK integer
count integer
price string (191)
status enum
timestamps timestamps

orders

id increments
user_id ^FK integer
family_id ^FK integer
driver_id ^FK integer
address_id ^FK integer
payment_types enum
order_time enum
date string (191)
time string (191)
total_price string (191)
status enum
order_code string (191)
cart_total string (191)
tax string (191)
delivery_cost string (191)
timestamps timestamps

order_cancels

id increments
order_id ^FK integer
user_id ^FK integer
message text
timestamps timestamps

order_carts

id increments
order_id ^FK integer
cart_id ^FK integer
timestamps timestamps

driver_rates

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

vacation_days

id increments
timestamps timestamps
family_id ^FK integer
day string (191)