需求
“A small business inventory database with products, suppliers, warehouses, purchase orders, sales orders, and inventory movements, showing the keys that track stock.”
接著試試Add a stocktake tableAdd a reorder alert for low stock
這張圖裡有什麼
看懂背後的決策。
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.