요청 내용
“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.