Answer the question
In order to leave comments, you need to log in
What is the best database structure for user moderation?
What is the best way to organize the database structure for user moderation? In particular, I'm interested in - is it better to make a new table or write data to the Users table? Considering that only 10-20% of users will be moderated.
More: There is a Users
table . There is a type column . I need to do moderation for users with type == 10 . I'm thinking of making a new user_moderation
table with the following fields: id user_id (id of the moderated user) status (record the moderation as a number) comment (moderator's comment) moderator_id (moderator's id)
date of creation/updating of the record
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question