Database design for admin role

Question

I am desiging an app that have users who can write different posts(text, file image etc.). In order these posts to be made visible to the other users, there should be an admin who will validate that the content of the post is correct and will give permission for the publishing of the post. I am using relational database. What is the best way to design the database in order to support this feature?

You can have a status on a post (preliminary, approved), or you could have separate preliminary posts and approved posts tables. — Gilbert Le Blanc, May 14 '16 at 11:41
Or separate posts and approved posts tables, or separate posts and preliminary posts tables. — philipxy, May 15 '16 at 02:21

score 1 · Answer 1 · edited May 16 '16 at 12:46

1

You should create posts table having status_flag(value 0 and 1) column.
If some one posts it, keep status 0 by default. When Admin approves it, change status to 1.

So single table will suffice all your need, you don't need to create dependency on tables resulting into better performance.

edited May 16 '16 at 12:46

Mohsen Heydari

7,256
4
31
46

answered May 15 '16 at 06:12

Bavishi PN

379
2
6

score 0 · Answer 2 · answered May 16 '16 at 20:07

Like Mohsen said, having a status_flag column would work. I would also add a foreign key in the posts table, that references the Id of the moderator. That way, you can track who approved each post. Additionally, you may want a third column, a timestamp called date_approved for more tracking purposes.

Database design for admin role

2 Answers2