home *** CD-ROM | disk | FTP | other *** search
/ Internet Magazine 2002 December / INTERNET97.ISO / pc / software / windows / building / xmlspy / setup44.exe / Data1.cab / DBschema2xml.xsd < prev    next >
Encoding:
Extensible Markup Language  |  2002-02-04  |  6.4 KB  |  217 lines
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!-- edited with XML Spy v4.3 beta 6 U (http://www.xmlspy.com) by Alex Pilz (pilzindustries) -->
  3. <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="unqualified" attributeFormDefault="unqualified">
  4.     <xs:element name="Altova">
  5.         <xs:complexType>
  6.             <xs:sequence>
  7.                 <xs:element name="PrimaryKey" type="xs:integer"/>
  8.                 <xs:element name="a">
  9.                     <xs:simpleType>
  10.                         <xs:restriction base="xs:string">
  11.                             <xs:maxLength value="255"/>
  12.                         </xs:restriction>
  13.                     </xs:simpleType>
  14.                 </xs:element>
  15.                 <xs:element name="xsi">
  16.                     <xs:simpleType>
  17.                         <xs:restriction base="xs:string">
  18.                             <xs:maxLength value="255"/>
  19.                         </xs:restriction>
  20.                     </xs:simpleType>
  21.                 </xs:element>
  22.                 <xs:element name="schemaLocation">
  23.                     <xs:simpleType>
  24.                         <xs:restriction base="xs:string">
  25.                             <xs:maxLength value="255"/>
  26.                         </xs:restriction>
  27.                     </xs:simpleType>
  28.                 </xs:element>
  29.                 <xs:element ref="Division" minOccurs="0" maxOccurs="unbounded"/>
  30.             </xs:sequence>
  31.             <xs:attribute name="Name" type="xs:string"/>
  32.         </xs:complexType>
  33.         <xs:key name="Altova_Primary">
  34.             <xs:selector xpath="."/>
  35.             <xs:field xpath="PrimaryKey"/>
  36.         </xs:key>
  37.     </xs:element>
  38.     <xs:element name="Division">
  39.         <xs:complexType>
  40.             <xs:sequence>
  41.                 <xs:element name="PrimaryKey" type="xs:integer"/>
  42.                 <xs:element name="ForeignKey" type="xs:integer"/>
  43.                 <xs:element name="ProfitCenter">
  44.                     <xs:simpleType>
  45.                         <xs:restriction base="xs:string">
  46.                             <xs:maxLength value="255"/>
  47.                         </xs:restriction>
  48.                     </xs:simpleType>
  49.                 </xs:element>
  50.                 <xs:element name="Desc">
  51.                     <xs:simpleType>
  52.                         <xs:restriction base="xs:string">
  53.                             <xs:maxLength value="255"/>
  54.                         </xs:restriction>
  55.                     </xs:simpleType>
  56.                 </xs:element>
  57.                 <xs:element name="Established">
  58.                     <xs:simpleType>
  59.                         <xs:restriction base="xs:string">
  60.                             <xs:maxLength value="255"/>
  61.                         </xs:restriction>
  62.                     </xs:simpleType>
  63.                 </xs:element>
  64.                 <xs:element name="Manager">
  65.                     <xs:simpleType>
  66.                         <xs:restriction base="xs:string">
  67.                             <xs:maxLength value="255"/>
  68.                         </xs:restriction>
  69.                     </xs:simpleType>
  70.                 </xs:element>
  71.                 <xs:element name="Name">
  72.                     <xs:simpleType>
  73.                         <xs:restriction base="xs:string">
  74.                             <xs:maxLength value="255"/>
  75.                         </xs:restriction>
  76.                     </xs:simpleType>
  77.                 </xs:element>
  78.                 <xs:element name="URL">
  79.                     <xs:simpleType>
  80.                         <xs:restriction base="xs:string">
  81.                             <xs:maxLength value="255"/>
  82.                         </xs:restriction>
  83.                     </xs:simpleType>
  84.                 </xs:element>
  85.                 <xs:element ref="Person" minOccurs="0" maxOccurs="unbounded"/>
  86.                 <xs:element ref="VIP" minOccurs="0" maxOccurs="unbounded"/>
  87.             </xs:sequence>
  88.         </xs:complexType>
  89.         <xs:keyref name="Division_Foreign" refer="Altova_Primary">
  90.             <xs:selector xpath="."/>
  91.             <xs:field xpath="ForeignKey"/>
  92.         </xs:keyref>
  93.         <xs:key name="Division_Primary">
  94.             <xs:selector xpath="."/>
  95.             <xs:field xpath="PrimaryKey"/>
  96.         </xs:key>
  97.     </xs:element>
  98.     <xs:element name="Person">
  99.         <xs:complexType>
  100.             <xs:sequence>
  101.                 <xs:element name="PrimaryKey" type="xs:integer"/>
  102.                 <xs:element name="ForeignKey" type="xs:integer"/>
  103.                 <xs:element name="Mgr">
  104.                     <xs:simpleType>
  105.                         <xs:restriction base="xs:string">
  106.                             <xs:maxLength value="255"/>
  107.                         </xs:restriction>
  108.                     </xs:simpleType>
  109.                 </xs:element>
  110.                 <xs:element name="Prg">
  111.                     <xs:simpleType>
  112.                         <xs:restriction base="xs:string">
  113.                             <xs:maxLength value="255"/>
  114.                         </xs:restriction>
  115.                     </xs:simpleType>
  116.                 </xs:element>
  117.                 <xs:element name="First">
  118.                     <xs:simpleType>
  119.                         <xs:restriction base="xs:string">
  120.                             <xs:maxLength value="255"/>
  121.                         </xs:restriction>
  122.                     </xs:simpleType>
  123.                 </xs:element>
  124.                 <xs:element name="ID">
  125.                     <xs:simpleType>
  126.                         <xs:restriction base="xs:string">
  127.                             <xs:maxLength value="255"/>
  128.                         </xs:restriction>
  129.                     </xs:simpleType>
  130.                 </xs:element>
  131.                 <xs:element name="Last">
  132.                     <xs:simpleType>
  133.                         <xs:restriction base="xs:string">
  134.                             <xs:maxLength value="255"/>
  135.                         </xs:restriction>
  136.                     </xs:simpleType>
  137.                 </xs:element>
  138.                 <xs:element name="PhoneExt" type="xs:integer"/>
  139.             </xs:sequence>
  140.         </xs:complexType>
  141.         <xs:keyref name="Person_Foreign" refer="Division_Primary">
  142.             <xs:selector xpath="."/>
  143.             <xs:field xpath="ForeignKey"/>
  144.         </xs:keyref>
  145.         <xs:key name="Person_Primary">
  146.             <xs:selector xpath="."/>
  147.             <xs:field xpath="PrimaryKey"/>
  148.         </xs:key>
  149.     </xs:element>
  150.     <xs:element name="VIP">
  151.         <xs:complexType>
  152.             <xs:sequence>
  153.                 <xs:element name="PrimaryKey" type="xs:integer"/>
  154.                 <xs:element name="ForeignKey" type="xs:integer"/>
  155.                 <xs:element name="Mgr">
  156.                     <xs:simpleType>
  157.                         <xs:restriction base="xs:string">
  158.                             <xs:maxLength value="255"/>
  159.                         </xs:restriction>
  160.                     </xs:simpleType>
  161.                 </xs:element>
  162.                 <xs:element name="Prg">
  163.                     <xs:simpleType>
  164.                         <xs:restriction base="xs:string">
  165.                             <xs:maxLength value="255"/>
  166.                         </xs:restriction>
  167.                     </xs:simpleType>
  168.                 </xs:element>
  169.                 <xs:element name="Club">
  170.                     <xs:simpleType>
  171.                         <xs:restriction base="xs:string">
  172.                             <xs:maxLength value="255"/>
  173.                         </xs:restriction>
  174.                     </xs:simpleType>
  175.                 </xs:element>
  176.                 <xs:element name="First">
  177.                     <xs:simpleType>
  178.                         <xs:restriction base="xs:string">
  179.                             <xs:maxLength value="255"/>
  180.                         </xs:restriction>
  181.                     </xs:simpleType>
  182.                 </xs:element>
  183.                 <xs:element name="ID">
  184.                     <xs:simpleType>
  185.                         <xs:restriction base="xs:string">
  186.                             <xs:maxLength value="255"/>
  187.                         </xs:restriction>
  188.                     </xs:simpleType>
  189.                 </xs:element>
  190.                 <xs:element name="Last">
  191.                     <xs:simpleType>
  192.                         <xs:restriction base="xs:string">
  193.                             <xs:maxLength value="255"/>
  194.                         </xs:restriction>
  195.                     </xs:simpleType>
  196.                 </xs:element>
  197.                 <xs:element name="PhoneExt" type="xs:integer"/>
  198.                 <xs:element name="Title">
  199.                     <xs:simpleType>
  200.                         <xs:restriction base="xs:string">
  201.                             <xs:maxLength value="255"/>
  202.                         </xs:restriction>
  203.                     </xs:simpleType>
  204.                 </xs:element>
  205.             </xs:sequence>
  206.         </xs:complexType>
  207.         <xs:keyref name="Vip_Foreign" refer="Division_Primary">
  208.             <xs:selector xpath="."/>
  209.             <xs:field xpath="ForeignKey"/>
  210.         </xs:keyref>
  211.         <xs:key name="Vip_Primary">
  212.             <xs:selector xpath="."/>
  213.             <xs:field xpath="PrimaryKey"/>
  214.         </xs:key>
  215.     </xs:element>
  216. </xs:schema>
  217.