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
