dspublisherstitles.xsd

来自「150个经典的入门学习程序源代码」· XSD 代码 · 共 39 行

<?xml version="1.0" standalone="yes" ?>
<xs:schema id="dsPublishersTitles" targetNamespace="http://www.tempuri.org/dsPublishersTitles.xsd" xmlns:mstns="http://www.tempuri.org/dsPublishersTitles.xsd" xmlns="http://www.tempuri.org/dsPublishersTitles.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified">
	<xs:element name="dsPublishersTitles" msdata:IsDataSet="true" msdata:Locale="zh-CN">
		<xs:complexType>
			<xs:choice maxOccurs="unbounded">
				<xs:element name="publishers">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="pub_id" type="xs:string" />
							<xs:element name="pub_name" type="xs:string" minOccurs="0" />
						</xs:sequence>
					</xs:complexType>
				</xs:element>
				<xs:element name="titles">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="title_id" type="xs:string" />
							<xs:element name="title" type="xs:string" />
							<xs:element name="pub_id" type="xs:string" minOccurs="0" />
							<xs:element name="price" 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:publishers" />
			<xs:field xpath="mstns:pub_id" />
		</xs:unique>
		<xs:unique name="titles_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
			<xs:selector xpath=".//mstns:titles" />
			<xs:field xpath="mstns:title_id" />
		</xs:unique>
		<xs:keyref name="publisherstitles" refer="mstns:Constraint1">
			<xs:selector xpath=".//mstns:titles" />
			<xs:field xpath="mstns:pub_id" />
		</xs:keyref>
	</xs:element>
</xs:schema>