Twist - Laravel Schema Designer

brands

id increments
timestamps timestamps
name string (40)
sku_template string (3)

products

id increments
timestamps timestamps
brand_id ^FK integer
name string (50)
description text
category_id ^FK integer
barcode_template string (5)

categories

id increments
timestamps timestamps
name string (50)

category_variant_template

timestamps timestamps
category_id ^FK integer
variant_template_id ^FK integer

product_variants

id increments
timestamps timestamps
product_id ^FK integer
variant_name_id ^FK integer

product_variant_values

id increments
timestamps timestamps
product_variant_id ^FK integer
variant_value_id ^FK integer
sku_template string (2)

skus

id increments
timestamps timestamps
softDeletes softDeletes
product_id ^FK integer
barcode string (20)
price decimal (8,2)

product_variant_value_sku

product_variant_value_id ^FK integer
sku_id ^FK integer
timestamps timestamps

locations

id increments
timestamps timestamps
softDeletes softDeletes
name string (50)
address string
city_id integer

location_sku

timestamps timestamps
location_id ^FK integer
sku_id ^FK integer
quantity integer

sku_images

id increments
timestamps timestamps
uri string
sku_id ^FK integer
is_cover tinyInteger

variant_names

id increments
timestamps timestamps
name string (30)

variant_values

id increments
timestamps timestamps
value string (30)
color_hex_value string (7)

variant_templates

id increments
timestamps timestamps
name string (30)

attribute_templates

id increments
timestamps timestamps
name string (30)

suppliers

id increments
timestamps timestamps
name string (50)
address string (100)
city_id integer

attribute_template_category

timestamps timestamps
attribute_template_id ^FK integer
product_type_id ^FK integer

transactions

id increments
timestamps timestamps
reason text
quantity integer
sku_id ^FK integer
location_id ^FK integer

product_attributes

id increments
timestamps timestamps
product_id ^FK integer
name string (30)
value string (30)

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