[OFBiz] SVN: r7718 - trunk/applications/content/entitydef

[jonesde@svn.ofbiz.org]

Author: jonesde
Date: 2006-05-30 23:37:29 -0500 (Tue, 30 May 2006)
New Revision: 7718

Modified:
   trunk/applications/content/entitydef/entitymodel.xml
Log:
Added OrderItem pointer fields, some fks to subscription entities

Modified: trunk/applications/content/entitydef/entitymodel.xml
===================================================================
--- trunk/applications/content/entitydef/entitymodel.xml	2006-05-31 00:19:54 UTC (rev 7717)
+++ trunk/applications/content/entitydef/entitymodel.xml	2006-05-31 04:37:29 UTC (rev 7718)
@@ -1079,6 +1079,8 @@
       <field name="roleTypeId" type="id"></field>
       <field name="partyNeedId" type="id"></field>
       <field name="needTypeId" type="id"></field>
+      <field name="orderId" type="id"></field>
+      <field name="orderItemSeqId" type="id"></field>
       <field name="productId" type="id"></field>
       <field name="productCategoryId" type="id"></field>
       <field name="subscriptionTypeId" type="id"></field>
@@ -1101,7 +1103,7 @@
       <relation type="one" fk-name="SUBSC_ROLE_TYPE" rel-entity-name="RoleType">
         <key-map field-name="roleTypeId"/>
       </relation>
-      <relation type="one" fk-name="SUBSC_PARTY_ROLE" rel-entity-name="PartyRole">
+      <relation type="one-nofk" rel-entity-name="PartyRole">
         <key-map field-name="partyId"/>
         <key-map field-name="roleTypeId"/>
       </relation>
@@ -1111,11 +1113,12 @@
       <relation type="one" fk-name="SUBSC_OROLE_TYPE" title="OriginatedFrom" rel-entity-name="RoleType">
         <key-map field-name="originatedFromRoleTypeId" rel-field-name="roleTypeId"/>
       </relation>
-      <relation type="one" fk-name="SUBSC_OPARTY_ROLE" title="OriginatedFrom" rel-entity-name="PartyRole">
+      <relation type="one-nofk" title="OriginatedFrom" rel-entity-name="PartyRole">
         <key-map field-name="originatedFromPartyId" rel-field-name="partyId"/>
         <key-map field-name="originatedFromRoleTypeId" rel-field-name="roleTypeId"/>
       </relation>
-      <relation type="one" fk-name="SUBSC_PARTY_NEED" rel-entity-name="PartyNeed">
+      <relation type="one-nofk" rel-entity-name="PartyNeed">
+        <description>No foreign key because we want to optionally be able to have a partyId without the other fields.</description>
         <key-map field-name="partyNeedId"/>
         <key-map field-name="partyId"/>
         <key-map field-name="roleTypeId"/>
@@ -1123,6 +1126,14 @@
       <relation type="one" fk-name="SUBSC_NEED_TYPE" rel-entity-name="NeedType">
         <key-map field-name="needTypeId"/>
       </relation>
+      <relation type="one-nofk" rel-entity-name="OrderHeader">
+        <description>Note that foreign key not needed because there is an fk for OrderItem.</description>
+        <key-map field-name="orderId"/>
+      </relation>
+      <relation type="one" fk-name="SUBSC_ORDERITM" rel-entity-name="OrderItem">
+        <key-map field-name="orderId"/>
+        <key-map field-name="orderItemSeqId"/>
+      </relation>
       <relation type="one" fk-name="SUBSC_PRODUCT" rel-entity-name="Product">
         <key-map field-name="productId"/>
       </relation>
@@ -1177,6 +1188,12 @@
         <relation type="one" fk-name="SUBSC_RES_PARENT" title="Parent" rel-entity-name="SubscriptionResource">
             <key-map field-name="parentResourceId" rel-field-name="subscriptionResourceId"/>
         </relation>
+        <relation type="one" fk-name="SUBSC_RES_CNTNT" rel-entity-name="Content">
+            <key-map field-name="contentId"/>
+        </relation>
+        <relation type="one" fk-name="SUBSC_RES_WBSITE" rel-entity-name="WebSite">
+            <key-map field-name="webSiteId"/>
+        </relation>
     </entity>
     <entity entity-name="SubscriptionType" package-name="org.ofbiz.content.subscription" title="Subscription Type Entity">
       <field name="subscriptionTypeId" type="id-ne"></field>