What is the best way to store the non-linear movement of documents in the database?

Question

Database design

There are several roles/cabinets. There is an order, which, as it is processed, goes to one of the offices. At the same time, the routes can be different, from role 1 to 3, then again to 1, and then to 5. Or maybe 1-2-4-5. And it may be necessary to add new paths. Also, part of the roles can at any time look at any site. I see what options - either make the "status" field for the order and write in which office the next one. Or make columns where each role is registered and visibility is set for this cabinet. Those.

id  | кабинет 1 | кабинет 2
12 |    false      |   true

Answer 1

Look this way. Just take the idea. Actually you will need a state table.
Where the workflow instance is displayed, the documents it owns, and the states it must go through.
https://docs.microsoft.com/en-us/dotnet/framework/...
This is an implementation for PHP
https://github.com/phpmentors-jp/workflower