Joining Strategy

Use this area to specify a mapped column for joining an entity association. By default, the mapping is assumed to have a single join.

Property Description Available for Mapping Type

Mapped by

The field in the database table that "owns" the relationship. This field is required only on the non-owning side of the relationship.

Many-to-many mapping, One-to-many mapping, and One-to-one mapping

Attribute



Primary key join columns


One-to-one mapping


Join columns

By default, the name is assumed to be the primary tables associated with the entities concatenated with an underscore.

Select Override Default, then Add, Edit, or Remove the join columns.

Many-to-one mapping, One-to-many mapping, and One-to-one mapping

Join table


Many-to-many mapping, Many-to-one mapping, One-to-many mapping, and One-to-one mapping

Name

Name of the join table that contains the foreign key column.You must specify the join table on the owning side.

By default, the name is assumed to be the primary tables associated with the entities concatenated with an underscore.


Schema

Schema of the table


Catalog

Catalog of the table


Join columns

The foreign key columns of the join table which reference the primary table of the entity owning the association. (that is, the owning side of the association).


Inverse join columns

The foreign key columns of the join table which reference the primary table of the entity that does not own the association. (that is, the inverse side of the association).