I had a few responses to my request for advice posted on 10 April, for which it
is time that I registered my many thanks.
It seems that I am now well sorted with a solution, parts of which I was able
to test very quickly, and now it is time to build a project structure. The
Youtube offerings
If you are worried about the audit trigger and also an additional audit
table to hold all the rows , then you may get an additional flag added to
your base table deleted_flag and when delete happens, you just need to
update that flag through your code manually, but not physically delete the
record