Relationships and Domains › Relationships in the Physical Model

Relationships in the Physical Model

This section contains the following topics:

Relationships in the Physical Model

Identifying Relationships in a Physical Model

Non-Identifying Relationships in the Physical Model

Optional Non-Identifying Relationships in the Physical Model

Mandatory Non-Identifying Relationships in the Physical Model

Relationship Tools in the Physical Model

Add a New Relationship in a Physical Model

Recursive Relationships

Specify Physical Properties for a Relationship

Set the Default Null Option for a Non-Identifying Relationship

Display a Relationship in the Physical Model Only

Delete a Relationship

Set Relationship Cardinality

Foreign Key Names

Assign a Foreign Key Constraint Name

Enter a Foreign Key Comment to a Relationship

Assign a Rolename to a Migrated Index

Define Referential Integrity Trigger Actions for Relationships

Assign Relationship UDP Values in a Physical Model

Subtype Relationships in the Physical Model

Partial Key Migration

Migrate a Partial Key in the Physical Model