Relationship Mapping Editor Overview

When you have foreign-key relationships between database tables, you will usually want to preserve those relationships in the CMP beans mapped to those tables. The Relationship Mapping editor lets you determine how relationships between mapped CMP beans are stored in the database. Relationships enable navigation from one bean to another in the same way that a foreign key enables navigation from one table to another.

The Relationship Mapping Editor takes you through the following steps:

  1. Establish relationships between related beans and fields.
  2. Link the mapped tables directly in a 1-1 or 1-n relationship, or using a join table.
  3. If you link the mapped tables using a join table, the next step is to map the relationship field to a key, either local or foreign.

See also

Mapping
Primary and Secondary Tables
Selecting a Secondary Table
Mapping Fields to Multiple Columns
Relationship Mapping Editor: Map to Key
Relationship Mapping Editor: Local to Join
Relationship Mapping Editor: Join to Foreign


Legal Notices