How to update the data already present on the site, only after moderation?

Question

PHP

Hello everyone, for the first time I'm asking a question, a big Google did not help: D I'm not used to using others, and I think that the results are the same.
There is a task:
The site has pages of users with information about their activities, dentists, cardiologists, etc.
It is possible to change this data.
And I would like that at first these changed data were visible only to the user, and when this user is satisfied with all the changes, he sends them to us for viewing, and we decide to update or not update what this user already has on the site.
In my opinion, you can’t do without two tables, shove everything into one and change the identifier the same way, it doesn’t look nice, it’s true. But I think if I make copies of the user table and all relational ones, then it’s also somehow too fancy, but more logical.
And hence the question to the experts. What is the best option to implement this using PHP, MySQL.

Answer 1

you can implement a revision mechanism.
one revision is currently active, when the data changes, a new revision is created with the status ala "requires moderation". Accordingly, its moderator can make it active.