ejb-modeler-schema.xml~5~

一个很不错的电子商务后台管理系统 这是一个电子商务网站的后台管理系统 要运行此系统必须具备以下条件 1.首先要把SNSQL文本中的SQL脚本确保在SQL Server中执行 2.包Se

      <schema-column-node name="orderUser" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="2" precision="50" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
    </schema-table-node>
    <schema-table-node name="product" node-type="1" status="0" catalog="null-object" ref="false null weblogic.jdbc.sqlserver.SQLServerDriver jdbc:bea:sqlserver://localhost:1433" sql-schema="dbo">
      <schema-column-node name="assprice" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="6" ordinal="7" precision="-1" scale="-1" vendor-type-name="float" is-primary-key="false" />
      <schema-column-node name="bigcatalog" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="10" precision="20" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="brand" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="3" precision="20" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="explain" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="-1" ordinal="9" precision="-1" scale="-1" vendor-type-name="text" is-primary-key="false" />
      <schema-column-node name="pictrue" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="8" precision="150" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="pID" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="1" precision="50" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="pname" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="2" precision="20" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="price" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="6" ordinal="6" precision="-1" scale="-1" vendor-type-name="float" is-primary-key="false" />
      <schema-column-node name="smaillcatalog" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="11" precision="30" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="spec" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="4" precision="15" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="unit" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="5" precision="50" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
    </schema-table-node>
    <schema-table-node name="smallcatalog" node-type="1" status="0" catalog="null-object" ref="false null weblogic.jdbc.sqlserver.SQLServerDriver jdbc:bea:sqlserver://localhost:1433" sql-schema="dbo">
      <schema-column-node name="catalog" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="1" precision="20" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="order" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="4" ordinal="2" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
    </schema-table-node>
    <schema-table-node name="sysconstraints" node-type="1" status="0" catalog="null-object" ref="false null weblogic.jdbc.sqlserver.SQLServerDriver jdbc:bea:sqlserver://localhost:1433" sql-schema="dbo">
      <schema-column-node name="actions" 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="colid" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="5" ordinal="3" precision="-1" scale="-1" vendor-type-name="smallint" is-primary-key="false" />
      <schema-column-node name="constid" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="4" ordinal="1" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
      <schema-column-node name="error" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="4" ordinal="7" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
      <schema-column-node name="id" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="4" ordinal="2" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
      <schema-column-node name="spare1" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="-6" ordinal="4" precision="-1" scale="-1" vendor-type-name="tinyint" is-primary-key="false" />
      <schema-column-node name="status" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="4" ordinal="5" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
    </schema-table-node>
    <schema-table-node name="syssegments" node-type="1" status="0" catalog="null-object" ref="false null weblogic.jdbc.sqlserver.SQLServerDriver jdbc:bea:sqlserver://localhost:1433" sql-schema="dbo">
      <schema-column-node name="name" node-type="2" status="0" col-default="null-object" is-nullable="NO " java-sql-type="12" ordinal="2" precision="10" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="segment" 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="status" node-type="2" status="0" col-default="null-object" is-nullable="NO " java-sql-type="4" ordinal="3" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
    </schema-table-node>
    <schema-table-node name="userInfo" node-type="1" status="0" catalog="null-object" ref="false null weblogic.jdbc.sqlserver.SQLServerDriver jdbc:bea:sqlserver://localhost:1433" sql-schema="dbo">
      <schema-column-node name="address" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="9" precision="50" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="age" 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="email" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="6" precision="50" 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="YES" java-sql-type="12" ordinal="5" precision="30" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="realName" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="2" precision="15" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="sex" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="3" precision="10" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="username" node-type="2" status="0" col-default="null-object" is-nullable="NO " java-sql-type="12" ordinal="1" precision="25" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="userType" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="4" ordinal="7" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
      <schema-column-node name="youBian" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="4" ordinal="8" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
    </schema-table-node>
  </schema-connection-node>
</schema-root-node>