I'm building a relational database that holds 21 tables, which is connected to my website application through PHP.
The website has search functionality which allows users to search this database. Also, users can enter new data, through a special form. Because these entries must pass rigorous control by administrators, I want to make some kind of approval system, available only to the administrators, which can see user input before it appears in the search results, and allow it, return it to the user to make changes, or delete it.
My question is what would be an approach for this situation from a relational database design standpoint, and what is the best practice?
P.S. I know my question is probably wide, but I could not found an answer by searching the internet or other posts on this website.