如何在不同的办公室周围移动文档 [英] How do I move document around different offices

问题描述

我想设计一个数据库，以便传递文档。例如。





假设有一个名为Doc1的文档，用户名为User1，user2，user3

和办公室名称off1，off2。

User1在办公室off1准备Doc1然后保存。保存后，它会在off2

点击user2进行审批。在user2批准后，user3也在他的办公室-off3收到它。如果收到的文件有任何问题，可以拒绝回复发送文件的用户。

请问如何设计表来完成此任务？在此先感谢

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

推荐答案

您的数据库应存储文档当前所在的办公室ID。我也同意评论，你可能想查看现有的工作流程解决方案，看看是否有适合你的东西。

Your database should store the office id that the document is currently at. I also agree with the comment, you may want to look into existing workflow solutions to see if there is something that already works for you.

这篇关于如何在不同的办公室周围移动文档的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！