I am currently creating a website which will allow people to buy consumer products (deodorant, shampoo, toothpastes, etc…) from a store. Those products tend to change price and other details twice per year or more. And I want to show past purchases’ prices and other details to the client. And I wanted to know what the best approach is. I’ve come up with the following approaches. Are they any good?
1st. Approach: I have a Product table, with the columns that tend to change, appended with the time of change as a suffix.
2nd Approach: In this one, I have the price and other details in a separate column.
But couldn't find them appropriate for my problem.