Database Schema and Views Reference Guide › Database Schema Introduction

Database Schema Introduction

This guide contains the database table specifications used by the CA DataMinder product. It is provided to allow customers to develop additional customized database queries. To make the best use of this document, you must be familiar with relational database design and have a thorough understanding of SQL.

This guide is based on the database schema version 3.80 used by CA DataMinder 14.1 (build 3000 and its derivatives). A diagram showing the relationship between all documented tables is included in the Table Schema Diagram section.

This section contains the following topics:

Datatypes

IDM Columns

CA DataMinder Datatype Mappings