Using preconfigured extension tables

Because extending the standard database schema is often associated with high effort and therefore costs, the Siebel data model designers have catered for so-called extension tables.

These tables are preconfigured to provide physical storage space for additional custom business component fields and even custom child business components without the need to create new columns or tables.

The following types of extension tables exist in the Siebel CRM schema:

• One-to-one (1:1) extension tables, supporting custom fields

• One-to-many (1:M) extension tables, supporting custom child business components

In the following section, we will discuss these table types and provide case study examples, how to use them to create new custom business component fields and custom child business components.

Using 1:1 extension tables

We can describe a 1:1 extension table with the following attributes:

• The Type property of the table object definition is Extension or Extension (Siebel)...