Hi all,
I have a question regarding AgreementWorkEffortAppl entity. I need to assign WorkEfforts to an Agreement instead of separate Agreement Items, but current data model doesn't allow that. The reason is in the relations of AgreementWorkEffortAppl entity: <relation type="one-nofk" rel-entity-name="Agreement"> <key-map field-name="agreementId"/> </relation> <relation type="one" fk-name="AGRMNT_WEA_AITM" rel-entity-name="AgreementItem"> <key-map field-name="agreementId"/> <key-map field-name="agreementItemSeqId"/> </relation> In my opinion the relation to Agreement entity should be "one" but not "one-nofk" and the relation to AgreementItem should be "one-nofk" instead of "one". This change would allow adding workefforts to the agreement w/o specifying an AgrementItem. Do you think that this change is right and acceptable in the project? (together with a service for data migration...) Bilgin Ibryam |
+1
On Nov 10, 2009, at 6:25 PM, Bilgin Ibryam wrote: > Hi all, > > I have a question regarding AgreementWorkEffortAppl entity. > I need to assign WorkEfforts to an Agreement instead of separate > Agreement Items, but current data model doesn't allow that. > The reason is in the relations of AgreementWorkEffortAppl entity: > > <relation type="one-nofk" rel-entity-name="Agreement"> > <key-map field-name="agreementId"/> > </relation> > <relation type="one" fk-name="AGRMNT_WEA_AITM" rel-entity- > name="AgreementItem"> > <key-map field-name="agreementId"/> > <key-map field-name="agreementItemSeqId"/> > </relation> > > > In my opinion the relation to Agreement entity should be "one" but > not "one-nofk" and the relation to AgreementItem should be "one- > nofk" instead of "one". This change would allow adding workefforts > to the agreement w/o specifying an AgrementItem. > > Do you think that this change is right and acceptable in the > project? (together with a service for data migration...) > > Bilgin Ibryam > |
Administrator
|
+1
Jacques From: "Jacopo Cappellato" <[hidden email]> > +1 > > On Nov 10, 2009, at 6:25 PM, Bilgin Ibryam wrote: > >> Hi all, >> >> I have a question regarding AgreementWorkEffortAppl entity. >> I need to assign WorkEfforts to an Agreement instead of separate >> Agreement Items, but current data model doesn't allow that. >> The reason is in the relations of AgreementWorkEffortAppl entity: >> >> <relation type="one-nofk" rel-entity-name="Agreement"> >> <key-map field-name="agreementId"/> >> </relation> >> <relation type="one" fk-name="AGRMNT_WEA_AITM" rel-entity- >> name="AgreementItem"> >> <key-map field-name="agreementId"/> >> <key-map field-name="agreementItemSeqId"/> >> </relation> >> >> >> In my opinion the relation to Agreement entity should be "one" but >> not "one-nofk" and the relation to AgreementItem should be "one- >> nofk" instead of "one". This change would allow adding workefforts >> to the agreement w/o specifying an AgrementItem. >> >> Do you think that this change is right and acceptable in the >> project? (together with a service for data migration...) >> >> Bilgin Ibryam >> > |
In reply to this post by Bilgin Ibryam-2
Bilgin Ibryam wrote:
> Hi all, > > I have a question regarding AgreementWorkEffortAppl entity. > I need to assign WorkEfforts to an Agreement instead of separate > Agreement Items, but current data model doesn't allow that. > The reason is in the relations of AgreementWorkEffortAppl entity: > > <relation type="one-nofk" rel-entity-name="Agreement"> > <key-map field-name="agreementId"/> > </relation> > <relation type="one" fk-name="AGRMNT_WEA_AITM" > rel-entity-name="AgreementItem"> > <key-map field-name="agreementId"/> > <key-map field-name="agreementItemSeqId"/> > </relation> > > > In my opinion the relation to Agreement entity should be "one" but not > "one-nofk" and the relation to AgreementItem should be "one-nofk" > instead of "one". This change would allow adding workefforts to the > agreement w/o specifying an AgrementItem. > > Do you think that this change is right and acceptable in the project? > (together with a service for data migration...) > > Bilgin Ibryam > |
Free forum by Nabble | Edit this page |