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