I have a set of tables that defines the workflow. Say possible states are New, InProgress, Cancelled, Complete. I have a worfklow steps table that defines which new state the current state goes to using a user response such as approve, decline, cancel, complete.
My question is how would you turn this data into a flow chart graph, using basically any programming language.
WorkflowStatesTable
ID | Description
1 | New
2 | InProgress
3 | Complete
4 | Cancelled
WorkflowStepsTable
UniqueID | CurrentWorkflowState | Response | NewWorkflowState
1 1(New) "Work" 2(InProgress)
2 1(New) "Cancel" 4(Cancelled)
3 1(New) "Complete" 3(Complete)
4 2(InProgress) "Complete" 3(Complete
5 2(InProgress) "Cancel" 4(Cancel)