Login  Register

Re: Users - Party Education and Work Experience Entities

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

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