Toters - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
fname char (50)
lname char (50)
nickname char
image char (50)
dob date
email_address char (60)
phone char (50)
country_code char (10)
otp char (4)
is_active tinyInteger
updated_phone char (50)
updated_country_code char (10)
tier_id ^FK bigInteger
orders_count integer

addresses

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK bigInteger
default tinyInteger
building string
street string
apartment string
phone string
country_code smallInteger
instructions string

reviews

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK bigInteger
rating decimal (2.1)
comment string
reviewable_id bigInteger
reviewable_type string

favourites

id increments
timestamps timestamps
softDeletes softDeletes
favoriteable_id bigInteger
favoriteable_type string
user_id ^FK bigInteger

search_histories

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK bigInteger
is_active tinyInteger
keyword string

countries

id increments
timestamps timestamps
softDeletes softDeletes
flag string
currency_id ^FK bigInteger

country_translations

id increments
name string
locale char
country_id ^FK bigInteger

currencies

id increments
timestamps timestamps
softDeletes softDeletes
isocode string
default tinyInteger

currency_translations

id increments
name string
locale string
currency_id ^FK bigInteger

devices

id increments
timestamps timestamps
device_token text
type enum
user_id ^FK bigInteger

sections

timestamps timestamps
softDeletes softDeletes
id increments
image string

subsections

id increments
timestamps timestamps
softDeletes softDeletes
section_id ^FK bigInteger
image string

coupons

id increments
timestamps timestamps
softDeletes softDeletes
store_id ^FK bigInteger
code string
discount_percentage integer
expire_date date
is_active tinyInteger

coupon_users

id increments
timestamps timestamps
softDeletes softDeletes
coupon_id ^FK bigInteger
user_id ^FK bigInteger

orders

id increments
timestamps timestamps
softDeletes softDeletes
offer_id ^FK bigInteger
driver_id ^FK bigInteger
user_id ^FK bigInteger
sub_total decimal (10,2)
total decimal (10,2)
delivery_charge decimal (10,2)
service_charge decimal (10.2)
payment_type string
transaction_id string
default_currency_id ^FK bigInteger
from_address ^FK bigInteger
to_address ^FK bigInteger
address_id ^FK bigInteger
expected_cost decimal (10.2)
from_driver_instructions text
to_driver_instructions text
delivery_time time
exchange_rate decimal (10.2)
coupon_id ^FK bigInteger

order_items

id increments
timestamps timestamps
softDeletes softDeletes
order_id ^FK bigInteger
item_id ^FK bigInteger
size_id ^FK bigInteger
options text
drinks text
sides text
price decimal (10,2)
qty integer
total_price decimal (10,2)
services text
option_id ^FK bigInteger
preference_id ^FK bigInteger
notes text
order longText

carts

id increments
timestamps timestamps
softDeletes softDeletes
item_id ^FK bigInteger
user_id ^FK bigInteger
size_id ^FK bigInteger
sides text
qty integer
options text
preference_id ^FK bigInteger
option_id ^FK bigInteger
drinks string
services text
notes text
gift_id ^FK bigInteger

punchcards

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK bigInteger

statuses

id increments
timestamps timestamps
softDeletes softDeletes

notifications

id increments
timestamps timestamps
softDeletes softDeletes
title string
data string
user_id ^FK bigInteger
is_read tinyInteger
read_at timestamp
notifiable_type string
notifiable_id bigInteger

tiers

id increments
timestamps timestamps
softDeletes softDeletes
orders_count integer
duration_bydays integer
expired_duration_bydays integer
earn_reward_point integer

tier_translations

id increments
tier_id ^FK bigInteger
locale string
name string
description string

providers

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK bigInteger
provider char
provider_id string

status_translations

id increments
locale string
name string
description text
status_id ^FK bigInteger

order_statuses

id increments
timestamps timestamps
softDeletes softDeletes
order_id ^FK bigInteger
status_id ^FK bigInteger

section_translations

id increments
name string
description text
section_id ^FK bigInteger
locale string

subsection_translations

id increments
sub_section_id ^FK bigInteger
locale string
name string
description text

stores

id increments
timestamps timestamps
softDeletes softDeletes
default_currency_id ^FK bigInteger
price decimal (10,2)
exchange_rate decimal (10.4)
to_currency_id ^FK bigInteger
image string
from_hour time
to_hour time
address text
lat double
lng double
delivery_time time
delivery_fees float
avg_rating decimal (2.1)
is_offered tinyInteger
admin_id ^FK bigInteger
sub_section_id ^FK bigInteger

store_translations

id increments
name string
description text
locale string
store_id ^FK bigInteger

point_users

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK bigInteger
pointeable_id bigInteger
pointeable_type string
point_earned integer
point_used integer
point_expired integer
expired_at date

point_stores

id increments
timestamps timestamps
softDeletes softDeletes
store_id ^FK bigInteger
order_counts integer
expire_days integer
min_price decimal (10,2)
points_earned integer

offers

id increments
timestamps timestamps
softDeletes softDeletes
store_id ^FK bigInteger
discount_percentage integer
order_counts integer
image string
min_price decimal (10,2)
required_points integer
tier_id ^FK bigInteger
earned_points integer
saveup_price decimal (10,2)
user_count integer
free_delivery tinyInteger
from_date date
to_date date

offer_users

id increments
timestamps timestamps
softDeletes softDeletes
offer_id ^FK bigInteger
user_id ^FK bigInteger
order_count_of_user integer
expire_at date

store_categories

id increments
timestamps timestamps
softDeletes softDeletes
store_id ^FK bigInteger

store_category_translations

id increments
name string
description string
store_category_id ^FK bigInteger
locale string

addons

id increments
timestamps timestamps
softDeletes softDeletes
name string
image string
price decimal (10,2)

drinks

id increments
timestamps timestamps
softDeletes softDeletes
image string
price float

drink_translations

id increments
timestamps timestamps
name char (50)
drink_id ^FK bigInteger
locale string

ingredients

id increments
timestamps timestamps
softDeletes softDeletes
image string
item_id ^FK bigInteger

items

id increments
timestamps timestamps
softDeletes softDeletes
category_id ^FK bigInteger
store_id ^FK bigInteger
image string
price decimal (10,2)
default_currency_id ^FK bigInteger
has_gift tinyInteger
has_offer bigInteger
is_restaurant bigInteger

Item_translations

id increments
name string
description string
item_id ^FK bigInteger
locale string

ingredient_translations

id increments
name string
ingredient_id ^FK bigInteger
locale string

item_addons

id increments
timestamps timestamps
softDeletes softDeletes
item_id ^FK bigInteger
addon_id ^FK bigInteger

item_drinks

id increments
timestamps timestamps
item_id ^FK bigInteger
drink_id ^FK bigInteger

offer_tanslations

id increments
name string
description string
offer_id ^FK bigInteger
locale string

sides

id increments
timestamps timestamps
softDeletes softDeletes
price decimal (10,2)
image string
item_id ^FK bigInteger

side_translations

id increments
name string
side_id ^FK bigInteger
locale string

sizes

id increments
timestamps timestamps
softDeletes softDeletes
item_id ^FK bigInteger
price decimal (10,2)

size_translations

id increments
name string
size_id ^FK bigInteger
locale string

item_gifts

id increments
timestamps timestamps
softDeletes softDeletes
item_id ^FK bigInteger
name string
image string

wallets

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK bigInteger
primary_currency_id ^FK bigInteger
primary_balance decimal (10,2)

settings

id increments
timestamps timestamps
softDeletes softDeletes

options

id increments
timestamps timestamps
softDeletes softDeletes
item_id ^FK bigInteger
price decimal (10.2)
image string

preferences

id increments
timestamps timestamps
softDeletes softDeletes
price decimal (10,2)
item_id ^FK bigInteger

services

id increments
timestamps timestamps
softDeletes softDeletes
item_id ^FK bigInteger
price decimal (10,2)

preference_translations

id increments
timestamps timestamps
softDeletes softDeletes
preference_id ^FK bigInteger
locale string
name string

service_translations

id increments
name string
service_id ^FK bigInteger
locale string

option_translations

id increments
name string
option_id ^FK bigInteger
locle string

cart_item_options

id increments
timestamps timestamps
softDeletes softDeletes
cart_id ^FK bigInteger
optionable_id bigInteger
optionable_type string
price decimal (10,2)