study.xsd

Source code for VB.NET book - Chapter 6

<?xml version="1.0" standalone="yes"?>
<xs:schema id="Study" targetNamespace="http://www.tempuri.org/Study.xsd" xmlns:mstns="http://www.tempuri.org/Study.xsd" xmlns="http://www.tempuri.org/Study.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:element name="Study" msdata:IsDataSet="true" msdata:Locale="zh-CN">
    <xs:complexType>
      <xs:choice maxOccurs="unbounded">
        <xs:element name="Employees">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="EmployeeID" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" />
              <xs:element name="LastName" type="xs:string" />
              <xs:element name="FirstName" type="xs:string" />
              <xs:element name="Title" type="xs:string" minOccurs="0" />
              <xs:element name="TitleOfCourtesy" type="xs:string" minOccurs="0" />
              <xs:element name="BirthDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="HireDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Address" type="xs:string" minOccurs="0" />
              <xs:element name="City" type="xs:string" minOccurs="0" />
              <xs:element name="Region" type="xs:string" minOccurs="0" />
              <xs:element name="PostalCode" type="xs:string" minOccurs="0" />
              <xs:element name="Country" type="xs:string" minOccurs="0" />
              <xs:element name="HomePhone" type="xs:string" minOccurs="0" />
              <xs:element name="Extension" type="xs:string" minOccurs="0" />
              <xs:element name="Photo" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="Notes" type="xs:string" minOccurs="0" />
              <xs:element name="ReportsTo" type="xs:int" minOccurs="0" />
              <xs:element name="PhotoPath" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Orders">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="OrderID" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" />
              <xs:element name="CustomerID" type="xs:string" minOccurs="0" />
              <xs:element name="EmployeeID" type="xs:int" minOccurs="0" />
              <xs:element name="OrderDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="RequiredDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ShippedDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ShipVia" type="xs:int" minOccurs="0" />
              <xs:element name="Freight" type="xs:decimal" minOccurs="0" />
              <xs:element name="ShipName" type="xs:string" minOccurs="0" />
              <xs:element name="ShipAddress" type="xs:string" minOccurs="0" />
              <xs:element name="ShipCity" type="xs:string" minOccurs="0" />
              <xs:element name="ShipRegion" type="xs:string" minOccurs="0" />
              <xs:element name="ShipPostalCode" type="xs:string" minOccurs="0" />
              <xs:element name="ShipCountry" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Employees" />
      <xs:field xpath="mstns:EmployeeID" />
    </xs:unique>
    <xs:unique name="Orders_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Orders" />
      <xs:field xpath="mstns:OrderID" />
    </xs:unique>
  </xs:element>
</xs:schema>