<?xml version="1.0" ?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
            xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
BEGIN CALLOUT A
   <xsd:element name="Order" sql:relation="Orders">
      <xsd:complexType>
         <xsd:sequence>
            <xsd:element name="ShipAddress" type="xsd:string" />
            <xsd:element name="ShipCountry" type="xsd:string" />
            <xsd:element name="LineItem" sql:relation="[Order Details]">
               <xsd:annotation>
                  <xsd:appinfo>
                     <sql:relationship parent="Orders"
                                                parent-key="OrderID"
                                                child="[Order Details]"
                         child-key="OrderID" />
                     </xsd:appinfo>
                  </xsd:annotation>
              <xsd:complexType>
                  <xsd:attribute name="Quantity" type="xsd:string" />
                  <xsd:attribute name="Product" type="xsd:IDREF"
                         sql:relation="Products"
                         sql:field="ProductID"
                         sql:prefix="PRODUCT-">
                  <xsd:annotation>
                  <xsd:appinfo>
                     <sql:relationship parent="[Order Details]"
                                                parent-key="ProductID"
                                                child="Products"
                                                child-key="ProductID" />
                        </xsd:appinfo>
                    </xsd:annotation>
                  </xsd:attribute>
              </xsd:complexType>
           </xsd:element>
        </xsd:sequence>
          <xsd:attribute name="OrderID" type="xsd:ID" sql:prefix="ORDER-" />
     </xsd:complexType>
</xsd:element>
END CALLOUT A

BEGIN CALLOUT B
   <xsd:element name="Product" sql:relation="Products">
      <xsd:complexType>
         <xsd:sequence>
            <xsd:element name="ProductName" type="xsd:string" />
         </xsd:sequence>
         <xsd:attribute name="ProductID" type="xsd:ID"
                     sql:prefix="PRODUCT-" />
     </xsd:complexType>
   </xsd:element>
END CALLOUT B

BEGIN CALLOUT C
   <!-- Root element -->
   <xsd:element name="root" sql:is-constant="1">
      <xsd:complexType>
         <xsd:sequence>
           <xsd:element ref="Order" />
           <xsd:element ref="Product" />
         </xsd:sequence>
      </xsd:complexType>
   </xsd:element>
END CALLOUT C
</xsd:schema>