Change in AgreementWorkEffortAppl entity

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Change in AgreementWorkEffortAppl entity

Bilgin Ibryam-2
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

Reply | Threaded
Open this post in threaded view
|

Re: Change in AgreementWorkEffortAppl entity

Jacopo Cappellato-4
+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
>

Reply | Threaded
Open this post in threaded view
|

Re: Change in AgreementWorkEffortAppl entity

Jacques Le Roux
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
>>
>

Reply | Threaded
Open this post in threaded view
|

Re: Change in AgreementWorkEffortAppl entity

Bilgin Ibryam-2
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
>
Done in r883140