dsproducts.xsd

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

<xsd:schema id="DSProducts" targetNamespace="http://www.tempuri.org/DSProducts.xsd" xmlns="http://www.tempuri.org/DSProducts.xsd" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified">
	<xsd:element name="DSProducts" msdata:IsDataSet="true">
		<xsd:complexType>
			<xsd:choice maxOccurs="unbounded">
				<xsd:element name="Categories">
					<xsd:complexType>
						<xsd:sequence>
							<xsd:element name="CategoryID" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xsd:int" />
							<xsd:element name="CategoryName" type="xsd:string" />
						</xsd:sequence>
					</xsd:complexType>
				</xsd:element>
				<xsd:element name="Products">
					<xsd:complexType>
						<xsd:sequence>
							<xsd:element name="ProductID" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xsd:int" />
							<xsd:element name="ProductName" type="xsd:string" />
							<xsd:element name="SupplierID" type="xsd:int" minOccurs="0" />
							<xsd:element name="CategoryID" type="xsd:int" minOccurs="0" />
							<xsd:element name="QuantityPerUnit" type="xsd:string" minOccurs="0" />
							<xsd:element name="UnitPrice" type="xsd:decimal" minOccurs="0" />
							<xsd:element name="UnitsInStock" type="xsd:short" minOccurs="0" />
							<xsd:element name="UnitsOnOrder" type="xsd:short" minOccurs="0" />
							<xsd:element name="ReorderLevel" type="xsd:short" minOccurs="0" />
							<xsd:element name="Discontinued" type="xsd:boolean" />
						</xsd:sequence>
					</xsd:complexType>
				</xsd:element>
				<xsd:element name="Suppliers">
					<xsd:complexType>
						<xsd:sequence>
							<xsd:element name="SupplierID" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xsd:int" />
							<xsd:element name="CompanyName" type="xsd:string" />
						</xsd:sequence>
					</xsd:complexType>
				</xsd:element>
			</xsd:choice>
		</xsd:complexType>
		<xsd:unique name="Constraint1" msdata:PrimaryKey="true">
			<xsd:selector xpath=".//Categories" />
			<xsd:field xpath="CategoryID" />
		</xsd:unique>
		<xsd:unique name="Products_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
			<xsd:selector xpath=".//Products" />
			<xsd:field xpath="ProductID" />
		</xsd:unique>
		<xsd:unique name="Suppliers_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
			<xsd:selector xpath=".//Suppliers" />
			<xsd:field xpath="SupplierID" />
		</xsd:unique>
		<xsd:keyref name="CategoriesProducts" refer="Constraint1">
			<xsd:selector xpath=".//Products" />
			<xsd:field xpath="CategoryID" />
		</xsd:keyref>
		<xsd:keyref name="SuppliersProducts" refer="Suppliers_Constraint1">
			<xsd:selector xpath=".//Products" />
			<xsd:field xpath="SupplierID" />
		</xsd:keyref>
	</xsd:element>
</xsd:schema>