<!DOCTYPE weblogic-rdbms-jar PUBLIC 
 '-//BEA Systems, Inc.//DTD WebLogic 6.0.0 EJB RDBMS Persistence//EN'
 'http://www.bea.com/servers/wls600/dtd/weblogic-rdbms20-persistence-600.dtd'>

<weblogic-rdbms-jar>

<weblogic-rdbms-bean>
    <ejb-name>Salesman</ejb-name>
    <data-source-name>wapDB</data-source-name>
    <table-name>salesman</table-name>
    <field-map>
      <cmp-field>salesmanId</cmp-field>
      <dbms-column>id</dbms-column>
    </field-map>
    <field-map>
      <cmp-field>salesmanName</cmp-field>
      <dbms-column>name</dbms-column>
    </field-map>
    <field-map>
      <cmp-field>salesmanPassword</cmp-field>
      <dbms-column>password</dbms-column>
    </field-map>
  </weblogic-rdbms-bean>


  <weblogic-rdbms-bean>
    <ejb-name>Client</ejb-name>
    <data-source-name>wapDB</data-source-name>
    <table-name>client</table-name>
    <field-map>
      <cmp-field>clientId</cmp-field>
      <dbms-column>id</dbms-column>
    </field-map>
    <field-map>
      <cmp-field>clientName</cmp-field>
      <dbms-column>name</dbms-column>
    </field-map>
    <field-map>
      <cmp-field>clientAddress</cmp-field>
      <dbms-column>address</dbms-column>
    </field-map>
    <field-map>
      <cmp-field>salesman_Id</cmp-field>
      <dbms-column>salesman_id</dbms-column>
    </field-map>	
  </weblogic-rdbms-bean>

  <weblogic-rdbms-bean>
    <ejb-name>Item</ejb-name>
    <data-source-name>wapDB</data-source-name>
    <table-name>item</table-name>
    <field-map>
      <cmp-field>itemId</cmp-field>
      <dbms-column>id</dbms-column>
    </field-map>
    <field-map>
      <cmp-field>itemName</cmp-field>
      <dbms-column>name</dbms-column>
    </field-map>
    <field-map>
      <cmp-field>itemDescription</cmp-field>
      <dbms-column>description</dbms-column>
    </field-map>
  </weblogic-rdbms-bean>

    <weblogic-rdbms-bean>
    <ejb-name>Order</ejb-name>
    <data-source-name>wapDB</data-source-name>
    <table-name>order_info</table-name>
    <field-map>
      <cmp-field>orderId</cmp-field>
      <dbms-column>id</dbms-column>
    </field-map>
    <field-map>
      <cmp-field>orderQuantity</cmp-field>
      <dbms-column>quantity</dbms-column>
    </field-map>
    <field-map>
      <cmp-field>salesman_Id</cmp-field>
      <dbms-column>salesman_id</dbms-column>
    </field-map>
   <field-map>
     <cmp-field>client_Id</cmp-field>
     <dbms-column>client_id</dbms-column>
   </field-map>
   <field-map>
     <cmp-field>item_Id</cmp-field>
    <dbms-column>item_id</dbms-column>
   </field-map>
  <field-map>
     <cmp-field>orderTime</cmp-field>
    <dbms-column>order_time</dbms-column>
   </field-map>
  </weblogic-rdbms-bean>

</weblogic-rdbms-jar>