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

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

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

variants

id increments
name string
timestamps timestamps

product_variants

id increments
product_id ^FK bigInteger
image_url string
price decimal ( 10, 2)
stock integer
sku string
timestamps timestamps

variant_values

id increments
product_variant_id ^FK bigInteger
variant_id ^FK bigInteger
value string
timestamps timestamps

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