I have a system where multiple users work. They CRUD Work Order which is a Master and Multiple Childs sort of form.
Now, we need to have a way to retrieve previous versions of a Work Order. So that whenever some one update any of the MASTER or CHILDs column/row, it first copy the EXISTING data to a update history table and then update the live DB.
At the moment - we are just populating an HTML template with the data and storing the whole HTML in the DB for earlier versions. But I want a better way to do this as in case we update our template etc, the earlier versions of the workword will remain in the old html in the database.
What is the best way to do this ? Please guide !
You could make it so that instead of editing the existing data, you can create new data with the date and time that it was created. That way each change is logged and you know when it was made. You could also have an auto-incrementing revision number to tell you which revision it is. You could even add a 'changed by who' to track who changed what when.