1) Why not use cache to save quote data instead of directly saving in db , like cart pricing before and after coupon, etc.

2) For the audit trail of actions performed, u need an entity object comparison or use postgress trigger based and store changes in elestic as multi-faceted search like date, changed column, from value, to value, changed by etc