요청 내용
“A retail store inventory database with products, categories, suppliers, purchase orders, sales, sale items, and inventory records, showing how stock is purchased and sold.”
그렇다면Add stock transfers between storesAdd a reorder level to each inventory record
이 도면에 담긴 내용
그 이면의 의사결정을 읽어 보세요.
01
Used an Inventory associative entity to store quantities per store-product pair
02
Linked PurchaseOrder to Store and Supplier directly
03
Separate PurchaseOrderItem table for order details
For any retail or warehouse management system requiring multi-store inventory tracking and procurement.