dataset1.xsd

学生公寓管理系统使用说明： 1.服务器运行环境 SQL 2000 .NET FRAMEWORK 1.1 .NET FRAMEWORK 1.1 CHINESE (SIMPL

<?xml version="1.0" standalone="yes"?>
<xs:schema id="DataSet1" targetNamespace="http://www.tempuri.org/DataSet1.xsd" xmlns:mstns="http://www.tempuri.org/DataSet1.xsd" xmlns="http://www.tempuri.org/DataSet1.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified">
    <xs:element name="DataSet1" msdata:IsDataSet="true" msdata:Locale="zh-CN">
        <xs:complexType>
            <xs:choice maxOccurs="unbounded">
                <xs:element name="Doc_User">
                    <xs:complexType>
                        <xs:sequence>
                            <xs:element name="USERID" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" />
                            <xs:element name="LOGINID" type="xs:string" />
                            <xs:element name="USERNAME" type="xs:string" minOccurs="0" />
                            <xs:element name="UsrPASSWORD" type="xs:string" />
                            <xs:element name="GROUPID" type="xs:int" />
                            <xs:element name="ISSYSTEM" type="xs:int" minOccurs="0" />
                        </xs:sequence>
                    </xs:complexType>
                </xs:element>
                <xs:element name="Student">
                    <xs:complexType>
                        <xs:sequence>
                            <xs:element name="Student_ID" type="xs:long" />
                            <xs:element name="Student_Name" type="xs:string" />
                            <xs:element name="Student_Password" type="xs:string" minOccurs="0" />
                            <xs:element name="Student_Birth" type="xs:string" minOccurs="0" />
                            <xs:element name="Student_Sex" type="xs:string" />
                            <xs:element name="Student_Photo" type="xs:string" minOccurs="0" />
                            <xs:element name="Student_Depart" type="xs:string" />
                            <xs:element name="Student_Course" type="xs:string" />
                            <xs:element name="Student_Postion" type="xs:string" minOccurs="0" />
                            <xs:element name="Room_ID" type="xs:long" minOccurs="0" />
                            <xs:element name="Student_Email" type="xs:string" minOccurs="0" />
                            <xs:element name="Student_LiveCost" type="xs:decimal" minOccurs="0" />
                            <xs:element name="Student_StudyCost" type="xs:decimal" minOccurs="0" />
                            <xs:element name="Student_Address" type="xs:string" minOccurs="0" />
                            <xs:element name="Student_Phone" type="xs:string" minOccurs="0" />
                        </xs:sequence>
                    </xs:complexType>
                </xs:element>
                <xs:element name="Manager">
                    <xs:complexType>
                        <xs:sequence>
                            <xs:element name="Manager_UserName" type="xs:string" />
                            <xs:element name="Manager_Name" type="xs:string" />
                            <xs:element name="Manager_Age" type="xs:int" minOccurs="0" />
                            <xs:element name="Manager_Sex" type="xs:string" />
                            <xs:element name="Manager_Tel" type="xs:long" minOccurs="0" />
                            <xs:element name="Floor_ID" type="xs:short" minOccurs="0" />
                        </xs:sequence>
                    </xs:complexType>
                </xs:element>
            </xs:choice>
        </xs:complexType>
        <xs:unique name="Constraint1" msdata:PrimaryKey="true">
            <xs:selector xpath=".//mstns:Doc_User" />
            <xs:field xpath="mstns:USERID" />
        </xs:unique>
        <xs:unique name="Student_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
            <xs:selector xpath=".//mstns:Student" />
            <xs:field xpath="mstns:Student_ID" />
        </xs:unique>
        <xs:unique name="Manager_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
            <xs:selector xpath=".//mstns:Manager" />
            <xs:field xpath="mstns:Manager_UserName" />
        </xs:unique>
    </xs:element>
</xs:schema>