Mapping Many-to-Many Relationships

The Many To Many Table Mapping sheet of the Relational Population Service wizard enables you to specify options for the many-to-many inverse relationships selected on the Many To Many Table Selection sheet. (For details, see "Adding Many-to-Many Relationships to an RPS Mapping", in the previous section.) This sheet is displayed only if the Show Many To Many combo box is checked on the Define RPS sheet in step 1 of the RPS mapping. (For details, see "Setting Up the RPS Options", earlier in this chapter.)

An example of the RPS Column Mappings sheet is shown in the following image.

This sheet displays the junction tables included in the mapping and the class to which it is mapped. The default name of the junction table is in the class‑name_collection‑name format.

To specify generated table and columns names for many-to-many relationships

1. If you want to change the name of a table, enter the required name in the appropriate row in the Table column.

2. To mark the table as excluded, check the Excluded check box in the appropriate row.

3. To include one or more special columns, check the appropriate _operation, _tranid, or _timestamp check box in the respective columns.