testdataset.xsd

来自「《VBA专业项目实例开发》源代码,学习vba必备」· XSD 代码 · 共 33 行

<?xml version="1.0" standalone="yes"?>
<xs:schema id="testdataset" targetNamespace="http://www.tempuri.org/testdataset.xsd" xmlns:mstns="http://www.tempuri.org/testdataset.xsd" xmlns="http://www.tempuri.org/testdataset.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:element name="testdataset" msdata:IsDataSet="true">
    <xs:complexType>
      <xs:choice maxOccurs="unbounded">
        <xs:element name="tblClients">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Address_Line1" type="xs:string" minOccurs="0" />
              <xs:element name="Address_Line2" type="xs:string" minOccurs="0" />
              <xs:element name="CellPhoneNumber" type="xs:string" minOccurs="0" />
              <xs:element name="City" type="xs:string" minOccurs="0" />
              <xs:element name="Client_ID" msdata:AutoIncrement="true" type="xs:int" />
              <xs:element name="Client_Name" type="xs:string" minOccurs="0" />
              <xs:element name="Contact_Person" type="xs:string" minOccurs="0" />
              <xs:element name="EmailAddress" type="xs:string" minOccurs="0" />
              <xs:element name="Fax" type="xs:string" minOccurs="0" />
              <xs:element name="PhoneNumber" type="xs:string" minOccurs="0" />
              <xs:element name="Remarks" type="xs:string" minOccurs="0" />
              <xs:element name="State" type="xs:string" minOccurs="0" />
              <xs:element name="Title" type="xs:string" minOccurs="0" />
              <xs:element name="ZipCode" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblClients" />
      <xs:field xpath="mstns:Client_ID" />
    </xs:unique>
  </xs:element>
</xs:schema>