- <schema-column-node name="pbh_ffce" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="17" precision="32" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="pbl_fhgt" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="5" ordinal="18" precision="-1" scale="-1" vendor-type-name="smallint" is-primary-key="false" />
- <schema-column-node name="pbl_fwgt" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="5" ordinal="19" precision="-1" scale="-1" vendor-type-name="smallint" is-primary-key="false" />
- <schema-column-node name="pbl_fitl" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="20" precision="1" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="pbl_funl" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="21" precision="1" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="pbl_fchr" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="5" ordinal="22" precision="-1" scale="-1" vendor-type-name="smallint" is-primary-key="false" />
- <schema-column-node name="pbl_fptc" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="5" ordinal="23" precision="-1" scale="-1" vendor-type-name="smallint" is-primary-key="false" />
- <schema-column-node name="pbl_ffce" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="24" precision="32" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="pbt_cmnt" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="25" precision="254" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- </schema-table-node>
- <schema-table-node name="pbcatvld" 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="pbv_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="pbv_vald" 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="pbv_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="pbv_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="pbv_msg" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="5" precision="254" scale="-1" vendor-type-name="varchar" 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="user_code" 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="true" />
- <schema-column-node name="user_name" 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="user_en" 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" />
- <schema-column-node name="password" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="4" precision="30" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="user_status" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="5" precision="1" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="party_name" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="6" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="partylevel" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="7" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="duty" 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="department" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="9" 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="YES" java-sql-type="12" ordinal="10" 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="YES" java-sql-type="12" ordinal="11" 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="YES" java-sql-type="12" ordinal="12" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="mobile" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="13" precision="17" 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="YES" java-sql-type="12" ordinal="14" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="operate_date" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="93" ordinal="15" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
- </schema-table-node>
- </schema-connection-node>
- <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="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="false" />
- <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="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="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" />
- <schema-column-node name="pbh_ffce" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="17" precision="32" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="pbl_fhgt" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="5" ordinal="18" precision="-1" scale="-1" vendor-type-name="smallint" is-primary-key="false" />
- <schema-column-node name="pbl_fwgt" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="5" ordinal="19" precision="-1" scale="-1" vendor-type-name="smallint" is-primary-key="false" />
- <schema-column-node name="pbl_fitl" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="20" precision="1" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="pbl_funl" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="21" precision="1" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="pbl_fchr" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="5" ordinal="22" precision="-1" scale="-1" vendor-type-name="smallint" is-primary-key="false" />
- <schema-column-node name="pbl_fptc" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="5" ordinal="23" precision="-1" scale="-1" vendor-type-name="smallint" is-primary-key="false" />
- <schema-column-node name="pbl_ffce" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="24" precision="32" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="pbt_cmnt" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="25" precision="254" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- </schema-table-node>
- <schema-table-node name="pbcatvld" 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="pbv_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="pbv_vald" 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="pbv_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="pbv_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="pbv_msg" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="5" precision="254" scale="-1" vendor-type-name="varchar" 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="user_code" 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="true" />
- <schema-column-node name="user_name" 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="user_en" 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" />
- <schema-column-node name="password" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="4" precision="30" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="user_status" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="5" precision="1" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="party_name" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="6" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="partylevel" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="7" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="duty" 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="department" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="9" 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="YES" java-sql-type="12" ordinal="10" 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="YES" java-sql-type="12" ordinal="11" 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="YES" java-sql-type="12" ordinal="12" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="mobile" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="13" precision="17" 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="YES" java-sql-type="12" ordinal="14" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="operate_date" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="93" ordinal="15" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
- </schema-table-node>
- </schema-connection-node>
- <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="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="false" />
- <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="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="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" />
- <schema-column-node name="pbh_ffce" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="17" precision="32" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="pbl_fhgt" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="5" ordinal="18" precision="-1" scale="-1" vendor-type-name="smallint" is-primary-key="false" />
- <schema-column-node name="pbl_fwgt" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="5" ordinal="19" precision="-1" scale="-1" vendor-type-name="smallint" is-primary-key="false" />
- <schema-column-node name="pbl_fitl" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="20" precision="1" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="pbl_funl" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="21" precision="1" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="pbl_fchr" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="5" ordinal="22" precision="-1" scale="-1" vendor-type-name="smallint" is-primary-key="false" />
- <schema-column-node name="pbl_fptc" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="5" ordinal="23" precision="-1" scale="-1" vendor-type-name="smallint" is-primary-key="false" />
- <schema-column-node name="pbl_ffce" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="24" precision="32" scale="-1" vendor-type-name="char" is-primary-key="false" />
- <schema-column-node name="pbt_cmnt" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="25" precision="254" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- </schema-table-node>
- <schema-table-node name="pbcatvld" 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="pbv_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="pbv_vald" 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="pbv_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="pbv_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="pbv_msg" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="5" precision="254" scale="-1" vendor-type-name="varchar" 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="user_code" 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="true" />
- <schema-column-node name="user_name" 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="user_en" 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" />
- <schema-column-node name="password" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="4" precision="30" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="user_status" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="5" precision="1" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="party_name" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="6" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="partylevel" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="7" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="duty" 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="department" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="9" 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="YES" java-sql-type="12" ordinal="10" 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="YES" java-sql-type="12" ordinal="11" 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="YES" java-sql-type="12" ordinal="12" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="mobile" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="13" precision="17" 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="YES" java-sql-type="12" ordinal="14" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
- <schema-column-node name="operate_date" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="93" ordinal="15" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
- </schema-table-node>
- </schema-connection-node>
- </schema-root-node>]]></ejb-modeler-schema.xml>
- <ejb-modeler-layout.xml extralocation="" timestamp="1063250457355"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
- <layout>
- <view>
- <name>Default</name>
- <ejb>
- <name>Apps</name>
- <x>186</x>
- <y>97</y>
- <width>68</width>
- <height>22</height>
- </ejb>
- <ejb>
- <name>SequenceGenerator</name>
- <x>186</x>
- <y>169</y>
- <width>149</width>
- <height>22</height>
- </ejb>
- <ejb>
- <name>Sequence</name>
- <x>304</x>
- <y>97</y>
- <width>94</width>
- <height>22</height>
- </ejb>
- <ejb>
- <name>VaoPort</name>
- <x>371</x>
- <y>23</y>
- <width>84</width>
- <height>22</height>
- </ejb>
- <ejb>
- <name>ServerDataModule</name>
- <x>180</x>
- <y>25</y>
- <width>141</width>
- <height>22</height>
- </ejb>
- </view>
- </layout>]]></ejb-modeler-layout.xml>
- </descriptors>