nwattribs.xsd

wrox出版社的另一套经典的VB2005数据库编程学习书籍,收集了书中源码,郑重推荐,电子书,电子书下载

<?xml version="1.0" standalone="yes"?>
<xs:schema id="Northwind" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
  <xs:element name="Northwind" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Customers">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CustomerID" type="xs:string" minOccurs="0" msdata:Ordinal="0" />
              <xs:element name="CompanyName" type="xs:string" minOccurs="0" msdata:Ordinal="1" />
              <xs:element name="ContactName" type="xs:string" minOccurs="0" msdata:Ordinal="2" />
              <xs:element name="ContactTitle" type="xs:string" minOccurs="0" msdata:Ordinal="3" />
              <xs:element name="Address" type="xs:string" minOccurs="0" msdata:Ordinal="4" />
              <xs:element name="City" type="xs:string" minOccurs="0" msdata:Ordinal="5" />
              <xs:element name="Region" type="xs:string" minOccurs="0" msdata:Ordinal="6" />
              <xs:element name="PostalCode" type="xs:string" minOccurs="0" msdata:Ordinal="7" />
              <xs:element name="Country" type="xs:string" minOccurs="0" msdata:Ordinal="8" />
              <xs:element name="Phone" type="xs:string" minOccurs="0" msdata:Ordinal="9" />
              <xs:element name="Fax" type="xs:string" minOccurs="0" msdata:Ordinal="10" />
              <xs:element name="Orders" minOccurs="0" maxOccurs="unbounded">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element name="OrderID" type="xs:string" minOccurs="0" msdata:Ordinal="0" />
                    <xs:element name="CustomerID" type="xs:string" minOccurs="0" msdata:Ordinal="1" />
                    <xs:element name="EmployeeID" type="xs:string" minOccurs="0" msdata:Ordinal="2" />
                    <xs:element name="OrderDate" type="xs:string" minOccurs="0" msdata:Ordinal="3" />
                    <xs:element name="RequiredDate" type="xs:string" minOccurs="0" msdata:Ordinal="4" />
                    <xs:element name="ShippedDate" type="xs:string" minOccurs="0" msdata:Ordinal="5" />
                    <xs:element name="ShipVia" type="xs:string" minOccurs="0" msdata:Ordinal="6" />
                    <xs:element name="Freight" type="xs:string" minOccurs="0" msdata:Ordinal="7" />
                    <xs:element name="ShipName" type="xs:string" minOccurs="0" msdata:Ordinal="8" />
                    <xs:element name="ShipAddress" type="xs:string" minOccurs="0" msdata:Ordinal="9" />
                    <xs:element name="ShipCity" type="xs:string" minOccurs="0" msdata:Ordinal="10" />
                    <xs:element name="ShipRegion" type="xs:string" minOccurs="0" msdata:Ordinal="11" />
                    <xs:element name="ShipPostalCode" type="xs:string" minOccurs="0" msdata:Ordinal="12" />
                    <xs:element name="ShipCountry" type="xs:string" minOccurs="0" msdata:Ordinal="13" />
                    <xs:element name="Order_Details" minOccurs="0" maxOccurs="unbounded">
                      <xs:complexType>
                        <xs:sequence>
                          <xs:element name="OrderID" type="xs:string" minOccurs="0" msdata:Ordinal="0" />
                          <xs:element name="ProductID" type="xs:string" minOccurs="0" msdata:Ordinal="1" />
                          <xs:element name="UnitPrice" type="xs:string" minOccurs="0" msdata:Ordinal="2" />
                          <xs:element name="Quantity" type="xs:string" minOccurs="0" msdata:Ordinal="3" />
                          <xs:element name="Discount" type="xs:string" minOccurs="0" msdata:Ordinal="4" />
                        </xs:sequence>
                        <xs:attribute name="totalAmount" type="xs:string" />
                      </xs:complexType>
                    </xs:element>
                  </xs:sequence>
                  <xs:attribute name="detailCount" type="xs:string" />
                </xs:complexType>
              </xs:element>
            </xs:sequence>
            <xs:attribute name="orderCount" type="xs:string" />
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
  </xs:element>
</xs:schema>