<?xml version="1.0" ?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    xmlns:dt="urn:schemas-microsoft-com:datatypes"
    xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
  <xsd:element name="Employee" type="EmployeeType"
    sql:relation="Employees"
    sql:key-fields="EmployeeID"
    sql:limit-field="ReportsTo"
    sql:max-depth="6">
  </xsd:element>

  <xsd:complexType name="EmployeeType">
   <xsd:sequence>
    <xsd:element name="Employee" type="EmployeeType"
      sql:relation="Employees"
      sql:key-fields="EmployeeID">
     <xsd:annotation>
      <xsd:appinfo>
       <sql:relationship parent="Employees"
         parent-key="EmployeeID"
         child="Employees"
         child-key="ReportsTo" />
      </xsd:appinfo>
     </xsd:annotation>
    </xsd:element>
   </xsd:sequence>
   <xsd:attribute name="FirstName" type="xsd:string"/>
   <xsd:attribute name="LastName" type="xsd:string"/>
  </xsd:complexType>
</xsd:schema>