allorders.xsd

来自「Mastering VBNet Include Source Code」· XSD 代码 · 共 78 行

<xsd:schema id="AllOrders" targetNamespace="http://www.tempuri.org/AllOrders.xsd" xmlns="http://www.tempuri.org/AllOrders.xsd" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified">
	<xsd:element name="AllOrders" msdata:IsDataSet="true">
		<xsd:complexType>
			<xsd:choice maxOccurs="unbounded">
				<xsd:element name="Customers">
					<xsd:complexType>
						<xsd:sequence>
							<xsd:element name="CustomerID" type="xsd:string" />
							<xsd:element name="CompanyName" type="xsd:string" />
							<xsd:element name="ContactName" type="xsd:string" minOccurs="0" />
							<xsd:element name="ContactTitle" type="xsd:string" minOccurs="0" />
							<xsd:element name="Address" type="xsd:string" minOccurs="0" />
							<xsd:element name="City" type="xsd:string" minOccurs="0" />
							<xsd:element name="Region" type="xsd:string" minOccurs="0" />
							<xsd:element name="PostalCode" type="xsd:string" minOccurs="0" />
							<xsd:element name="Country" type="xsd:string" minOccurs="0" />
							<xsd:element name="Phone" type="xsd:string" minOccurs="0" />
							<xsd:element name="Fax" type="xsd:string" minOccurs="0" />
						</xsd:sequence>
					</xsd:complexType>
				</xsd:element>
				<xsd:element name="Order_x0020_Details">
					<xsd:complexType>
						<xsd:sequence>
							<xsd:element name="OrderID" type="xsd:int" />
							<xsd:element name="ProductID" type="xsd:int" />
							<xsd:element name="UnitPrice" type="xsd:decimal" />
							<xsd:element name="Quantity" type="xsd:short" />
							<xsd:element name="Discount" type="xsd:float" />
						</xsd:sequence>
					</xsd:complexType>
				</xsd:element>
				<xsd:element name="Orders">
					<xsd:complexType>
						<xsd:sequence>
							<xsd:element name="OrderID" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xsd:int" />
							<xsd:element name="CustomerID" type="xsd:string" minOccurs="0" />
							<xsd:element name="EmployeeID" type="xsd:int" minOccurs="0" />
							<xsd:element name="OrderDate" type="xsd:dateTime" minOccurs="0" />
							<xsd:element name="RequiredDate" type="xsd:dateTime" minOccurs="0" />
							<xsd:element name="ShippedDate" type="xsd:dateTime" minOccurs="0" />
							<xsd:element name="ShipVia" type="xsd:int" minOccurs="0" />
							<xsd:element name="Freight" type="xsd:decimal" minOccurs="0" />
							<xsd:element name="ShipName" type="xsd:string" minOccurs="0" />
							<xsd:element name="ShipAddress" type="xsd:string" minOccurs="0" />
							<xsd:element name="ShipCity" type="xsd:string" minOccurs="0" />
							<xsd:element name="ShipRegion" type="xsd:string" minOccurs="0" />
							<xsd:element name="ShipPostalCode" type="xsd:string" minOccurs="0" />
							<xsd:element name="ShipCountry" type="xsd:string" minOccurs="0" />
						</xsd:sequence>
					</xsd:complexType>
				</xsd:element>
			</xsd:choice>
		</xsd:complexType>
		<xsd:unique name="Constraint1" msdata:PrimaryKey="true">
			<xsd:selector xpath=".//Customers" />
			<xsd:field xpath="CustomerID" />
		</xsd:unique>
		<xsd:unique name="Order_x0020_Details_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
			<xsd:selector xpath=".//Order_x0020_Details" />
			<xsd:field xpath="OrderID" />
			<xsd:field xpath="ProductID" />
		</xsd:unique>
		<xsd:unique name="Orders_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
			<xsd:selector xpath=".//Orders" />
			<xsd:field xpath="OrderID" />
		</xsd:unique>
		<xsd:keyref name="CustomersOrders" refer="Constraint1">
			<xsd:selector xpath=".//Orders" />
			<xsd:field xpath="CustomerID" />
		</xsd:keyref>
		<xsd:keyref name="OrdersOrder_x005F_x0020_Details" refer="Orders_Constraint1">
			<xsd:selector xpath=".//Order_x0020_Details" />
			<xsd:field xpath="OrderID" />
		</xsd:keyref>
	</xsd:element>
</xsd:schema>