Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2008
    Posts
    4

    How to design an approval worflow?

    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é.

  2. #2
    Join Date
    Dec 2007
    Location
    London, UK
    Posts
    741
    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.

  3. #3
    Join Date
    Oct 2008
    Posts
    4
    Thanks for your reply. I got it!

    Best Regards,
    André.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •