e-commerce - Laravel Schema Designer

users

id increments
username string (32)
email string
password string
location string (191)
softDeletes softDeletes
timestamps timestamps
remember_token rememberToken
email_verified_at timestamp

roles

id increments
slug string
name string
permissions jsonb
timestamps timestamps

categories

id increments
user_id ^FK integer
parent_id ^FK integer
type string
timestamps timestamps

products

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
photo string
name string
description text
reviewed boolean
reviewed_at date
price integer

sales

id increments
timestamps timestamps
percentage float
saleable_id integer
saleable_type string
active boolean
user_id ^FK integer
expires_at timestamp

product_variations

id increments
timestamps timestamps
product_id ^FK integer
details text
order integer
product_variation_type_id ^FK integer

product_variation_types

id increments
timestamps timestamps
product_id ^FK integer
name string
stock integer
price integer

carts

id increments
timestamps timestamps
product_id ^FK integer
product_variation_type_id ^FK integer
quantity integer

wishlists

id increments
timestamps timestamps
product_id ^FK integer
product_variation_type_id ^FK integer
quantity integer

coupons

id increments
timestamps timestamps
code string (32)
user_id ^FK integer
amount integer
active boolean
expires_at timestamp
percentage float

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