Altova MapForce 2023 Enterprise Edition

Introduction to Database Mappings

Home Prev Top Next

This section explains how to add a database to your mapping, select, remove, and edit database objects, handle database relationships, and configure various database settings.

 

Database column icons

Database tables are represented by the icDBTable icon. Database columns are represented by the icDBColumn icon. If there is a constraint set for the column, the column's icon will have an additional symbol. If a column has more than one constraint assigned to it, only the constraint with the highest priority is shown in the column icon. The priority of constraints is described in the table below, starting with the highest priority.

 

icDBPrimaryKeyColumn

This column is used as the table's primary key.

icDBUniqueKeyColumn

This column has a unique constraint.

icDBForeignKeyColumn

This column has a foreign key that references the primary key of a different table.

icDBXMLColumn

This column contains XML data.

icDBDefaultValueColumn

There is a default value set for this column. If no value is supplied to this column, the default value will be inserted instead.

 

© 2017-2023 Altova GmbH