Hi,

I need to design a approval workflow for a blog.

I have 3 types of users. "Administrators", "Managers" and "Writers".

The "Managers" approve "Writers" posts and the "Administrator" approve the "Managers" decisions.

How can I design the database to handle this?

Best Regards,
André.

AdministratorApproval {Post, Administrator}
ManagerApproval {Post, Manager}
Post {Post, Writer}

If every post is to be approved by one manager and one admin then Post is the key of all three tables. If more than one manager/admin may approve a single post then make the key {Post, Manager}, {Post, Administrator} accordingly.

Thanks for your reply. I got it!

Best Regards,
André.