advanced product - Laravel Schema Designer

products

id increments
category_id ^FK integer
name_az string
name_ru string
timestamps timestamps
softDeletes softDeletes
price decimal

features

id increments
name_az string (100)
name_ru string (100)
unit_group_id ^FK integer

attributes

id increments
attribute_group_id ^FK integer
name_az string
color string (15)
name_ru string

categories

id increments
parent_id ^FK integer
name_az string
name_ru string

units

id increments
name_az string (10)
name_ru string (10)
unit_group_id ^FK integer
base_ratio float

quantities

id increments
product_id ^FK integer
attribute_id ^FK integer
value decimal

products_features

id increments
product_id ^FK integer
feature_id ^FK integer
unit_id ^FK integer
value string

photos

id increments
product_id ^FK integer
attribute_id ^FK integer
title_az string
title_ru string
filename string
timestamps timestamps

products_attributes

id increments
product_id ^FK integer
attribute_id ^FK integer
price_impact decimal (8,2)
price_total decimal

unit_groups

id increments
name string
base_unit_id ^FK integer

attribute_groups

id increments
global_name string (20)
name_az string (20)
name_ru string (20)
is_color_group boolean

stock_movements

id increments
quantity_id ^FK integer
change integer
reason_id ^FK integer
timestamps timestamps

stock_movement_reasons

id increments
value string (100)

categories_features

id increments
timestamps timestamps
category_id ^FK integer
feature_id ^FK integer

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