I’m trying to implement effective-dated product pricing with 2 related tables of Product and ProductPrices.
Any suggestion what is the best approach to create this representation in Cuba? If i create Product - ProductPrices as 1-To-Many composition, then how to control the price effective date is unique for a particular product?
Below is example of the 2 entity details.
- Item No
- Effective date