Re: Users - Party Education and Work Experience Entities

Posted by David E. Jones on Feb 20, 2006; 10:24pm
URL: http://ofbiz.116.s1.nabble.com/Users-Party-Education-and-Work-Experience-Entities-tp137491p137499.html


The extensibility pattern is documented in the OFBiz documentation,  
namely in a document on the Docs & Books page of the ofbiz.org web site.

In general this is ONLY meant to be used when you DO NOT know what  
the fields will be in advance or when they vary too much for a more  
static field to work. It is really not meant to be used in this sort  
of circumstance where it is possible to define the structure and  
meaning of every field in advance.

-David


On Feb 20, 2006, at 3:17 PM, Si Chen wrote:

> Can you give an example of your "extensibility pattern"?
>
> Adrian Crum wrote:
>
>> I wouldn't add fields to PartyRelationship - I would add  
>> properties to the
>> parties via the "extensibility pattern." I firmly believe the  
>> existing data
>> model will support Vinay's requirements.
>>
>> Si Chen wrote:
>>
>>
>>
>>> Yes, Adrian, you are right.  I was just agreeing with Jeffrey  
>>> that maybe
>>> we don't need to track these institutions as parties.  Now  
>>> looking at it
>>> further, though, it seems that Vinay has pointed out a lot of fields
>>> which do not belong in other PartyRelationships, even if the  
>>> institution
>>> were a Party.  You can add all those fields to PartyRelationship  
>>> to be
>>> used only for education history, but my personal preference is to  
>>> keep
>>> stuff where they are intuitive.
>>>
>>> Si
>>>
>>> Adrian Crum wrote:
>>>
>>>
>>>
>>>
>>>> Vinay's suggestion includes an "instituteId" field - which I  
>>>> assume points to
>>>> information about an educational institution. That is no  
>>>> different than making
>>>> the institution a party, so why introduce an unnecessary entity?  
>>>> If Vinay's
>>>> "instituteId" can be accomodated by the Party entity, then why  
>>>> make a custom
>>>> entity to tie the two together? Just use PartyRelationship.
>>>>
>>>> It looks to me like the amount of data stored in Vinay's  
>>>> suggestion is no
>>>> different than the one I suggested.
>>>>
>>>>
>>>> Si Chen wrote:
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>> I agree with Jeffrey.  There is no need to create Party and
>>>>> PartyRelationship unless you are actively working with that  
>>>>> Party.  If
>>>>> an employee went to a certain high school at some point but  
>>>>> that's that,
>>>>> and you don't have any other activities with that high school, why
>>>>> create a Party for it?
>>>>>
>>>>> Si
>>>>>
>>>>> Blessing, Jeffrey J wrote:
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>> Wouldn't this mean that every possible college, university,  
>>>>>> school of
>>>>>> higher learning, etc. would potentially need to be entered as  
>>>>>> an entity
>>>>>> into the database just to model education?  This sounds like a  
>>>>>> lot of
>>>>>> work just to represent the fact that someone has a degree from
>>>>>> somewhere!
>>>>>>
>>>>>> -----Original Message-----
>>>>>> From: [hidden email]
>>>>>> [mailto:[hidden email]] On Behalf Of Adrian Crum
>>>>>> Sent: Monday, February 20, 2006 11:00 AM
>>>>>> To: OFBiz Users / Usage Discussion
>>>>>> Subject: Re: [OFBiz] Users - Party Education and Work Experience
>>>>>> Entities
>>>>>>
>>>>>> This seems to duplicate the PartyRelationship entity. I would  
>>>>>> recommend
>>>>>> making
>>>>>> the educational institution a party (or party group), create  
>>>>>> roles for
>>>>>> the
>>>>>> institution and student, then link them together using
>>>>>> PartyRelationship.
>>>>>>
>>>>>> You'll still need an entity or property to persist the degree.
>>>>>>
>>>>>>
>>>>>> Vinay Agarwal wrote:
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>> Hello,
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> I need party education and work experience entities to build  
>>>>>>> resume
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>> like
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>> structure for a party. The entities that I came up for them are
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>> detailed
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>> below.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> 1. Am doing it write?
>>>>>>> 2. Is it worth putting them back on OFBiz?
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> Regards,
>>>>>>>
>>>>>>> Vinay Agarwal
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> <entity entity-name="Education"
>>>>>>>
>>>>>>>                                package-
>>>>>>> name="org.ofbiz.grayzilla"
>>>>>>>
>>>>>>>                                title="Party Education Entity">
>>>>>>>
>>>>>>>                    <field name="partyId" type="id-ne"></field>
>>>>>>>
>>>>>>>                    <field name="instituteId"
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>> type="id-ne"></field>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>>                    <field name="degree" type="id-long"></field>
>>>>>>>
>>>>>>>                    <field name="studentId"
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>> type="id-long"></field>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>>                    <field name="fromDate"
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>> type="date-time"></field>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>>                    <field name="thruDate"
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>> type="date-time"></field>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>>                    <prim-key field="partyId"/>
>>>>>>>
>>>>>>>                    <prim-key field="instituteId"/>
>>>>>>>
>>>>>>>                    <prim-key field="fromDate"/>
>>>>>>>
>>>>>>>                    <relation type="one" fk-name="EDU_PRTY"
>>>>>>> rel-entity-name="Party">
>>>>>>>
>>>>>>>                                <key-map field-name="partyId"/>
>>>>>>>
>>>>>>>                    </relation>
>>>>>>>
>>>>>>>                    <relation type="one" fk-name="EDU_INST"
>>>>>>> rel-entity-name="Party">
>>>>>>>
>>>>>>>                                <key-map field-name="instituteId"
>>>>>>> rel-field-name="partyId"/>
>>>>>>>
>>>>>>>                    </relation>
>>>>>>>
>>>>>>> </entity>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> <entity entity-name="Experience"
>>>>>>>
>>>>>>>                                package-
>>>>>>> name="org.ofbiz.grayzilla"
>>>>>>>
>>>>>>>                                title="Party Experience Entity">
>>>>>>>
>>>>>>>                    <field name="partyId" type="id-ne"></field>
>>>>>>>
>>>>>>>                    <field name="companyId" type="id-ne"></field>
>>>>>>>
>>>>>>>                    <field name="titleLast"
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>> type="id-long"></field>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>>                    <field name="description"
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>> type="id-vlong"></field>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>>                    <field name="fromDate"
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>> type="date-time"></field>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>>                    <field name="thruDate"
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>> type="date-time"></field>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>>                    <prim-key field="partyId"/>
>>>>>>>
>>>>>>>                    <prim-key field="companyId"/>
>>>>>>>
>>>>>>>                    <prim-key field="fromDate"/>
>>>>>>>
>>>>>>>                    <relation type="one" fk-name="EXPER_PRTY"
>>>>>>> rel-entity-name="Party">
>>>>>>>
>>>>>>>                                <key-map field-name="partyId"/>
>>>>>>>
>>>>>>>                    </relation>
>>>>>>>
>>>>>>>                    <relation type="one" fk-name="EXPER_COMP"
>>>>>>> rel-entity-name="Party">
>>>>>>>
>>>>>>>                                <key-map field-name="companyId"
>>>>>>> rel-field-name="partyId"/>
>>>>>>>
>>>>>>>                    </relation>
>>>>>>>
>>>>>>> </entity>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>> -----------------------------------------------------------------
>>>>>> -------
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>> _______________________________________________
>>>>>>> Users mailing list
>>>>>>> [hidden email]
>>>>>>> http://lists.ofbiz.org/mailman/listinfo/users
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>> _______________________________________________
>>>>>> Users mailing list
>>>>>> [hidden email]
>>>>>> http://lists.ofbiz.org/mailman/listinfo/users
>>>>>>
>>>>>> _______________________________________________
>>>>>> Users mailing list
>>>>>> [hidden email]
>>>>>> http://lists.ofbiz.org/mailman/listinfo/users
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>> _______________________________________________
>>>>> Users mailing list
>>>>> [hidden email]
>>>>> http://lists.ofbiz.org/mailman/listinfo/users
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>> _______________________________________________
>>>> Users mailing list
>>>> [hidden email]
>>>> http://lists.ofbiz.org/mailman/listinfo/users
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>> _______________________________________________
>>> Users mailing list
>>> [hidden email]
>>> http://lists.ofbiz.org/mailman/listinfo/users
>>>
>>>
>>>
>>
>> _______________________________________________
>> Users mailing list
>> [hidden email]
>> http://lists.ofbiz.org/mailman/listinfo/users
>>
>>
>>
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users