自动从XSD创建SQL表 [英] Automate creating SQL tables from XSD
本文介绍了自动从XSD创建SQL表的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我有一些XSD文件和包含供应商数据的相关XML文件。我将XML数据导入SQL Server。但首先我需要在SQL Server中设置表以匹配XSD文件中描述的结构。我的问题是，是否有自动创建SQL表的工具或方法？我搜索了XSD到DML，XML到SQL工具，并找到了有用的东西。还有其他人这样做过吗？有关选项的任何建议吗？
I have a few XSD files and associated XML files containing data from a vendor. I will be importing the XML data into SQL Server. But first I need to setup the tables in SQL Server to match the structure described in the XSD files. The question I have, is there a tool or way to automate created the SQL tables? I have searched for XSD to DML, XML to SQL tools and have found anything helpful. Has anyone else done this? Any suggestions on options to try?
推荐答案
看看下面的链接。
http://technet.microsoft.com/en-us/library/ms171993.aspx
http： //stackoverflow.com/questions/138575/how-can-i-create-database-tables-from-xsd-files
<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="IR56B">
<xs:complexType>
<xs:sequence>
<xs:element name="Section"> <!-- Section -->
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:length value="3" />
<xs:pattern value="[0-9a-zA-Z]*" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ERN"> <!-- ERN -->
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:minLength value="1" />
<xs:maxLength value="8" />
<xs:pattern value="[0-9]*" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="YrErReturn"> <!-- Year of Employer’s Return -->
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:length value="4" />
<xs:pattern value="[0-9]*" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="SubDate"> <!-- Submission Date -->
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:length value="8" />
<xs:pattern value="[0-9]*" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ErName"> <!-- Employer’s Name -->
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:minLength value="1" />
<xs:maxLength value="70" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Designation"> <!-- Designation -->
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="25" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="NoRecordBatch"> <!-- No. of Records in Batch -->
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:minLength value="1" />
<xs:maxLength value="5" />
<xs:pattern value="[0-9]*" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="TotIncomeBatch"> <!-- Total Income in Batch -->
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:minLength value="1" />
<xs:maxLength value="11" />
<xs:pattern value="[0-9]*" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Employee" minOccurs="1" maxOccurs="unbounded"> <!-- Employee’s IR56B record -->
<xs:complexType>
<xs:sequence>
<xs:element name="SheetNo"> <!-- Sheet No -->
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:minLength value="1" />
<xs:maxLength value="6" />
<xs:pattern value="[0-9]*" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="HKID" default="AA000000A"> <!-- Employee’s HKID with Check Digit -->
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="9" />
<xs:pattern value="[A-Z a-z]{0,1}[A-Za-z]{1}[0-9]{6}[Aa0-9]{0,1}" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="TypeOfForm"> <!-- Status -->
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:enumeration value="O" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Surname"> <!-- Employee’s Surname -->
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:minLength value="1" />
<xs:maxLength value="20" />
<xs:pattern value="[A-Za-z'\.\-]*" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="GivenName"> <!-- Employee’s Given Names in Full -->
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:minLength value="1" />
<xs:maxLength value="55" />
<xs:pattern value="[A-Z a-z0-9!#%&\*\(\)_\+\-=\\:";& ;apos;<>?,\./@]*\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"NameInChinese\"> <!-- Employee’s Full N ame in Chinese -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"25\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"Sex\"> <!-- Employee’s Sex -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<x s:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:enumeration value=\"M\" />
\t\t\t\t\t\t\t\t\t\t<xs:enumeration value=\"F\" />
\t\t\t\t\t\t\t\t\t\t<xs:enumeration value=\"m\" />
\t\t\t\t\t\t\t\t\t\t<xs:enumeration value=\"f\" />
\t\t\t\t\t\t\t\t\t\t<xs:enumeration value=\"\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"MaritalStatus\"> <!-- Employee’s Marital Status -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:enumeration value=\"1\" />
\t\t\t\t\t\t\t\t\t\t<xs:enumeration value=\"< span class=\"code-keyword\">2\" />
\t\t\t\t\t\t\t\t\t\t<xs:enumeration value=\"\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"PpNum\"> <!-- Employee’s Passport No. and Country of Issue -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"40\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"SpouseName\"> <!-- Spouse’s Name -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"50\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"SpouseHKID\"> <!-- Spouse’s HKID with Check Digit -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"9\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"SpousePpNum\"> <!-- Spouse’s Passport No. and Country of Issue -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\" >
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"40\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"ResAddr\"> <!-- Employee’s Residential Address -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"90\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"AreaCodeResAddr\"> <!-- Area Code of Employee’s Residential Address -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"1\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"PosAddr\"> <!-- Employee’s Postal Address -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"60\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"Capacity\"> <!-- Capacity in which Employed -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"40\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"PtPrinEmp\"> <!-- If Part Time, Name of Principal Employer -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"30\" /< span class=\"code-keyword\">>
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"StartDateOfEmp\"> <!-- Start Date of Employment -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:length value=\"8\" />
\t\t\t\t\t\t\t\t\t\t<xs:pattern value=\"[0 -9]*\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"EndDateOfEmp\"> <!-- End Date of Employment -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:length value=\"8\" />
\t\t\t\t\t\t\t\t\t\t<xs:pattern value=\"[0-9]*\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"PerOfSalary\"> <!-- Period of Salary/Wages -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"19\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"AmtOfSalary\" type=\"amount\" /> <!-- Amount of Salary/Wages -->
\t\t\t\t\t\t\t<xs:element name=\"PerOfLeavePay\"> <!-- Period of Leave Pay -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"19\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"AmtOfLeavePay\" type=\"amount\" /> <!-- Amount of Leave Pay -->
\t\t\t\t\t\t\t<xs:element name=\"PerOfDirectorFee\"> <!-- Period of Director’s Fee -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"19\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"AmtOfDirectorFee\" type=\"amount\" /> <!-- Amount of Director’s Fee -->
\t\t\t\t\t\t\t<xs:element name=\"PerOfCommFee\"> <!-- Period of Commission /Fees -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"19\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"AmtOfCommFee\" type=\"amount\" /> <!-- Amount of Commission /Fees -->
\t\t\t\t\t\t\t<xs:element name=\"PerOfBonus\"> <!-- Period of Bonus -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"19\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"AmtOfBonus\" type=\"amount\" /> <!-- Amount of Bonus -->
\t\t\t\t\t\t\t<xs:element name=\"PerOfBpEtc\"& gt; <!-- Period of Back Pay, Payment in Lieu of Notice, Terminal Awards or
\t\t\t\t\t\t\t\t\tGratuities, etc. -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"19\" < span class=\"code-keyword\">/>
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"AmtOfBpEtc\" type=\"amount\" /> <!-- Amount of Back Pay, Payment in Lieu of Notice, Terminal Awards or
\t\t\t\t\t\t\t\tGratuities, etc. -->
\t\t\t\t\t\t\t<xs:element name=\"PerOfPayRetire\"> <!-- Period of Certain Payments from Retirement Schemes -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"19\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"AmtOfPayRetire\" type=\"amount\" /> <!-- Amount of Certain Payments from Retirement Schemes -->
\t\t\t\t\t\t\t<xs:element name=\"PerOfSalT axPaid\"> <!-- Period of Salaries Tax Paid by Employer -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"19\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"AmtOfSalTaxPaid\" type=\"amount\" /> <!-- Amount of Salaries Tax Paid by Employer -->
\t\t\t\t\t\t\t<xs:element name=\"PerOfEduBen\"> <!-- Period of Education Benefits -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"19\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"AmtOfEduBen\" type=\"amount\" /> <!-- Amount of Education Benefits -->
\t\t\t\t\t\t\t<xs:element name=\"PerOfGainShareOption\"> <!-- Period of Gain Realized Under Share Option Scheme -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"19\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"AmtOfGainShareOption\" type=\"amount\" /> <!-- Amount of Gain Realized Under Share Option Scheme -->
\t\t\t\t\t\t\t<xs:element name=\"NatureOtherRAP1\"> <!-- Nature of 1st Other Rewards, Allowances or Perquisites -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"35\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"PerOfOtherRAP1\"> <!-- Period of 1st Other Rewards, Allowances or Perquisites -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"19\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"AmtOfOtherRAP1\" type=\"amount\" /> <!-- Amount of 1st Other Rewards, Allowances or Perquisites -->
\t\t\t\t\t\t\t<xs:element name=\"NatureOtherRAP2\"> <!-- Nature of 2nd Other Rewards, Allowances or Perquisites -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"35\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"PerOfOtherRAP2\"> <!-- Period of 2nd Other Rewards, Allowances or Perquisites -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"19\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"AmtOfOtherRAP2\" type=\"amount\" /> <!-- Amount of 2nd Other Rewards, Allowances or Perquisites -->
\t\t\t\t\t\t\t<xs:element name=\"NatureOtherRAP3\"> <!-- Nature of 3r d Other Rewards, Allowances or Perquisites -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"35\" />
\t\t\t\t\t\t\t\t\t</xs:r estriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"PerOfOtherRAP3\"> <!-- Period of 3rd Other Rewards, Allowances or Perquisites -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"19\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t< /xs:element>
\t\t\t\t\t\t\t<xs:element name=\"AmtOfOtherRAP3\" type=\"amount\" /> <!-- Amount of 3rd Other Rewards, Allowances or Perquisites -->
\t\t\t\t\t\t\t<xs:element name=\"PerOfPension\"> <!-- Period of Pensions -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"19\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"AmtOfPension\" type=\"amount\" /> <!-- Amount of Pensions -->
\t\t\t\t\t\t\t<xs:element name=\"TotalIncome\"> <!-- Total Income -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:minLength value=\"1\" />
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"9\" />
\t\t\t\t\t\t\t\t\t\t<xs:pattern value=\"[0-9]*\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"PlaceOfResInd\"> & lt;!-- Place of Residence Indicator -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:enumeration value=\"0\" />
\t\t\t\t\t\t\t\t\t\t<xs:enumeration value=\"1\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"AddrOfPlace1\"> <!-- Address of 1st Place of Residence -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"110\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"NatureOfPlace1\"> <!-- Nature of 1st Place of Residence -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"19\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"PerOfPlace1\"> <!-- Period of 1st Place of Residence -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"26\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"RentPaidEr1\" type=\"rentAmt\" /> <!-- Rent of 1st Place of Residence Paid to Landlord by Employer -->
\t\t\t\t\t\t\t<xs:element name=\"RentPaidEe1\" type=\"rentAmt\" /> <!-- Rent of 1st Place of Residence Paid to Landlord by Employee -->
\t\t\t\t\t\t\t<xs:element name=\"RentRefund1\" type=\"rentAmt\" /> <!-- Rent of 1st Place of Residence Refunded to Employee -->
\t\t\t\t\t\t\t<xs:element name=\"RentPaidErByEe1\" type=\"rentAmt\" /> <!-- Rent of 1st Place of Residence Paid to Employer by Employee -->
\t\t\t\t\t\t\t<xs:element name=\"AddrOfPlace2\"> <!-- Address of 2nd Place of Residence -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"110\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"NatureOfPlace2\"> <!-- Nature of 2nd Place of Residence -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"19\" />
\t\t\t\t\t\t\t\t\t</ xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"PerOfPlace2\"> <!-- Period of 2nd Place of Residence -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"26\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"RentPaidEr2\" type=\"rentAmt\" /> <!-- Rent of 2nd Place of Residence Paid to Landlord by Employer -->
\t\t\t\t\t\t\t<xs:element name=\"RentPaidEe2\" type=\"rentAmt\" /> <!-- Rent of 2nd Place of Residence Paid to Landlord by Employee -->
\t\t\t\t\t\t\t<xs:element name=\"RentRefund2\" type=\"rentAmt\" /> <!-- Rent of 2nd Place of Residence Refunded to Employee -->
\t\t\t\t\t\t\t<xs:element name=\"RentPaidErByEe2\" type=\"rentAmt\" /> <!-- Rent of 2nd Place of Residence Paid to Employer by Employee -->
\t\t\t\t\t\t\t<xs:element name=\"OverseaIncInd\"> <!-- Overseas Income Indicator -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:enumeration value=\"0\" />
\t\t\t\t\t\t\t\t\t\t<xs:enumeration value=\"1\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"AmtPaidOverseaCo\"> <!-- Amount Paid by Overseas Company -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"20\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element nam e=\"NameOfOverseaCo\"> <!-- Name of Overseas Company -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"60\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"AddrOfOverseaCo\"> <!-- Address of Overseas Company -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"60\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t\t<xs:element name=\"Remarks\"> <!-- Remarks -->
\t\t\t\t\t\t\t\t<xs:simpleType>
\t\t\t\t\t\t\t\t\t<xs:restriction base=\"xs:string\">
\t\t\t\t\t\t\t\t\t\t<xs:maxLength value=\"60\" />
\t\t\t\t\t\t\t\t\t</xs:restriction>
\t\t\t\t\t\t\t\t</xs:simpleType>
\t\t\t\t\t\t\t</xs:element>
\t\t\t\t\t\t</xs:sequence>
\t\t\t\t\t</xs:complexType>
\t\t\t\t</xs:element>
\t\t\t</xs:sequence>
\t\t</xs:complexType>
\t</xs:element>
\t<xs:simpleType name=\"amount\">
\t\t<xs:restriction base=\"xs:string\">
\t\t\t<xs:maxLength value=\"9\" />
\t\t\t<xs:pattern value=\"[0-9]*\"/>
\t\t</xs:restriction>
\t</xs:simpleType>
\t<xs:simpleType name=\"rentAmt\">
\t\t<xs:restriction base=\"xs:string\">
\t\t\t<xs:maxLength value=\"7\" />
\t\t\t<xs:pattern value=\"[0-9]*\" />
\t\t</xs:restriction>
\t</xs:simpleType>
&l t;/xs:schema>
%&\*\(\)_\+\-=\\:";'<>?,\./@]*" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="NameInChinese"> <!-- Employee’s Full Name in Chinese --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="25" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="Sex"> <!-- Employee’s Sex --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:enumeration value="M" /> <xs:enumeration value="F" /> <xs:enumeration value="m" /> <xs:enumeration value="f" /> <xs:enumeration value="" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="MaritalStatus"> <!-- Employee’s Marital Status --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:enumeration value="1" /> <xs:enumeration value="2" /> <xs:enumeration value="" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="PpNum"> <!-- Employee’s Passport No. and Country of Issue --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="40" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="SpouseName"> <!-- Spouse’s Name --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="SpouseHKID"> <!-- Spouse’s HKID with Check Digit --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="9" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="SpousePpNum"> <!-- Spouse’s Passport No. and Country of Issue --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="40" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="ResAddr"> <!-- Employee’s Residential Address --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="90" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="AreaCodeResAddr"> <!-- Area Code of Employee’s Residential Address --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="1" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="PosAddr"> <!-- Employee’s Postal Address --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="60" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="Capacity"> <!-- Capacity in which Employed --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="40" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="PtPrinEmp"> <!-- If Part Time, Name of Principal Employer --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="30" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="StartDateOfEmp"> <!-- Start Date of Employment --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:length value="8" /> <xs:pattern value="[0-9]*" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="EndDateOfEmp"> <!-- End Date of Employment --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:length value="8" /> <xs:pattern value="[0-9]*" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="PerOfSalary"> <!-- Period of Salary/Wages --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="19" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="AmtOfSalary" type="amount" /> <!-- Amount of Salary/Wages --> <xs:element name="PerOfLeavePay"> <!-- Period of Leave Pay --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="19" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="AmtOfLeavePay" type="amount" /> <!-- Amount of Leave Pay --> <xs:element name="PerOfDirectorFee"> <!-- Period of Director’s Fee --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="19" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="AmtOfDirectorFee" type="amount" /> <!-- Amount of Director’s Fee --> <xs:element name="PerOfCommFee"> <!-- Period of Commission /Fees --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="19" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="AmtOfCommFee" type="amount" /> <!-- Amount of Commission /Fees --> <xs:element name="PerOfBonus"> <!-- Period of Bonus --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="19" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="AmtOfBonus" type="amount" /> <!-- Amount of Bonus --> <xs:element name="PerOfBpEtc"> <!-- Period of Back Pay, Payment in Lieu of Notice, Terminal Awards or Gratuities, etc. --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="19" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="AmtOfBpEtc" type="amount" /> <!-- Amount of Back Pay, Payment in Lieu of Notice, Terminal Awards or Gratuities, etc. --> <xs:element name="PerOfPayRetire"> <!-- Period of Certain Payments from Retirement Schemes --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="19" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="AmtOfPayRetire" type="amount" /> <!-- Amount of Certain Payments from Retirement Schemes --> <xs:element name="PerOfSalTaxPaid"> <!-- Period of Salaries Tax Paid by Employer --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="19" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="AmtOfSalTaxPaid" type="amount" /> <!-- Amount of Salaries Tax Paid by Employer --> <xs:element name="PerOfEduBen"> <!-- Period of Education Benefits --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="19" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="AmtOfEduBen" type="amount" /> <!-- Amount of Education Benefits --> <xs:element name="PerOfGainShareOption"> <!-- Period of Gain Realized Under Share Option Scheme --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="19" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="AmtOfGainShareOption" type="amount" /> <!-- Amount of Gain Realized Under Share Option Scheme --> <xs:element name="NatureOtherRAP1"> <!-- Nature of 1st Other Rewards, Allowances or Perquisites --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="35" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="PerOfOtherRAP1"> <!-- Period of 1st Other Rewards, Allowances or Perquisites --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="19" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="AmtOfOtherRAP1" type="amount" /> <!-- Amount of 1st Other Rewards, Allowances or Perquisites --> <xs:element name="NatureOtherRAP2"> <!-- Nature of 2nd Other Rewards, Allowances or Perquisites --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="35" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="PerOfOtherRAP2"> <!-- Period of 2nd Other Rewards, Allowances or Perquisites --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="19" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="AmtOfOtherRAP2" type="amount" /> <!-- Amount of 2nd Other Rewards, Allowances or Perquisites --> <xs:element name="NatureOtherRAP3"> <!-- Nature of 3rd Other Rewards, Allowances or Perquisites --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="35" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="PerOfOtherRAP3"> <!-- Period of 3rd Other Rewards, Allowances or Perquisites --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="19" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="AmtOfOtherRAP3" type="amount" /> <!-- Amount of 3rd Other Rewards, Allowances or Perquisites --> <xs:element name="PerOfPension"> <!-- Period of Pensions --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="19" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="AmtOfPension" type="amount" /> <!-- Amount of Pensions --> <xs:element name="TotalIncome"> <!-- Total Income --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:minLength value="1" /> <xs:maxLength value="9" /> <xs:pattern value="[0-9]*" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="PlaceOfResInd"> <!-- Place of Residence Indicator --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:enumeration value="0" /> <xs:enumeration value="1" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="AddrOfPlace1"> <!-- Address of 1st Place of Residence --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="110" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="NatureOfPlace1"> <!-- Nature of 1st Place of Residence --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="19" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="PerOfPlace1"> <!-- Period of 1st Place of Residence --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="26" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="RentPaidEr1" type="rentAmt" /> <!-- Rent of 1st Place of Residence Paid to Landlord by Employer --> <xs:element name="RentPaidEe1" type="rentAmt" /> <!-- Rent of 1st Place of Residence Paid to Landlord by Employee --> <xs:element name="RentRefund1" type="rentAmt" /> <!-- Rent of 1st Place of Residence Refunded to Employee --> <xs:element name="RentPaidErByEe1" type="rentAmt" /> <!-- Rent of 1st Place of Residence Paid to Employer by Employee --> <xs:element name="AddrOfPlace2"> <!-- Address of 2nd Place of Residence --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="110" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="NatureOfPlace2"> <!-- Nature of 2nd Place of Residence --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="19" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="PerOfPlace2"> <!-- Period of 2nd Place of Residence --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="26" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="RentPaidEr2" type="rentAmt" /> <!-- Rent of 2nd Place of Residence Paid to Landlord by Employer --> <xs:element name="RentPaidEe2" type="rentAmt" /> <!-- Rent of 2nd Place of Residence Paid to Landlord by Employee --> <xs:element name="RentRefund2" type="rentAmt" /> <!-- Rent of 2nd Place of Residence Refunded to Employee --> <xs:element name="RentPaidErByEe2" type="rentAmt" /> <!-- Rent of 2nd Place of Residence Paid to Employer by Employee --> <xs:element name="OverseaIncInd"> <!-- Overseas Income Indicator --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:enumeration value="0" /> <xs:enumeration value="1" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="AmtPaidOverseaCo"> <!-- Amount Paid by Overseas Company --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="20" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="NameOfOverseaCo"> <!-- Name of Overseas Company --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="60" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="AddrOfOverseaCo"> <!-- Address of Overseas Company --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="60" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="Remarks"> <!-- Remarks --> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="60" /> </xs:restriction> </xs:simpleType> </xs:element> </xs:sequence> </xs:complexType> </xs:element> </xs:sequence> </xs:complexType> </xs:element> <xs:simpleType name="amount"> <xs:restriction base="xs:string"> <xs:maxLength value="9" /> <xs:pattern value="[0-9]*" /> </xs:restriction> </xs:simpleType> <xs:simpleType name="rentAmt"> <xs:restriction base="xs:string"> <xs:maxLength value="7" /> <xs:pattern value="[0-9]*" /> </xs:restriction> </xs:simpleType> </xs:schema>
这篇关于自动从XSD创建SQL表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
