Appian ACD201 Exam - Topic 1 Question 24 Discussion

Question

You're building an application with a review workflow.

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?

Lashandra · Accepted Answer

C) Three tables:
Review to store id, statusId, comment
Ref Status with columns id, value
Review User with columns id, reviewId, user

Lashandra · Answer

A) Two tables:
Review with columns id, statusId, comment, user
Ref Status with columns id, value

Lashandra · Answer

B) Two tables:
Review with columns id, statusId, comment, user1, user2, user3
Ref Status with columns id, value