与mysql中的递归一对多关系需要至少4个表? [英] Does a many-to-many relationship with a recursive one-to-many in mysql require at least 4 tables?
问题描述
我有以下关系(业务规则):
I have the following relationships (Business rules):
- User_Company :多对多每个用户有多个公司,每个公司有多个用户)
- 所有权:一对一(对于关系表中的每个条目,它指定用户是否为所有者或雇员,如果所有者的百分比必须在那里)
- Company_ownership :一对一的公司(递归关系),因为另一家公司也可以一个公司的所有者,必须给出百分比。
- User_Company : Many-to-many (multiple companies per user, multiple users per company)
- Ownership : One-to-One (For each entry in relationship table, it specifies whether user is an owner or employee. If owner then a percentage must be there)
- Company_ownership : One-to-many for company (Recursive relationship), as another company can also be an owner in a company, percentage must be given.
所以所有权或公司可以由多个公司和用户。
所以我开发了以下内容:
So I have developed the following:
那么还有必须至少4个表可以用于这种关系,也可以简化。
我觉得这是相当复杂的,对于另一个开发人员来说不是直观的?如何优化和优雅地排列?
So does there have to be at least 4 tables for this sort of relationship or can it be simplified. I feel it is quite complicated and would not be intuitive for another developer? How could it be optimized and elegantly arranged?
推荐答案
我认为所有权和就业是不同的概念,更建议有他们分开。
想想约翰谁是 A
公司的所有者之一,同时他也是 A
。
公司和人员可以有一个基础来减少实体的冗余。
I think ownership and employment are different concepts, that would be more advised to have them separated.
Think about John who is one of the owners of A
company and in the mean time he is the CTO of A
.
Company and People can have a base to reduce redundancy of entities.
这篇关于与mysql中的递归一对多关系需要至少4个表?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!