I am building an app which aims to gather all possible data and keep track of all the changes that an user could make on it.
Therefore I created a system which automatically makes a row out of date and creates a new up to date row when a user changing any information in the app.
In fact, on the user’s point of view, he is editing the information, but from our point of view, this new information is going to be saved and considered up to date, while the old row is out of date.
The problem is that I cannot track this information by the key (generated with the UNIQUE ID) since it changes everytime I copy this row.
Is there any possibility of copying the same key in this case, to allows me to keep track of all the changes made?