ecommerce - Laravel Schema Designer

products

id increments
sku string (255)
upc string (255)
name string (255)
cartDescription string (255)
description text
inventory integer
weight float
taxable tinyInteger
live tinyInteger
retired tinyInteger
slug string (255)
timestamps timestamps

products_options

id increments
product_id ^FK integer
name string (255)
title string (255)
description string (35)
live boolean
timestamps timestamps

products_options_values

id increments
product_option_id ^FK integer
product_price_tier_id integer
sku string (255)
inventory integer
name string (255)
value string (255)
price decimal (9,2)
taxable tinyInteger
sort_order integer
timestamps timestamps

products_images

id increments
product_id ^FK integer
product_option_value_id integer
name string (255)
title string (255)
alt string (255)
link string (255)
description text
sort_order integer
timestamps timestamps

option_values

product_option_id ^FK integer
product_option_value_id ^FK integer

products_prices

id increments
primary tinyInteger
product_id ^FK integer
price decimal (9,2)
sale decimal (9,2)
qty integer
timestamps timestamps

products_price_tiers

id increments
product_id ^FK integer
maxqty integer
price decimal (9,2)
code string (5)
sort_order integer
timestamps timestamps

categories

id increments
parent_id integer
name string (255)
description text
image string (255)
slug string (255)
live tinyInteger
sort_order integer
timestamps timestamps

category_product

category_id ^FK integer
product_id ^FK integer

custom_option_values

id increments
products_options_value_id ^FK integer
name string (255)
value string (255)
sort_order integer
timestamps timestamps

category_images

id increments
category_id ^FK integer
name string (255)
title string (255)
alt string (255)
link string (255)
description text
sort_order integer
timestamps timestamps

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