Configuring Siebel eBusiness Applications > Configuring Tables and Columns > About Extension Tables >

About One-to-One Extension Tables

Names of one-to-one extension tables are appended with the suffix _X. Rows in the extension table have one-to-one relationships with corresponding rows in the base table. They are basically an extension of the base table record. The Type property of a one-to-one extension table is set to the value Extension.

One-to-many extension tables require that you create new fields for the business component of the base table and map them to available columns in the one-to-one extension table. For example, consider the example shown in Figure 11. Three fields, Hobby, Married, and Spouse, are added to the Contact business component and map to columns in the S_CONTACT_X extension table.

Figure 11.  Extension Table Example

Related Topics

Configuring Data-Driven Read-Only Behavior

Using Static 1:1 Extension Tables

Creating 1:1 Extension Tables Using the Object List Editor

Creating New Tables Using the New Table Wizard