Question

我有一份准入申请,我有一份雇员表。雇员是本组织若干不同层次的一部分。 org化有1个全球机制,5个部门负责人,每个部门负责人是几个主管,由这些主管担任。

根据雇员的地位,他们只能查阅其下属人员的记录。

我想以某种级别制度来代表本组织。我认为,问题在于,在同一个级别上有许多ppl(例如主管),但他们不能查阅另一个部门的主管记录。我如何处理这个问题?

Answer 1

在数据库中保存这种等级数据的一种共同办法,只使用一个表格,其中的领域有:

userId (primary key)
userName
supervisorId (self-referential "foreign key", refers to another userId in this same table)
positionCode (could be simple like 1=lakey, 2=supervisor; or a foreign key pointing to another table of positions and such)
...whatever else you need to store for each employee...

然后,您的问询用了KQ号,表示许可。如果告诉雇员,允许X级主管(例如,其用户为3人)见面,请询问所有雇员,监督Id=3。

如果你想要高档的船能够看看一看他们背后的人,那么最容易的是进行休养式搜查。 I.e. query for all those that reports to this Great bos, and for each of them query who reports to them, all the path.

这是否有意义? 您请该数据库通过所有用户进行分类,因为计算机在这类情况下是好的。

比如,如果你希望某些人获得不同的许可,我就这样说了立场。

或许我要让其他一些人试图更好地解释。

Here s an article from Microsoft s Access Cookbook that explains these queries rather well.
And here is a somewhat chunky explanation of the same.
Here s a completely different method (the "adjacency list model") that you might find useful, and his explanation is pretty good. He also points out some difficulties with both methods (when he talks about the tables being "denormalized").

友情链接