its the routing(Entity) part(views) that i dont know how to go about, how to break it down.
how to make the routing path and Tracking from one person to another. As there suppose to be a routing guideline, internal and external routing path. I am thinking for example ,Lets say a document ,documentId 12345 , of documentType 789, have to go through these 5 person.
STOPS 1 -----------------------> 2 -------------------------> 3 --------------------------> 4 ------------------------> 5 Officer2 Officer3 Officer5 Officer1 Officer8
how do i go about making a view for that from the routing entity, how do i split it into tables.