Introduction to Database Mappings
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 icon. Database columns are represented by the 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.
This column is used as the table's primary key. | |
This column has a unique constraint. | |
This column has a foreign key that references the primary key of a different table. | |
This column contains XML data. | |
There is a default value set for this column. If no value is supplied to this column, the default value will be inserted instead. |