开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > 电子政务应用 > 查看源码
ack.ejbgrpx
资源名称：shiponline.rar　[点击查看]
上传用户：jnhyscl
上传日期：2010-03-08
资源大小：345k
文件大小：144k
源码类别：

电子政务应用

开发平台：

Java

ack.ejbgrpx：源码内容
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <descriptors>
  3.   <ejb-jar.xml extralocation="" timestamp="1064578559814"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
  4. <!DOCTYPE ejb-jar PUBLIC "-//Sun Microsystems, Inc.//DTD Enterprise JavaBeans 2.0//EN" "http://java.sun.com/dtd/ejb-jar_2_0.dtd">
  5. <ejb-jar>
  6.     <enterprise-beans>
  7.         <entity>
  8.             <display-name>EsiteUserShoppingCart</display-name>
  9.             <ejb-name>EsiteUserShoppingCart</ejb-name>
  10.             <local-home>shiponline.EsiteUserShoppingCartHome</local-home>
  11.             <local>shiponline.EsiteUserShoppingCart</local>
  12.             <ejb-class>shiponline.EsiteUserShoppingCartBean</ejb-class>
  13.             <persistence-type>Container</persistence-type>
  14.             <prim-key-class>shiponline.EsiteUserShoppingCartPK</prim-key-class>
  15.             <reentrant>False</reentrant>
  16.             <cmp-version>2.x</cmp-version>
  17.             <abstract-schema-name>EsiteUserShoppingCart</abstract-schema-name>
  18.             <cmp-field>
  19.                 <field-name>user</field-name>
  20.             </cmp-field>
  21.             <cmp-field>
  22.                 <field-name>shoppingCartUserid</field-name>
  23.             </cmp-field>
  24.             <cmp-field>
  25.                 <field-name>shoppingCartInventoryid</field-name>
  26.             </cmp-field>
  27.         </entity>
  28.         <entity>
  29.             <display-name>VaoVslcargo</display-name>
  30.             <ejb-name>VaoVslcargo</ejb-name>
  31.             <local-home>shiponline.VaoVslcargoHome</local-home>
  32.             <local>shiponline.VaoVslcargo</local>
  33.             <ejb-class>shiponline.VaoVslcargoBean</ejb-class>
  34.             <persistence-type>Container</persistence-type>
  35.             <prim-key-class>java.lang.Integer</prim-key-class>
  36.             <reentrant>False</reentrant>
  37.             <cmp-version>2.x</cmp-version>
  38.             <abstract-schema-name>VaoVslcargo</abstract-schema-name>
  39.             <cmp-field>
  40.                 <field-name>vaoVslcargoId</field-name>
  41.             </cmp-field>
  42.             <cmp-field>
  43.                 <field-name>vaoVslentrustId</field-name>
  44.             </cmp-field>
  45.             <cmp-field>
  46.                 <field-name>loadordischarge</field-name>
  47.             </cmp-field>
  48.             <cmp-field>
  49.                 <field-name>cargotypecode</field-name>
  50.             </cmp-field>
  51.             <cmp-field>
  52.                 <field-name>cargotypename</field-name>
  53.             </cmp-field>
  54.             <cmp-field>
  55.                 <field-name>cargoeabbr</field-name>
  56.             </cmp-field>
  57.             <cmp-field>
  58.                 <field-name>cargocabbr</field-name>
  59.             </cmp-field>
  60.             <cmp-field>
  61.                 <field-name>ifdangerous</field-name>
  62.             </cmp-field>
  63.             <cmp-field>
  64.                 <field-name>cargostatus</field-name>
  65.             </cmp-field>
  66.             <cmp-field>
  67.                 <field-name>cargoweight</field-name>
  68.             </cmp-field>
  69.             <cmp-field>
  70.                 <field-name>weightunit</field-name>
  71.             </cmp-field>
  72.             <cmp-field>
  73.                 <field-name>cargomeasure</field-name>
  74.             </cmp-field>
  75.             <cmp-field>
  76.                 <field-name>measureunit</field-name>
  77.             </cmp-field>
  78.             <cmp-field>
  79.                 <field-name>numofpkgs</field-name>
  80.             </cmp-field>
  81.             <cmp-field>
  82.                 <field-name>typeofpkgs</field-name>
  83.             </cmp-field>
  84.             <cmp-field>
  85.                 <field-name>deliveryitem</field-name>
  86.             </cmp-field>
  87.             <cmp-field>
  88.                 <field-name>branchcode</field-name>
  89.             </cmp-field>
  90.             <cmp-field>
  91.                 <field-name>branchname</field-name>
  92.             </cmp-field>
  93.             <primkey-field>vaoVslcargoId</primkey-field>
  94.         </entity>
  95.     </enterprise-beans>
  96.     <assembly-descriptor>
  97.         <container-transaction>
  98.             <method>
  99.                 <ejb-name>EsiteUserShoppingCart</ejb-name>
  100.                 <method-name>*</method-name>
  101.             </method>
  102.             <trans-attribute>Required</trans-attribute>
  103.         </container-transaction>
  104.         <container-transaction>
  105.             <method>
  106.                 <ejb-name>VaoVslcargo</ejb-name>
  107.                 <method-name>*</method-name>
  108.             </method>
  109.             <trans-attribute>Required</trans-attribute>
  110.         </container-transaction>
  111.     </assembly-descriptor>
  112. </ejb-jar>]]></ejb-jar.xml>
  113.   <sybase-easerver-config.xml extralocation="" timestamp="1064576913107"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
  114. <!DOCTYPE sybase-easerver-config SYSTEM "http://download.sybase.com/specifications/xsd/sybase-easerver-config_1_0.dtd">
  115. <sybase-easerver-config>
  116.   <configure type="update" entity="Component:ack/EsiteUserShoppingCart">
  117.     <property name="com.sybase.jaguar.component.bind.naming" value="EsiteUserShoppingCart" />
  118.     <property name="com.sybase.jaguar.component.storage" value="CtsComponents/JdbcStorage(cache=shiponline,table=map:&quot;esite_user_shoppingCart&quot;)" />
  119.     <property name="mapField:user" value="user" />
  120.     <property name="mapField:shoppingCartUserid" value="shoppingCart_userid" />
  121.     <property name="mapField:shoppingCartInventoryid" value="shoppingCart_inventoryid" />
  122.   </configure>
  123.   <configure type="update" entity="Component:ack/VaoVslcargo">
  124.     <property name="com.sybase.jaguar.component.bind.naming" value="VaoVslcargo" />
  125.     <property name="com.sybase.jaguar.component.storage" value="CtsComponents/JdbcStorage(cache=shiponline,table=map:&quot;VAO_VSLCARGO&quot;)" />
  126.     <property name="mapField:vaoVslcargoId" value="VAO_VSLCARGO_ID" />
  127.     <property name="mapField:vaoVslentrustId" value="VAO_VSLENTRUST_ID" />
  128.     <property name="mapField:loadordischarge" value="LOADORDISCHARGE" />
  129.     <property name="mapField:cargotypecode" value="CARGOTYPECODE" />
  130.     <property name="mapField:cargotypename" value="CARGOTYPENAME" />
  131.     <property name="mapField:cargoeabbr" value="CARGOEABBR" />
  132.     <property name="mapField:cargocabbr" value="CARGOCABBR" />
  133.     <property name="mapField:ifdangerous" value="IFDANGEROUS" />
  134.     <property name="mapField:cargostatus" value="CARGOSTATUS" />
  135.     <property name="mapField:cargoweight" value="CARGOWEIGHT" />
  136.     <property name="mapField:weightunit" value="WEIGHTUNIT" />
  137.     <property name="mapField:cargomeasure" value="CARGOMEASURE" />
  138.     <property name="mapField:measureunit" value="MEASUREUNIT" />
  139.     <property name="mapField:numofpkgs" value="NUMOFPKGS" />
  140.     <property name="mapField:typeofpkgs" value="TYPEOFPKGS" />
  141.     <property name="mapField:deliveryitem" value="DELIVERYITEM" />
  142.     <property name="mapField:branchcode" value="BRANCHCODE" />
  143.     <property name="mapField:branchname" value="BRANCHNAME" />
  144.   </configure>
  145. </sybase-easerver-config>
  146. ]]></sybase-easerver-config.xml>
  147.   <ejb-borland.xml extralocation="" timestamp="1064578559814"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
  148. <!DOCTYPE ejb-jar PUBLIC "-//Borland Software Corporation//DTD Enterprise JavaBeans 2.0//EN" "http://www.borland.com/devsupport/appserver/dtds/ejb-jar_2_0-borland.dtd">
  149. <ejb-jar>
  150.     <enterprise-beans>
  151.         <entity>
  152.             <ejb-name>EsiteUserShoppingCart</ejb-name>
  153.             <bean-local-home-name>EsiteUserShoppingCart</bean-local-home-name>
  154.             <cmp2-info>
  155.                 <cmp-field>
  156.                     <field-name>user</field-name>
  157.                     <column-name>user</column-name>
  158.                 </cmp-field>
  159.                 <cmp-field>
  160.                     <field-name>shoppingCartUserid</field-name>
  161.                     <column-name>shoppingCart_userid</column-name>
  162.                 </cmp-field>
  163.                 <cmp-field>
  164.                     <field-name>shoppingCartInventoryid</field-name>
  165.                     <column-name>shoppingCart_inventoryid</column-name>
  166.                 </cmp-field>
  167.                 <table-name>esite_user_shoppingCart</table-name>
  168.             </cmp2-info>
  169.             <property>
  170.                 <prop-name>ejb-designer-id</prop-name>
  171.                 <prop-type>String</prop-type>
  172.                 <prop-value>EsiteUserShoppingCart</prop-value>
  173.             </property>
  174.         </entity>
  175.         <entity>
  176.             <ejb-name>VaoVslcargo</ejb-name>
  177.             <bean-local-home-name>VaoVslcargo</bean-local-home-name>
  178.             <cmp2-info>
  179.                 <cmp-field>
  180.                     <field-name>vaoVslcargoId</field-name>
  181.                     <column-name>VAO_VSLCARGO_ID</column-name>
  182.                 </cmp-field>
  183.                 <cmp-field>
  184.                     <field-name>vaoVslentrustId</field-name>
  185.                     <column-name>VAO_VSLENTRUST_ID</column-name>
  186.                 </cmp-field>
  187.                 <cmp-field>
  188.                     <field-name>loadordischarge</field-name>
  189.                     <column-name>LOADORDISCHARGE</column-name>
  190.                 </cmp-field>
  191.                 <cmp-field>
  192.                     <field-name>cargotypecode</field-name>
  193.                     <column-name>CARGOTYPECODE</column-name>
  194.                 </cmp-field>
  195.                 <cmp-field>
  196.                     <field-name>cargotypename</field-name>
  197.                     <column-name>CARGOTYPENAME</column-name>
  198.                 </cmp-field>
  199.                 <cmp-field>
  200.                     <field-name>cargoeabbr</field-name>
  201.                     <column-name>CARGOEABBR</column-name>
  202.                 </cmp-field>
  203.                 <cmp-field>
  204.                     <field-name>cargocabbr</field-name>
  205.                     <column-name>CARGOCABBR</column-name>
  206.                 </cmp-field>
  207.                 <cmp-field>
  208.                     <field-name>ifdangerous</field-name>
  209.                     <column-name>IFDANGEROUS</column-name>
  210.                 </cmp-field>
  211.                 <cmp-field>
  212.                     <field-name>cargostatus</field-name>
  213.                     <column-name>CARGOSTATUS</column-name>
  214.                 </cmp-field>
  215.                 <cmp-field>
  216.                     <field-name>cargoweight</field-name>
  217.                     <column-name>CARGOWEIGHT</column-name>
  218.                 </cmp-field>
  219.                 <cmp-field>
  220.                     <field-name>weightunit</field-name>
  221.                     <column-name>WEIGHTUNIT</column-name>
  222.                 </cmp-field>
  223.                 <cmp-field>
  224.                     <field-name>cargomeasure</field-name>
  225.                     <column-name>CARGOMEASURE</column-name>
  226.                 </cmp-field>
  227.                 <cmp-field>
  228.                     <field-name>measureunit</field-name>
  229.                     <column-name>MEASUREUNIT</column-name>
  230.                 </cmp-field>
  231.                 <cmp-field>
  232.                     <field-name>numofpkgs</field-name>
  233.                     <column-name>NUMOFPKGS</column-name>
  234.                 </cmp-field>
  235.                 <cmp-field>
  236.                     <field-name>typeofpkgs</field-name>
  237.                     <column-name>TYPEOFPKGS</column-name>
  238.                 </cmp-field>
  239.                 <cmp-field>
  240.                     <field-name>deliveryitem</field-name>
  241.                     <column-name>DELIVERYITEM</column-name>
  242.                 </cmp-field>
  243.                 <cmp-field>
  244.                     <field-name>branchcode</field-name>
  245.                     <column-name>BRANCHCODE</column-name>
  246.                 </cmp-field>
  247.                 <cmp-field>
  248.                     <field-name>branchname</field-name>
  249.                     <column-name>BRANCHNAME</column-name>
  250.                 </cmp-field>
  251.                 <table-name>VAO_VSLCARGO</table-name>
  252.             </cmp2-info>
  253.             <property>
  254.                 <prop-name>ejb-designer-id</prop-name>
  255.                 <prop-type>String</prop-type>
  256.                 <prop-value>VaoVslcargo</prop-value>
  257.             </property>
  258.         </entity>
  259.     </enterprise-beans>
  260.     <table-properties>
  261.         <table-name>esite_user_shoppingCart</table-name>
  262.         <column-properties>
  263.             <column-name>user</column-name>
  264.         </column-properties>
  265.         <column-properties>
  266.             <column-name>shoppingCart_userid</column-name>
  267.         </column-properties>
  268.         <column-properties>
  269.             <column-name>shoppingCart_inventoryid</column-name>
  270.         </column-properties>
  271.         <property>
  272.             <prop-name>datasource</prop-name>
  273.             <prop-type>String</prop-type>
  274.             <prop-value>serial://datasources/shiponline</prop-value>
  275.         </property>
  276.     </table-properties>
  277.     <table-properties>
  278.         <table-name>VAO_VSLCARGO</table-name>
  279.         <column-properties>
  280.             <column-name>VAO_VSLCARGO_ID</column-name>
  281.         </column-properties>
  282.         <column-properties>
  283.             <column-name>VAO_VSLENTRUST_ID</column-name>
  284.         </column-properties>
  285.         <column-properties>
  286.             <column-name>LOADORDISCHARGE</column-name>
  287.         </column-properties>
  288.         <column-properties>
  289.             <column-name>CARGOTYPECODE</column-name>
  290.         </column-properties>
  291.         <column-properties>
  292.             <column-name>CARGOTYPENAME</column-name>
  293.         </column-properties>
  294.         <column-properties>
  295.             <column-name>CARGOEABBR</column-name>
  296.         </column-properties>
  297.         <column-properties>
  298.             <column-name>CARGOCABBR</column-name>
  299.         </column-properties>
  300.         <column-properties>
  301.             <column-name>IFDANGEROUS</column-name>
  302.         </column-properties>
  303.         <column-properties>
  304.             <column-name>CARGOSTATUS</column-name>
  305.         </column-properties>
  306.         <column-properties>
  307.             <column-name>CARGOWEIGHT</column-name>
  308.         </column-properties>
  309.         <column-properties>
  310.             <column-name>WEIGHTUNIT</column-name>
  311.         </column-properties>
  312.         <column-properties>
  313.             <column-name>CARGOMEASURE</column-name>
  314.         </column-properties>
  315.         <column-properties>
  316.             <column-name>MEASUREUNIT</column-name>
  317.         </column-properties>
  318.         <column-properties>
  319.             <column-name>NUMOFPKGS</column-name>
  320.         </column-properties>
  321.         <column-properties>
  322.             <column-name>TYPEOFPKGS</column-name>
  323.         </column-properties>
  324.         <column-properties>
  325.             <column-name>DELIVERYITEM</column-name>
  326.         </column-properties>
  327.         <column-properties>
  328.             <column-name>BRANCHCODE</column-name>
  329.         </column-properties>
  330.         <column-properties>
  331.             <column-name>BRANCHNAME</column-name>
  332.         </column-properties>
  333.         <property>
  334.             <prop-name>datasource</prop-name>
  335.             <prop-type>String</prop-type>
  336.             <prop-value>serial://datasources/shiponline</prop-value>
  337.         </property>
  338.     </table-properties>
  339.     <assembly-descriptor />
  340. </ejb-jar>]]></ejb-borland.xml>
  341.   <ejb-modeler-schema.xml extralocation="" timestamp="1064577313333"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
  342. <schema-root-node name="DataSources" node-type="0" status="0">
  343.   <schema-connection-node name="shiponline" node-type="4" status="0" catalog="null-object" connection-type="1" data-source-name="shiponline" driver="com.sybase.jdbc.SybDriver" file="null-object" password="" sql-schema="null-object" url="jdbc:sybase:Tds:fanhua02:5000/shiponline" use-data-source="true" username="sa" all-schemas="true" all-views="true">
  344.     <schema-table-node name="INVENTORY" node-type="1" status="0" catalog="null-object" ref="false null com.sybase.jdbc.SybDriver jdbc:sybase:Tds:fanhua02:5000/shiponline" sql-schema="null-object">
  345.       <schema-column-node name="ID" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="1" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="true" />
  346.       <schema-column-node name="AUTHOR" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="2" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  347.       <schema-column-node name="BOOKTITLE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="3" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  348.       <schema-column-node name="PRICE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="8" ordinal="4" precision="-1" scale="-1" vendor-type-name="double precis" is-primary-key="false" />
  349.       <schema-column-node name="INSTOCK" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="5" ordinal="5" precision="-1" scale="-1" vendor-type-name="smallint" is-primary-key="false" />
  350.     </schema-table-node>
  351.     <schema-table-node name="ORDERITEM" node-type="1" status="0" catalog="null-object" ref="false null com.sybase.jdbc.SybDriver jdbc:sybase:Tds:fanhua02:5000/shiponline" sql-schema="null-object">
  352.       <schema-column-node name="ORDERID" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="1" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="true" />
  353.       <schema-column-node name="INVENTORYID" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="2" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="true" />
  354.       <schema-column-node name="QUANTITY" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="3" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
  355.     </schema-table-node>
  356.     <schema-table-node name="ORDERS" node-type="1" status="0" catalog="null-object" ref="false null com.sybase.jdbc.SybDriver jdbc:sybase:Tds:fanhua02:5000/shiponline" sql-schema="null-object">
  357.       <schema-column-node name="ORDERSID" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="1" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="true" />
  358.       <schema-column-node name="USERID" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="2" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
  359.       <schema-column-node name="PROCESSED" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="3" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  360.     </schema-table-node>
  361.     <schema-table-node name="SEQUENCE" node-type="1" status="0" catalog="null-object" ref="false null com.sybase.jdbc.SybDriver jdbc:sybase:Tds:fanhua02:5000/shiponline" sql-schema="null-object">
  362.       <schema-column-node name="SEQUENCE_NAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="1" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="true" />
  363.       <schema-column-node name="SEQUENCE_INDEX" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="4" ordinal="2" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
  364.     </schema-table-node>
  365.     <schema-table-node name="SHOPPINGCART" node-type="1" status="0" catalog="null-object" ref="false null com.sybase.jdbc.SybDriver jdbc:sybase:Tds:fanhua02:5000/shiponline" sql-schema="null-object">
  366.       <schema-column-node name="USERID" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="1" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="true" />
  367.       <schema-column-node name="INVENTORYID" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="2" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="true" />
  368.       <schema-column-node name="QUANTITY" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="5" ordinal="3" precision="-1" scale="-1" vendor-type-name="smallint" is-primary-key="false" />
  369.     </schema-table-node>
  370.     <schema-table-node name="USERS" node-type="1" status="0" catalog="null-object" ref="false null com.sybase.jdbc.SybDriver jdbc:sybase:Tds:fanhua02:5000/shiponline" sql-schema="null-object">
  371.       <schema-column-node name="ID" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="1" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
  372.       <schema-column-node name="USERNAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="2" precision="10" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  373.       <schema-column-node name="FIRSTNAME" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="3" precision="10" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  374.       <schema-column-node name="LASTNAME" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="4" precision="10" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  375.       <schema-column-node name="ADDRESS" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="5" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  376.       <schema-column-node name="CITY" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="6" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  377.       <schema-column-node name="STATE" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="7" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  378.       <schema-column-node name="ZIP" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="8" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  379.       <schema-column-node name="PASSWORD" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="9" precision="10" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  380.       <schema-column-node name="LASTACCESSED" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="10" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  381.     </schema-table-node>
  382.     <schema-table-node name="VAO_AGENTFEE" node-type="1" status="0" catalog="null-object" ref="false null com.sybase.jdbc.SybDriver jdbc:sybase:Tds:fanhua02:5000/shiponline" sql-schema="null-object">
  383.       <schema-column-node name="VAO_AGENTFEE_ID" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="1" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="true" />
  384.       <schema-column-node name="VAO_VSLENTRUST_ID" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="2" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
  385.       <schema-column-node name="CURRENCY" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="1" ordinal="3" precision="3" scale="-1" vendor-type-name="char" is-primary-key="false" />
  386.       <schema-column-node name="AMOUNT" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="2" ordinal="4" precision="12" scale="12" vendor-type-name="numeric" is-primary-key="false" />
  387.       <schema-column-node name="BRANCHCODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="5" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  388.       <schema-column-node name="BRANCHNAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="6" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  389.     </schema-table-node>
  390.     <schema-table-node name="VAO_ANCHORAREA" node-type="1" status="0" catalog="null-object" ref="false null com.sybase.jdbc.SybDriver jdbc:sybase:Tds:fanhua02:5000/shiponline" sql-schema="null-object">
  391.       <schema-column-node name="BRANCHCODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="1" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  392.       <schema-column-node name="BRANCHNAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="2" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  393.       <schema-column-node name="VAO_ANCHORAREA_ID" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="3" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="true" />
  394.       <schema-column-node name="WORKAREACODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="4" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  395.       <schema-column-node name="WORKAREANAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="5" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  396.       <schema-column-node name="PORTCODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="6" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  397.       <schema-column-node name="PORTCNAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="7" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  398.       <schema-column-node name="ANCHORCODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="8" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  399.       <schema-column-node name="ANCHORNAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="9" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  400.       <schema-column-node name="ANCHORLOACTION" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="10" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  401.       <schema-column-node name="ANCHORLONGGITUDE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="11" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  402.       <schema-column-node name="ANCHORLATITUDE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="12" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  403.       <schema-column-node name="ANCHORWATER" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="2" ordinal="13" precision="6" scale="6" vendor-type-name="numeric" is-primary-key="false" />
  404.       <schema-column-node name="ANCHORBOTTOM" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="14" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  405.       <schema-column-node name="ANCHORTON" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="15" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  406.       <schema-column-node name="ANCHORUSAGE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="16" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  407.       <schema-column-node name="OPERATOR" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="17" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  408.       <schema-column-node name="OPERATETIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="18" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  409.       <schema-column-node name="MODIFIER" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="19" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  410.       <schema-column-node name="MODIFIEDTIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="20" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  411.     </schema-table-node>
  412.     <schema-table-node name="VAO_BERTH" node-type="1" status="0" catalog="null-object" ref="false null com.sybase.jdbc.SybDriver jdbc:sybase:Tds:fanhua02:5000/shiponline" sql-schema="null-object">
  413.       <schema-column-node name="BRANCHCODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="1" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  414.       <schema-column-node name="BRANCHNAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="2" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  415.       <schema-column-node name="VAO_BERTH_ID" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="3" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="true" />
  416.       <schema-column-node name="PORTCODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="4" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  417.       <schema-column-node name="PORTCNAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="5" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  418.       <schema-column-node name="WORKAREACODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="6" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  419.       <schema-column-node name="WORKAREANAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="7" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  420.       <schema-column-node name="OPTCOMPANYCODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="8" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  421.       <schema-column-node name="OPTCOMPANY" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="9" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  422.       <schema-column-node name="BERTHCODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="10" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  423.       <schema-column-node name="BERTHNAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="11" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  424.       <schema-column-node name="BERTHLONGGITUDE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="12" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  425.       <schema-column-node name="BERTHLATITUDE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="13" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  426.       <schema-column-node name="BERTHLENGTH" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="2" ordinal="14" precision="6" scale="6" vendor-type-name="numeric" is-primary-key="false" />
  427.       <schema-column-node name="BERTHDEPTH" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="2" ordinal="15" precision="6" scale="6" vendor-type-name="numeric" is-primary-key="false" />
  428.       <schema-column-node name="BERTHTON" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="16" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  429.       <schema-column-node name="BERTHCARGO" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="17" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  430.       <schema-column-node name="BERTHAPPLIANCE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="18" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  431.       <schema-column-node name="REMARK" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="19" precision="255" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  432.       <schema-column-node name="OPERATOR" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="20" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  433.       <schema-column-node name="OPERATETIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="21" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  434.       <schema-column-node name="MODIFIER" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="22" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  435.       <schema-column-node name="MODIFIEDTIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="23" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  436.     </schema-table-node>
  437.     <schema-table-node name="VAO_BRANCH" node-type="1" status="0" catalog="null-object" ref="false null com.sybase.jdbc.SybDriver jdbc:sybase:Tds:fanhua02:5000/shiponline" sql-schema="null-object">
  438.       <schema-column-node name="VAO_BRANCH_ID" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="1" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="true" />
  439.       <schema-column-node name="BRANCHCODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="2" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  440.       <schema-column-node name="BRANCHNAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="3" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  441.       <schema-column-node name="PORTCODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="4" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  442.       <schema-column-node name="PORTCNAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="5" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  443.     </schema-table-node>
  444.     <schema-table-node name="VAO_CARGOTYPE" node-type="1" status="0" catalog="null-object" ref="false null com.sybase.jdbc.SybDriver jdbc:sybase:Tds:fanhua02:5000/shiponline" sql-schema="null-object">
  445.       <schema-column-node name="VAO_CARGOTYPE_ID" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="1" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="true" />
  446.       <schema-column-node name="CARGOTYPECODE" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="2" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  447.       <schema-column-node name="CARGOTYPE" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="3" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  448.       <schema-column-node name="OPERATOR" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="4" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  449.       <schema-column-node name="OPERATETIME" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="93" ordinal="5" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  450.       <schema-column-node name="MODIFIER" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="6" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  451.       <schema-column-node name="MODIFIEDTIME" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="93" ordinal="7" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  452.     </schema-table-node>
  453.     <schema-table-node name="VAO_CNTRTYPE" node-type="1" status="0" catalog="null-object" ref="false null com.sybase.jdbc.SybDriver jdbc:sybase:Tds:fanhua02:5000/shiponline" sql-schema="null-object">
  454.       <schema-column-node name="VAO_CNTRTYPE_ID" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="1" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="true" />
  455.       <schema-column-node name="CNTRTYPECODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="1" ordinal="2" precision="2" scale="-1" vendor-type-name="char" is-primary-key="false" />
  456.       <schema-column-node name="CNTRTYPE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="3" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  457.       <schema-column-node name="OPERATOR" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="4" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  458.       <schema-column-node name="OPERATETIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="5" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  459.       <schema-column-node name="MODIFIER" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="6" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  460.       <schema-column-node name="MODIFIEDTIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="7" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  461.     </schema-table-node>
  462.     <schema-table-node name="VAO_ENTRCONTACT" node-type="1" status="0" catalog="null-object" ref="false null com.sybase.jdbc.SybDriver jdbc:sybase:Tds:fanhua02:5000/shiponline" sql-schema="null-object">
  463.       <schema-column-node name="VAO_ENTRCONTACT_ID" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="1" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="true" />
  464.       <schema-column-node name="VAO_ENTRUSTER_ID" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="4" ordinal="2" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
  465.       <schema-column-node name="CURRENTMARK" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="3" precision="1" scale="-1" vendor-type-name="char" is-primary-key="false" />
  466.       <schema-column-node name="CONTACTOR" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="4" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  467.       <schema-column-node name="GENDER" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="5" precision="1" scale="-1" vendor-type-name="char" is-primary-key="false" />
  468.       <schema-column-node name="DEPARTMENT" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="6" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  469.       <schema-column-node name="JOBPOST" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="7" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  470.       <schema-column-node name="TITLE" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="8" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  471.       <schema-column-node name="POSITION" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="9" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  472.       <schema-column-node name="AGE" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="10" precision="3" scale="-1" vendor-type-name="char" is-primary-key="false" />
  473.       <schema-column-node name="EFFECTDATE" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="11" precision="8" scale="-1" vendor-type-name="char" is-primary-key="false" />
  474.       <schema-column-node name="EXPIREDATE" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="12" precision="8" scale="-1" vendor-type-name="char" is-primary-key="false" />
  475.       <schema-column-node name="POSTALCODE" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="13" precision="10" scale="-1" vendor-type-name="char" is-primary-key="false" />
  476.       <schema-column-node name="TELEX" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="14" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  477.       <schema-column-node name="TELEPHONE" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="15" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  478.       <schema-column-node name="EMAIL" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="16" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  479.       <schema-column-node name="FAX" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="17" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  480.       <schema-column-node name="OPERATOR" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="18" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  481.       <schema-column-node name="OPERATETIME" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="93" ordinal="19" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  482.       <schema-column-node name="MODIFIER" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="20" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  483.       <schema-column-node name="MODIFIEDTIME" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="93" ordinal="21" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  484.       <schema-column-node name="BRANCHCODE" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="22" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  485.       <schema-column-node name="BRANCHNAME" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="23" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  486.     </schema-table-node>
  487.     <schema-table-node name="VAO_ENTRUSTER" node-type="1" status="0" catalog="null-object" ref="false null com.sybase.jdbc.SybDriver jdbc:sybase:Tds:fanhua02:5000/shiponline" sql-schema="null-object">
  488.       <schema-column-node name="VAO_ENTRUSTER_ID" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="1" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="true" />
  489.       <schema-column-node name="BRANCHCODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="2" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  490.       <schema-column-node name="BRANCHNAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="3" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  491.       <schema-column-node name="ENTRUSTERCODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="4" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  492.       <schema-column-node name="MEMORYCODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="5" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  493.       <schema-column-node name="EABBR" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="6" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  494.       <schema-column-node name="CABBR" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="7" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  495.       <schema-column-node name="ENAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="8" precision="255" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  496.       <schema-column-node name="CNAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="9" precision="255" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  497.       <schema-column-node name="DISTRICT" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="10" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  498.       <schema-column-node name="ADDRESS" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="11" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  499.       <schema-column-node name="TELEX" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="12" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  500.       <schema-column-node name="EMAIL" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="13" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  501.       <schema-column-node name="POSTALCODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="1" ordinal="14" precision="10" scale="-1" vendor-type-name="char" is-primary-key="false" />