order_data.xsd

来自「某大型国企试用的网上订餐管理系统完整源代码」· XSD 代码 · 共 90 行

<?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="T_ORDER">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="Order_id" type="xs:unsignedInt" minOccurs="0" />
							<xs:element name="Date" type="xs:date" minOccurs="0" />
							<xs:element name="Kind" type="xs:string" minOccurs="0" />
							<xs:element name="send_dest" type="xs:string" minOccurs="0" />
							<xs:element name="User_id" type="xs:string" minOccurs="0" />
							<xs:element name="Name" type="xs:string" minOccurs="0" />
							<xs:element name="Department_id" type="xs:string" minOccurs="0" />
							<xs:element name="Department" type="xs:string" minOccurs="0" />
							<xs:element name="Totel_price" type="xs:float" minOccurs="0" />
							<xs:element name="Free" type="xs:string" minOccurs="0" />
							<xs:element name="Memo" type="xs:string" minOccurs="0" />
							<xs:element name="Menu_Name" type="xs:string" minOccurs="0" />
							<xs:element name="Quantity" type="xs:unsignedInt" minOccurs="0" />
							<xs:element name="balance" type="xs:float" minOccurs="0" />
						</xs:sequence>
					</xs:complexType>
				</xs:element>
				<xs:element name="T_ORDER_DETAIL">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="Order_id" type="xs:unsignedInt" minOccurs="0" />
							<xs:element name="name" type="xs:string" minOccurs="0" />
							<xs:element name="Quantity" type="xs:unsignedInt" minOccurs="0" />
						</xs:sequence>
					</xs:complexType>
				</xs:element>
				<xs:element name="T_BATCH_ORDER">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="BATCH_ORDER_id" type="xs:unsignedInt" minOccurs="0" />
							<xs:element name="Date" type="xs:date" minOccurs="0" />
							<xs:element name="Kind" type="xs:string" minOccurs="0" />
							<xs:element name="Department_id" type="xs:string" minOccurs="0" />
							<xs:element name="Department" type="xs:string" minOccurs="0" />
							<xs:element name="Num" type="xs:int" />
							<xs:element name="send_dest" type="xs:string" minOccurs="0" />
							<xs:element name="Reason" type="xs:string" minOccurs="0" />
							<xs:element name="Manager_id" type="xs:string" minOccurs="0" />
							<xs:element name="Manager_name" type="xs:string" minOccurs="0" />
							<xs:element name="Effect" type="xs:string" minOccurs="0" />
							<xs:element name="Checker_id" type="xs:string" minOccurs="0" />
							<xs:element name="Checker_name" type="xs:string" minOccurs="0" />
						</xs:sequence>
					</xs:complexType>
				</xs:element>
				<xs:element name="Batch_Date_Total">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="Date" type="xs:date" minOccurs="0" />
							<xs:element name="Kind" type="xs:string" minOccurs="0" />
							<xs:element name="Department" type="xs:string" minOccurs="0" />
							<xs:element name="Num" type="xs:int" minOccurs="0" />
						</xs:sequence>
					</xs:complexType>
				</xs:element>
				<xs:element name="Batch_Dep_Total">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="Date" type="xs:date" minOccurs="0" />
							<xs:element name="Kind" type="xs:string" minOccurs="0" />
							<xs:element name="Department" type="xs:string" minOccurs="0" />
							<xs:element name="Num" type="xs:int" minOccurs="0" />
						</xs:sequence>
					</xs:complexType>
				</xs:element>
				<xs:element name="Order_date_Total">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="Date" type="xs:date" minOccurs="0" />
							<xs:element name="Free" type="xs:string" minOccurs="0" />
							<xs:element name="Kind" type="xs:string" />
							<xs:element name="Num" type="xs:int" minOccurs="0" />
							<xs:element name="Totel_price" type="xs:float" minOccurs="0" />
						</xs:sequence>
					</xs:complexType>
				</xs:element>
			</xs:choice>
		</xs:complexType>
	</xs:element>
</xs:schema>