Hi Adrian,
I agree with your suggestion. To go further, this schema can be extended
to all EntityType since the problem that you have is also present to
manage RoleType, CustRequestType, ...
It resolve the problem : How to handle the same type in different context.
When I have finished my previous spot (yes the day will come) I'm
starting to give a hand to soften the pattern
Nicolas
Le 21/08/2011 10:56, Adrian Crum a écrit :
I know we have discussed this before, but I'm trying to use the OFBiz
party classification entities for another client and I'm running into
the same problem I've had before - the current party classification
data model just doesn't work.
The party classification data model presented in the The Data Model
Resource Book is simple and flexible. My preference would be to use
that model, but in previous discussions there was some resistance to
using the OFBiz PartyType entity in the way the book describes. So, I
have come up with a compromise solution: Use the OFBiz
PartyClassificationType entity as a replacement for the DMRB PartyType
entity, and implement the DMRB Party Classification subtypes by
grouping PartyClassificationTypes.
This is what it would look like:
PartyClassification
-------------------
partyId*, id-ne
partyClassificationTypeId*, id-ne
fromDate*, date-time
thruDate, date-time
PartyClassificationType
-----------------------
partyClassificationTypeId*, id-ne
description, description
PartyClassificationGroup
------------------------
partyClassificationTypeId*, id-ne
partyClassificationGroupTypeId*, id-ne
PartyClassificationGroupType
----------------------------
partyClassificationGroupTypeId*, id-ne
description, description
If the data currently stored in PartyClassificationType is moved to
PartyClassificationGroupType, then the proposed model will be capable
of supporting the party classification scheme illustrated in Table 2.3
of the DMRB.
What do you think?
-Adrian
--
Nicolas MALIN
Consultant
Tél : 06.17.66.40.06
Site projet : http://www.neogia.org/
-------
Société LibrenBerry
Tél : 02.48.02.56.12
Site : http://www.librenberry.net/
