we do have requirement of tracking insert,update and delete action of tables with tracking userid.
two approach is there.
1) creating single table with below fields:
Action tinyint (1= Insert,2=Update,3=Delete)
CreatedDate DateTime(Default will be current date)
2) Add below fields in all the tables:
transactionType Char(1) --this will have action like 'I','D' or 'U' for insert update and delete
which approach will be good for performance ?