The request
“A small business inventory database with products, suppliers, warehouses, purchase orders, sales orders, and inventory movements, showing the keys that track stock.”
Then tryAdd a stocktake tableAdd a reorder alert for low stock
What is in this drawing
Read the decisions behind it.
01
Separated Product, Category, and Inventory to normalize stock tracking per warehouse
02
Used PurchaseOrder and PurchaseOrderLine to model many-to-many relationship between orders and products
03
Included reorder level in Inventory to support automatic reorder triggers
Suitable for any small-to-medium retail or wholesale business that needs to manage inventory across locations, track suppliers, and monitor purchase orders.
More like this