dorra - Laravel Schema Designer

products

id increments
title string
description longText
category_id ^FK bigInteger
sub_category_id ^FK bigInteger
free_shipping boolean
timestamps timestamps
softDeletes softDeletes

tags

id increments
name string
timestamps timestamps

product_tag

product_id ^FK bigInteger
tag_id ^FK bigInteger
timestamps timestamps

categories

id increments
name string
parent_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

carts

id increments
user_id ^FK bigInteger
product_id ^FK bigInteger
cookie_id char (36)
quantity integer
price decimal
timestamps timestamps

users

id increments
first_name string
softDeletes softDeletes
last_name string
timestamps timestamps
email string
phone_number string
country_code_id ^FK bigInteger

country_codes

id increments
country_name string
iso_code string (3)
phone_code string (5)
timestamps timestamps
softDeletes softDeletes

discounts

id increments
code char (36)
type string
value decimal
start_date date
end_date date
timestamps timestamps

discount_product

product_id ^FK bigInteger
discount_id ^FK bigInteger
timestamps timestamps

orders

id increments
user_id ^FK bigInteger
sub_total decimal
discount double
shipping decimal
tax double
total decimal
status string
timestamps timestamps
softDeletes softDeletes

order_product

order_id ^FK bigInteger
product_id ^FK bigInteger
quantity integer
price decimal
timestamps timestamps

reviews

id increments
timestamps timestamps
review string
rate tinyInteger
user_id ^FK bigInteger
product_id ^FK bigInteger

product_variants

id increments
product_id ^FK bigInteger
color_name string
available_stock bigInteger
timestamps timestamps

product_prices

id increments
quantity decimal
original_price decimal
sale_price decimal
product_id ^FK bigInteger
timestamps timestamps

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