ejb20.ejbgrpx~329~
上传用户:jnhyscl
上传日期:2010-03-08
资源大小:345k
文件大小:245k
- <?xml version="1.0" encoding="UTF-8"?>
- <descriptors>
- <ejb-jar.xml extralocation="" timestamp="1063335932971"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
- <!DOCTYPE ejb-jar PUBLIC "-//Sun Microsystems, Inc.//DTD Enterprise JavaBeans 2.0//EN" "http://java.sun.com/dtd/ejb-jar_2_0.dtd">
- <ejb-jar>
- <enterprise-beans>
- <session>
- <display-name>ServerDataModule</display-name>
- <ejb-name>ServerDataModule</ejb-name>
- <local-home>shiponline.ServerDataModuleLocalHome</local-home>
- <local>shiponline.ServerDataModuleLocal</local>
- <ejb-class>shiponline.ServerDataModuleBean</ejb-class>
- <session-type>Stateless</session-type>
- <transaction-type>Container</transaction-type>
- <ejb-local-ref>
- <description />
- <ejb-ref-name>VaoPort</ejb-ref-name>
- <ejb-ref-type>Entity</ejb-ref-type>
- <local-home>shiponline.VaoPortHome</local-home>
- <local>shiponline.VaoPort</local>
- <ejb-link>VaoPort</ejb-link>
- </ejb-local-ref>
- <ejb-local-ref>
- <description />
- <ejb-ref-name>SequenceGenerator</ejb-ref-name>
- <ejb-ref-type>Session</ejb-ref-type>
- <local-home>shiponline.SequenceGeneratorLocalHome</local-home>
- <local>shiponline.SequenceGeneratorLocal</local>
- <ejb-link>SequenceGenerator</ejb-link>
- </ejb-local-ref>
- </session>
- <session>
- <display-name>Apps</display-name>
- <ejb-name>Apps</ejb-name>
- <home>shiponline.AppsHome</home>
- <remote>shiponline.Apps</remote>
- <ejb-class>shiponline.AppsBean</ejb-class>
- <session-type>Stateful</session-type>
- <transaction-type>Container</transaction-type>
- <ejb-local-ref>
- <description />
- <ejb-ref-name>ServerDataModule</ejb-ref-name>
- <ejb-ref-type>Session</ejb-ref-type>
- <local-home>shiponline.ServerDataModuleLocalHome</local-home>
- <local>shiponline.ServerDataModuleLocal</local>
- <ejb-link>ServerDataModule</ejb-link>
- </ejb-local-ref>
- <ejb-local-ref>
- <description />
- <ejb-ref-name>VaoPort</ejb-ref-name>
- <ejb-ref-type>Entity</ejb-ref-type>
- <local-home>shiponline.VaoPortHome</local-home>
- <local>shiponline.VaoPort</local>
- <ejb-link>VaoPort</ejb-link>
- </ejb-local-ref>
- </session>
- <session>
- <display-name>SequenceGenerator</display-name>
- <ejb-name>SequenceGenerator</ejb-name>
- <local-home>shiponline.SequenceGeneratorLocalHome</local-home>
- <local>shiponline.SequenceGeneratorLocal</local>
- <ejb-class>shiponline.SequenceGeneratorBean</ejb-class>
- <session-type>Stateless</session-type>
- <transaction-type>Container</transaction-type>
- <env-entry>
- <description />
- <env-entry-name>blockSize</env-entry-name>
- <env-entry-type>java.lang.Integer</env-entry-type>
- <env-entry-value>1</env-entry-value>
- </env-entry>
- <env-entry>
- <description />
- <env-entry-name>retryCount</env-entry-name>
- <env-entry-type>java.lang.Integer</env-entry-type>
- <env-entry-value>5</env-entry-value>
- </env-entry>
- <ejb-local-ref>
- <description />
- <ejb-ref-name>Sequence</ejb-ref-name>
- <ejb-ref-type>Entity</ejb-ref-type>
- <local-home>shiponline.SequenceHome</local-home>
- <local>shiponline.Sequence</local>
- <ejb-link>Sequence</ejb-link>
- </ejb-local-ref>
- </session>
- <entity>
- <display-name>VaoPort</display-name>
- <ejb-name>VaoPort</ejb-name>
- <local-home>shiponline.VaoPortHome</local-home>
- <local>shiponline.VaoPort</local>
- <ejb-class>shiponline.VaoPortBean</ejb-class>
- <persistence-type>Container</persistence-type>
- <prim-key-class>java.lang.Integer</prim-key-class>
- <reentrant>False</reentrant>
- <cmp-version>2.x</cmp-version>
- <abstract-schema-name>VaoPort</abstract-schema-name>
- <cmp-field>
- <field-name>vaoPortId</field-name>
- </cmp-field>
- <cmp-field>
- <field-name>portcode</field-name>
- </cmp-field>
- <cmp-field>
- <field-name>cname</field-name>
- </cmp-field>
- <cmp-field>
- <field-name>ename</field-name>
- </cmp-field>
- <cmp-field>
- <field-name>nationcode</field-name>
- </cmp-field>
- <cmp-field>
- <field-name>nationname</field-name>
- </cmp-field>
- <cmp-field>
- <field-name>operator</field-name>
- </cmp-field>
- <cmp-field>
- <field-name>operatetime</field-name>
- </cmp-field>
- <cmp-field>
- <field-name>modifier</field-name>
- </cmp-field>
- <cmp-field>
- <field-name>modifiedtime</field-name>
- </cmp-field>
- <primkey-field>vaoPortId</primkey-field>
- <query>
- <query-method>
- <method-name>findAll</method-name>
- <method-params />
- </query-method>
- <ejb-ql>SELECT p FROM VaoPort AS p</ejb-ql>
- </query>
- <query>
- <query-method>
- <method-name>findByCode</method-name>
- <method-params>
- <method-param>java.lang.String</method-param>
- </method-params>
- </query-method>
- <ejb-ql>SELECT p FROM VaoPort AS p WHERE p.portcode=?1</ejb-ql>
- </query>
- <query>
- <query-method>
- <method-name>findByName</method-name>
- <method-params>
- <method-param>java.lang.String</method-param>
- </method-params>
- </query-method>
- <ejb-ql>SELECT p FROM VaoPort AS p WHERE p.ename=?1</ejb-ql>
- </query>
- </entity>
- <entity>
- <display-name>Sequence</display-name>
- <ejb-name>Sequence</ejb-name>
- <local-home>shiponline.SequenceHome</local-home>
- <local>shiponline.Sequence</local>
- <ejb-class>shiponline.SequenceBean</ejb-class>
- <persistence-type>Container</persistence-type>
- <prim-key-class>java.lang.String</prim-key-class>
- <reentrant>False</reentrant>
- <cmp-version>2.x</cmp-version>
- <abstract-schema-name>Sequence</abstract-schema-name>
- <cmp-field>
- <field-name>sequenceName</field-name>
- </cmp-field>
- <cmp-field>
- <field-name>sequenceIndex</field-name>
- </cmp-field>
- <primkey-field>sequenceName</primkey-field>
- </entity>
- </enterprise-beans>
- <assembly-descriptor>
- <container-transaction>
- <method>
- <ejb-name>ServerDataModule</ejb-name>
- <method-name>*</method-name>
- </method>
- <trans-attribute>Required</trans-attribute>
- </container-transaction>
- <container-transaction>
- <method>
- <ejb-name>VaoPort</ejb-name>
- <method-name>*</method-name>
- </method>
- <trans-attribute>Required</trans-attribute>
- </container-transaction>
- <container-transaction>
- <method>
- <ejb-name>Apps</ejb-name>
- <method-name>*</method-name>
- </method>
- <trans-attribute>Required</trans-attribute>
- </container-transaction>
- <container-transaction>
- <method>
- <ejb-name>Sequence</ejb-name>
- <method-name>*</method-name>
- </method>
- <trans-attribute>Required</trans-attribute>
- </container-transaction>
- <container-transaction>
- <method>
- <ejb-name>SequenceGenerator</ejb-name>
- <method-name>*</method-name>
- </method>
- <trans-attribute>Required</trans-attribute>
- </container-transaction>
- </assembly-descriptor>
- </ejb-jar>]]></ejb-jar.xml>
- <sybase-easerver-config.xml extralocation="" timestamp="1062983283782"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
- <!DOCTYPE sybase-easerver-config SYSTEM "http://download.sybase.com/specifications/xsd/sybase-easerver-config_1_0.dtd">
- <sybase-easerver-config>
- <configure type="update" entity="Component:ejb20/VaoPort">
- <property name="com.sybase.jaguar.component.bind.naming" value="VaoPort" />
- <property name="com.sybase.jaguar.component.storage" value="CtsComponents/JdbcStorage(cache=shiponline,table=map:"VAO_PORT")" />
- <property name="mapField:vaoPortId" value="VAO_PORT_ID" />
- <property name="mapField:portcode" value="PORTCODE" />
- <property name="mapField:cname" value="CNAME" />
- <property name="mapField:ename" value="ENAME" />
- <property name="mapField:nationcode" value="NATIONCODE" />
- <property name="mapField:nationname" value="NATIONNAME" />
- <property name="mapField:operator" value="OPERATOR" />
- <property name="mapField:operatetime" value="OPERATETIME" />
- <property name="mapField:modifier" value="MODIFIER" />
- <property name="mapField:modifiedtime" value="MODIFIEDTIME" />
- </configure>
- <configure type="update" entity="Component:ejb20/ServerDataModule">
- <property name="com.sybase.jaguar.component.bind.naming" value="ServerDataModuleLocal" />
- <property name="com.sybase.jaguar.component.ejb-local-ref" value="(ejb-link=VaoPort,ejb-ref-name=VaoPort,local=shiponline.VaoPort,local-home=shiponline.VaoPortHome,ejb-ref-type=Entity,description=,jaguar-link=VaoPort),(ejb-link=SequenceGenerator,ejb-ref-name=SequenceGenerator,local=shiponline.SequenceGeneratorLocal,local-home=shiponline.SequenceGeneratorLocalHome,ejb-ref-type=Session,description=,jaguar-link=SequenceGeneratorLocal)" />
- </configure>
- <configure type="update" entity="Component:ejb20/Apps">
- <property name="com.sybase.jaguar.component.bind.naming" value="Apps" />
- <property name="com.sybase.jaguar.component.ejb-local-ref" value="(ejb-link=ServerDataModule,ejb-ref-name=ServerDataModule,local=shiponline.ServerDataModuleLocal,local-home=shiponline.ServerDataModuleLocalHome,ejb-ref-type=Session,description=,jaguar-link=ServerDataModuleLocal),(ejb-link=VaoPort,ejb-ref-name=VaoPort,local=shiponline.VaoPort,local-home=shiponline.VaoPortHome,ejb-ref-type=Entity,description=,jaguar-link=VaoPort)" />
- </configure>
- <configure type="update" entity="Component:ejb20/SequenceGenerator">
- <property name="com.sybase.jaguar.component.bind.naming" value="SequenceGeneratorLocal" />
- <property name="com.sybase.jaguar.component.ejb-local-ref" value="(ejb-link=Sequence,ejb-ref-name=Sequence,local=shiponline.Sequence,local-home=shiponline.SequenceHome,ejb-ref-type=Entity,description=,jaguar-link=Sequence)" />
- </configure>
- <configure type="update" entity="Component:ejb20/Sequence">
- <property name="com.sybase.jaguar.component.bind.naming" value="Sequence" />
- <property name="com.sybase.jaguar.component.storage" value="CtsComponents/JdbcStorage(cache=shiponline,table=map:"SEQUENCE")" />
- <property name="mapField:sequenceName" value="SEQUENCE_NAME" />
- <property name="mapField:sequenceIndex" value="SEQUENCE_INDEX" />
- </configure>
- </sybase-easerver-config>
- ]]></sybase-easerver-config.xml>
- <ejb-borland.xml extralocation="" timestamp="1063335932971"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
- <!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">
- <ejb-jar>
- <enterprise-beans>
- <session>
- <ejb-name>ServerDataModule</ejb-name>
- <bean-local-home-name>ServerDataModuleLocal</bean-local-home-name>
- <ejb-local-ref>
- <ejb-ref-name>VaoPort</ejb-ref-name>
- </ejb-local-ref>
- <ejb-local-ref>
- <ejb-ref-name>SequenceGenerator</ejb-ref-name>
- </ejb-local-ref>
- <property>
- <prop-name>ejb-designer-id</prop-name>
- <prop-type>String</prop-type>
- <prop-value>ServerDataModule</prop-value>
- </property>
- </session>
- <session>
- <ejb-name>Apps</ejb-name>
- <bean-home-name>Apps</bean-home-name>
- <ejb-local-ref>
- <ejb-ref-name>ServerDataModule</ejb-ref-name>
- </ejb-local-ref>
- <ejb-local-ref>
- <ejb-ref-name>VaoPort</ejb-ref-name>
- </ejb-local-ref>
- <property>
- <prop-name>ejb-designer-id</prop-name>
- <prop-type>String</prop-type>
- <prop-value>Apps</prop-value>
- </property>
- </session>
- <session>
- <ejb-name>SequenceGenerator</ejb-name>
- <bean-local-home-name>SequenceGeneratorLocal</bean-local-home-name>
- <ejb-local-ref>
- <ejb-ref-name>Sequence</ejb-ref-name>
- </ejb-local-ref>
- <property>
- <prop-name>ejb-designer-id</prop-name>
- <prop-type>String</prop-type>
- <prop-value>SequenceGenerator</prop-value>
- </property>
- </session>
- <entity>
- <ejb-name>VaoPort</ejb-name>
- <bean-local-home-name>VaoPort</bean-local-home-name>
- <cmp2-info>
- <cmp-field>
- <field-name>vaoPortId</field-name>
- <column-name>VAO_PORT_ID</column-name>
- </cmp-field>
- <cmp-field>
- <field-name>portcode</field-name>
- <column-name>PORTCODE</column-name>
- </cmp-field>
- <cmp-field>
- <field-name>cname</field-name>
- <column-name>CNAME</column-name>
- </cmp-field>
- <cmp-field>
- <field-name>ename</field-name>
- <column-name>ENAME</column-name>
- </cmp-field>
- <cmp-field>
- <field-name>nationcode</field-name>
- <column-name>NATIONCODE</column-name>
- </cmp-field>
- <cmp-field>
- <field-name>nationname</field-name>
- <column-name>NATIONNAME</column-name>
- </cmp-field>
- <cmp-field>
- <field-name>operator</field-name>
- <column-name>OPERATOR</column-name>
- </cmp-field>
- <cmp-field>
- <field-name>operatetime</field-name>
- <column-name>OPERATETIME</column-name>
- </cmp-field>
- <cmp-field>
- <field-name>modifier</field-name>
- <column-name>MODIFIER</column-name>
- </cmp-field>
- <cmp-field>
- <field-name>modifiedtime</field-name>
- <column-name>MODIFIEDTIME</column-name>
- </cmp-field>
- <table-name>VAO_PORT</table-name>
- </cmp2-info>
- <property>
- <prop-name>ejb-designer-id</prop-name>
- <prop-type>String</prop-type>
- <prop-value>VaoPort</prop-value>
- </property>
- <property>
- <prop-name>ejb.datasource</prop-name>
- <prop-type>String</prop-type>
- <prop-value>shiponline</prop-value>
- </property>
- </entity>
- <entity>
- <ejb-name>Sequence</ejb-name>
- <bean-local-home-name>Sequence</bean-local-home-name>
- <cmp2-info>
- <cmp-field>
- <field-name>sequenceName</field-name>
- <column-name>SEQUENCE_NAME</column-name>
- </cmp-field>
- <cmp-field>
- <field-name>sequenceIndex</field-name>
- <column-name>SEQUENCE_INDEX</column-name>
- </cmp-field>
- <table-name>SEQUENCE</table-name>
- </cmp2-info>
- <property>
- <prop-name>ejb-designer-id</prop-name>
- <prop-type>String</prop-type>
- <prop-value>Sequence</prop-value>
- </property>
- <property>
- <prop-name>ejb.datasource</prop-name>
- <prop-type>String</prop-type>
- <prop-value>shiponline</prop-value>
- </property>
- </entity>
- </enterprise-beans>
- <table-properties>
- <table-name>VAO_PORT</table-name>
- <column-properties>
- <column-name>VAO_PORT_ID</column-name>
- </column-properties>
- <column-properties>
- <column-name>PORTCODE</column-name>
- </column-properties>
- <column-properties>
- <column-name>CNAME</column-name>
- </column-properties>
- <column-properties>
- <column-name>ENAME</column-name>
- </column-properties>
- <column-properties>
- <column-name>NATIONCODE</column-name>
- </column-properties>
- <column-properties>
- <column-name>NATIONNAME</column-name>
- </column-properties>
- <column-properties>
- <column-name>OPERATOR</column-name>
- </column-properties>
- <column-properties>
- <column-name>OPERATETIME</column-name>
- </column-properties>
- <column-properties>
- <column-name>MODIFIER</column-name>
- </column-properties>
- <column-properties>
- <column-name>MODIFIEDTIME</column-name>
- </column-properties>
- <property>
- <prop-name>datasource</prop-name>
- <prop-type>String</prop-type>
- <prop-value>serial://datasources/shiponline</prop-value>
- </property>
- </table-properties>
- <table-properties>
- <table-name>SEQUENCE</table-name>
- <column-properties>
- <column-name>SEQUENCE_NAME</column-name>
- </column-properties>
- <column-properties>
- <column-name>SEQUENCE_INDEX</column-name>
- </column-properties>
- <property>
- <prop-name>datasource</prop-name>
- <prop-type>String</prop-type>
- <prop-value>serial://datasources/shiponline</prop-value>
- </property>
- </table-properties>
- <assembly-descriptor />
- </ejb-jar>]]></ejb-borland.xml>
- <ejb-modeler-schema.xml extralocation="" timestamp="1063241280520"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
- <schema-root-node name="DataSources" node-type="0" status="0">
- <schema-connection-node name="shiponline" node-type="4" status="0" catalog="null-object" connection-type="1" data-source-name="sybase:Tds:fanhua02:5000/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="false">
- <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">
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- </schema-table-node>
- <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">
- <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" />
- <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" />
- <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" />
- </schema-table-node>
- <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">
- <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" />
- <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" />
- <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" />
- </schema-table-node>
- <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">
- <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" />
- <schema-column-node name="SEQUENCE_INDEX" 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" />
- </schema-table-node>
- <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">
- <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" />
- <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" />
- <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" />
- </schema-table-node>
- <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">
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- </schema-table-node>
- <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">
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <schema-column-node name="ANCHORWATER" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="2" ordinal="11" precision="6" scale="6" vendor-type-name="numeric" is-primary-key="false" />
- <schema-column-node name="ANCHORBOTTOM" 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" />
- <schema-column-node name="ANCHORTON" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="13" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="ANCHORUSAGE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="14" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="OPERATOR" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="15" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="OPERATETIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="16" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
- <schema-column-node name="MODIFIER" 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" />
- <schema-column-node name="MODIFIEDTIME" 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" />
- </schema-table-node>
- <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">
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <schema-column-node name="BERTHLENGTH" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="2" ordinal="12" precision="6" scale="6" vendor-type-name="numeric" is-primary-key="false" />
- <schema-column-node name="BERTHDEPTH" 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" />
- <schema-column-node name="BERTHTON" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="14" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="BERTHCARGO" 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" />
- <schema-column-node name="BERTHAPPLIANCE" 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" />
- <schema-column-node name="REMARK" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="17" precision="255" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="OPERATOR" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="18" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="OPERATETIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="19" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
- <schema-column-node name="MODIFIER" 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" />
- <schema-column-node name="MODIFIEDTIME" 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" />
- </schema-table-node>
- <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">
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- </schema-table-node>
- <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">
- <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" />
- <schema-column-node name="CARGOTYPECODE" 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" />
- <schema-column-node name="CARGOTYPE" 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" />
- <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" />
- <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" />
- <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" />
- <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" />
- </schema-table-node>
- <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">
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- </schema-table-node>
- <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">
- <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" />
- <schema-column-node name="VAO_ENTRUSTER_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" />
- <schema-column-node name="CURRENTMARK" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="1" ordinal="3" precision="1" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="CONTACTOR" 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" />
- <schema-column-node name="POSTALCODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="1" ordinal="5" precision="10" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="TELEX" 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" />
- <schema-column-node name="TELEPHONE" 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" />
- <schema-column-node name="EMAIL" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="8" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="FAX" 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" />
- <schema-column-node name="OPERATOR" 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" />
- <schema-column-node name="OPERATETIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="11" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
- <schema-column-node name="MODIFIER" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="12" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="MODIFIEDTIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="13" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
- </schema-table-node>
- <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">
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <schema-column-node name="TELEPHONE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="15" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="FAX" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="16" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <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" />
- <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" />
- <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" />
- <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" />
- </schema-table-node>
- <schema-table-node name="VAO_LINE" 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">
- <schema-column-node name="VAO_LINE_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" />
- <schema-column-node name="LINECODE" 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" />
- <schema-column-node name="LINENAME" 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" />
- <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" />
- <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" />
- <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" />
- <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" />
- </schema-table-node>
- <schema-table-node name="VAO_NATION" 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">
- <schema-column-node name="VAO_NATION_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" />
- <schema-column-node name="NATIONCODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="1" ordinal="2" precision="3" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="ENAME" 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" />
- <schema-column-node name="CNAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="4" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="OPERATOR" 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" />
- <schema-column-node name="OPERATETIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="6" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
- <schema-column-node name="MODIFIER" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="7" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="MODIFIEDTIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="8" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
- </schema-table-node>
- <schema-table-node name="VAO_OPERATOR" 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">
- <schema-column-node name="VAO_OPERATOR_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" />
- <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" />
- <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" />
- <schema-column-node name="OPERATORCODE" 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" />
- <schema-column-node name="NAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="1" ordinal="5" precision="10" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="DEPARTMENT" 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" />
- <schema-column-node name="GENDER" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="1" ordinal="7" precision="2" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="AGE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="8" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
- <schema-column-node name="RANK" 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" />
- <schema-column-node name="CONTACTWAY" 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" />
- <schema-column-node name="RESUME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="11" precision="255" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="OPERATOR" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="12" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="OPERATETIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="13" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
- <schema-column-node name="MODIFIER" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="14" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="MODIFIEDTIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="15" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
- </schema-table-node>
- <schema-table-node name="VAO_PORT" 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">
- <schema-column-node name="VAO_PORT_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" />
- <schema-column-node name="PORTCODE" 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" />
- <schema-column-node name="CNAME" 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" />
- <schema-column-node name="ENAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="4" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="NATIONCODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="1" ordinal="5" precision="3" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="NATIONNAME" 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" />
- <schema-column-node name="OPERATOR" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="7" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="OPERATETIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="8" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
- <schema-column-node name="MODIFIER" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="9" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="MODIFIEDTIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="10" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
- </schema-table-node>
- <schema-table-node name="VAO_POSALLOCATE" 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">
- <schema-column-node name="VAO_POSALLOCATE_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" />
- <schema-column-node name="VAO_POSITION_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" />
- <schema-column-node name="VAO_OPERATOR_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="false" />
- <schema-column-node name="BRANCHCODE" 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" />
- <schema-column-node name="BRANCHNAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="5" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- </schema-table-node>
- <schema-table-node name="VAO_POSITION" 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">
- <schema-column-node name="VAO_POSITION_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" />
- <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" />
- <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" />
- <schema-column-node name="POSITIONCODE" 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" />
- <schema-column-node name="POSITION" 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" />
- <schema-column-node name="POSITIONDESCRIPT" 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" />
- <schema-column-node name="OPERATOR" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="7" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="OPERATETIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="8" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
- <schema-column-node name="MODIFIER" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="9" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="MODIFIEDTIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="10" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
- </schema-table-node>
- <schema-table-node name="VAO_THISPORTDETAIL" 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">
- <schema-column-node name="VAO_THISPORTDETAIL" 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" />
- <schema-column-node name="PORTCODE" 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" />
- <schema-column-node name="PORTCNAME" 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" />
- <schema-column-node name="PORTENAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="4" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <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" />
- <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" />
- <schema-column-node name="LOCATION" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="7" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="DEPOTDESCRIPT" 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" />
- <schema-column-node name="TIDEDESCRIPT" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="9" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="DROPDESCRIPT" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="10" precision="255" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="PILOTDESCRIPT" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="11" precision="255" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="NIGHTIN" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="1" ordinal="12" precision="1" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="WEATHERDESCRIPT" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="13" precision="255" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="MAINCARGO" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="14" precision="255" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="WIRELESSDESCRIPT" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="15" precision="255" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="VSLREPAIR" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="1" ordinal="16" precision="1" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="FLOATDESCRIPT" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="17" precision="255" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="SERVEDESCRIPT" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="18" precision="255" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="TUGBOATDESCRIPT" 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" />
- <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" />
- <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" />
- <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" />
- <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" />
- </schema-table-node>
- <schema-table-node name="VAO_VESSEL" 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">
- <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" />
- <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" />
- <schema-column-node name="VAO_VESSEL_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" />
- <schema-column-node name="VSLCODE" 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" />
- <schema-column-node name="VSLCUSTOMSCODE" 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" />
- <schema-column-node name="ENAME" 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" />
- <schema-column-node name="CNAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="7" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="NATIONCODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="1" ordinal="8" precision="3" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="NATIONNAME" 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" />
- <schema-column-node name="NATIONCERTIFICATE" 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" />
- <schema-column-node name="VSLTYPE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="1" ordinal="11" precision="10" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="BUILTDATE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="12" precision="8" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="AGENTCOMPANY" 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" />
- <schema-column-node name="VSLLENGTH" 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" />
- <schema-column-node name="VSLWIDTH" 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" />
- <schema-column-node name="VSLHEIGHT" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="2" ordinal="16" precision="6" scale="6" vendor-type-name="numeric" is-primary-key="false" />
- <schema-column-node name="VSLALLTON" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="2" ordinal="17" precision="12" scale="12" vendor-type-name="numeric" is-primary-key="false" />
- <schema-column-node name="VSLNETTON" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="2" ordinal="18" precision="12" scale="12" vendor-type-name="numeric" is-primary-key="false" />
- <schema-column-node name="VSLHOLDTON" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="2" ordinal="19" precision="12" scale="12" vendor-type-name="numeric" is-primary-key="false" />
- <schema-column-node name="TPITPC" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="20" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="FFWATER" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="2" ordinal="21" precision="6" scale="6" vendor-type-name="numeric" is-primary-key="false" />
- <schema-column-node name="FBWATER" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="2" ordinal="22" precision="6" scale="6" vendor-type-name="numeric" is-primary-key="false" />
- <schema-column-node name="EFWATER" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="2" ordinal="23" precision="6" scale="6" vendor-type-name="numeric" is-primary-key="false" />
- <schema-column-node name="EBWATER" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="2" ordinal="24" precision="6" scale="6" vendor-type-name="numeric" is-primary-key="false" />
- <schema-column-node name="INBOARDTEU" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="25" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
- <schema-column-node name="ONBOARDTEU" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="26" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
- <schema-column-node name="WRAPQUANTITY" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="2" ordinal="27" precision="12" scale="12" vendor-type-name="numeric" is-primary-key="false" />
- <schema-column-node name="QUANTITY" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="2" ordinal="28" precision="12" scale="12" vendor-type-name="numeric" is-primary-key="false" />
- <schema-column-node name="CABINCOUNT" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="29" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
- <schema-column-node name="ENGINE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="2" ordinal="30" precision="12" scale="12" vendor-type-name="numeric" is-primary-key="false" />
- <schema-column-node name="SPEED" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="2" ordinal="31" precision="6" scale="6" vendor-type-name="numeric" is-primary-key="false" />
- <schema-column-node name="APPLIANCE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="32" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="RANKNUMBER" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="33" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="RANKCERTIFICATE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="34" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="VESSELCOLOR" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="35" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="CHIMNEYCOLOR" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="36" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="TELEX" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="37" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="FAX" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="38" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="REMARK" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="39" precision="255" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="OPERATOR" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="40" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="OPERATETIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="41" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
- <schema-column-node name="MODIFIER" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="42" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="MODIFIEDTIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="43" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
- </schema-table-node>
- <schema-table-node name="VAO_VESSELTYPE" 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">
- <schema-column-node name="VAO_VESSELTYPE_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" />
- <schema-column-node name="VESSELTYPECODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="1" ordinal="2" precision="3" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="VESSELTYPE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="1" ordinal="3" precision="10" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <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" />
- <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" />
- <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" />
- <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" />
- </schema-table-node>
- <schema-table-node name="VAO_WORKAREA" 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">
- <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" />
- <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" />
- <schema-column-node name="VAO_WORKAREA_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" />
- <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" />
- <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" />
- <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" />
- <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" />
- <schema-column-node name="OPERATOR" 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" />
- <schema-column-node name="OPERATETIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="9" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
- <schema-column-node name="MODIFIER" 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" />
- <schema-column-node name="MODIFIEDTIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="11" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
- </schema-table-node>
- <schema-table-node name="esite_user_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">
- <schema-column-node name="user" 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" />
- <schema-column-node name="shoppingCart_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="true" />
- <schema-column-node name="shoppingCart_inventoryid" 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" />
- </schema-table-node>
- <schema-table-node name="pbcatcol" 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">
- <schema-column-node name="pbc_tnam" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="1" ordinal="1" precision="30" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="pbc_tid" 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" />
- <schema-column-node name="pbc_ownr" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="1" ordinal="3" precision="30" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="pbc_cnam" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="1" ordinal="4" precision="30" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="pbc_cid" 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" />
- <schema-column-node name="pbc_labl" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="6" precision="254" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="pbc_lpos" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="5" ordinal="7" precision="-1" scale="-1" vendor-type-name="smallint" is-primary-key="false" />
- <schema-column-node name="pbc_hdr" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="8" precision="254" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="pbc_hpos" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="5" ordinal="9" precision="-1" scale="-1" vendor-type-name="smallint" is-primary-key="false" />
- <schema-column-node name="pbc_jtfy" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="5" ordinal="10" precision="-1" scale="-1" vendor-type-name="smallint" is-primary-key="false" />
- <schema-column-node name="pbc_mask" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="11" precision="31" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="pbc_case" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="5" ordinal="12" precision="-1" scale="-1" vendor-type-name="smallint" is-primary-key="false" />
- <schema-column-node name="pbc_hght" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="5" ordinal="13" precision="-1" scale="-1" vendor-type-name="smallint" is-primary-key="false" />
- <schema-column-node name="pbc_wdth" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="5" ordinal="14" precision="-1" scale="-1" vendor-type-name="smallint" is-primary-key="false" />
- <schema-column-node name="pbc_ptrn" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="15" precision="31" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="pbc_bmap" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="16" precision="1" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="pbc_init" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="17" precision="254" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="pbc_cmnt" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="18" precision="254" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="pbc_edit" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="19" precision="31" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="pbc_tag" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="20" precision="254" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- </schema-table-node>
- <schema-table-node name="pbcatedt" 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">
- <schema-column-node name="pbe_name" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="1" precision="30" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="pbe_edit" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="2" precision="254" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="pbe_type" 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" />
- <schema-column-node name="pbe_cntr" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="4" ordinal="4" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
- <schema-column-node name="pbe_seqn" 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" />
- <schema-column-node name="pbe_flag" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="4" ordinal="6" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
- <schema-column-node name="pbe_work" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="7" precision="32" scale="-1" vendor-type-name="char" is-primary-key="false" />
- </schema-table-node>
- <schema-table-node name="pbcatfmt" 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">
- <schema-column-node name="pbf_name" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="1" precision="30" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="pbf_frmt" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="2" precision="254" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="pbf_type" 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" />
- <schema-column-node name="pbf_cntr" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="4" ordinal="4" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
- </schema-table-node>
- <schema-table-node name="pbcattbl" 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">
- <schema-column-node name="pbt_tnam" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="1" ordinal="1" precision="30" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="pbt_tid" 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" />
- <schema-column-node name="pbt_ownr" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="1" ordinal="3" precision="30" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="pbd_fhgt" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="5" ordinal="4" precision="-1" scale="-1" vendor-type-name="smallint" is-primary-key="false" />
- <schema-column-node name="pbd_fwgt" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="5" ordinal="5" precision="-1" scale="-1" vendor-type-name="smallint" is-primary-key="false" />
- <schema-column-node name="pbd_fitl" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="6" precision="1" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="pbd_funl" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="7" precision="1" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="pbd_fchr" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="5" ordinal="8" precision="-1" scale="-1" vendor-type-name="smallint" is-primary-key="false" />
- <schema-column-node name="pbd_fptc" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="5" ordinal="9" precision="-1" scale="-1" vendor-type-name="smallint" is-primary-key="false" />
- <schema-column-node name="pbd_ffce" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="10" precision="32" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="pbh_fhgt" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="5" ordinal="11" precision="-1" scale="-1" vendor-type-name="smallint" is-primary-key="false" />
- <schema-column-node name="pbh_fwgt" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="5" ordinal="12" precision="-1" scale="-1" vendor-type-name="smallint" is-primary-key="false" />
- <schema-column-node name="pbh_fitl" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="13" precision="1" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="pbh_funl" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="14" precision="1" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="pbh_fchr" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="5" ordinal="15" precision="-1" scale="-1" vendor-type-name="smallint" is-primary-key="false" />
- <schema-column-node name="pbh_fptc" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="5" ordinal="16" precision="-1" scale="-1" vendor-type-name="smallint" is-primary-key="false" />