Hi All
New to DDD here and have a architecture question which should be a typical problem.
I have a StockItem entity and a Store entity. I assign a StockItem to multiple Stores and set different ParLevels for each store. I then need to have transactions (sale, purchase, transfer-in etc) that adjust the quantity on hand at the various store.
What is the preferred way to model this solution? In my DB I would have the following simplied table structure:
[StockItem]
StockItemID pk
Name
[Store]
StoreID pk
Name
[Store_StockItem]
StoreStockItemID pk
StoreID fk
StockItemID fk
ParlLevel
QuantityOnHand
[StockItemTransaction]
StockItemTransactionID pk
StockItemStoreID fk
StockItemTransactionTypeID fk
Quantity
Any advice greatly appreciated
|