dataset1.xsd

来自「做一个关于学生的教务管理系统」· XSD 代码 · 共 39 行

<?xml version="1.0" encoding="utf-8" ?>
<xs:schema id="Dataset1" targetNamespace="http://tempuri.org/Dataset1.xsd" elementFormDefault="qualified" attributeFormDefault="qualified" xmlns="http://tempuri.org/Dataset1.xsd" xmlns:mstns="http://tempuri.org/Dataset1.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
	<xs:element name="Dataset1" msdata:IsDataSet="true">
		<xs:complexType>
			<xs:choice maxOccurs="unbounded">
				<xs:element name="Department">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="Dep_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" />
							<xs:element name="Dep_Number" type="xs:int" />
							<xs:element name="Dep_Name" type="xs:string" />
							<xs:element name="Dep_Head" type="xs:string" />
							<xs:element name="Dep_Des" type="xs:string" minOccurs="0" />
						</xs:sequence>
					</xs:complexType>
				</xs:element>
				<xs:element name="Students">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="Stu_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" />
							<xs:element name="Stu_Number" type="xs:string" />
							<xs:element name="Stu_Name" type="xs:string" />
							<xs:element name="Stu_Age" type="xs:int" />
							<xs:element name="Dep_Number" type="xs:int" />
						</xs:sequence>
					</xs:complexType>
				</xs:element>
			</xs:choice>
		</xs:complexType>
		<xs:unique name="Dataset1Key1" msdata:PrimaryKey="true">
			<xs:selector xpath=".//mstns:Department" />
			<xs:field xpath="mstns:Dep_Number" />
		</xs:unique>
		<xs:unique name="Dataset1Key2" msdata:PrimaryKey="true">
			<xs:selector xpath=".//mstns:Students" />
			<xs:field xpath="mstns:Stu_Number" />
		</xs:unique>
	</xs:element>
</xs:schema>