I have a data model that has Orders, Order Line Items, Products, and Product Prices. The attributes of Product Prices are ID, Start Date, End Date, Product ID, Unit Price. I want to generate data like this:
1, 1/1/2019, 10/30/2020, 33, $17,40
2, 10/31/2020, 12/31/3000, 33, $18.55
3, 4/5/2017, 12/31/2018, 47, $222.78
4, 1/1/2019, 4/15/2020, 47, $250.00
5, 4/16/2020, 12/31/3000, 47, $260.00
The record order does not matter. The important thing is that there are at least two price records for many products and those records cover every date from the date of product introduction until 12/31/3000.
Is there a way to do this in Mockaroo?