How to change the required data?

Question

MySQL

Hello! I apologize for the stupid wording of the question! Couldn't think of a better one.
It's hard to describe the question, so I drew it) I hope you understand!
Briefly: To make a product, you need to perform a certain number of operations at a certain price.
Operations can change and prices for them too! And therefore, it is necessary to somehow remember this information for each ordered product, so that it would be possible to calculate the cost of wages, and so on.

So far, I see only one solution to store for each item in each transaction order. As if there are no problems, but for some time the number of lines will be simply huge!

I hope you got what I meant! What do you recommend?

Answer 1

You need to have a product table, an operation table, and a product-operation (1-*) link table, which will also contain the link version and the current price. In this case, the version of the current link will be recorded in the product table. When the link changes, it simply increases by 1 and the set of changed links is entered into the link table. For example, from your scheme there will be such bundles:
t - product, op - operation, v -
version v1.8r) If the price does not change
, then it is simply copied to the new version: back and calculate your cost.