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