<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
           xmlns="Omnidex"
           targetNamespace="Omnidex"
           elementFormDefault="qualified"
           version="40400">
  <xs:annotation>
    <xs:documentation xml:lang="en">
      Omnidex schema definition
      Copyright 2006 Dynamic Information Systems Corporation.  All rights reserved.
    </xs:documentation>
  </xs:annotation>

  <!-- ******************* -->
  <!-- *** ENVIRONMENT *** -->
  <!-- ******************* -->
  <!-- *** <environment> *** -->
  <xs:element name="environment" type="environmentType" >
    <xs:annotation>
      <xs:appinfo>table:ENVIRONMENTS</xs:appinfo>
      <xs:documentation source="Omnidex_xsd.html#environment"/>
    </xs:annotation>
  </xs:element>

  <!-- ******************* -->
  <!-- *** ENVIRONMENT *** -->
  <!-- ******************* -->
  <xs:complexType name="environmentType">
    <xs:sequence>
      <!-- *** <environment><name> *** -->
      <xs:element name="name" type="nameType" minOccurs="1" maxOccurs="1" >
        <xs:annotation>
          <xs:appinfo>column:ENVIRONMENTS.NAME datatype:CHARACTER(32)</xs:appinfo>
          <xs:documentation source="Omnidex_xsd.html#environment.name"/>
        </xs:annotation>
      </xs:element>
      <!-- *** <environment><title> *** -->
      <xs:element name="title" type="titleType" minOccurs="0" maxOccurs="1" >
        <xs:annotation>
          <xs:appinfo>column:ENVIRONMENTS.TITLE datatype:CHARACTER(80)</xs:appinfo>
          <xs:documentation source="Omnidex_xsd.html#environment.title"/>
        </xs:annotation>
      </xs:element>
      <!-- *** <environment><globalSettings> *** -->
      <xs:element name="globalSettings" minOccurs="0" maxOccurs="1" >
        <xs:annotation>
          <xs:appinfo>INCLUDE_CHILDREN</xs:appinfo>
          <xs:documentation source="Omnidex_xsd.html#environment.globalSettings"/>
        </xs:annotation>
        <xs:complexType>
          <xs:all>
            <!-- *** <environment><globalSettings><centuryThreshold> *** -->
            <xs:element name="centuryThreshold" type="centuryThresholdType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:ENVIRONMENTS.CENTURY_THRESHOLD datatype:TINYINT</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.globalSettings.centuryThreshold"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><globalSettings><dataCache> *** -->
            <xs:element name="dataCache" type="xs:positiveInteger" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:ENVIRONMENTS.DATA_CACHE datatype:INTEGER</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.globalSettings.dataCache"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><globalSettings><metadataCache> *** -->
            <xs:element name="metadataCache" type="xs:positiveInteger" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:ENVIRONMENTS.METADATA_CACHE datatype:INTEGER</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.globalSettings.metadataCache"/>
              </xs:annotation>
            </xs:element>
          </xs:all>
        </xs:complexType>
      </xs:element>
      <!-- *** <environment><application> *** -->
      <xs:element name="application" type="applicationType" minOccurs="0" maxOccurs="1" >
        <xs:annotation>
          <xs:appinfo>exclude</xs:appinfo>
          <xs:documentation source="Omnidex_xsd.html#environment.application"/>
        </xs:annotation>
      </xs:element>
      <!-- *** <environment><documentation> *** -->
      <xs:element name="documentation" type="documentationType" minOccurs="0" maxOccurs="1" >
        <xs:annotation>
          <xs:appinfo>exclude</xs:appinfo>
          <xs:documentation source="Omnidex_xsd.html#environment.documentation"/>
        </xs:annotation>
      </xs:element>
      <!-- *** <environment><databases> *** -->
      <xs:element name="databases" type="databasesType" minOccurs="1" maxOccurs="1" >
        <xs:annotation>
          <xs:appinfo>table:DATABASES inherit:ENVIRONMENTS.NUMBER ENVIRONMENT_NUMBER</xs:appinfo>
          <xs:documentation source="Omnidex_xsd.html#environment.databases"/>
        </xs:annotation>
      </xs:element>
    </xs:sequence>
    <!-- *** <environment filename=x> *** -->
    <xs:attribute name="filename" type="physicalType" use="optional">
      <xs:annotation>
        <xs:appinfo>column:ENVIRONMENTS.FILENAME datatype:CHARACTER(255)</xs:appinfo>
        <xs:documentation source="Omnidex_xsd.html#environment.filename"/>
      </xs:annotation>
    </xs:attribute>
    <!-- *** <environment number=x> *** -->
    <xs:attribute name="number" type="xs:positiveInteger" use="optional">
      <xs:annotation>
        <xs:appinfo>column:ENVIRONMENTS.NUMBER datatype:INTEGER</xs:appinfo>
        <xs:documentation source="Omnidex_xsd.html#environment.number"/>
      </xs:annotation>
    </xs:attribute>
  </xs:complexType>
  <!-- **************** -->
  <!-- *** DATABASE *** -->
  <!-- **************** -->
  <xs:complexType name="databasesType">
    <xs:sequence>
      <!-- *** <environment><databases><num_databases> *** -->
      <xs:element name="numDatabases" type="xs:positiveInteger" minOccurs="0" maxOccurs="1" >
        <xs:annotation>
          <xs:appinfo>column:ENVIRONMENTS.NUM_DATABASES datatype:INTEGER</xs:appinfo>
          <xs:documentation source="Omnidex_xsd.html#environment.databases.numDatabases"/>
        </xs:annotation>
      </xs:element>
      <!-- *** <environment><databases><database> *** -->
      <xs:element name="database" minOccurs="1" maxOccurs="unbounded">
        <xs:annotation>
          <xs:appinfo>row:DATABASES</xs:appinfo>
          <xs:documentation source="Omnidex_xsd.html#environment.databases.database"/>
        </xs:annotation>
        <xs:complexType>
          <xs:sequence>
            <!-- *** <environment><databases><database><name> *** -->
            <xs:element name="name" type="nameType" minOccurs="1" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:DATABASES.NAME datatype:CHARACTER(32)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.name"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><application> *** -->
            <xs:element name="application" type="applicationType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>exclude</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.application"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><documentation> *** -->
            <xs:element name="documentation" type="documentationType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>exclude</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.documentation"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><connections> *** -->
            <xs:element name="connections" type="connectionsType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>table:DATABASE_CONNECTIONS inherit:ENVIRONMENTS.NUMBER ENVIRONMENT_NUMBER,DATABASES.NUMBER DATABASE_NUMBER</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.connections"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables> *** -->
            <xs:element name="tables" type="tablesType" minOccurs="1" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>table:TABLES inherit:ENVIRONMENTS.NUMBER ENVIRONMENT_NUMBER,DATABASES.NUMBER DATABASE_NUMBER</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables"/>
              </xs:annotation>
            </xs:element>
          </xs:sequence>
          <!-- *** <environment><databases><database number=x> *** -->
          <xs:attribute name="number" type="xs:positiveInteger" use="optional" >
            <xs:annotation>
              <xs:appinfo>column:DATABASES.NUMBER datatype:INTEGER</xs:appinfo>
              <xs:documentation source="Omnidex_xsd.html#environment.databases.database.number"/>
            </xs:annotation>
          </xs:attribute>
          <!-- *** <environment><databases><database subtype=x> *** -->
          <xs:attribute name="subtype" type="databaseSubtypeType" use="optional" >
            <xs:annotation>
              <xs:appinfo>column:DATABASES.SUBTYPE datatype:CHARACTER(32)</xs:appinfo>
              <xs:documentation source="Omnidex_xsd.html#environment.databases.subtype"/>
            </xs:annotation>
          </xs:attribute>
          <!-- *** <environment><databases><database type=x> *** -->
          <xs:attribute name="type" type="databaseTypeType" use="required">
            <xs:annotation>
              <xs:appinfo>column:DATABASES.TYPE datatype:CHARACTER(32)</xs:appinfo>
              <xs:documentation source="Omnidex_xsd.html#environment.databases.database.type"/>
            </xs:annotation>
          </xs:attribute>
          <!-- *** <environment><databases><database version=x> *** -->
          <xs:attribute name="version" type="tokenType" use="optional">
            <xs:annotation>
              <xs:appinfo>column:DATABASES.VERSION datatype:CHARACTER(32)</xs:appinfo>
              <xs:documentation source="Omnidex_xsd.html#environment.databases.database.version"/>
            </xs:annotation>
          </xs:attribute>
        </xs:complexType>
      </xs:element>
    </xs:sequence>
  </xs:complexType>
  <!-- **************************** -->
  <!-- *** DATABASE CONNECTIONS *** -->
  <!-- **************************** -->
  <xs:complexType name="connectionsType">
    <xs:sequence>
      <!-- *** <environment><databases><database><connections><numConnections> *** -->
      <xs:element name="numConnections" type="xs:positiveInteger" minOccurs="0" maxOccurs="1" >
        <xs:annotation>
          <xs:appinfo>column:DATABASES.NUM_CONNECTIONS datatype:INTEGER</xs:appinfo>
          <xs:documentation source="Omnidex_xsd.html#environment.databases.database.connections.numConnections"/>
        </xs:annotation>
      </xs:element>
      <!-- *** <environment><databases><database><connections><connection> *** -->
      <xs:element name="connection" minOccurs="1" maxOccurs="unbounded">
        <xs:annotation>
          <xs:appinfo>row:DATABASE_CONNECTIONS</xs:appinfo>
          <xs:documentation source="Omnidex_xsd.html#environment.databases.database.connections.connection"/>
        </xs:annotation>
        <xs:complexType>
          <xs:sequence>
            <!-- *** <environment><databases><database><connections><connection><name> *** -->
            <xs:element name="name" type="nameType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:DATABASE_CONNECTIONS.NAME datatype:CHARACTER(32)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.connections.connection.name"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><connections><connection><server> *** -->
            <xs:element name="server" type="tokenType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:DATABASE_CONNECTIONS.SERVER datatype:CHARACTER(32)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.connections.connection.server"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><connections><connection><physical> *** -->
            <xs:element name="physical" type="physicalType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:DATABASE_CONNECTIONS.PHYSICAL datatype:CHARACTER(255)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.connections.connection.physical"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><connections><connection><indexPrefix> *** -->
            <xs:element name="indexPrefix" type="physicalType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:DATABASE_CONNECTIONS.INDEX_PREFIX datatype:CHARACTER(255)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.connections.connection.indexPrefix"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><connections><connection><indexMaintenance> *** -->
            <xs:element name="indexMaintenance" type="indexMaintenanceType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:DATABASE_CONNECTIONS.INDEX_MAINTENANCE datatype:CHARACTER(32)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.connections.connection.indexMaintenance"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><connections><connection><dbmsUser> *** -->
            <xs:element name="dbmsUser" type="tokenType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:DATABASE_CONNECTIONS.DBMS_USER datatype:CHARACTER(32)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.connections.connection.dbmsUser"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><connections><connection><dbmsPassword> *** -->
            <xs:element name="dbmsPassword" type="passwordType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:DATABASE_CONNECTIONS.DBMS_PASSWORD datatype:CHARACTER(32)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.connections.connection.dbmsPassword"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><connections><connection><application> *** -->
            <xs:element name="application" type="applicationType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>exclude</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.connections.connection.application"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><connections><connection><documentation> *** -->
            <xs:element name="documentation" type="documentationType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>exclude</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.connections.connection.documentation"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><connections><connection><nodes> *** -->
            <xs:element name="nodes" type="nodesType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>table:DATABASE_CONNECTION_NODES inherit:ENVIRONMENTS.NUMBER ENVIRONMENT_NUMBER,DATABASES.NUMBER DATABASE_NUMBER,DATABASE_CONNECTIONS.NUMBER DATABASE_CONNECTIONS_NUMBER</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.connections.connection.nodes"/>
              </xs:annotation>
            </xs:element>
          </xs:sequence>
          <!-- *** <environment><databases><database><connections><connection number=x> *** -->
          <xs:attribute name="number" type="xs:positiveInteger" use="optional">
            <xs:annotation>
              <xs:appinfo>column:DATABASE_CONNECTIONS.NUMBER datatype:INTEGER</xs:appinfo>
              <xs:documentation source="Omnidex_xsd.html#environment.databases.database.connections.connection.number"/>
            </xs:annotation>
          </xs:attribute>
          <!-- *** <environment><databases><database><connections><connection type=x> *** -->
          <xs:attribute name="type" type="databaseConnectionTypeType" use="required">
            <xs:annotation>
              <xs:appinfo>column:DATABASE_CONNECTIONS.TYPE datatype:CHARACTER(32)</xs:appinfo>
              <xs:documentation source="Omnidex_xsd.html#environment.databases.database.connections.connection.type"/>
            </xs:annotation>
          </xs:attribute>
        </xs:complexType>
      </xs:element>
    </xs:sequence>
  </xs:complexType>
  <!-- ********************** -->
  <!-- *** DATABASE NODES *** -->
  <!-- ********************** -->
  <xs:complexType name="nodesType">
    <xs:sequence>
      <!-- *** <environment><databases><database><connections><connection><nodes><numNodes> *** -->
      <xs:element name="numNodes" type="xs:positiveInteger" minOccurs="0" maxOccurs="1" >
        <xs:annotation>
          <xs:appinfo>column:DATABASE_CONNECTIONS.NUM_NODES datatype:INTEGER</xs:appinfo>
          <xs:documentation source="Omnidex_xsd.html#environment.databases.database.connections.connection.nodes.numNodes"/>
        </xs:annotation>
      </xs:element>
      <!-- *** <environment><databases><database><connections><connection><nodes><node> *** -->
      <xs:element name="node" minOccurs="1" maxOccurs="unbounded">
        <xs:annotation>
          <xs:appinfo>row:DATABASE_CONNECTION_NODES</xs:appinfo>
          <xs:documentation source="Omnidex_xsd.html#environment.databases.database.connections.connection.nodes.node"/>
        </xs:annotation>
        <xs:complexType>
          <xs:all>
            <!-- *** <environment><databases><database><connections><connection><nodes><node><name> *** -->
            <xs:element name="name" type="nameType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:DATABASE_CONNECTION_NODES.NAME datatype:CHARACTER(32)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.connections.connection.nodes.node.name"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><connections><connection><nodes><node><server> *** -->
            <xs:element name="server" type="tokenType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:DATABASE_CONNECTION_NODES.SERVER datatype:CHARACTER(32)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.connections.connection.nodes.node.server"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><connections><connection><nodes><node><physical> *** -->
            <xs:element name="physical" type="physicalType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:DATABASE_CONNECTION_NODES.PHYSICAL datatype:CHARACTER(255)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.connections.connection.nodes.node.physical"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><connections><connection><nodes><node><indexPrefix> *** -->
            <xs:element name="indexPrefix" type="physicalType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:DATABASE_CONNECTION_NODES.INDEX_PREFIX datatype:CHARACTER(255)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.connections.connection.nodes.node.indexPrefix"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><connections><connection><nodes><node><indexMaintenance> *** -->
            <xs:element name="indexMaintenance" type="indexMaintenanceType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:DATABASE_CONNECTION_NODES.INDEX_MAINTENANCE datatype:CHARACTER(32)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.connections.connection.nodes.node.indexMaintenance"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><connections><connection><nodes><node><dbmsUser> *** -->
            <xs:element name="dbmsUser" type="tokenType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:DATABASE_CONNECTION_NODES.DBMS_USER datatype:CHARACTER(32)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.connections.connection.nodes.node.dbsmUser"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><connections><connection><nodes><node><dbmsPassword> *** -->
            <xs:element name="dbmsPassword" type="passwordType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:DATABASE_CONNECTION_NODES.DBMS_PASSWORD datatype:CHARACTER(32)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.connections.connection.nodes.node.dbmsPassword"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><connections><connection><nodes><node><partitionBy> *** -->
            <xs:element name="partitionBy" type="xs:string" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:DATABASE_CONNECTION_NODES.PARTITION_BY datatype:CHARACTER(255)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.connections.connection.nodes.node.partitionBy"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><connections><connection><nodes><node><application> *** -->
            <xs:element name="application" type="applicationType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>exclude</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.connections.connection.nodes.node.application"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><connections><connection><nodes><node><documentation> *** -->
            <xs:element name="documentation" type="documentationType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>exclude</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.connections.connection.nodes.node.documentation"/>
              </xs:annotation>
            </xs:element>
          </xs:all>
          <!-- *** <environment><databases><database><connections><connection><nodes><node number=x> *** -->
          <xs:attribute name="number" type="xs:positiveInteger" use="optional">
            <xs:annotation>
              <xs:appinfo>column:DATABASE_CONNECTION_NODES.NUMBER datatype:INTEGER</xs:appinfo>
              <xs:documentation source="Omnidex_xsd.html#environment.databases.database.connections.connection.nodes.node.number"/>
            </xs:annotation>
          </xs:attribute>
          <!-- *** <environment><databases><database><connections><connection><nodes><node type=x> *** -->
          <xs:attribute name="type" type="databaseConnectionTypeType" use="required">
            <xs:annotation>
              <xs:appinfo>column:DATABASE_CONNECTION_NODES.TYPE datatype:CHARACTER(32)</xs:appinfo>
              <xs:documentation source="Omnidex_xsd.html#environment.databases.database.connections.connection.nodes.node.type"/>
            </xs:annotation>
          </xs:attribute>
        </xs:complexType>
      </xs:element>
    </xs:sequence>
  </xs:complexType>
  <!-- ************** -->
  <!-- *** TABLES *** -->
  <!-- ************** -->
  <xs:complexType name="tablesType">
    <xs:sequence>
      <!-- *** <environment><databases><database><tables><numTables> *** -->
      <xs:element name="numTables" type="xs:positiveInteger" minOccurs="0" maxOccurs="1" >
        <xs:annotation>
          <xs:appinfo>column:DATABASES.NUM_TABLES datatype:INTEGER</xs:appinfo>
          <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.numTables."/>
        </xs:annotation>
      </xs:element>
      <!-- *** <environment><databases><database><tables><table> *** -->
      <xs:element name="table" minOccurs="1" maxOccurs="unbounded">
        <xs:annotation>
          <xs:appinfo>row:TABLES</xs:appinfo>
          <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table."/>
        </xs:annotation>
        <xs:complexType>
          <xs:sequence>
            <!-- *** <environment><databases><database><tables><table><name> *** -->
            <xs:element name="name" type="nameType" minOccurs="1" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:TABLES.NAME datatype:CHARACTER(32)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.name"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><physical> *** -->
            <xs:element name="physical" type="physicalType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:TABLES.PHYSICAL datatype:CHARACTER(255)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.physical"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><options> *** -->
            <xs:element name="options" type="optionsType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:TABLES.OPTIONS datatype:CHARACTER(255)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.options"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><indexMaintenance> *** -->
            <xs:element name="indexMaintenance" type="indexMaintenanceType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:TABLES.INDEX_MAINTENANCE datatype:CHARACTER(32)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexMaintenance"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><dataCaching> *** -->
            <xs:element name="dataCaching" type="tableCachingTypeType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:TABLES.DATA_CACHING datatype:CHARACTER(32)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.dataCaching"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><autoFilter> *** -->
            <xs:element name="autoFilter" type="xs:string" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:TABLES.AUTOFILTER datatype:CHARACTER(256)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.autoFilter"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><as> *** -->
            <xs:element name="as" type="xs:string" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:TABLES.AS datatype:CHARACTER(256)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.as"/>
              </xs:annotation>
            </xs:element>
            <xs:element name="statistics" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>INCLUDE_CHILDREN</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.statistics"/>
              </xs:annotation>
              <xs:complexType>
                <xs:all>
                  <!-- *** <environment><databases><database><tables><table><statistics><cardinality> *** -->
                  <xs:element name="cardinality" type="xs:nonNegativeInteger" minOccurs="0" maxOccurs="1" >
                    <xs:annotation>
                      <xs:appinfo>column:TABLES.CARDINALITY datatype:UNSIGNED INTEGER</xs:appinfo>
                      <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.statistics.cardinality"/>
                    </xs:annotation>
                  </xs:element>
                  <!-- *** <environment><databases><database><tables><table><statistics><dateModified> *** -->
                  <xs:element name="dateModified" type="xs:dateTime" minOccurs="0" maxOccurs="1" >
                    <xs:annotation>
                      <xs:appinfo>column:TABLES.DATE_MODIFIED datatype:DATETIME</xs:appinfo>
                      <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.statistics.dateModified"/>
                    </xs:annotation>
                  </xs:element>
                </xs:all>
              </xs:complexType>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><application> *** -->
            <xs:element name="application" type="applicationType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>exclude</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.application"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><documentation> *** -->
            <xs:element name="documentation" type="documentationType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>exclude</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.documentation"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><indexes> *** -->
            <xs:element name="indexes" type="indexesType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>table:INDEXES inherit:ENVIRONMENTS.NUMBER ENVIRONMENT_NUMBER,DATABASES.NUMBER DATABASE_NUMBER,TABLES.NUMBER TABLE_NUMBER</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><constraints> *** -->
            <xs:element name="constraints" type="constraintsType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>table:TABLE_CONSTRAINTS inherit:ENVIRONMENTS.NUMBER ENVIRONMENT_NUMBER,DATABASES.NUMBER DATABASE_NUMBER,TABLES.NUMBER TABLE_NUMBER</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.constraints"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><partitions> *** -->
            <xs:element name="partitions" type="partitionsType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>table:TABLE_PARTITIONS inherit:ENVIRONMENTS.NUMBER ENVIRONMENT_NUMBER,DATABASES.NUMBER DATABASE_NUMBER,TABLES.NUMBER TABLE_NUMBER</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.partitions"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><columns> *** -->
            <xs:element name="columns" type="columnsType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>table:COLUMNS inherit:ENVIRONMENTS.NUMBER ENVIRONMENT_NUMBER,DATABASES.NUMBER DATABASE_NUMBER,TABLES.NUMBER TABLE_NUMBER</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.columns"/>
              </xs:annotation>
            </xs:element>
          </xs:sequence>
          <!-- *** <environment><databases><database><tables><table cardinality=x> *** -->
          <xs:attribute name="cardinality" type="xs:nonNegativeInteger" use="optional">
            <xs:annotation>
              <xs:appinfo>exclude</xs:appinfo>
              <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.cardinality"/>
            </xs:annotation>
          </xs:attribute>
          <!-- *** <environment><databases><database><tables><table nativeRecordLength=x> *** -->
          <xs:attribute name="nativeRecordLength" type="xs:positiveInteger" use="optional">
            <xs:annotation>
              <xs:appinfo>column:TABLES.NATIVE_RECORD_LENGTH datatype:INTEGER</xs:appinfo>
              <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.nativeRecordLength"/>
            </xs:annotation>
          </xs:attribute>
          <!-- *** <environment><databases><database><tables><table number=x> *** -->
          <xs:attribute name="number" type="xs:positiveInteger" use="optional">
            <xs:annotation>
              <xs:appinfo>column:TABLES.NUMBER datatype:INTEGER</xs:appinfo>
              <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.number"/>
            </xs:annotation>
          </xs:attribute>
          <!-- *** <environment><databases><database><tables><table omnidexTableType=x> *** -->
          <xs:attribute name="omnidexTableType" type="omnidexDomainType" use="optional">
            <xs:annotation>
              <xs:appinfo>column:OMNIDEX_TABLE_TYPE datatype:CHARACTER(32)</xs:appinfo>
              <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.omnidexTableType"/>
            </xs:annotation>
          </xs:attribute>
          <!-- *** <environment><databases><database><tables><table recordLength=x> *** -->
          <xs:attribute name="recordLength" type="xs:positiveInteger" use="optional">
            <xs:annotation>
              <xs:appinfo>column:TABLES.RECORD_LENGTH datatype:INTEGER</xs:appinfo>
              <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.recordLength"/>
            </xs:annotation>
          </xs:attribute>
          <!-- *** <environment><databases><database><tables><table temporary=x> *** -->
          <xs:attribute name="temporary" type="xs:boolean" use="optional">
            <xs:annotation>
              <xs:appinfo>column:TABLES.TEMPORARY datatype:CHARACTER(1)</xs:appinfo>
              <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.temporary"/>
            </xs:annotation>
          </xs:attribute>
          <!-- *** <environment><databases><database><tables><table type=x> *** -->
          <xs:attribute name="type" type="tableTypeType" use="optional">
            <xs:annotation>
              <xs:appinfo>column:TABLES.TYPE datatype:CHARACTER(32)</xs:appinfo>
              <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.type"/>
            </xs:annotation>
          </xs:attribute>
        </xs:complexType>
      </xs:element>
    </xs:sequence>
  </xs:complexType>
  <!-- ****************** -->
  <!-- *** CONSTRAINT *** -->
  <!-- ****************** -->
  <xs:complexType name="constraintsType">
    <xs:sequence>
      <!-- *** <environment><databases><database><tables><table><constraints><numConstraints> *** -->
      <xs:element name="numConstraints" type="xs:positiveInteger" minOccurs="0" maxOccurs="1" >
        <xs:annotation>
          <xs:appinfo>column:TABLES.NUM_CONSTRAINTS datatype:INTEGER</xs:appinfo>
          <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.constraints.numConstraints"/>
        </xs:annotation>
      </xs:element>
      <!-- *** <environment><databases><database><tables><table><constraints><constraint> *** -->
      <xs:element name="constraint" minOccurs="1" maxOccurs="unbounded">
        <xs:annotation>
          <xs:appinfo>row:TABLE_CONSTRAINTS</xs:appinfo>
          <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.constraints.constraint"/>
        </xs:annotation>
        <xs:complexType>
          <xs:sequence>
            <!-- *** <environment><databases><database><tables><table><constraints><constraint><name> *** -->
            <xs:element name="name" type="nameType" minOccurs="1" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:TABLE_CONSTRAINTS.NAME datatype:CHARACTER(32)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.constraints.constraint.name"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><constraints><constraint><constraintColumns> *** -->
            <xs:element name="constraintColumns" minOccurs="1" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>table:TABLE_CONSTRAINT_COLUMNS inherit:ENVIRONMENTS.NUMBER ENVIRONMENT_NUMBER,DATABASES.NUMBER DATABASE_NUMBER,TABLES.NUMBER TABLE_NUMBER,TABLE_CONSTRAINTS.NUMBER CONSTRAINT_NUMBER</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.constraints.constraint.columns"/>
              </xs:annotation>
              <xs:complexType>
                <xs:sequence>
                  <!-- *** <environment><databases><database><tables><table><constraints><constraint><numConstraintColumns> *** -->
                  <xs:element name="numConstraintColumns" type="xs:positiveInteger" minOccurs="0" maxOccurs="1" >
                    <xs:annotation>
                      <xs:appinfo>column:TABLE_CONSTRAINTS.NUM_CONSTRAINT_COLUMNS datatype:INTEGER</xs:appinfo>
                      <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.constraints.constraint.numConstraintColumns"/>
                    </xs:annotation>
                  </xs:element>
                  <!-- *** <environment><databases><database><tables><table><constraints><constraint><columns><constraintColumn> *** -->
                  <xs:element name="constraintColumn" minOccurs="1" maxOccurs="unbounded" >
                    <xs:annotation>
                      <xs:appinfo>row:TABLE_CONSTRAINT_COLUMNS</xs:appinfo>
                      <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.constraints.constraint.constraintColumns.constraintColumn"/>
                    </xs:annotation>
                    <xs:complexType>
                      <xs:all>
                        <!-- *** <environment><databases><database><tables><table><constraints><constraint><constraintColumns><constraintColumn><name> *** -->
                        <xs:element name="name" type="nameType" minOccurs="1" maxOccurs="1" >
                          <xs:annotation>
                            <xs:appinfo>column:TABLE_CONSTRAINT_COLUMNS.NAME datatype:CHARACTER(32)</xs:appinfo>
                            <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.constraints.constraint.constraintColumns.constraintColumn.name"/>
                          </xs:annotation>
                        </xs:element>
                      </xs:all>
                      <!-- *** <environment><databases><database><tables><table><constraints><constraint><constraintColumns><constraintColumn number=x> *** -->
                      <xs:attribute name="number" type="xs:positiveInteger" use="optional">
                        <xs:annotation>
                          <xs:appinfo>column:TABLE_CONSTRAINT_COLUMNS.NUMBER datatype:INTEGER</xs:appinfo>
                          <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.constraints.constraint.constraintColumns.constraintColumn.number"/>
                        </xs:annotation>
                      </xs:attribute>
                    </xs:complexType>
                  </xs:element>
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><constraints><constraint><referenceConstraint> *** -->
            <xs:element name="referenceConstraint" type="nameType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:TABLE_CONSTRAINTS.REFERENCE_CONSTRAINT datatype:CHARACTER(32)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.constraints.constraint.referenceConstraint"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><constraints><constraint><referenceTableName> *** -->
            <xs:element name="referenceTableName" type="nameType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:TABLE_CONSTRAINTS.REFERENCE_TABLE_NAME datatype:CHARACTER(32)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.constraints.constraint.referenceTableName"/>
              </xs:annotation>
            </xs:element>
          </xs:sequence>
          <!-- *** <environment><databases><database><tables><table><constraints><constraint number=x> *** -->
          <xs:attribute name="number" type="xs:positiveInteger" use="optional">
            <xs:annotation>
              <xs:appinfo>column:TABLE_CONSTRAINTS.NUMBER datatype:INTEGER</xs:appinfo>
              <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.constraints.constraint.number"/>
            </xs:annotation>
          </xs:attribute>
          <!-- *** <environment><databases><database><tables><table><constraints><constraint type=x> *** -->
          <xs:attribute name="type" type="tableConstraintType" use="required">
            <xs:annotation>
              <xs:appinfo>column:TABLE_CONSTRAINTS.TYPE datatype:CHARACTER(32)</xs:appinfo>
              <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.constraints.constraint.type"/>
            </xs:annotation>
          </xs:attribute>
        </xs:complexType>
      </xs:element>
    </xs:sequence>
  </xs:complexType>
  <!-- ****************** -->
  <!-- *** PARTITIONS *** -->
  <!-- ****************** -->
  <xs:complexType name="partitionsType">
    <xs:sequence>
      <!-- *** <environment><databases><database><tables><table><partitions><numPartitions> *** -->
      <xs:element name="numPartitions" type="xs:positiveInteger" minOccurs="0" maxOccurs="1" >
        <xs:annotation>
          <xs:appinfo>column:TABLES.NUM_PARTITIONS datatype:INTEGER</xs:appinfo>
          <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.partitions.numPartitions"/>
        </xs:annotation>
      </xs:element>
      <!-- *** <environment><databases><database><tables><table><partitions><partition> *** -->
      <xs:element name="partition" minOccurs="1" maxOccurs="unbounded">
        <xs:annotation>
          <xs:appinfo>row:TABLE_PARTITIONS</xs:appinfo>
          <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.partitions.partition"/>
        </xs:annotation>
        <xs:complexType>
          <xs:all>
            <!-- *** <environment><databases><database><tables><table><partitions><partition><name> *** -->
            <xs:element name="name" type="nameType" minOccurs="1" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:TABLE_PARTITIONS.NAME datatype:CHARACTER(32)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.partitions.partition.name"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><partitions><partition><physical> *** -->
            <xs:element name="physical" type="physicalType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:TABLE_PARTITIONS.PHYSICAL datatype:CHARACTER(255)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.partitions.partition.physical"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><partitions><partition><partitionBy> *** -->
            <xs:element name="partitionBy" type="xs:string" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:TABLE_PARTITIONS.PARTITION_BY datatype:CHARACTER(256)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.partitions.partition.partitionBy"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><partitions><partition><application> *** -->
            <xs:element name="application" type="applicationType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>exclude</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.partitions.partition.application"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><partitions><partition><documentation> *** -->
            <xs:element name="documentation" type="documentationType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>exclude</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.partitions.partition.documentation"/>
              </xs:annotation>
            </xs:element>
          </xs:all>
          <!-- *** <environment><databases><database><tables><table><partitions><partition cardinality=x> *** -->
          <xs:attribute name="cardinality" type="xs:nonNegativeInteger" use="optional">
            <xs:annotation>
              <xs:appinfo>exclude</xs:appinfo>
              <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.partitions.partition.cardinality"/>
            </xs:annotation>
          </xs:attribute>
          <!-- *** <environment><databases><database><tables><table><partitions><partition number=x> *** -->
          <xs:attribute name="number" type="xs:positiveInteger" use="optional" >
            <xs:annotation>
              <xs:appinfo>column:TABLE_PARTITIONS.NUMBER datatype:INTEGER</xs:appinfo>
              <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.partitions.partition.number"/>
            </xs:annotation>
          </xs:attribute>
        </xs:complexType>
      </xs:element>
    </xs:sequence>
  </xs:complexType>
  <!-- *************** -->
  <!-- *** COLUMNS *** -->
  <!-- *************** -->
  <xs:complexType name="columnsType">
    <xs:sequence>
      <!-- *** <environment><databases><database><tables><table><columns><numColumns> *** -->
      <xs:element name="numColumns" type="xs:positiveInteger" minOccurs="0" maxOccurs="1" >
        <xs:annotation>
          <xs:appinfo>column:TABLES.NUM_COLUMNS datatype:INTEGER</xs:appinfo>
          <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.columns.numColumns"/>
        </xs:annotation>
      </xs:element>
      <!-- *** <environment><databases><database><tables><table><columns><column> *** -->
      <xs:element name="column" minOccurs="1" maxOccurs="unbounded">
        <xs:annotation>
          <xs:appinfo>row:COLUMNS</xs:appinfo>
          <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.columns.column"/>
        </xs:annotation>
        <xs:complexType>
          <xs:all>
            <!-- *** <environment><databases><database><tables><table><columns><column><name> *** -->
            <xs:element name="name" type="nameType" minOccurs="1" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:COLUMNS.NAME datatype:CHARACTER(32)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.columns.column.name"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><columns><column><physical> *** -->
            <xs:element name="physical" type="physicalType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:COLUMNS.PHYSICAL datatype:CHARACTER(255)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.columns.column.physical"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><columns><column><datatype> *** -->
            <xs:element name="datatype" type="datatypeType" minOccurs="1" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:COLUMNS.DATATYPE datatype:CHARACTER(32)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.columns.column.datatype"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><columns><column><length> *** -->
            <xs:element name="length" type="xs:positiveInteger" minOccurs="1" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:COLUMNS.LENGTH datatype:INTEGER</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.columns.column.length"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><columns><column><usage> *** -->
            <xs:element name="usage" type="columnUsageType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:COLUMNS.USAGE datatype:CHARACTER(32)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.columns.column.usage"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><columns><column><options> *** -->
            <xs:element name="options" type="columnOptionsType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:COLUMNS.OPTIONS datatype:CHARACTER(256)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.columns.column.options"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><columns><column><format> *** -->
            <xs:element name="format" type="columnFormatType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:COLUMNS.FORMAT datatype:CHARACTER(32)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.columns.column.format"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><columns><column><pseudoColumn> *** -->
            <xs:element name="pseudoColumn" type="xs:string" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:COLUMNS.PSEUDO_COLUMN datatype:CHARACTER(256)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.columns.column.pseudoColumn"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><columns><column><textSettings> *** -->
            <xs:element name="textSettings" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>INCLUDE_CHILDREN</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.columns.column.textSettings"/>
              </xs:annotation>
              <xs:complexType>
                <xs:all>
                  <!-- *** <environment><databases><database><tables><table><columns><column><textSettings><forms> *** -->
                  <xs:element name="forms" type="xs:string" minOccurs="0" maxOccurs="1" >
                    <xs:annotation>
                      <xs:appinfo>column:COLUMNS.FORMS datatype:CHARACTER(256)</xs:appinfo>
                      <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.columns.column.textSettings.forms"/>
                    </xs:annotation>
                  </xs:element>
                  <!-- *** <environment><databases><database><tables><table><columns><column><textSettings><synonyms> *** -->
                  <xs:element name="synonyms" type="xs:string" minOccurs="0" maxOccurs="1" >
                    <xs:annotation>
                      <xs:appinfo>column:COLUMNS.SYNONYMS datatype:CHARACTER(256)</xs:appinfo>
                      <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.columns.column.textSettings.synonyms"/>
                    </xs:annotation>
                  </xs:element>
                  <!-- *** <environment><databases><database><tables><table><columns><column><textSettings><stopwords> *** -->
                  <xs:element name="stopwords" type="xs:string" minOccurs="0" maxOccurs="1" >
                    <xs:annotation>
                      <xs:appinfo>column:COLUMNS.STOPWORDS datatype:CHARACTER(256)</xs:appinfo>
                      <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.columns.column.textSettings.stopwords"/>
                    </xs:annotation>
                  </xs:element>
                  <!-- *** <environment><databases><database><tables><table><columns><column><textSettings><spellcheck> *** -->
                  <xs:element name="spellcheck" type="xs:string" minOccurs="0" maxOccurs="1" >
                    <xs:annotation>
                      <xs:appinfo>column:COLUMNS.SPELLCHECK datatype:CHARACTER(256)</xs:appinfo>
                      <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.columns.column.textSettings.spellcheck"/>
                    </xs:annotation>
                  </xs:element>
                  <!-- *** <environment><databases><database><tables><table><columns><column><textSettings><phonetic> *** -->
                  <xs:element name="phonetic" type="xs:string" minOccurs="0" maxOccurs="1" >
                    <xs:annotation>
                      <xs:appinfo>column:COLUMNS.PHONETIC datatype:CHARACTER(256)</xs:appinfo>
                      <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.columns.column.textSettings.phonetic"/>
                    </xs:annotation>
                  </xs:element>
                  <!-- *** <environment><databases><database><tables><table><columns><column><textSettings><misspellings> *** -->
                  <xs:element name="misspellings" type="xs:string" minOccurs="0" maxOccurs="1" >
                    <xs:annotation>
                      <xs:appinfo>column:COLUMNS.MISSPELLINGS datatype:CHARACTER(256)</xs:appinfo>
                      <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.columns.column.textSettings.misspellings"/>
                    </xs:annotation>
                  </xs:element>
                  <!-- *** <environment><databases><database><tables><table><columns><column><textSettings><proximity> *** -->
                  <xs:element name="proximity" type="xs:string" minOccurs="0" maxOccurs="1" >
                    <xs:annotation>
                      <xs:appinfo>column:COLUMNS.PROXIMITY datatype:CHARACTER(256)</xs:appinfo>
                      <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.columns.column.textSettings.proximity"/>
                    </xs:annotation>
                  </xs:element>
                </xs:all>
              </xs:complexType>
            </xs:element>
            <xs:element name="statistics" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>INCLUDE_CHILDREN</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.columns.column.statistics"/>
              </xs:annotation>
              <xs:complexType>
                <xs:all>
                  <!-- *** <environment><databases><database><tables><table><columns><column><statistics><cardinality> *** -->
                  <xs:element name="cardinality" type="xs:nonNegativeInteger" minOccurs="0" maxOccurs="1" >
                    <xs:annotation>
                      <xs:appinfo>column:COLUMNS.CARDINALITY datatype:UNSIGNED INTEGER</xs:appinfo>
                      <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.columns.column.statistics.cardinality"/>
                    </xs:annotation>
                  </xs:element>
                </xs:all>
              </xs:complexType>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><columns><column><application> *** -->
            <xs:element name="application" type="applicationType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>exclude</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.columns.column.application"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><columns><column><documentation> *** -->
            <xs:element name="documentation" type="documentationType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>exclude</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.columns.column.documentation"/>
              </xs:annotation>
            </xs:element>
          </xs:all>
          <!-- *** <environment><databases><database><tables><table><columns><column cardinality=x> *** -->
          <xs:attribute name="cardinality" type="xs:nonNegativeInteger" use="optional">
            <xs:annotation>
              <xs:appinfo>exclude</xs:appinfo>
              <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.columns.column.cardinality"/>
            </xs:annotation>
          </xs:attribute>
          <!-- *** <environment><databases><database><tables><table><columns><column number=x> *** -->
          <xs:attribute name="number" type="xs:positiveInteger" use="optional">
            <xs:annotation>
              <xs:appinfo>column:COLUMNS.NUMBER datatype:INTEGER</xs:appinfo>
              <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.columns.column.number"/>
            </xs:annotation>
          </xs:attribute>
          <!-- *** <environment><databases><database><tables><table><columns><column type=x> *** -->
          <xs:attribute name="type" type="columnTypeType" use="optional">
            <xs:annotation>
              <xs:appinfo>column:COLUMNS.TYPE datatype:CHARACTER(32)</xs:appinfo>
              <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.columns.column.type"/>
            </xs:annotation>
          </xs:attribute>
        </xs:complexType>
      </xs:element>
    </xs:sequence>
  </xs:complexType>
  <!-- *************** -->
  <!-- *** INDEXES *** -->
  <!-- *************** -->
  <xs:complexType name="indexesType">
    <xs:sequence>
      <!-- *** <environment><databases><database><tables><table><indexes><numIndexes> *** -->
      <xs:element name="numIndexes" type="xs:positiveInteger" minOccurs="0" maxOccurs="1" >
        <xs:annotation>
          <xs:appinfo>column:TABLES.NUM_INDEXES datatype:INTEGER</xs:appinfo>
          <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.numIndexes"/>
        </xs:annotation>
      </xs:element>
      <!-- *** <environment><databases><database><tables><table><indexes><index> *** -->
      <xs:element name="index" minOccurs="1" maxOccurs="unbounded" >
        <xs:annotation>
          <xs:appinfo>row:INDEXES</xs:appinfo>
          <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.index"/>
        </xs:annotation>
        <xs:complexType>
          <xs:sequence>
            <!-- *** <environment><databases><database><tables><table><indexes><index><name> *** -->
            <xs:element name="name" type="nameType" minOccurs="1" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:INDEXES.NAME datatype:CHARACTER(32)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.index.name"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><indexes><index><physical> *** -->
            <xs:element name="physical" type="physicalType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:INDEXES.PHYSICAL datatype:CHARACTER(255)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.index.physical"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><indexes><index><omnidexSettings> *** -->
            <xs:element name="omnidexSettings" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>INCLUDE_CHILDREN</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.index.omnidexSettings"/>
              </xs:annotation>
              <xs:complexType>
                <xs:all>
                  <!-- *** <environment><databases><database><tables><table><indexes><index><omnidexSettings><odxDomainType> *** -->
                  <xs:element name="omnidexDomainType" type="omnidexDomainType" minOccurs="0" maxOccurs="1" >
                    <xs:annotation>
                      <xs:appinfo>column:INDEXES.OMNIDEX_DOMAIN_TYPE datatype:CHARACTER(32)</xs:appinfo>
                      <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.index.omnidexSettings.omnidexDomainType"/>
                    </xs:annotation>
                  </xs:element>
                  <!-- *** <environment><databases><database><tables><table><indexes><index><omnidexSettings><primaryTableName> *** -->
                  <xs:element name="primaryTableName" type="nameType" minOccurs="0" maxOccurs="1" >
                    <xs:annotation>
                      <xs:appinfo>column:INDEXES.PRIMARY_TABLE_NAME datatype:CHARACTER(32)</xs:appinfo>
                      <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.index.omnidexSettings.primaryTableName"/>
                    </xs:annotation>
                  </xs:element>
                  <!-- *** <environment><databases><database><tables><table><indexes><index><omnidexSettings><ownerTableName> *** -->
                  <xs:element name="ownerTableName" type="nameType" minOccurs="0" maxOccurs="1" >
                    <xs:annotation>
                      <xs:appinfo>column:INDEXES.OWNER_TABLE_NAME datatype:CHARACTER(32)</xs:appinfo>
                      <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.index.omnidexSettings.ownerTableName"/>
                    </xs:annotation>
                  </xs:element>
                  <!-- *** <environment><databases><database><tables><table><indexes><index><omnidexSettings><indexSize> *** -->
                  <xs:element name="indexSize" type="xs:nonNegativeInteger" minOccurs="0" maxOccurs="1" >
                    <xs:annotation>
                      <xs:appinfo>column:INDEXES.INDEX_SIZE datatype:INTEGER</xs:appinfo>
                      <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.index.omnidexSettings.indexSize"/>
                    </xs:annotation>
                  </xs:element>
                  <!-- *** <environment><databases><database><tables><table><indexes><index><omnidexSettings><indexFilename> *** -->
                  <xs:element name="indexFilename" type="physicalType" minOccurs="0" maxOccurs="1" >
                    <xs:annotation>
                      <xs:appinfo>column:INDEXES.INDEX_FILENAME datatype:CHARACTER(255)</xs:appinfo>
                      <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.index.omnidexSettings.indexFilename"/>
                    </xs:annotation>
                  </xs:element>
                  <!-- *** <environment><databases><database><tables><table><indexes><index><omnidexSettings><options> *** -->
                  <xs:element name="options" type="indexOptionsType" minOccurs="0" maxOccurs="1" >
                    <xs:annotation>
                      <xs:appinfo>column:INDEXES.OPTIONS datatype:CHARACTER(255)</xs:appinfo>
                      <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.index.omnidexSettings.options"/>
                    </xs:annotation>
                  </xs:element>
                  <!-- *** <environment><databases><database><tables><table><indexes><index><omnidexSettings><groupNumber> *** -->
                  <xs:element name="groupNumber" type="xs:positiveInteger" minOccurs="0" maxOccurs="1" >
                    <xs:annotation>
                      <xs:appinfo>column:INDEXES.GROUP_NUMBER datatype:INTEGER</xs:appinfo>
                      <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.index.omnidexSettings.groupNumber"/>
                    </xs:annotation>
                  </xs:element>
                  <!-- *** <environment><databases><database><tables><table><indexes><index><omnidexSettings><groupMasterTableName> *** -->
                  <xs:element name="groupMasterTableName" type="nameType" minOccurs="0" maxOccurs="1" >
                    <xs:annotation>
                      <xs:appinfo>column:INDEXES.GROUP_MASTER_TABLE_NAME datatype:CHARACTER(32)</xs:appinfo>
                      <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.index.omnidexSettings.groupMasterTableName"/>
                    </xs:annotation>
                  </xs:element>
                  <!-- *** <environment><databases><database><tables><table><indexes><index><omnidexSettings><groupMasterIndexName> *** -->
                  <xs:element name="groupMasterIndexName" type="nameType" minOccurs="0" maxOccurs="1" >
                    <xs:annotation>
                      <xs:appinfo>column:INDEXES.GROUP_MASTER_INDEX_NAME datatype:CHARACTER(32)</xs:appinfo>
                      <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.index.omnidexSettings.groupMasterIndexName"/>
                    </xs:annotation>
                  </xs:element>
                </xs:all>
              </xs:complexType>
            </xs:element>
            <xs:element name="statistics" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>INCLUDE_CHILDREN</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.index.statistics"/>
              </xs:annotation>
              <xs:complexType>
                <xs:all>
                  <!-- *** <environment><databases><database><tables><table><indexes><index><statistics><cardinality> *** -->
                  <xs:element name="cardinality" type="xs:nonNegativeInteger" minOccurs="0" maxOccurs="1" >
                    <xs:annotation>
                      <xs:appinfo>column:INDEXES.CARDINALITY datatype:UNSIGNED INTEGER</xs:appinfo>
                      <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.index.statistics.cardinality"/>
                    </xs:annotation>
                  </xs:element>
                  <!-- *** <environment><databases><database><tables><table><indexes><index><statistics><totalEntries> *** -->
                  <xs:element name="totalEntries" type="xs:nonNegativeInteger" minOccurs="0" maxOccurs="1" >
                    <xs:annotation>
                      <xs:appinfo>column:INDEXES.TOTAL_ENTRIES datatype:UNSIGNED INTEGER</xs:appinfo>
                      <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.index.statistics.totalEntries"/>
                    </xs:annotation>
                  </xs:element>
                  <!-- *** <environment><databases><database><tables><table><indexes><index><statistics><numSearches> *** -->
                  <xs:element name="numSearches" type="xs:nonNegativeInteger" minOccurs="0" maxOccurs="1" >
                    <xs:annotation>
                      <xs:appinfo>column:INDEXES.NUM_SEARCHES datatype:UNSIGNED INTEGER</xs:appinfo>
                      <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.index.statistics.numSearches"/>
                    </xs:annotation>
                  </xs:element>
                  <!-- *** <environment><databases><database><tables><table><indexes><index><statistics><dateCreated> *** -->
                  <xs:element name="dateCreated" type="xs:dateTime" minOccurs="0" maxOccurs="1" >
                    <xs:annotation>
                      <xs:appinfo>column:INDEXES.DATE_CREATED datatype:DATETIME</xs:appinfo>
                      <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.index.statistics.dateCreated"/>
                    </xs:annotation>
                  </xs:element>
                </xs:all>
              </xs:complexType>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><indexes><index><application> *** -->
            <xs:element name="application" type="applicationType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>exclude</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.index.application"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><indexes><index><documentation> *** -->
            <xs:element name="documentation" type="documentationType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>exclude</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.index.documentation"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><indexes><index><indexComponents> *** -->
            <xs:element name="indexComponents" type="indexComponentsType" minOccurs="1" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>table:INDEX_COMPONENTS inherit:ENVIRONMENTS.NUMBER ENVIRONMENT_NUMBER,DATABASES.NUMBER DATABASE_NUMBER,TABLES.NUMBER TABLE_NUMBER,INDEXES.NUMBER INDEX_NUMBER</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.index.indexComponents"/>
              </xs:annotation>
            </xs:element>
          </xs:sequence>
          <!-- *** <environment><databases><database><tables><table><indexes><index dataclass=x> *** -->
          <xs:attribute name="dataclass" type="dataclassType" use="optional" >
            <xs:annotation>
              <xs:appinfo>column:INDEXES.DATACLASS datatype:CHARACTER(32)</xs:appinfo>
              <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.index.dataclass"/>
            </xs:annotation>
          </xs:attribute >
          <!-- *** <environment><databases><database><tables><table><indexes><index length=x> *** -->
          <xs:attribute name="length" type="xs:positiveInteger" use="optional" >
            <xs:annotation>
              <xs:appinfo>column:INDEXES.LENGTH datatype:INTEGER</xs:appinfo>
              <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.index.length"/>
            </xs:annotation>
          </xs:attribute >
          <!-- *** <environment><databases><database><tables><table><indexes><index number=x> *** -->
          <xs:attribute name="number" type="xs:positiveInteger" use="optional" >
            <xs:annotation>
              <xs:appinfo>column:INDEXES.NUMBER datatype:INTEGER</xs:appinfo>
              <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.index.number"/>
            </xs:annotation>
          </xs:attribute >
          <!-- *** <environment><databases><database><tables><table><indexes><index type=x> *** -->
          <xs:attribute name="type" type="indexTypeType" use="optional" >
            <xs:annotation>
              <xs:appinfo>column:INDEXES.TYPE datatype:CHARACTER(32)</xs:appinfo>
              <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.index.type"/>
            </xs:annotation>
          </xs:attribute >
        </xs:complexType>
      </xs:element>
    </xs:sequence>
  </xs:complexType>
  <!-- ************************ -->
  <!-- *** INDEX COMPONENTS *** -->
  <!-- ************************ -->
  <xs:complexType name="indexComponentsType">
    <xs:sequence>
      <!-- *** <environment><databases><database><tables><table><indexes><index><indexComponents><numIndexComponents> *** -->
      <xs:element name="numIndexComponents" type="xs:positiveInteger" minOccurs="0" maxOccurs="1" >
        <xs:annotation>
          <xs:appinfo>column:INDEXES.NUM_INDEX_COMPONENTS datatype:INTEGER</xs:appinfo>
          <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.index.indexComponents.numIndexComponents"/>
        </xs:annotation>
      </xs:element>
      <!-- *** <environment><databases><database><tables><table><indexes><index><indexComponents><IndexComponent> *** -->
      <xs:element name="indexComponent" minOccurs="1" maxOccurs="unbounded">
        <xs:annotation>
          <xs:appinfo>row:INDEX_COMPONENTS</xs:appinfo>
          <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.index.indexComponents.indexComponent"/>
        </xs:annotation>
        <xs:complexType>
          <xs:all>
            <!-- *** <environment><databases><database><tables><table><indexes><index><indexComponents><IndexComponent><tableName> *** -->
            <xs:element name="tableName" type="nameType" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:INDEX_COMPONENTS.TABLE_NAME datatype:CHARACTER(32)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.index.indexComponents.indexComponent.tableName"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><indexes><index><indexComponents><IndexComponent><columnName> *** -->
            <xs:element name="columnName" type="nameType" minOccurs="1" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:INDEX_COMPONENTS.COLUMN_NAME datatype:CHARACTER(32)</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.index.indexComponents.indexComponent.columnName"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><indexes><index><indexComponents><IndexComponent><startByte> *** -->
            <xs:element name="startByte" type="xs:nonNegativeInteger" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:INDEX_COMPONENTS.START_BYTE datatype:INTEGER</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.index.indexComponents.indexComponent.startByte"/>
              </xs:annotation>
            </xs:element>
            <!-- *** <environment><databases><database><tables><table><indexes><index><indexComponents><IndexComponent><length> *** -->
            <xs:element name="length" type="xs:positiveInteger" minOccurs="0" maxOccurs="1" >
              <xs:annotation>
                <xs:appinfo>column:INDEX_COMPONENTS.LENGTH datatype:INTEGER</xs:appinfo>
                <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.index.indexComponents.indexComponent.length"/>
              </xs:annotation>
            </xs:element>
          </xs:all>
          <!-- *** <environment><databases><database><tables><table><indexes><index><indexComponents><IndexComponent number=x> *** -->
          <xs:attribute name="number" type="xs:positiveInteger" use="optional" >
            <xs:annotation>
              <xs:appinfo>column:INDEX_COMPONENTS.NUMBER datatype:INTEGER</xs:appinfo>
              <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.index.indexComponents.indexComponent.number"/>
            </xs:annotation>
          </xs:attribute>
          <!-- *** <environment><databases><database><tables><table><indexes><index><indexComponents><IndexComponent type=x> *** -->
          <xs:attribute name="type" type="indexComponentTypeType" use="required" >
            <xs:annotation>
              <xs:appinfo>column:INDEX_COMPONENTS.TYPE datatype:CHARACTER(32)</xs:appinfo>
              <xs:documentation source="Omnidex_xsd.html#environment.databases.database.tables.table.indexes.index.indexComponents.indexComponent.type"/>
            </xs:annotation>
          </xs:attribute>
        </xs:complexType>
      </xs:element>
    </xs:sequence>
  </xs:complexType>
  <!-- ******************* -->
  <!-- *** APPLICATION *** -->
  <!-- ******************* -->
  <xs:complexType name="applicationType">
    <xs:all>
      <!-- *** ...<application><prompt> *** -->
      <xs:element name="prompt" minOccurs="0" maxOccurs="1" >
        <xs:annotation>
          <xs:appinfo>column:PROMPT datatype:CHARACTER(32)</xs:appinfo>
          <xs:documentation source="Omnidex_xsd.html#application.prompt"/>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:string">
            <xs:maxLength value="34" />
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <!-- *** ...<application><heading> *** -->
      <xs:element name="heading" minOccurs="0" maxOccurs="1" >
        <xs:annotation>
          <xs:appinfo>column:HEADING datatype:CHARACTER(32)</xs:appinfo>
          <xs:documentation source="Omnidex_xsd.html#application.heading"/>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:string">
            <xs:maxLength value="32" />
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <!-- *** ...<application><label> *** -->
      <xs:element name="label" minOccurs="0" maxOccurs="1" >
        <xs:annotation>
          <xs:appinfo>column:LABEL datatype:CHARACTER(32)</xs:appinfo>
          <xs:documentation source="Omnidex_xsd.html#application.label"/>
        </xs:annotation>
        <xs:simpleType>
          <xs:restriction base="xs:string">
            <xs:maxLength value="33" />
          </xs:restriction>
        </xs:simpleType>
      </xs:element>
      <!-- *** ...<application><userData1> *** -->
      <xs:element name="userData1" type="xs:string" minOccurs="0" maxOccurs="1" />
      <!-- *** ...<application><userData2> *** -->
      <xs:element name="userData2" type="xs:string" minOccurs="0" maxOccurs="1" />
      <!-- *** ...<application><userData3> *** -->
      <xs:element name="userData3" type="xs:string" minOccurs="0" maxOccurs="1" />
    </xs:all>
  </xs:complexType>
  <!-- ********************* -->
  <!-- *** DOCUMENTATION *** -->
  <!-- ********************* -->
  <xs:complexType name="documentationType">
    <xs:all>
      <!-- *** ...<documentation><description> *** -->
      <xs:element name="description" type="xs:string" minOccurs="0" maxOccurs="1" />
    </xs:all>
  </xs:complexType>
  <!-- ******************** -->
  <!-- *** SIMPLE TYPES *** -->
  <!-- ******************** -->
  <!-- *** nameType *** -->
  <xs:simpleType name="nameType">
    <xs:restriction base="xs:token">
      <xs:pattern value="[A-Za-z$][A-Za-z\d!@#$%^_]{0,31}" />
    </xs:restriction>
  </xs:simpleType>
  <!-- *** titleType *** -->
  <xs:simpleType name="titleType">
    <xs:restriction base="xs:token">
      <xs:maxLength value="80" />
    </xs:restriction>
  </xs:simpleType>
  <!-- *** tokenType *** -->
  <xs:simpleType name="tokenType">
    <xs:restriction base="xs:token">
      <xs:maxLength value="32" />
    </xs:restriction>
  </xs:simpleType>
  <!-- *** physicalType *** -->
  <xs:simpleType name="physicalType">
    <xs:restriction base="xs:string">
      <xs:maxLength value="255" />
    </xs:restriction>
  </xs:simpleType>
  <!-- *** optionsType *** -->
  <xs:simpleType name="optionsType">
    <xs:restriction base="xs:string">
      <xs:maxLength value="255" />
    </xs:restriction>
  </xs:simpleType>
  <!-- *** passwordType *** -->
  <xs:simpleType name="passwordType">
    <xs:restriction base="xs:string">
      <xs:maxLength value="32" />
    </xs:restriction>
  </xs:simpleType>
  <!-- *** datatypeType *** -->
  <xs:simpleType name="datatypeType">
    <xs:restriction base="xs:token">
      <xs:enumeration value="UNKNOWN" />
      <xs:enumeration value="CHARACTER" />
      <xs:enumeration value="NATIONAL CHARACTER" />
      <xs:enumeration value="C STRING" />
      <xs:enumeration value="NATIONAL C STRING" />
      <xs:enumeration value="INTEGER" />
      <xs:enumeration value="TINYINT" />
      <xs:enumeration value="SMALLINT" />
      <xs:enumeration value="BIGINT" />
      <xs:enumeration value="UNSIGNED INTEGER" />
      <xs:enumeration value="UNSIGNED TINYINT" />
      <xs:enumeration value="UNSIGNED SMALLINT" />
      <xs:enumeration value="UNSIGNED BIGINT" />
      <xs:enumeration value="FLOAT" />
      <xs:enumeration value="DOUBLE" />
      <xs:enumeration value="DATE" />
      <xs:enumeration value="INFORMIX DATE" />
      <xs:enumeration value="ODBC DATE" />
      <xs:enumeration value="ASCII DATE" />
      <xs:enumeration value="DB2 DATE" />
      <xs:enumeration value="OMNIDEX DATE" />
      <xs:enumeration value="TIME" />
      <xs:enumeration value="ODBC TIME" />
      <xs:enumeration value="DB2 TIME" />
      <xs:enumeration value="OMNIDEX TIME" />
      <xs:enumeration value="DATETIME" />
      <xs:enumeration value="ORACLE DATETIME" />
      <xs:enumeration value="SQLSERVER DATETIME" />
      <xs:enumeration value="C DATETIME" />
      <xs:enumeration value="INFORMIX DATETIME" />
      <xs:enumeration value="ODBC DATETIME" />
      <xs:enumeration value="DB2 DATETIME" />
      <xs:enumeration value="OMNIDEX DATETIME" />
      <xs:enumeration value="VARCHAR" />
      <xs:enumeration value="NATIONAL VARCHAR" />
      <xs:enumeration value="OMNIDEX VARCHAR" />
      <xs:enumeration value="CLOB" />
      <xs:enumeration value="NATIONAL CLOB" />
      <xs:enumeration value="OMNIDEX CLOB" />
    </xs:restriction>
  </xs:simpleType>
  <!-- *** dataclassType *** -->
  <xs:simpleType name="dataclassType">
    <xs:restriction base="xs:token">
      <xs:enumeration value="BINARY" />
      <xs:enumeration value="CHARACTER" />
      <xs:enumeration value="INTEGER" />
      <xs:enumeration value="FLOAT" />
      <xs:enumeration value="DATE" />
      <xs:enumeration value="ROWID" />
    </xs:restriction>
  </xs:simpleType>
  <!-- *** omnidexDomainType *** -->
  <xs:simpleType name="omnidexDomainType">
    <xs:restriction base="xs:token">
      <xs:enumeration value="NONE" />
      <xs:enumeration value="IDSI" />
      <xs:enumeration value="TR" />
      <xs:enumeration value="TRR" />
      <xs:enumeration value="DR" />
      <xs:enumeration value="LINKED CHILD" />
      <xs:enumeration value="HYBRID IDSI" />
      <xs:enumeration value="HYBRID TR" />
      <xs:enumeration value="HYBRID TRR" />
      <xs:enumeration value="HYBRID DR" />
      <xs:enumeration value="ASK" />
    </xs:restriction>
  </xs:simpleType>
  <!-- *** indexMaintenanceType *** -->
  <xs:simpleType name="indexMaintenanceType">
    <xs:restriction base="xs:token">
      <xs:enumeration value="API" />
      <xs:enumeration value="DBMS" />
    </xs:restriction>
  </xs:simpleType>
  <!-- *** databaseTypeType *** -->
  <xs:simpleType name="databaseTypeType">
    <xs:restriction base="xs:token">
      <xs:enumeration value="FLATFILE" />
      <xs:enumeration value="ORACLE" />
      <xs:enumeration value="SQLSERVER" />
      <xs:enumeration value="DB2" />
      <xs:enumeration value="ODBC" />
      <xs:enumeration value="INFORMIX" />
    </xs:restriction>
  </xs:simpleType>
  <!-- *** centuryThresholdType *** -->
  <xs:simpleType name="centuryThresholdType">
    <xs:restriction base="xs:nonNegativeInteger">
      <xs:minInclusive value="00"/>
      <xs:maxInclusive value="99"/>
    </xs:restriction>
  </xs:simpleType>
  <!-- *** databaseSubtypeType *** -->
  <xs:simpleType name="databaseSubtypeType">
    <xs:restriction base="xs:token">
      <xs:enumeration value="ORACLE" />
      <xs:enumeration value="SQLSERVER" />
      <xs:enumeration value="DB2" />
      <xs:enumeration value="INFORMIX" />
      <xs:enumeration value="ACCESS" />
      <xs:enumeration value="MYSQL" />
    </xs:restriction>
  </xs:simpleType>
  <!-- *** databaseConnectionTypeType*** -->
  <xs:simpleType name="databaseConnectionTypeType">
    <xs:restriction base="xs:token">
      <xs:enumeration value="LOCAL" />
      <xs:enumeration value="REMOTE" />
    </xs:restriction>
  </xs:simpleType>
  <!-- *** tableTypeType *** -->
  <xs:simpleType name="tableTypeType">
    <xs:restriction base="xs:token">
      <xs:enumeration value="TDF" />
      <xs:enumeration value="OST" />
      <xs:enumeration value="DYNAMIC VIEW" />
      <xs:enumeration value="RELATIONAL" />
      <xs:enumeration value="ROLLUP" />
      <xs:enumeration value="PARTITION" />
    </xs:restriction>
  </xs:simpleType>
  <!-- *** tableCachingType *** -->
  <xs:simpleType name="tableCachingTypeType">
    <xs:restriction base="xs:token">
      <xs:enumeration value="DYNAMIC" />
      <xs:enumeration value="STATIC" />
      <xs:enumeration value="NONE" />
    </xs:restriction>
  </xs:simpleType>
  <!-- *** tableConstraintType *** -->
  <xs:simpleType name="tableConstraintType">
    <xs:restriction base="xs:token">
      <xs:enumeration value="PRIMARY" />
      <xs:enumeration value="FOREIGN" />
      <xs:enumeration value="UNIQUE" />
    </xs:restriction>
  </xs:simpleType>
  <!-- *** columnTypeType *** -->
  <xs:simpleType name="columnTypeType">
    <xs:restriction base="xs:token">
      <xs:enumeration value="NATIVE"/>
      <xs:enumeration value="PSEUDOCOLUMN" />
    </xs:restriction>
  </xs:simpleType>
  <!-- *** columnUsageType *** -->
  <xs:simpleType name="columnUsageType">
    <xs:restriction base="xs:token">
      <xs:enumeration value="ASCENDING AUTO ROWID"/>
      <xs:enumeration value="ASCENDING ROWID" />
      <xs:enumeration value="AUTO ROWID" />
      <xs:enumeration value="CURRENCY" />
      <xs:enumeration value="LATITUDE" />
      <xs:enumeration value="LONGITUDE" />
      <xs:enumeration value="ROWID" />
    </xs:restriction>
  </xs:simpleType>
  <!-- *** columnOptionsEnum *** -->
  <xs:simpleType name="columnOptionsEnum">
    <xs:restriction base="xs:token">
      <xs:enumeration value="LJ" />
      <xs:enumeration value="RJ" />
      <xs:enumeration value="UPS" />
      <xs:enumeration value="DNS" />
      <xs:enumeration value="SF" />
      <xs:enumeration value="ZF" />
      <xs:enumeration value="BWZ" />
      <xs:enumeration value="PAREN" />
      <xs:enumeration value="MIN" />
      <xs:enumeration value="TRIM" />
      <xs:enumeration value="EXP" />
    </xs:restriction>
  </xs:simpleType>
  <!-- *** columnOptionsList *** -->
  <xs:simpleType name="columnOptionsList">
    <xs:list itemType="columnOptionsEnum"/>
  </xs:simpleType>
  <!-- *** columnOptionsType *** -->
  <xs:simpleType name="columnOptionsType">
    <xs:restriction base="columnOptionsList">
      <xs:minLength value="0"/>
    </xs:restriction>
  </xs:simpleType>
  <!-- *** columnFormatType *** -->
  <xs:simpleType name="columnFormatType">
    <xs:restriction base="xs:token">
      <xs:enumeration value="" />
      <xs:enumeration value="YYYY" />
      <xs:enumeration value="YYYYMM" />
      <xs:enumeration value="YYYYMMDD" />
      <xs:enumeration value="YYYYMMDDHH" />
      <xs:enumeration value="YYYYMMDDHHNN" />
      <xs:enumeration value="YYYYMMDDHHNNSS" />
      <xs:enumeration value="YYYYMMDDHHNNSSFF" />
      <xs:enumeration value="YY" />
      <xs:enumeration value="YYMM" />
      <xs:enumeration value="YYMMDD" />
      <xs:enumeration value="YYMMDDHH" />
      <xs:enumeration value="YYMMDDHHNN" />
      <xs:enumeration value="YYMMDDHHNNSS" />
      <xs:enumeration value="YYMMDDHHNNSSFF" />
      <xs:enumeration value="MM" />
      <xs:enumeration value="MMDD" />
      <xs:enumeration value="MMDDHH" />
      <xs:enumeration value="MMDDHHNN" />
      <xs:enumeration value="MMDDHHNNSS" />
      <xs:enumeration value="MMDDHHNNSSFF" />
      <xs:enumeration value="DD" />
      <xs:enumeration value="DDHH" />
      <xs:enumeration value="DDHHNN" />
      <xs:enumeration value="DDHHNNSS" />
      <xs:enumeration value="DDHHNNSSFF" />
      <xs:enumeration value="HH" />
      <xs:enumeration value="HHNN" />
      <xs:enumeration value="HHNNSS" />
      <xs:enumeration value="HHNNSSFF" />
      <xs:enumeration value="NN" />
      <xs:enumeration value="NNSS" />
      <xs:enumeration value="NNSSFF" />
      <xs:enumeration value="SS" />
      <xs:enumeration value="SSFF" />
      <xs:enumeration value="FF" />
    </xs:restriction>
  </xs:simpleType>
  <!-- *** indexTypeType *** -->
  <xs:simpleType name="indexTypeType">
    <xs:restriction base="xs:token">
      <xs:enumeration value="NATIVE HASHED" />
      <xs:enumeration value="NATIVE SORTED" />
      <xs:enumeration value="OMNIDEX ASK" />
      <xs:enumeration value="OMNIDEX MDK" />
    </xs:restriction>
  </xs:simpleType>
  <!-- *** indexOptionsEnum *** -->
  <xs:simpleType name="indexOptionsEnum">
    <xs:restriction base="xs:token">
      <xs:enumeration value="KW" />
      <xs:enumeration value="CI" />
      <xs:enumeration value="CS" />
      <xs:enumeration value="EW" />
      <xs:enumeration value="NE" />
      <xs:enumeration value="SX" />
      <xs:enumeration value="SX2" />
      <xs:enumeration value="SX3" />
      <xs:enumeration value="PX" />
      <xs:enumeration value="RC" />
      <xs:enumeration value="BM" />
      <xs:enumeration value="DI" />
      <xs:enumeration value="RK" />
    </xs:restriction>
  </xs:simpleType>
  <!-- *** indexOptionsList *** -->
  <xs:simpleType name="indexOptionsList">
    <xs:list itemType="indexOptionsEnum"/>
  </xs:simpleType>
  <!-- *** indexOptionsType *** -->
  <xs:simpleType name="indexOptionsType">
    <xs:restriction base="indexOptionsList">
      <xs:minLength value="0"/>
    </xs:restriction>
  </xs:simpleType>
  <!-- *** indexComponentTypeType *** -->
  <xs:simpleType name="indexComponentTypeType">
    <xs:restriction base="xs:token">
      <xs:enumeration value="DATA" />
      <xs:enumeration value="TARGET" />
      <xs:enumeration value="TARGET PRIMARY SI" />
      <xs:enumeration value="TARGET FOREIGN SI" />
      <xs:enumeration value="TARGET UNIQUEKEY" />
    </xs:restriction>
  </xs:simpleType>
</xs:schema>
