Login  Register

Re: Users - Party Education and Work Experience Entities

Posted by Adrian Crum on Feb 20, 2006; 10:17pm
URL: http://ofbiz.116.s1.nabble.com/Users-Party-Education-and-Work-Experience-Entities-tp137491p137497.html

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