I think we can manage audit table while still having CREATED_BY,
CREATED_TIME,UPDATED_BY, UPDATED_TIME in same tables. So with that
approach we may never need to do table scan of audit table while fetching
updates. So each updates will recorded in separate table while original
table having all relevant information. WDYT?
Architecture mailing list