0
Hello,
well, at first I have a table called projects. And I need to create versions of the data contained in it, because as THE DATA OF THIS TABLE goes through corrections, I need to show them to whoever is correcting... What would be the best way to manage the versions of the data contained in it?
For example, in the title I have a certain datum:
Version 1: This is a title I want to see
Now after a change:
Version 1: This is a title I want to see
Version 2: This is a title I want to Versionar, which is in the second version
That is, I want to keep both versions and show them to the user... Would it be necessary for me to create another table for that? Wouldn’t it be an unnecessary waste of memory space for that?
Att. Thankful.
wouldn’t it be better if you had backups routines?
– André Martins
Could put a new field in the table with the name "father" being integer. In this field, you can refer to the original ID with the data from the previous version. Thus, the first record (e.g., ID 56) if the "parent" field is reset, it is the original record. When copying the data to a new record, you place the previous one’s ID in the "parent" field. Example: data copied to ID 98, in the "parent" field would be ID 56, which stores where the data came from. So you can work this "integration" in the same table, just creating a new field
– Rodrigo Tognin