<?xml version="1.0" encoding="utf-8" ?>
<xs:schema id="Flight" targetNamespace="http://tempuri.org/Flight.xsd" elementFormDefault="qualified"
	xmlns="http://tempuri.org/Flight.xsd" xmlns:mstns="http://tempuri.org/Flight.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema"
	xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
	<xs:element name="FlightData" msdata:Locale="zh-CN">
		<xs:complexType>
			<xs:choice maxOccurs="unbounded">
				<xs:element name="Flight">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="FlightId" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" />
							<xs:element name="FlightName" type="xs:string" />
							<xs:element name="DepartureCityId" type="xs:int" />
							<xs:element name="ArrivalCityId" type="xs:int" />
							<xs:element name="DepartureTime" type="xs:dateTime" />
							<xs:element name="ArrivalTime" type="xs:dateTime" />
							<xs:element name="Cabin">
								<xs:complexType>
									<xs:sequence>
										<xs:element name="CabinId" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" />
										<xs:element name="CabinName" type="xs:string" />
										<xs:element name="FlightId" type="xs:int" />
										<xs:element name="RemainTickets" type="xs:int" />
										<xs:element name="Type" type="xs:string" />
										<xs:element name="Price" type="xs:decimal" />
										<xs:element name="Discount" type="xs:double" minOccurs="0" />
									</xs:sequence>
								</xs:complexType>
							</xs:element>
						</xs:sequence>
					</xs:complexType>
				</xs:element>
			</xs:choice>
		</xs:complexType>
		<xs:unique name="FlightDataKey1" msdata:PrimaryKey="true">
			<xs:selector xpath=".//mstns:Flight" />
			<xs:field xpath="mstns:FlightId" />
		</xs:unique>
		<xs:unique name="FlightDataKey2" msdata:PrimaryKey="true">
			<xs:selector xpath=".//mstns:Cabin" />
			<xs:field xpath="mstns:CabinId" />
		</xs:unique>
		<xs:key name="FlightDataKey3">
			<xs:selector xpath=".//mstns:Flight" />
			<xs:field xpath="mstns:FlightId" />
		</xs:key>
		<xs:keyref name="FlightCabin" refer="FlightDataKey1">
			<xs:selector xpath=".//mstns:Cabin" />
			<xs:field xpath="mstns:FlightId" />
		</xs:keyref>
		<xs:key name="FlightDataKey4">
			<xs:selector xpath=".//mstns:Flight" />
			<xs:field xpath="mstns:FlightId" />
		</xs:key>
	</xs:element>
</xs:schema>