magsaltysite - Laravel Schema Designer

country

id increments
name string (191)
flag string (191)
zip_code string (191)
code string (191)
currency string (191)
digits integer
timezone string
tax float
pricing_method string (191)
commition string (191)
commition_type integer
price_per_km integer
min_price integer
status integer
by_area integer
sent_orders_drivers integer
drivers_type integer
driver_destination string (191)
timestamps timestamps

city

id increments
country_id ^FK integer
name string (191)
sort string (191)
status integer
default_driver_price float
timestamps timestamps

area

id increments
city_id ^FK integer
name string (191)
sort integer
status integer
delivey_price string (191)
timestamps timestamps

users

id increments
name string (191)
email string (191)
phone integer
password string (191)
image string (191)
social_provider string (191)
social_id integer
status integer
social_image string (191)
store_id ^FK integer
country_id ^FK integer
location_updated_at datetime
is_online boolean
rate integer
in_service boolean
activation_date datetime
longitude string (191)
latitude string (191)
timestamps timestamps
language_id ^FK integer

language

id increments
name string (191)
code string (191)
status integer
timestamps timestamps

country_language

id increments
country_id ^FK integer
language_id ^FK integer
timestamps timestamps

days

id increments
name string (191)
mahcine_name string (191)
sort integer
timestamps timestamps
status integer

app_intro

id increments
title string (191)
text longText
image string (191)
sort integer
timestamps timestamps
status integer
country_id ^FK integer

categories

id increments
timestamps timestamps
name string (191)
image string (191)
machine_name string (191)
sort integer
status mediumInteger

country_category

id increments
timestamps timestamps
country_id ^FK integer
category_id ^FK integer

users_addresses

id increments
timestamps timestamps
nickname string (191)
user_id ^FK integer
area_id ^FK integer
address string (191)
phone string (191)
status integer
is_default integer
latitude string (191)
longitude string (191)

campaign

timestamps timestamps
from datetime
to datetime
id increments
percentage string (191)
fixed_amount string (191)
status mediumInteger

campaign_stores

id increments
timestamps timestamps
campaign_id ^FK integer
store_id ^FK integer

store

id increments
timestamps timestamps
name string (191)
subname string (191)
rate integer
logo string (191)
min_order_default integer
delivery_by integer
country_category_id ^FK integer
status integer

cart

id increments
timestamps timestamps
user_id ^FK integer
quantity integer
item_id ^FK integer
service_id ^FK integer

order

id increments
timestamps timestamps
user_id ^FK integer
coupon_id ^FK integer
store_id ^FK integer
time_to time
time_from time
payment_method string (191)
user_address_id ^FK integer
satus integer
driver_id ^FK integer
rate integer
item_amount bigInteger
tax_amount integer
delivery_amount integer
total_amount bigInteger

order_review

id increments
timestamps timestamps
order_id ^FK integer
user_id ^FK integer
rate integer
comment string (191)
status integer

order_details

id increments
timestamps timestamps
item_id ^FK integer
service_id ^FK integer
unit_price integer
quantity integer
total_price integer
status integer
coupon_id ^FK integer
order_id ^FK integer

coupon

id increments
timestamps timestamps
percentage integer
fixid_amount integer
code string (191)
from_datetime datetime
to_datetime datetime
status integer

app_info

id increments
timestamps timestamps
name string (191)
text longText
machine_name string (191)
sort integer
status integer
country_id ^FK integer

app_settings

id increments
timestamps timestamps
contact_phone string (191)
contact_email string (191)
ios_version string (191)
android_version string (191)
reset_password_timer bigInteger

status_area

id increments
timestamps timestamps
store_id ^FK integer
area_id ^FK integer
delivery_price integer
status integer
min_order integer

app_social_link

id increments
timestamps timestamps
name string (191)
image string (191)
link string (191)
sort integer
status integer

predefined_service

id increments
timestamps timestamps
name string (191)
icon string (191)
sort integer
status integer

store_rate

id increments
timestamps timestamps
user_id ^FK integer
store_id ^FK integer
rate integer
message longText

store_time_slots

id increments
timestamps timestamps
store_id ^FK integer
day_id ^FK integer
time_from time
time_to time
status integer

notifiction_template

id increments
timestamps timestamps
title string (191)
description longText
status integer

additional_services

timestamps timestamps
title string (191)
text string (191)
price integer
sort integer
status integer
id increments

notifiction

id increments
timestamps timestamps
title string (191)
description longText
fcm_notifictation_data string (191)
notification_template_id ^FK integer
user_id ^FK integer
status integer

store_menu_category

id increments
timestamps timestamps
name string (191)
sort integer
status integer
store_id ^FK integer

store_menu_item

id increments
timestamps timestamps
name string (191)
image string (191)
menu_category_id ^FK integer
status integer

store_menu_subitems

id increments
timestamps timestamps
service_id ^FK integer
price integer
sort integer
item_id ^FK integer

user_fcm

id increments
timestamps timestamps
fcm string (191)
status integer
device_id integer
user_id integer