ilscipio/scipio-erp

<?xml version="1.0" encoding="UTF-8"?>
<!--
This file is subject to the terms and conditions defined in the
files 'LICENSE' and 'NOTICE', which are part of this source
code package.
-->

<entitymodel xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/entitymodel.xsd">
    <!-- ========================================================= -->
    <!-- ======================== Defaults ======================= -->
    <!-- ========================================================= -->
    <title>Entity of an Apache OFBiz Component</title>
    <description>None</description>
    <version>1.0</version>
    <!-- ========================================================= -->
    <!-- ======================== Data Model ===================== -->
    <!-- The modules in this file are as follows:                  -->
    <!--  - org.ofbiz.product.facility -->
    <!-- ========================================================= -->


    <!-- ========================================================= -->
    <!-- org.ofbiz.product.facility -->
    <!-- ========================================================= -->

    <entity entity-name="OldFacilityRole" table-name="FACILITY_ROLE"
            package-name="org.ofbiz.product.facility"
            title="Facility Role">
      <field name="facilityId" type="id-ne"></field>
      <field name="partyId" type="id-ne"></field>
      <field name="roleTypeId" type="id-ne"></field>
      <prim-key field="facilityId"/>
      <prim-key field="partyId"/>
      <prim-key field="roleTypeId"/>
      <relation type="one" fk-name="FACILITY_RLE_FAC" rel-entity-name="Facility">
        <key-map field-name="facilityId"/>
      </relation>
      <relation type="one" fk-name="FACILITY_RLE_PRTY" rel-entity-name="Party">
        <key-map field-name="partyId"/>
      </relation>
      <relation type="one-nofk" fk-name="FACILITY_RLE_ROLE"  rel-entity-name="RoleType">
        <key-map field-name="roleTypeId"/>
      </relation>
    </entity>
    <entity entity-name="OldProductKeyword" table-name="PRODUCT_KEYWORD"
            package-name="org.ofbiz.product.facility"
            title="Old Product Keyword">
      <field name="productId" type="id-ne"></field>
      <field name="keyword" type="short-varchar"></field>
      <field name="relevancyWeight" type="numeric"></field>
      <prim-key field="productId"/>
      <prim-key field="keyword"/>
      <relation type="one" fk-name="PROD_KWD_PROD" rel-entity-name="Product">
        <key-map field-name="productId"/>
      </relation>
      <index name="PROD_KWD_KWD">
        <index-field name="keyword"/>
      </index>
    </entity>
    <entity entity-name="OldProductKeywordResult" table-name="PRODUCT_KEYWORD_RESULT"
            package-name="org.ofbiz.product.product"
            never-cache="true"
            title="Product Keyword Result">
      <field name="productKeywordResultId" type="id-ne"></field>
      <field name="visitId" type="id"></field>
      <field name="productCategoryId" type="id"></field>
      <field name="searchString" type="short-varchar"></field>
      <field name="intraKeywordOperator" type="very-short"></field>
      <field name="anyPrefix" type="indicator"></field>
      <field name="anySuffix" type="indicator"></field>
      <field name="removeStems" type="indicator"></field>
      <field name="numResults" type="numeric"></field>
      <prim-key field="productKeywordResultId"/>
      <relation type="one-nofk" rel-entity-name="ProductCategory">
        <key-map field-name="productCategoryId"/>
      </relation>
    </entity>

</entitymodel>