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
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