svn commit: r1817347 - /ofbiz/ofbiz-framework/trunk/applications/datamodel/entitydef/product-entitymodel.xml

Author: jleroux
Date: Thu Dec  7 10:45:26 2017
New Revision: 1817347

URL: http://svn.apache.org/viewvc?rev=1817347&view=rev
Log:
Implemented: Create a new entity FacilityCalendar
(OFBIZ-10040)

Creates a new entity facilityCalendar which will create the one-to-many
relationship between facility and calendar. Here are the entity attributes:

*FacilityCalendar*
    * facilityId*
    * calendarId*
    * facilityCalendarTypeId*
    * fromDate*
    * thruDate

*FacilityCalendarType*
    * facilityCalendarTypeId*
    * parentTypeId
    * description


A calendar will be used to store opening time, closing time, working weekdays
and all this type of stuff.

For further information please refer
http://ofbiz.markmail.org/message/nectwaze6ina7y6z

Thanks: Vaibhav Jain for the initial proposition and all people who participated

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

Modified: ofbiz/ofbiz-framework/trunk/applications/datamodel/entitydef/product-entitymodel.xml
URL: http://svn.apache.org/viewvc/ofbiz/ofbiz-framework/trunk/applications/datamodel/entitydef/product-entitymodel.xml?rev=1817347&r1=1817346&r2=1817347&view=diff
==============================================================================
--- ofbiz/ofbiz-framework/trunk/applications/datamodel/entitydef/product-entitymodel.xml (original)
+++ ofbiz/ofbiz-framework/trunk/applications/datamodel/entitydef/product-entitymodel.xml Thu Dec  7 10:45:26 2017
@@ -1074,6 +1074,35 @@ under the License.
             <key-map field-name="attrName"/>
         </relation>
     </entity>
+
+    <entity entity-name="FacilityCalendar" package-name="org.apache.ofbiz.product.facility" title="Facility Calendar Entity">
+        <field name="facilityId" type="id"/>
+        <field name="calendarId" type="id"/>
+        <field name="facilityCalendarTypeId" type="id"/>
+        <field name="fromDate" type="date-time"/>
+        <field name="thruDate" type="date-time"/>
+        <prim-key field="facilityId"/>
+        <prim-key field="calendarId"/>
+        <prim-key field="facilityCalendarTypeId"/>
+        <prim-key field="fromDate"/>
+        <relation type="one" fk-name="FACILITY_CALENDAR_FAC" rel-entity-name="Facility">
+            <key-map field-name="facilityId"/>
+        </relation>
+        <relation type="many" fk-name="FACILITY_CALENDAR_CAL" rel-entity-name="TechDataCalendar">
+            <key-map field-name="calendarId"/>
+        </relation>
+        <relation type="one" fk-name="FACILITY_CALENDAR_TYPE" rel-entity-name="FacilityCalendarType">
+            <key-map field-name="facilityCalendarTypeId"/>
+        </relation>
+    </entity>
+
+    <entity entity-name="FacilityCalendarType" package-name="org.apache.ofbiz.product.facility" title="Facility Calendar Type Entity">
+        <field name="facilityCalendarTypeId" type="id"/>
+        <field name="parentTypeId" type="id"/>
+        <field name="description" type="description"/>
+        <prim-key field="facilityCalendarTypeId"/>
+    </entity>
+
     <entity entity-name="FacilityCarrierShipment" package-name="org.apache.ofbiz.product.facility" title="Facility Role Type Entity">
         <field name="facilityId" type="id"></field>
         <field name="partyId" type="id"></field>