Before doing it with triggers, I had a table that mirrored the main one. So whenever there was an update to any value, all of the data would be copied. If a col

Before doing it with triggers, I had a table that mirrored the main one. So whenever there was an update to any value, all of the data would be copied. If a column was changed in the main I would have to change it in the history table. Now I would change the trigger instead of that other table. Rows are never deleted from the database, a soft delete is used. When a user edits something the application does store that in the original table. How would you propose doing it differently?