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 ...

Get Oracle Siebel CRM 8 Developer's Handbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.