Our company has a project about Government Health. In this project, Client asked to audit any changes against more than 20 tables. So we created triggers (insert, update,delete) to every table.

Created two tables to save changes. one save who does what aginist which table and which object. another save the detailed changes.