I want to design a database such that documents can be passed around. eg.
lets say there is a document by name Doc1, Users by names User1,user2, user3
and offices by name off1, off2.
User1 prepares Doc1 at office off1 then save it. After saving it hits user2 at off2
for approval. After user2 approves user3 also receives it at his office -off3. If there is any problem with the document recieved, it can be rejected to go back to the user who sent it.
Please how do I design tables to achieve this task? Thanks in advance