Relationships and Domains › Relationships in the Physical Model › Non-Identifying Relationships in the Physical Model

Non-Identifying Relationships in the Physical Model

A non-identifying relationship is a relationship between two tables in which an instance of the child table is not identified through its association with a parent table, which means the child table is not dependent on the parent table for its identity, and can exist without it. In a non-identifying relationship, one instance of the parent table is related to multiple instances of the child.

You can add these types of non-identifying relationships:

• Optional non-identifying relationship
• Mandatory non-identifying relationship

You can also use non-identifying relationships to create recursive relationships.

Note: Primary keys are automatically migrated from a parent table to a child table, so you do not need to enter any foreign keys in the child.

More information:

Optional Non-Identifying Relationships in the Physical Model

Mandatory Non-Identifying Relationships in the Physical Model