You're building an application with a review workflow.

Appian ACD201 Question Answer

Each submission must be approved by three users who can each approve or reject their request, and leave a comment. This action changes the status of the submission to 'Approved' or 'Rejected' correspondingly, and pushes the review to the previous or next assignee.

Which data model captures the workflow requirements appropriately?

Two tables:

Review with columns id, statusId, comment, user

Ref Status with columns id, value

Two tables:

Review with columns id, statusId, comment, user1, user2, user3

Ref Status with columns id, value

Three tables:

Review to store id, statusId, comment

Ref Status with columns id, value

Review User with columns id, reviewId, user