analytics/webcontent/relmd/metadata/import_/relmdMetadataImportRules.xsd

<?xml version="1.0" encoding="UTF-8"?>
<!-- edited with XMLSpy v2010 rel. 3 sp1 (http://www.altova.com) by QING ZHU (IBM SWG CANADA) -->
<!--
 Licensed Materials - Property of IBM

 IBM Cognos Products: relmd

 (C) Copyright IBM Corp. 2008, 2015

 US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
-->
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns="http://www.ibm.com/xmlns/prod/cognos/relmd/1/0" targetNamespace="http://www.ibm.com/xmlns/prod/cognos/relmd/1/0" elementFormDefault="qualified" attributeFormDefault="qualified">
	<xs:include schemaLocation="../../vendor/access/relmdVendorAccess.xsd"/>
	<!--
	Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved.
	Cognos (R) is a trademark of Cognos ULC, (formerly Cognos Incorporated).

	Relational metadata database extraction rules.
-->
	<xs:group name="metadataImportRules">
		<xs:sequence>
			<xs:element ref="tablesImportRules"/>
			<xs:element ref="viewsImportRules"/>
			<xs:element ref="columnsImportRules"/>
			<xs:element ref="uniqueKeysImportRules"/>
			<xs:element ref="foreignKeysImportRules"/>
			<xs:element ref="indexesImportRules"/>
			<xs:element ref="synonymsImportRules"/>
			<xs:element ref="routinesImportRules"/>
			<xs:element ref="proceduresImportRules"/>
			<xs:element ref="functionsImportRules"/>
			<xs:element ref="routineArgumentsImportRules"/>
			<xs:element ref="procedureRoutineArgusImportRules"/>
			<xs:element ref="functionRoutineArgusImportRules"/>
			<xs:element ref="sqlObjectImportRules"/>
		</xs:sequence>
	</xs:group>
	<xs:element name="tablesImportRules">
		<xs:complexType>
			<xs:sequence>
				<xs:group ref="extractionRulesResultSetProvider"/>
			</xs:sequence>
			<xs:attributeGroup ref="tablesRecordIndexMappings"/>
		</xs:complexType>
	</xs:element>
	<xs:element name="viewsImportRules">
		<xs:complexType>
			<xs:sequence>
				<xs:group ref="extractionRulesResultSetProvider"/>
			</xs:sequence>
			<xs:attributeGroup ref="tablesRecordIndexMappings"/>
		</xs:complexType>
	</xs:element>
	<xs:element name="columnsImportRules">
		<xs:complexType>
			<xs:choice>
				<xs:group ref="extractionRulesResultSetProvider"/>
			</xs:choice>
			<xs:attributeGroup ref="importRule"/>
			<xs:attributeGroup ref="columnsRecordIndexMappings"/>
		</xs:complexType>
	</xs:element>
	<xs:element name="uniqueKeysImportRules">
		<xs:complexType>
			<xs:group ref="extractionRulesResultSetProvider"/>
			<xs:attributeGroup ref="uniqueKeysRecordIndexMappings"/>
		</xs:complexType>
	</xs:element>
	<xs:element name="foreignKeysImportRules">
		<xs:complexType>
			<xs:group ref="extractionRulesResultSetProvider"/>
			<xs:attributeGroup ref="foreignKeysRecordIndexMappings"/>
		</xs:complexType>
	</xs:element>
	<xs:element name="indexesImportRules">
		<xs:complexType>
			<xs:group ref="extractionRulesResultSetProvider"/>
			<xs:attributeGroup ref="indexesRecordIndexMappings"/>
		</xs:complexType>
	</xs:element>
	<xs:element name="synonymsImportRules">
		<xs:complexType>
			<xs:group ref="extractionRulesResultSetProvider"/>
			<xs:attributeGroup ref="synonymsRecordIndexMappings"/>
		</xs:complexType>
	</xs:element>
	<xs:element name="routinesImportRules">
		<xs:complexType>
			<xs:group ref="extractionRulesResultSetProvider"/>
			<xs:attributeGroup ref="proceduresRecordIndexMappings"/>
		</xs:complexType>
	</xs:element>
	<xs:element name="functionsImportRules">
		<xs:complexType>
			<xs:group ref="extractionRulesResultSetProvider"/>
			<xs:attributeGroup ref="proceduresRecordIndexMappings"/>
		</xs:complexType>
	</xs:element>
	<xs:element name="proceduresImportRules">
		<xs:complexType>
			<xs:group ref="extractionRulesResultSetProvider"/>
			<xs:attributeGroup ref="proceduresRecordIndexMappings"/>
		</xs:complexType>
	</xs:element>
	<xs:element name="routineArgumentsImportRules">
		<xs:complexType>
			<xs:sequence>
				<xs:group ref="extractionRulesResultSetProvider"/>
			</xs:sequence>
			<xs:attributeGroup ref="procedureParametersRecordIndexMappings"/>
		</xs:complexType>
	</xs:element>
	<xs:element name="procedureRoutineArgusImportRules">
		<xs:complexType>
			<xs:sequence>
				<xs:group ref="extractionRulesResultSetProvider"/>
			</xs:sequence>
			<xs:attributeGroup ref="procedureParametersRecordIndexMappings"/>
		</xs:complexType>
	</xs:element>
	<xs:element name="functionRoutineArgusImportRules">
		<xs:complexType>
			<xs:sequence>
				<xs:group ref="extractionRulesResultSetProvider"/>
			</xs:sequence>
			<xs:attributeGroup ref="procedureParametersRecordIndexMappings"/>
		</xs:complexType>
	</xs:element>
	<xs:attributeGroup name="sqlColumnRecordIndexMappings">
		<xs:attribute name="datatype" type="resultSetRecordColumnIndexType" use="optional" default="5"/>
		<xs:attribute name="precision" type="resultSetRecordColumnIndexType" use="optional" default="6"/>
		<xs:attribute name="length" type="resultSetRecordColumnIndexType" use="optional" default="7"/>
		<xs:attribute name="scale" type="resultSetRecordColumnIndexType" use="optional" default="8"/>
		<xs:attribute name="nullableFlag" type="resultSetRecordColumnIndexType" use="optional" default="9"/>
		<xs:attribute name="defaultValue" type="resultSetRecordColumnIndexType" use="optional" default="10"/>
		<xs:attribute name="characterSet" type="resultSetRecordColumnIndexType" use="optional" default="11"/>
		<xs:attribute name="language" type="resultSetRecordColumnIndexType" use="optional" default="12"/>
	</xs:attributeGroup>
	<xs:attributeGroup name="columnsRecordIndexMappings">
		<xs:attributeGroup ref="parentQueryObjectRecordIndexMappings"/>
		<xs:attribute name="columnName" type="resultSetRecordColumnIndexType" use="optional" default="4"/>
		<xs:attributeGroup ref="sqlColumnRecordIndexMappings"/>
		<xs:attribute name="description" type="resultSetRecordColumnIndexType" use="optional" default="13"/>
		<xs:attribute name="systemFlag" type="resultSetRecordColumnIndexType" use="optional" default="1"/>
	</xs:attributeGroup>
	<xs:attributeGroup name="proceduresRecordIndexMappings">
		<xs:attributeGroup ref="parentSchemaRecordIndexMappings"/>
		<xs:attribute name="procedureName" type="resultSetRecordColumnIndexType" use="optional" default="3"/>
		<xs:attribute name="isSystemObject" type="resultSetRecordColumnIndexType" use="optional" default="4"/>
		<xs:attribute name="description" type="resultSetRecordColumnIndexType" use="optional" default="5"/>
		<xs:attribute name="procedureType" type="resultSetRecordColumnIndexType" use="optional" default="6"/>
	</xs:attributeGroup>
	<xs:attributeGroup name="procedureParametersRecordIndexMappings">
		<xs:attributeGroup ref="parentQueryObjectRecordIndexMappings"/>
		<xs:attribute name="argumentName" type="resultSetRecordColumnIndexType" use="optional" default="4"/>
		<xs:attributeGroup ref="sqlColumnRecordIndexMappings"/>
		<xs:attribute name="description" type="resultSetRecordColumnIndexType" use="optional" default="13"/>
		<xs:attribute name="signatureIndex" type="resultSetRecordColumnIndexType" use="optional" default="14"/>
		<xs:attribute name="mode" type="resultSetRecordColumnIndexType" use="optional" default="15"/>
		<xs:attribute name="occurs" type="resultSetRecordColumnIndexType" use="optional" default="16"/>
		<xs:attribute name="parameterSequence" type="resultSetRecordColumnIndexType" use="optional" default="17"/>
		<xs:attribute name="dataLevel" type="resultSetRecordColumnIndexType" use="optional" default="18"/>
		<xs:attribute name="dataLevelPosition" type="resultSetRecordColumnIndexType" use="optional" default="19"/>
	</xs:attributeGroup>
	<xs:attributeGroup name="uniqueKeysRecordIndexMappings">
		<xs:attributeGroup ref="parentQueryObjectRecordIndexMappings"/>
		<xs:attribute name="keyName" type="schemaChildObjectNameIndexType" use="optional" default="4"/>
		<xs:attribute name="refColumnName" type="refColumnNameIndexType" use="optional" default="5"/>
		<xs:attribute name="refColumnSequence" type="refColumnSequenceIndexType" use="optional" default="6"/>
		<xs:attribute name="description" type="resultSetRecordColumnIndexType" use="optional" default="unsupported"/>
	</xs:attributeGroup>
	<xs:attributeGroup name="tablesRecordIndexMappings">
		<xs:attributeGroup ref="parentSchemaRecordIndexMappings"/>
		<xs:attribute name="tableName" type="resultSetRecordColumnIndexType" use="optional" default="3"/>
		<xs:attribute name="systemFlag" type="resultSetRecordColumnIndexType" use="optional" default="4"/>
		<xs:attribute name="tableType" type="resultSetRecordColumnIndexType" use="optional" default="5"/>
		<xs:attribute name="description" type="resultSetRecordColumnIndexType" use="optional" default="unsupported"/>
	</xs:attributeGroup>
	<xs:attributeGroup name="indexesRecordIndexMappings">
		<xs:attributeGroup ref="parentSchemaRecordIndexMappings"/>
		<xs:attribute name="indexName" type="resultSetRecordColumnIndexType" use="optional" default="3"/>
		<xs:attribute name="isUnique" type="resultSetRecordColumnIndexType" use="optional" default="4"/>
		<xs:attribute name="storageType" type="resultSetRecordColumnIndexType" use="optional" default="5"/>
		<xs:attribute name="refColumnCatalog" type="refCatalogNameIndexType" use="optional" default="6"/>
		<xs:attribute name="refColumnSchema" type="refSchemaNameIndexType" use="optional" default="7"/>
		<xs:attribute name="refColumnQueryObject" type="refQueryObjectNameIndexType" use="optional" default="8"/>
		<xs:attribute name="refColumnSequence" type="refColumnSequenceIndexType" use="optional" default="9"/>
		<xs:attribute name="refColumnName" type="refColumnNameIndexType" use="optional" default="10"/>
		<xs:attribute name="sortOrder" type="resultSetRecordColumnIndexType" use="optional" default="11"/>
		<xs:attribute name="description" type="resultSetRecordColumnIndexType" use="optional" default="unsupported"/>
	</xs:attributeGroup>
	<xs:attributeGroup name="synonymsRecordIndexMappings">
		<xs:attributeGroup ref="parentSchemaRecordIndexMappings"/>
		<xs:attribute name="synonymName" type="resultSetRecordColumnIndexType" use="optional" default="3"/>
		<xs:attributeGroup ref="objectReferenceRecordIndexMappings"/>
		<xs:attribute name="systemFlag" type="resultSetRecordColumnIndexType" use="optional" default="7"/>
		<xs:attribute name="description" type="resultSetRecordColumnIndexType" use="optional" default="8"/>
		<xs:attribute name="refQueryObjecttType" type="resultSetRecordColumnIndexType" use="optional" default="9"/>
	</xs:attributeGroup>
	<xs:attributeGroup name="foreignKeysRecordIndexMappings">
		<xs:attributeGroup ref="parentQueryObjectRecordIndexMappings"/>
		<xs:attribute name="foreignKeyName" type="resultSetRecordColumnIndexType" use="optional" default="4"/>
		<xs:attribute name="exportedColumn" type="refCatalogNameIndexType" use="optional" default="5"/>
		<xs:attribute name="columnSequence" type="refColumnSequenceIndexType" use="optional" default="6"/>
		<xs:attribute name="importedCatalog" type="refCatalogNameIndexType" use="optional" default="7"/>
		<xs:attribute name="importedSchema" type="refSchemaNameIndexType" use="optional" default="8"/>
		<xs:attribute name="importedTable" type="refQueryObjectNameIndexType" use="optional" default="9"/>
		<xs:attribute name="importedUniqueKey" type="resultSetRecordColumnIndexType" use="optional" default="10"/>
		<xs:attribute name="importedColumn" type="refKeyNameIndexType" use="optional" default="11"/>
		<xs:attribute name="description" type="xs:string" use="optional" default="12"/>
	</xs:attributeGroup>
	<xs:attributeGroup name="parentQueryObjectRecordIndexMappings">
		<xs:attributeGroup ref="parentSchemaRecordIndexMappings"/>
		<xs:attribute name="parentQueryObject" type="resultSetRecordColumnIndexType" use="optional" default="3"/>
	</xs:attributeGroup>
	<xs:attributeGroup name="schemaReferenceRecordIndexMappings">
		<xs:attribute name="refCatalogIndex" type="refCatalogNameIndexType" use="optional" default="4"/>
		<xs:attribute name="refSchemaIndex" type="refSchemaNameIndexType" use="optional" default="5"/>
	</xs:attributeGroup>
	<xs:attributeGroup name="objectReferenceRecordIndexMappings">
		<xs:attributeGroup ref="schemaReferenceRecordIndexMappings"/>
		<xs:attribute name="refQueryObjectIndex" type="refQueryObjectNameIndexType" use="optional" default="6"/>
	</xs:attributeGroup>
	<xs:attributeGroup name="columnReferenceRecordIndexMappings">
		<xs:attributeGroup ref="objectReferenceRecordIndexMappings"/>
		<xs:attribute name="refColumnIndex" type="resultSetRecordColumnIndexType" use="optional" default="4"/>
	</xs:attributeGroup>
	<xs:attributeGroup name="importRule">
		<xs:attribute name="extractionFailureFallback" type="xs:string" use="optional" default="none"/>
	</xs:attributeGroup>
	<xs:element name="sqlObjectImportRules">
		<xs:complexType>
			<xs:group ref="sqlAccess"/>
		</xs:complexType>
	</xs:element>
</xs:schema>