brandify - Laravel Schema Designer

users

id increments
timestamps timestamps

categories

id increments
timestamps timestamps
name string

products

id increments
category_id ^FK integer
name string (255)
slug string
price float
compare_price float
description longText
is_active boolean
best_sellar boolean
stock integer
timestamps timestamps

carts

id increments
user_id ^FK integer
cookie_uuid string
product_id ^FK integer
quantity integer
timestamps timestamps

wishlists

id increments
user_id ^FK integer
cookie_uuid string
product_id ^FK integer
timestamps timestamps

orders

id increments
user_id ^FK integer
order_number string
discount float
tax float
prefinal_total float
final_total float
status enum
payment_status enum
options string
timestamps timestamps

order_items

id increments
order_id ^FK integer
product_id ^FK integer
quantity integer
price float
compare_price float
timestamps timestamps

order_addresses

id increments
order_id ^FK integer
type enum
email string
first_name string
last_name string
company_name string
country string
city string
code string
phone string
house smallInteger
information text
timestamps timestamps

attachments

id increments
type enum
model_id integer
model_type string
path string
timestamps timestamps

product_ratings

id increments
product_id integer
timestamps timestamps

product_colors

id increments
product_id integer
color string
timestamps timestamps

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