Unique Identifier (UID, or Key) Properties

This dialog box displays the properties of a candidate key, which is an object defined in the Logical Model.

General

Name: Name of the key.

Synonym: Synonym for the key.

Long Name: Long name for display purposes.

State: State or purpose of the key: Primary Key or Unique Key.

Attributes and Relations

Displays attributes and relations that are available to be added to the key definition on the left, and attributes and relations that are included in the index definition on the right. You can select attributes and relations and use the arrow keys to move them from one side to the other.

Engineer To

Enables you to specify the relational models to which this key should be propagated in forward engineering operations.

Engineer: Controls whether the key is propagated to the specified Relational Design (model) during forward engineering operations.

Impact Analysis

Enables you to view and specify information to be used by Oracle Warehouse Builder for impact analysis.

Comments, Notes, Measurements, Change Requests, Responsible Parties, Documents, Summary

See Common Information in Dialog Boxes.