dsproducts.xsd

Mastering VBNet Include Source Code

<xsd:schema id="DSProducts" targetNamespace="http://www.tempuri.org/DSProducts.xsd" xmlns="http://www.tempuri.org/DSProducts.xsd" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xsd:element name="DSProducts" msdata:IsDataSet="true">
    <xsd:complexType>
      <xsd:choice maxOccurs="unbounded">
        <xsd:element name="Products">
          <xsd:complexType>
            <xsd:sequence>
              <xsd:element name="ProductID" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xsd:int" />
              <xsd:element name="ProductName" type="xsd:string" />
              <xsd:element name="SupplierID" type="xsd:int" minOccurs="0" />
              <xsd:element name="CategoryID" type="xsd:int" minOccurs="0" />
              <xsd:element name="QuantityPerUnit" type="xsd:string" minOccurs="0" />
              <xsd:element name="UnitPrice" type="xsd:decimal" minOccurs="0" />
              <xsd:element name="UnitsInStock" type="xsd:short" minOccurs="0" />
              <xsd:element name="UnitsOnOrder" type="xsd:short" minOccurs="0" />
              <xsd:element name="ReorderLevel" type="xsd:short" minOccurs="0" />
              <xsd:element name="Discontinued" type="xsd:boolean" />
            </xsd:sequence>
          </xsd:complexType>
        </xsd:element>
        <xsd:element name="Categories">
          <xsd:complexType>
            <xsd:sequence>
              <xsd:element name="CategoryID" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xsd:int" />
              <xsd:element name="CategoryName" type="xsd:string" />
              <xsd:element name="Description" type="xsd:string" minOccurs="0" />
              <xsd:element name="Picture" minOccurs="0">
                <xsd:simpleType>
                  <xsd:restriction base="xsd:base64Binary" />
                </xsd:simpleType>
              </xsd:element>
            </xsd:sequence>
          </xsd:complexType>
        </xsd:element>
        <xsd:element name="Suppliers">
          <xsd:complexType>
            <xsd:sequence>
              <xsd:element name="SupplierID" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xsd:int" />
              <xsd:element name="CompanyName" type="xsd:string" />
              <xsd:element name="ContactName" type="xsd:string" minOccurs="0" />
              <xsd:element name="ContactTitle" type="xsd:string" minOccurs="0" />
              <xsd:element name="Address" type="xsd:string" minOccurs="0" />
              <xsd:element name="City" type="xsd:string" minOccurs="0" />
              <xsd:element name="Region" type="xsd:string" minOccurs="0" />
              <xsd:element name="PostalCode" type="xsd:string" minOccurs="0" />
              <xsd:element name="Country" type="xsd:string" minOccurs="0" />
              <xsd:element name="Phone" type="xsd:string" minOccurs="0" />
              <xsd:element name="Fax" type="xsd:string" minOccurs="0" />
              <xsd:element name="HomePage" type="xsd:string" minOccurs="0" />
            </xsd:sequence>
          </xsd:complexType>
        </xsd:element>
      </xsd:choice>
    </xsd:complexType>
    <xsd:unique name="Constraint1" msdata:PrimaryKey="true">
      <xsd:selector xpath=".//Products" />
      <xsd:field xpath="ProductID" />
    </xsd:unique>
    <xsd:unique name="Categories_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xsd:selector xpath=".//Categories" />
      <xsd:field xpath="CategoryID" />
    </xsd:unique>
    <xsd:unique name="Suppliers_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xsd:selector xpath=".//Suppliers" />
      <xsd:field xpath="SupplierID" />
    </xsd:unique>
    <xsd:keyref name="SuppliersProducts" refer="Suppliers_Constraint1">
      <xsd:selector xpath=".//Products" />
      <xsd:field xpath="SupplierID" />
    </xsd:keyref>
    <xsd:keyref name="CategoriesProducts" refer="Categories_Constraint1">
      <xsd:selector xpath=".//Products" />
      <xsd:field xpath="CategoryID" />
    </xsd:keyref>
  </xsd:element>
</xsd:schema>