Overview of an Intersection Table

An intersection table is a table that defines a many-to-many relationship. It includes an intersection between two business components. A many-to-many relationship includes a one-to-many relationship from either direction. For example, a many-to-many relationship exists between Accounts and Contacts. You can view this relationship in the Siebel client:

The Account Detail - Contacts View displays one account with multiple detail contacts.
The Contact Detail - Accounts View displays one contact with multiple detail accounts.

Siebel CRM can include the two different views in different business objects. The business objects associate the two business components in opposite directions.

No database construct directly creates a many-to-many relationship. Instead, the Siebel schema uses two links and an intersection table to create a many-to-many relationship.

The following figure gives an example of how an intersection table defines a many-to-many relationship.

Example of how an intersection table defines a many-to-many relationship: This image is described in the surrounding text.

This figure shows that the many-to-many relationship between Opportunity Business Component and Contact Business Component can be implemented as follows:

Define a one-to-many relationship between Opportunity Business Component and S_OPTY_CON Intersection Table.
Define a many-to-one relationship between S_OPTY_CON Intersection Table and Contact Business Component.

The Type property of an intersection table contains Data (Intersection).

You can add custom extension columns to an intersection table. You cannot use custom extension tables to configure an intersection table. For more information, see About Links.