J
J
jazzus2018-12-22 06:52:51
Database design
jazzus, 2018-12-22 06:52:51

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

1 answer(s)
K
Konstantin Tsvetkov, 2018-12-22
@tsklab

DELETE FROM Users WHERE (type = 10)
And deal with the end.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question