In app i need to log every record change in table. If for example name of SKU is changed I have to store previous name so audit can review data changes over time. This have to be done on multiple tables.
I’m thinking of creating Product_audit table which is same as Product table. When some changes on record occurs I would create new record in audit table with previous record content - before update. I’m not sure if this is right way to do it.
So my general question is what is common practice to log record changes.