e-commerce-db - Laravel Schema Designer

users

id increments
name string (155)
phone string
email string
password string
image string
status enum
timestamps timestamps

addresses

id increments
user_id ^FK bigInteger
country string
city string
street string
is_default boolean
timestamps timestamps
lat string
lng string

products

id increments
name json
description json
type enum
status enum
slug json
price decimal (2)
discount_type enum
in_stock boolean
is_new boolean
is_featured boolean
category_id ^FK bigInteger
vat string
meta_title json
meta_description json
meta_keywords json
timestamps timestamps

categories

id increments
name json
description json
parent_id ^FK bigInteger
timestamps timestamps

product_colors

id increments
product_id ^FK integer
color_name string
color_code string
image_url string
quantity integer
timestamps timestamps

vouchers

id increments
category_id ^FK integer
product_id ^FK integer
code string
name string
type enum
value decimal
max_uses integer
max_uses_per_user integer
start_date date
end_date string
timestamps timestamps

voucher_users

id increments
voucher_id ^FK integer
user_id ^FK integer
usage_count integer
timestamps timestamps

product_sizes

id increments
product_color_id ^FK integer
size string
quantity integer
timestamps timestamps

roles

id increments
name string
guard_name string
timestamps timestamps

orders

id increments
timestamps timestamps

wishlists

id increments
timestamps timestamps

reviews

id increments
timestamps timestamps

offers

id increments
name json
description json
special_price string
start_at date
end_at date
product_id ^FK integer
timestamps timestamps

permissions

id increments
timestamps timestamps
name string
guard_name string

role_has_permissions

id increments
timestamps timestamps

sizes

id increments
name string
timestamps timestamps

colors

id increments
name string
image_url string
hex_code string
timestamps timestamps

product_variations

id increments
product_id ^FK integer
color_id ^FK integer
stock integer
size_id ^FK integer
sku string
price string
timestamps timestamps

product_stocks

id increments
product_variation_id ^FK integer
total_stock integer
unit_price integer
total_price integer
type enum
timestamps timestamps

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01