I'm breaking my head here to get a common denominator, I have a system in Delphi with PostgreSQL, this system has a budget session
I need to track the changes made in these budgets by putting version number, ie with each change requested by the customer the seller resending a new budget has to register in the system every change.
Example: Vendor sent 10 items, customer asked to leave only 9
So the first budget would be: 1.00, but the second 1.01
I'll need to control everything, everything, even a comma.
I was thinking of cloning the tables (6 tables) that are used in that budget and saving the records on them whenever there is a update , but I see that it will be very laborious to keep this mirroring. >
I ask colleagues if they have had a need for something similar and if they can contribute ideas, I work alone so I turned to you.