stuaddedinfo.xsd

来自「c#开发宝典 光盘内容。本光盘主要为书中的源程序」· XSD 代码 · 共 91 行

<?xml version="1.0" encoding="utf-8" ?>
<xs:schema id="StuAddedInfo" targetNamespace="http://tempuri.org/StuAddedInfo.xsd" elementFormDefault="qualified"
  attributeFormDefault="qualified" xmlns="http://tempuri.org/StuAddedInfo.xsd" xmlns:mstns="http://tempuri.org/StuAddedInfo.xsd"
  xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
  <xs:element name="StuAddedInfo" msdata:IsDataSet="true">
    <xs:complexType>
      <xs:choice maxOccurs="unbounded">
        <xs:element name="awards">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="award_ID" msdata:AutoIncrement="true" type="xs:int" />
              <xs:element name="award_studentID" type="xs:string" minOccurs="0" />
              <xs:element name="award_content" type="xs:string" minOccurs="0" />
              <xs:element name="award_reason" type="xs:string" minOccurs="0" />
              <xs:element name="award_date" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="changes">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="change_ID" msdata:AutoIncrement="true" type="xs:int" />
              <xs:element name="change_studentID" type="xs:string" minOccurs="0" />
              <xs:element name="change_changeType" type="xs:int" minOccurs="0" />
              <xs:element name="change_reason" type="xs:string" minOccurs="0" />
              <xs:element name="change_date" type="xs:dateTime" minOccurs="0" />
              <xs:element name="changeType_name" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="punishments">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="punishment_ID" msdata:AutoIncrement="true" type="xs:int" />
              <xs:element name="punishment_studentID" type="xs:string" minOccurs="0" />
              <xs:element name="punishment_typeID" type="xs:int" minOccurs="0" />
              <xs:element name="punishment_reason" type="xs:string" minOccurs="0" />
              <xs:element name="punishment_date" type="xs:dateTime" minOccurs="0" />
              <xs:element name="punishment_isMoved" type="xs:boolean" minOccurs="0" />
              <xs:element name="punishmentType_name" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="changeTypes">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="changeType_ID" type="xs:int" />
              <xs:element name="changeType_name" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="punishmentTypes">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="punishmentType_ID" type="xs:int" />
              <xs:element name="punishmentType_name" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="StuAddedInfoKey1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:awards" />
      <xs:field xpath="mstns:award_ID" />
    </xs:unique>
    <xs:unique name="StuAddedInfoKey2" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:changes" />
      <xs:field xpath="mstns:change_ID" />
    </xs:unique>
    <xs:unique name="StuAddedInfoKey3" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:punishments" />
      <xs:field xpath="mstns:punishment_ID" />
    </xs:unique>
    <xs:unique name="StuAddedInfoKey4" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:changeTypes" />
      <xs:field xpath="mstns:changeType_ID" />
    </xs:unique>
    <xs:unique name="StuAddedInfoKey5" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:punishmentTypes" />
      <xs:field xpath="mstns:punishmentType_ID" />
    </xs:unique>
    <xs:keyref name="changeTypeschanges" refer="StuAddedInfoKey4" msdata:ConstraintOnly="true">
      <xs:selector xpath=".//mstns:changes" />
      <xs:field xpath="mstns:change_changeType" />
    </xs:keyref>
    <xs:keyref name="punishmentTypespunishments" refer="StuAddedInfoKey5">
      <xs:selector xpath=".//mstns:punishments" />
      <xs:field xpath="mstns:punishment_typeID" />
    </xs:keyref>
  </xs:element>
</xs:schema>