Creating custom tables

To support entirely new business entities or a very large number of extension columns, Siebel Tools provides the ability to create custom table definitions using the New Table wizard. The following types of tables can be created:

• Standalone tables

• 1:1 extension tables for existing tables

• 1:M extension tables for existing tables

• Intersection tables to support many-to-many (M:M) relationships

The New Table wizard creates the table and all required system columns as well as some index and user key definitions. However, any additionally required attribute columns as well as any required indexes or user keys must be created manually.

Case study example: Creating a custom standalone table

One of the key requirements of the All Hardware Company is to provide a unified list of all customer documents (opportunities, quotes, orders, and campaign responses) to their employees.

The technical architects have determined that a custom table must be created to support the storage of the document...