It will also depends on what you would be using the log entries for. What kind of queries? Retention period? If you will query most often on date range and also purge by date, then better log all in one table and partition by date.
You can log old and new records in json format in one column that way you don't need to worry about changing structure of underlying tables.
In the triggers which you use for auditing, you can transform rows to a json document.
You can have columns for tableName, Action (insert/update/delete), NewRecord (json), oldRecord (json), datetime
--
--
Best Regards
Sameer Kumar | DB Solution Architect
ASHNIK PTE. LTD.