Author: sichen
Date: Tue Jan 23 11:35:28 2007
New Revision: 499107
URL:
http://svn.apache.org/viewvc?view=rev&rev=499107Log:
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>