datasetquery.xsd

visualc#+sql图书出租管理系统

<?xml version="1.0" standalone="yes" ?>
<xs:schema id="DataSetQuery" targetNamespace="http://www.tempuri.org/DataSetQuery.xsd" xmlns:mstns="http://www.tempuri.org/DataSetQuery.xsd"
	xmlns="http://www.tempuri.org/DataSetQuery.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema"
	xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified">
	<xs:element name="DataSetQuery" msdata:IsDataSet="true" msdata:Locale="zh-CN">
		<xs:complexType>
			<xs:choice maxOccurs="unbounded">
				<xs:element name="Book">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="BookID" type="xs:string" />
							<xs:element name="BookName" type="xs:string" minOccurs="0" />
							<xs:element name="BookWriter" type="xs:string" minOccurs="0" />
							<xs:element name="BookPublish" type="xs:string" minOccurs="0" />
							<xs:element name="BookPublishDate" type="xs:dateTime" minOccurs="0" />
							<xs:element name="BookPrice" type="xs:double" minOccurs="0" />
							<xs:element name="BookSort" type="xs:string" minOccurs="0" />
							<xs:element name="BookAmount" type="xs:int" minOccurs="0" />
							<xs:element name="BookRemain" type="xs:int" minOccurs="0" />
						</xs:sequence>
					</xs:complexType>
				</xs:element>
				<xs:element name="Borrow">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="ReaderID" type="xs:string" />
							<xs:element name="ReaderName" type="xs:string" minOccurs="0" />
							<xs:element name="ReaderPhoneNo" type="xs:string" minOccurs="0" />
							<xs:element name="BookID" type="xs:string" />
							<xs:element name="BookName" type="xs:string" minOccurs="0" />
							<xs:element name="BookWriter" type="xs:string" minOccurs="0" />
							<xs:element name="BorrowDate" type="xs:dateTime" minOccurs="0" />
							<xs:element name="ReturnDate" type="xs:dateTime" minOccurs="0" />
						</xs:sequence>
					</xs:complexType>
				</xs:element>
				<xs:element name="PublishCompany">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="PublishName" type="xs:string" />
							<xs:element name="PublishAddress" type="xs:string" minOccurs="0" />
							<xs:element name="PublishPhoneNo" type="xs:string" minOccurs="0" />
							<xs:element name="PbulishEmail" type="xs:string" minOccurs="0" />
						</xs:sequence>
					</xs:complexType>
				</xs:element>
				<xs:element name="Reader">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="ReaderID" type="xs:string" />
							<xs:element name="ReaderName" type="xs:string" minOccurs="0" />
							<xs:element name="ReaderPassword" type="xs:string" minOccurs="0" />
							<xs:element name="ReaderPhoneNo" type="xs:string" minOccurs="0" />
							<xs:element name="ReaderEmail" type="xs:string" minOccurs="0" />
							<xs:element name="ReaderBorrowedbooks" type="xs:int" minOccurs="0" />
						</xs:sequence>
					</xs:complexType>
				</xs:element>
			</xs:choice>
		</xs:complexType>
		<xs:unique name="Constraint1" msdata:PrimaryKey="true">
			<xs:selector xpath=".//mstns:Book" />
			<xs:field xpath="mstns:BookID" />
		</xs:unique>
		<xs:unique name="PublishCompany_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
			<xs:selector xpath=".//mstns:PublishCompany" />
			<xs:field xpath="mstns:PublishName" />
		</xs:unique>
		<xs:unique name="Reader_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
			<xs:selector xpath=".//mstns:Reader" />
			<xs:field xpath="mstns:ReaderID" />
		</xs:unique>
	</xs:element>
</xs:schema>