Hi team,
We are looking to build in some audit/history capabilities within our app.
For instance the user can log in and see a history of changes that have been made to a piece of information relating to them. Another example is showing a history of an item moving through an approval process.
Can you suggest how it might be best to set up tables to do this?
Thank you!
Sophie
The description is too broad.
I cannot advise without knowing the structure of your data, and a description of desired result.
In general your case doesn’t sound like something complex, but it can only be so at a first glance.
You may separate the historical data by categories, e.g. if the amount is huge, or you may put it in one table with the marker columns.
For approving you may use Business Logic and deploy a peace of code which will make a decision according to some conditions.
Also we have UserService which simplify the work with users’ authentication.