ProductTables - Laravel Schema Designer

products

id bigIncrements
product string
description text
picture string (32)
timestamps timestamps
softDeletes softDeletes

types

id bigIncrements
type string
timestamps timestamps
softDeletes softDeletes

sizes

id bigIncrements
size string (64)
timestamps timestamps
softDeletes softDeletes

colors

id bigIncrements
color string (64)
hexadecimal string (6)
timestamps timestamps
softDeletes softDeletes

product_size

id bigIncrements
product_id ^FK bigInteger
size_id ^FK bigInteger
price double
timestamps timestamps
softDeletes softDeletes

color_product

id bigIncrements
product_id ^FK bigInteger
product_size_id ^FK bigInteger
color_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

product_pictures

id bigIncrements
product_id ^FK bigInteger
color_product_id ^FK bigInteger
picture_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

attribute_product

id bigIncrements
product_id ^FK bigInteger
attribute_id ^FK bigInteger
value string (64)
timestamps timestamps
softDeletes softDeletes

attributes

id bigIncrements
attribute string (64)
timestamps timestamps
softDeletes softDeletes

combos

id bigIncrements
combo string (64)
size_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

combo_items

id bigIncrements
combo_id ^FK bigInteger
product_id ^FK bigInteger
product_size_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

combo_Item_options

id bigIncrements
combo_item_id ^FK bigInteger
product_id ^FK bigInteger
product_size_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

menu_classifications

id bigIncrements
classification string (32)
timestamps timestamps
softDeletes softDeletes

menu_classification_products

id bigIncrements
classification_id ^FK bigInteger
product_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

trademarks

id bigIncrements
trademark string (64)
logo string
timestamps timestamps
softDeletes softDeletes

trademark_products

id bigIncrements
trademark_id ^FK bigInteger
product_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

ingredients

id bigIncrements
ingredient string (64)
measuring_unit_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

measuring_units

id bigIncrements
measuring_unit string (16)
timestamps timestamps
softDeletes softDeletes

product_size_ingredients

id bigIncrements
product_size_id ^FK bigInteger
ingredient_id ^FK bigInteger
value double
timestamps timestamps
softDeletes softDeletes

pictures

id bigIncrements
picture string
width integer
height integer
size integer
thumbnail string (64)
timestamps timestamps
softDeletes softDeletes

categories

id bigIncrements
category string (64)
description longText
picture_id bigInteger
timestamps timestamps
softDeletes softDeletes

category_product

id increments
product_id bigInteger
category_id bigInteger
timestamps timestamps
softDeletes softDeletes

codes

id bigIncrements
code string (128)
used boolean
timestamps timestamps
softDeletes softDeletes

code_product

id increments
product_id ^FK bigInteger
code_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

product_types

id increments
product_id ^FK bigInteger
type_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

inventory

id bigIncrements
inventory string (32)
central boolean
status boolean
timestamps timestamps
softDeletes softDeletes

branches

id bigIncrements
branch string (32)
status boolean
timestamps timestamps
softDeletes softDeletes

branch_inventory

id bigIncrements
inventory_id ^FK bigInteger
branch_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

branch_inventory_ingredients

id increments
branch_inventory_id ^FK bigInteger
ingredient_id ^FK bigInteger
value decimal
timestamps timestamps
softDeletes softDeletes

stocks

id bigIncrements
stock string (32)
central boolean
status boolean
timestamps timestamps
softDeletes softDeletes

branch_stock

id increments
stock_id ^FK bigInteger
branch_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

branch_stock_products

id increments
product_id ^FK bigInteger
size_id ^FK bigInteger
color_id ^FK bigInteger
quantity decimal
timestamps timestamps
softDeletes softDeletes

product_prices

id increments
product_id ^FK bigInteger
product_size_id ^FK bigInteger
color_product_id ^FK bigInteger
price double
timestamps timestamps
softDeletes softDeletes

branch_categories

id bigIncrements
branch_id ^FK bigInteger
category_id ^FK bigInteger
status boolean
timestamps timestamps
softDeletes softDeletes

branch_category_products

id increments
branch_category_id ^FK bigInteger
product_id ^FK bigInteger
status boolean
timestamps timestamps
softDeletes softDeletes

cashiers

id bigIncrements
branch_id ^FK bigInteger
name string (32)
code integer
password string
status boolean
activation_code string
timestamps timestamps
softDeletes softDeletes

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