salesdb_1_app_purchase.tblxmi

来自「一个简单的EJB实例.用DB2连接.JSP页面.很好用.供大家学习」· TBLXMI 代码 · 共 36 行

<?xml version="1.0" encoding="UTF-8"?>
<RDBSchema:RDBTable xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI" xmlns:RDBSchema="RDBSchema.xmi" xmi:id="PURCHASE" name="PURCHASE" primaryKey="PURCHASEPK">
  <database href="META-INF/backends/DB2UDBNT_V8_1/salesdb_1.dbxmi#salesdb"/>
  <schema href="META-INF/backends/DB2UDBNT_V8_1/salesdb_1_APP.schxmi#APP"/>
  <columns xmi:type="RDBSchema:RDBColumn" xmi:id="PURCHASEID" name="PURCHASEID">
    <type xmi:type="RDBSchema:SQLExactNumeric" xmi:id="SQLExactNumeric_1138282785250">
      <originatingType xmi:type="RDBSchema:SQLExactNumeric" href="DB2UDBNT_V8_Primitives.xmi#SQLExactNumeric_3"/>
    </type>
  </columns>
  <columns xmi:type="RDBSchema:RDBColumn" xmi:id="TIMESTMP" name="TIMESTMP">
    <type xmi:type="RDBSchema:SQLCharacterStringType" xmi:id="SQLCharacterStringType_1138282785250" characterSet="800" length="40">
      <originatingType xmi:type="RDBSchema:SQLCharacterStringType" href="DB2UDBNT_V8_Primitives.xmi#SQLCharacterStringType_3"/>
    </type>
  </columns>
  <columns xmi:type="RDBSchema:RDBColumn" xmi:id="ITEMID" name="ITEMID" allowNull="true">
    <type xmi:type="RDBSchema:SQLExactNumeric" xmi:id="SQLExactNumeric_1138282785251">
      <originatingType xmi:type="RDBSchema:SQLExactNumeric" href="DB2UDBNT_V8_Primitives.xmi#SQLExactNumeric_3"/>
    </type>
  </columns>
  <columns xmi:type="RDBSchema:RDBColumn" xmi:id="LOCATIONID" name="LOCATIONID" allowNull="true">
    <type xmi:type="RDBSchema:SQLCharacterStringType" xmi:id="SQLCharacterStringType_1138282785251" characterSet="800" length="5">
      <originatingType xmi:type="RDBSchema:SQLCharacterStringType" href="DB2UDBNT_V8_Primitives.xmi#SQLCharacterStringType_1"/>
    </type>
  </columns>
  <namedGroup xmi:type="RDBSchema:SQLReference" xmi:id="PURCHASEPK" name="PURCHASEPK" members="PURCHASEID" constraint="SQLConstraint_1138282785250"/>
  <namedGroup xmi:type="RDBSchema:RDBReferenceByKey" xmi:id="ITEMFK" name="ITEMFK" members="ITEMID" onDelete="NO ACTION" onUpdate="NO ACTION" constraint="SQLConstraint_1138282785251">
    <target href="META-INF/backends/DB2UDBNT_V8_1/salesdb_1_APP_ITEM.tblxmi#ITEMPK"/>
  </namedGroup>
  <namedGroup xmi:type="RDBSchema:RDBReferenceByKey" xmi:id="LOCATIONFK" name="LOCATIONFK" members="LOCATIONID" onDelete="NO ACTION" onUpdate="NO ACTION" constraint="SQLConstraint_1138282785252">
    <target href="META-INF/backends/DB2UDBNT_V8_1/salesdb_1_APP_LOCATION.tblxmi#ZIPCODEPK"/>
  </namedGroup>
  <constraints xmi:id="SQLConstraint_1138282785250" name="PURCHASEPK" type="PRIMARYKEY" primaryKey="PURCHASEPK"/>
  <constraints xmi:id="SQLConstraint_1138282785251" name="ITEMFK" type="FOREIGNKEY" referenceByKey="ITEMFK"/>
  <constraints xmi:id="SQLConstraint_1138282785252" name="LOCATIONFK" type="FOREIGNKEY" referenceByKey="LOCATIONFK"/>
</RDBSchema:RDBTable>