如何在Ofbiz中建立党际关系数据模型? [英] How to model party relationship data in ofbiz?

问题描述

我对ofbiz数据模型感到困惑.

I'm confused with the ofbiz data model.

PARTY RELATIONSHIP 是从一个 PARTY 到另一个 PARTY 的关系，对应于一对 PARTY ROLE

PARTY RELATIONSHIP is a relationship from one PARTY to a another PARTY corresponding to a pair of PARTY ROLEs.

实体 PARTY RELATIONSHIP 将具有 PARTY_ID_FROM ， PARTY_ID_TO ， ROLE_TYPE_ID_FROM ， ROLE_TYPE_ID_TO 和 PARTY_RELATIONSHIP_TYPE_ID (存储在 PARTY RELATIONSHIP TYPE 实体中)

Entity PARTY RELATIONSHIP will have PARTY_ID_FROM, PARTY_ID_TO, ROLE_TYPE_ID_FROM, ROLE_TYPE_ID_TO and PARTY_RELATIONSHIP_TYPE_ID which is stored in PARTY RELATIONSHIP TYPE entity.

但是在该实体中还存储了 ROLE_TYPE_ID_VALID_FROM 和 ROLE_TYPE_ID_VALID_TO .

But in that entity is also stored ROLE_TYPE_ID_VALID_FROM and ROLE_TYPE_ID_VALID_TO.

那里可能有重复的数据吗?

Could have duplicate data in there ?

PARTY_RELATIONSHIP_TYPE_ID 是 PARTY RELATIONSHIP 实体密钥的一部分吗?

And would PARTY_RELATIONSHIP_TYPE_ID be a part of the key to the PARTY RELATIONSHIP entity?

推荐答案

甲方关系只加入了另外两个实体:

A PARTY RELATIONSHIP joins only two other entities:

1)与两个角色类型相关联的派对关系类型":供应商是客户还是员工是部门.

1) A PARTY RELATIONSHIP TYPE which associates two ROLE TYPES: e.g. supplier to customer or employee to department.

2)参与关系角色的实际PARTIES: ABC COMPANY为供应商，Thang Nguyen为客户.

2) The actual PARTIES participating in the relationship ROLES: e.g. ABC COMPANY as supplier and Thang Nguyen as customer.

这些当事方以其各自的角色代表了PARTY ROLE实体.

These parties in their respective roles are what's represented by the PARTY ROLE entity.

此PARTY ROLE实体可以在表格中表示，在这种情况下，您将为关系中的每一方都拥有PARTY ROLE ID.或者，派对角色可能没有单独的表，只能在派对关系"表中实现，在这种情况下，如您所指定的，它将为关系中的每个派对都具有一个PARTY和ROLE TYPE ID.

This PARTY ROLE entity may be expressed in a table, in which case you would have PARTY ROLE ID's for each of the two parties in the relationship. Or the party role may not have a separate table and only be realized in the Party Relationship table, in which case it will have, as you specify, a PARTY and ROLE TYPE ID for each of the parties in the relationship.

在PARTY RELATIONSHIP实体中您将不会有重复的数据，因为FROM DATE是密钥的一部分，并且与两个PARTY ROLES组合在一起将是唯一的.

You won't have duplicate data in the PARTY RELATIONSHIP entity because FROM DATE is part of the key and would be unique in combination with the two PARTY ROLES.

从"和截止"日期用于该聚会关系，而不是聚会关系类型.

The from and to dates are for that party relationship, not party relationship type.

这篇关于如何在Ofbiz中建立党际关系数据模型?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！