svn commit: r499107 - /ofbiz/trunk/applications/content/entitydef/entitymodel.xml

[si...@apache.org]

Author: sichen
Date: Tue Jan 23 11:35:28 2007
New Revision: 499107

URL: http://svn.apache.org/viewvc?view=rev&rev=499107
Log:
comments for previous foreign key change to MimeType based on our mailing list discussions

Modified:
    ofbiz/trunk/applications/content/entitydef/entitymodel.xml

Modified: ofbiz/trunk/applications/content/entitydef/entitymodel.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/content/entitydef/entitymodel.xml?view=diff&rev=499107&r1=499106&r2=499107
==============================================================================
--- ofbiz/trunk/applications/content/entitydef/entitymodel.xml (original)
+++ ofbiz/trunk/applications/content/entitydef/entitymodel.xml Tue Jan 23 11:35:28 2007
@@ -114,6 +114,9 @@
       <relation type="one" fk-name="CONTENT_PRIVENM" title="Privilege" rel-entity-name="Enumeration">
         <key-map field-name="privilegeEnumId" rel-field-name="enumId"/>
       </relation>
+      <!-- the relationship to MimeType is one-nofk so that you can still do a lookup on MimeType but a new
+      and unexpected mime type would not cause a foreign key constraint violation, so MimeType can store the
+      most common mime types instead of an exhaustive list of all possible mime types --> 
       <relation type="one-nofk" rel-entity-name="MimeType">
         <key-map field-name="mimeTypeId"/>
       </relation>
@@ -757,6 +760,7 @@
       <relation type="one" fk-name="DATA_REC_DTSRC" rel-entity-name="DataSource">
         <key-map field-name="dataSourceId"/>
       </relation>
+      <!-- see comment above for Content.mimeTypeId --> 
       <relation type="one-nofk" rel-entity-name="MimeType">
         <key-map field-name="mimeTypeId"/>
       </relation>