I would like to create a history table in my application, which should indicate when which user has done what.
For now, I have created an audit table and a trigger that enters the necessary data into this table after an UPDATE, DELETE or INSERT on the specific table.
In the history table, however, I want to log every process step and fill it with the information WHO did WHAT WHEN and display it. This table should be updated in the course of the process, so that one can see which steps have already been taken and by whom.
But now I am not sure how to create such a history table database-wise, because I want to log every process step executed by any user and display it in the history tab.
Should I create a trigger for this as well and a table for each process step (although that would probably be a bad database design). I'm not asking for any code here, just a hint if it's possible and in best case some keywords so I can search for the right things to implement it.
Thank you in advance!!