Approval Review

Question

I have a section on my site that needs to be edited by users / everyone. Since I want to approve everything first, I thought of doing it as SO for edited posts. Does anyone have any sources or good ideas on what the database should look like?

Current idea:

Divide the table in my database with each revision for an entry that has the approved BOOL flag. A new version that has approved=true will be shown as an entry.

Any better ideas?

Answer 1

PrimaryKey | PostID | TIMESTAMP | APPROVED

Your script will display the newest timestamp for the PostID, which is listed as APPROVED. You can have 1 table that contains the entire revision history other than TIMESTAMP.