stock_management - Laravel Schema Designer

users

id increments
timestamps timestamps

warehouse

id increments
user_id ^FK integer
name string
address string
latitude string
longitude string
timestamps timestamps
softDeletes softDeletes

categories

id increments
category_name string
parent_id integer
status enum
timestamps timestamps

products

id increments
product_name string
description longText
category_id ^FK integer
subcategory_id ^FK integer
image string
status enum
timestamps timestamps
softDeletes softDeletes

warehouse_products

id increments
warehouse_id ^FK integer
product_id ^FK integer
product_variant_map_id ^FK integer
opening_stock bigInteger
in_stock bigInteger
stock_out bigInteger
status enum
timestamps timestamps
softDeletes softDeletes

variants

id increments
name string
timestamps timestamps

variant_values

id increments
variant_id ^FK integer
name string
value string
timestamps timestamps

units

id increments
name string
status enum
timestamps timestamps
softDeletes softDeletes

product_variants_map

id increments
product_id ^FK integer
product_sku string
variant_value_size_id integer
variant_value_color_id integer
manufacturing_cost float (8,2)
supplier_cost float (8,2)
track_quantity enum
unit_id ^FK integer
quantity string
status enum
timestamps timestamps
softDeletes softDeletes

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