Multi Vendor E-commerce - Laravel Schema Designer

users

id increments
name string
email string
password string
user_type enum
status enum
timestamps timestamps
softDeletes softDeletes

categories

id increments
category_name string
parent_id integer
image string
status enum
slug string
timestamps timestamps
softDeletes softDeletes

vendor_profile

id increments
user_id ^FK integer
store_name string
store_address string
store_phone string
store_city string
store_logo string
store_image string
longitude string
latitude string
store_type enum
timestamps timestamps
softDeletes softDeletes

user_profile

id increments
user_id ^FK integer
address string
city string
phone string
latitude string
longitude string
timestamps timestamps
softDeletes softDeletes

products

id increments
user_id ^FK integer
product_title string
brand_id ^FK integer
category_id ^FK integer
subcategory_id ^FK integer
child_category_id ^FK integer
image string
slug string
status enum
timestamps timestamps
softDeletes softDeletes

brands

id increments
brand_name string
status enum
slug string
timestamps timestamps
softDeletes softDeletes

variants

id increments
name string
timestamps timestamps
softDeletes softDeletes

variant_values

id increments
variant_id ^FK integer
name string
values string
timestamps timestamps
softDeletes softDeletes

product_variant_map

id increments
user_id ^FK integer
product_id ^FK integer
product_sub_title longText
product_sku string
variant_id ^FK integer
variant_value_id ^FK integer
quantity string
unit_id ^FK integer
regular_price decimal
discount_type enum
discount_value decimal
sale_price decimal
in_stock bigInteger
tax_id ^FK integer
product_description longText
status enum
timestamps timestamps
softDeletes softDeletes

product_images

id increments
product_id ^FK integer
image string
status enum
timestamps timestamps

shipping

id increments
user_id ^FK integer
shipping_name string
shipping_address string
shipping_email string
shipping_phone string
shipping_country integer
shipping_state integer
shipping_city string
timestamps timestamps
softDeletes softDeletes

payment

id increments
payment_method string
payment_status enum
payment_date date
timestamps timestamps
softDeletes softDeletes

orders

id increments
user_id ^FK integer
shipping_id ^FK integer
payment_id ^FK integer
order_total decimal
total_discount decimal
delivery_charge decimal
total_tax decimal
gross_amount decimal
status enum
order_date timestamp
timestamps timestamps
softDeletes softDeletes

order_details

id increments
order_id ^FK integer
product_id ^FK integer
vendor_id ^FK integer
product_variant_map_id ^FK integer
product_details json
supplier_details json
price string
quantity integer
total_price decimal
timestamps timestamps
softDeletes softDeletes

store_images

id increments
user_id string
image string
status enum
timestamps timestamps

units

id increments
name string
short_name string
status enum
timestamps timestamps

taxes

id increments
title string
value decimal
status enum
timestamps timestamps

tax_details

id increments
tax_id ^FK integer
title string
value decimal
timestamps timestamps

carts

id increments
unique_id string
user_id ^FK integer
product_variant_map_id ^FK integer
quantity integer
timestamps timestamps

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