dataset1.xsd

民航订票系统,实现自助订票,方便快捷!请大家放心下载!

<?xml version="1.0" standalone="yes"?>
<xs:schema id="DataSet1" targetNamespace="http://www.tempuri.org/DataSet1.xsd" xmlns:mstns="http://www.tempuri.org/DataSet1.xsd" xmlns="http://www.tempuri.org/DataSet1.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:element name="DataSet1" msdata:IsDataSet="true">
    <xs:complexType>
      <xs:choice maxOccurs="unbounded">
        <xs:element name="dtFltDetails">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="FltNo" type="xs:string" />
              <xs:element name="Origin" type="xs:string" />
              <xs:element name="Destination" type="xs:string" />
              <xs:element name="Deptime" type="xs:dateTime" />
              <xs:element name="Arrtime" type="xs:dateTime" />
              <xs:element name="AircraftType" type="xs:string" />
              <xs:element name="SeatsExec" type="xs:int" />
              <xs:element name="SeatsBn" type="xs:int" />
              <xs:element name="FareExec" type="xs:int" />
              <xs:element name="FareBn" type="xs:int" />
              <xs:element name="LaunchDate" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="dtFltStatus">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="FltNo" type="xs:string" />
              <xs:element name="StatusDate" type="xs:dateTime" />
              <xs:element name="StatusClass" type="xs:string" />
              <xs:element name="Status" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="dtReservations">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="TicketNo" type="xs:string" />
              <xs:element name="FltNo" type="xs:string" />
              <xs:element name="DateOfJourney" type="xs:dateTime" />
              <xs:element name="ClassOfRes" type="xs:string" />
              <xs:element name="Name" type="xs:string" />
              <xs:element name="EMail" type="xs:string" minOccurs="0" />
              <xs:element name="Fare" type="xs:int" />
              <xs:element name="Status" type="xs:int" />
              <xs:element name="ReservedBy" type="xs:string" />
              <xs:element name="DateOfRes" type="xs:dateTime" />
              <xs:element name="TicketConfirmed" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:dtFltDetails" />
      <xs:field xpath="mstns:FltNo" />
    </xs:unique>
    <xs:unique name="dtReservations_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:dtReservations" />
      <xs:field xpath="mstns:TicketNo" />
    </xs:unique>
  </xs:element>
</xs:schema>