dsonetomany.xsd

进销存

<?xml version="1.0" standalone="yes" ?>
<xs:schema id="DSOneToMany" targetNamespace="http://www.tempuri.org/DSOneToMany.xsd" xmlns:mstns="http://www.tempuri.org/DSOneToMany.xsd"
	xmlns="http://www.tempuri.org/DSOneToMany.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema"
	xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified">
	<xs:element name="DSOneToMany" msdata:IsDataSet="true" msdata:Locale="zh-CN">
		<xs:complexType>
			<xs:choice maxOccurs="unbounded">
				<xs:element name="Order_x0020_Details">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="OrderID" type="xs:int" />
							<xs:element name="ProductID" type="xs:int" />
							<xs:element name="UnitPrice" type="xs:decimal" />
							<xs:element name="Quantity" type="xs:short" />
							<xs:element name="ItemTotal" msdata:Expression="Quantity * UnitPrice" type="xs:decimal" minOccurs="0" />
							<xs:element name="ProductName" type="xs:string" minOccurs="0" />
						</xs:sequence>
					</xs:complexType>
				</xs:element>
				<xs:element name="Orders">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="OrderID" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int"
								msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" />
							<xs:element name="CustomerID" type="xs:string" minOccurs="0" />
							<xs:element name="EmployeeID" type="xs:int" minOccurs="0" />
							<xs:element name="OrderDate" type="xs:dateTime" minOccurs="0" />
						</xs:sequence>
					</xs:complexType>
				</xs:element>
				<xs:element name="Employees">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="EmployeeID" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" />
							<xs:element name="EmployeeName" msdata:ReadOnly="true" type="xs:string" minOccurs="0" />
						</xs:sequence>
					</xs:complexType>
				</xs:element>
				<xs:element name="Products">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="ProductID" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" />
							<xs:element name="ProductName" type="xs:string" />
							<xs:element name="UnitPrice" type="xs:decimal" minOccurs="0" />
						</xs:sequence>
					</xs:complexType>
				</xs:element>
			</xs:choice>
		</xs:complexType>
		<xs:unique name="Constraint1" msdata:PrimaryKey="true">
			<xs:selector xpath=".//mstns:Order_x0020_Details" />
			<xs:field xpath="mstns:OrderID" />
			<xs:field xpath="mstns:ProductID" />
		</xs:unique>
		<xs:unique name="Orders_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
			<xs:selector xpath=".//mstns:Orders" />
			<xs:field xpath="mstns:OrderID" />
		</xs:unique>
		<xs:unique name="Employees_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
			<xs:selector xpath=".//mstns:Employees" />
			<xs:field xpath="mstns:EmployeeID" />
		</xs:unique>
		<xs:unique name="Products_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
			<xs:selector xpath=".//mstns:Products" />
			<xs:field xpath="mstns:ProductID" />
		</xs:unique>
		<xs:keyref name="OrderToDetails" refer="Orders_Constraint1">
			<xs:selector xpath=".//mstns:Order_x0020_Details" />
			<xs:field xpath="mstns:OrderID" />
		</xs:keyref>
	</xs:element>
</xs:schema>