Hi , I am currently working on Book Management System in which I have a table which contains Books details in which PRIMARY KEY is book_id uuid. The requirement is to create DB in which we have to keep data of Updated values as well as which user update the particular book details and what they update.
For example:- id:- 1 Name: - Harry Poter Author : - JK Rolling New Update Done by user_id 2:- id :- 1 Name:- Harry Pottor Author:- J.K. Rolls So I need to update the details of Book which is done by UPSERT. But also I have to keep details like which user updated and what updated. I hope, I am able to describe my scenario in details. Please suggest on above scenario.