You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ofbiz.apache.org by jl...@apache.org on 2016/02/08 17:00:52 UTC
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>