svn commit: r1729198 - /ofbiz/trunk/applications/datamodel/entitydef/party-entitymodel.xml

Author: jleroux
Date: Mon Feb  8 16:00:51 2016
New Revision: 1729198

URL: http://svn.apache.org/viewvc?rev=1729198&view=rev
Log:
A patch from Pierre Smits for "Extend the PostalAddress entity with additional elements" https://issues.apache.org/jira/browse/OFBIZ-6882

Various modern day 3rd party delivery solutions (e.g. PostNL in The Netherlands) require that elements are delivered separately, so that addresses can be checked more easily.

Current definition of the PostalAddress doesn't have separation of:
* street name
* house number
* house number addition or extension

Modified:
    ofbiz/trunk/applications/datamodel/entitydef/party-entitymodel.xml

Modified: ofbiz/trunk/applications/datamodel/entitydef/party-entitymodel.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/datamodel/entitydef/party-entitymodel.xml?rev=1729198&r1=1729197&r2=1729198&view=diff
==============================================================================
--- ofbiz/trunk/applications/datamodel/entitydef/party-entitymodel.xml (original)
+++ ofbiz/trunk/applications/datamodel/entitydef/party-entitymodel.xml Mon Feb  8 16:00:51 2016
@@ -1186,13 +1186,17 @@ under the License.
       <field name="attnName" type="name"></field>
       <field name="address1" type="long-varchar"></field>
       <field name="address2" type="long-varchar"></field>
+      <field name="houseNumber" type="numeric"></field>
+      <field name="houseNumberExt" type="short-varchar"></field>
       <field name="directions" type="long-varchar"></field>
       <field name="city" type="name"></field>
+      <field name="cityGeoId" type="id"></field>
       <field name="postalCode" type="short-varchar"></field>
       <field name="postalCodeExt" type="short-varchar"></field>
       <field name="countryGeoId" type="id"></field>
       <field name="stateProvinceGeoId" type="id"></field>
       <field name="countyGeoId" type="id"></field>
+      <field name="municipalityGeoId" type="id"></field>
       <field name="postalCodeGeoId" type="id"></field>
       <field name="geoPointId" type="id"></field>
       <prim-key field="contactMechId"/>
@@ -1208,6 +1212,12 @@ under the License.
       <relation type="one" fk-name="POST_ADDR_CNTG" title="County" rel-entity-name="Geo">
         <key-map field-name="countyGeoId" rel-field-name="geoId"/>
       </relation>
+      <relation type="one" fk-name="POST_ADDR_MNCP" title="Municipality" rel-entity-name="Geo">
+        <key-map field-name="municipalityGeoId" rel-field-name="geoId"/>
+      </relation>
+      <relation type="one" fk-name="POST_ADDR_CITY" title="City" rel-entity-name="Geo">
+        <key-map field-name="cityGeoId" rel-field-name="geoId"/>
+      </relation>
       <relation type="one" fk-name="POST_ADDR_PCGEO" title="PostalCode" rel-entity-name="Geo">
         <key-map field-name="postalCodeGeoId" rel-field-name="geoId"/>
       </relation>