A solicitação
“A small business inventory database with products, suppliers, warehouses, purchase orders, sales orders, and inventory movements, showing the keys that track stock.”
Depois, tenteAdd a stocktake tableAdd a reorder alert for low stock
O que há neste desenho
Entenda as decisões por trás dele.
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.