shop - Laravel Schema Designer

products

id increments
name string
stock mediumInteger
base_price decimal
has_options boolean
timestamps timestamps
softDeletes softDeletes

attributes

id increments
name string
timestamps timestamps
softDeletes softDeletes

values

id increments
attribute_id ^FK integer
name string
timestamps timestamps
softDeletes softDeletes

options

id increments
product_id ^FK integer
attribute_name string
value_name string
stock integer
surcharge decimal
timestamps timestamps
softDeletes softDeletes

orders

id increments
timestamps timestamps

order_items

id increments
order_id ^FK integer
product_id integer
name string
price decimal

order_item_options

id increments
order_item_id ^FK integer
option_id integer
attribute_name string
value_name string

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