<?xml version="1.0" encoding="UTF-8"?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified">
	<xsd:element name="tpcNestedDB">
		<xsd:annotation>
			<xsd:documentation>Comment describing your root element</xsd:documentation>
		</xsd:annotation>
		<xsd:complexType>
			<xsd:all>
				<xsd:element name="suppliers" minOccurs="0">
					<xsd:complexType>
						<xsd:all>
							<xsd:element name="supplier" minOccurs="0" maxOccurs="unbounded">
								<xsd:complexType>
									<xsd:all>
										<xsd:element name="name" type="xsd:string"/>
										<xsd:element name="nation" type="xsd:string" nillable="true"/>
										<xsd:element name="region" type="xsd:string" nillable="true"/>
										<xsd:element name="part" minOccurs="0" maxOccurs="unbounded">
											<xsd:complexType>
												<xsd:all>
													<xsd:element name="name" type="xsd:string"/>
													<xsd:element name="order" minOccurs="0" maxOccurs="unbounded">
														<xsd:complexType>
															<xsd:all>
																<xsd:element name="orderkey" type="xsd:string"/>
																<xsd:element name="custID" type="xsd:string"/>
																<xsd:element name="status" type="xsd:string"/>
															</xsd:all>
														</xsd:complexType>
													</xsd:element>
												</xsd:all>
											</xsd:complexType>
										</xsd:element>
									</xsd:all>
								</xsd:complexType>
							</xsd:element>
						</xsd:all>
					</xsd:complexType>
				</xsd:element>
				<xsd:element name="customers" minOccurs="0">
					<xsd:complexType>
						<xsd:all>
							<xsd:element name="customer" minOccurs="0" maxOccurs="unbounded">
								<xsd:complexType>
									<xsd:all>
										<xsd:element name="custID" type="xsd:string"/>
										<xsd:element name="name" type="xsd:string"/>
										<xsd:element name="cnation" type="xsd:string" nillable="true"/>
									</xsd:all>
								</xsd:complexType>
							</xsd:element>
						</xsd:all>
					</xsd:complexType>
				</xsd:element>
			</xsd:all>
		</xsd:complexType>
		<xsd:key name="tk1">
			<xsd:selector xpath="./customers/customer"/>
			<xsd:field xpath="custID"/>
		</xsd:key>
		<xsd:keyref name="tfk1" refer="tk1">
			<xsd:selector xpath="./suppliers/supplier/part/order"/>
			<xsd:field xpath="custID"/>
		</xsd:keyref>
	</xsd:element>
</xsd:schema>
