Hi

Table will only will be used for audit purpose so we could fingerpoint or otherwise know who did what.

To undo unwanted changes we are already following data replication and data backup. So that is not much a issue.

We can't use bigint instead of varhar for primary field as not every table will have primary key as identity. Instead we have quite a lot of tables with primary key as varchar.

As per our biz policy one table could have only one column as primary key. If more than one column is required, then we have to divide that table into parts and then create a master table to map these sub tables