data1.xsd

来自「从数据库导入文件到EXCEL 从EXCEL导入到数据库表 速度快」· XSD 代码 · 共 28 行

<?xml version="1.0" standalone="yes"?>
<xs:schema id="data1" targetNamespace="http://www.tempuri.org/data1.xsd" xmlns:mstns="http://www.tempuri.org/data1.xsd" xmlns="http://www.tempuri.org/data1.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:element name="data1" msdata:IsDataSet="true" msdata:Locale="zh-CN">
    <xs:complexType>
      <xs:choice maxOccurs="unbounded">
        <xs:element name="zSYSSequence">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="zTableName" type="xs:string" />
              <xs:element name="zFieldName" type="xs:string" />
              <xs:element name="zMinValue" type="xs:long" minOccurs="0" />
              <xs:element name="zValidValue" type="xs:long" minOccurs="0" />
              <xs:element name="zMaxValue" type="xs:long" minOccurs="0" />
              <xs:element name="zMemo" type="xs:string" minOccurs="0" />
              <xs:element name="zIsValid" type="xs:int" minOccurs="0" />
              <xs:element name="zCreatedBy" type="xs:string" minOccurs="0" />
              <xs:element name="zDateCreated" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:zSYSSequence" />
      <xs:field xpath="mstns:zTableName" />
    </xs:unique>
  </xs:element>
</xs:schema>