Bookshelf Home | Contents | Index | Search | PDF

Siebel Tools Reference > Adding Custom Extensions to the Data Model >

Creating New Tables Using the Table Wizard

---

The Table Wizard allows you to create new stand-alone tables, extension tables, and intersection tables. It provides picklists with appropriate choices for each type of table and makes sure that the naming conventions are observed. You can only create tables of types: Data (Public), Data (Intersection), and Data (Extension). You must explicitly grant permissions on any table that you create.

To use the Table Wizard

1. Choose File > New Objects.

   The New Objects dialog box appears.

2. Select the Table Wizard icon.

   The General dialog box appears.
3. In the "Enter a name for the new Table" field, it is noted that you must enter a new table that starts with "CX_" or it will automatically add a prefix.

   NOTE:  The Table Name must be upper case. Mixed case or lower case names may lead to problems when applying the changes on certain databases.
   If you choose 1:1 extension tables, "_X" is suffixed to the table names.

4. In the "Choose a Project in which you wish to create the Table" field, choose a project.

   NOTE:  The Project list is restricted only to those projects that have been locked by the developer. All picklists are restricted to objects that belong to projects that are locked.

5. In the "Select the type of the Table" field, choose from the options: A stand-alone Table, 1:1 Extension Table for an existing Table, M:1 Extension Table for an existing Table, An intersection Table between two existing Tables.
6. Click Next.

   NOTE:  The next dialog box displayed depends on the type of table that is being added.

   1. If you choose Stand-alone Tables, the Parent Specification Table dialog box is not displayed and you are taken to the Finish dialog box, stating that the new table can now be created.
   2. For 1:1 Extension Tables and M:1 Tables, the Parent Specification Table dialog box allows you to select the parent table. See the following figure:
   3. For 1:1 Extension Tables, the picklist of available parent tables is restricted to tables of type Data (Public).
   4. For M:1 Extension Tables, the picklist of available parent tables is restricted to tables of type Data (Public).

      NOTE:  Users can add new columns to S_CONTACT, S_ORG_EXT, S_POSTN, or S_USER, for example (and this is generally preferable to adding new columns to S_PARTY); they cannot create new 1:1 relationships to them.

   5. For Intersection Tables, the dialog box allows you to add both parent tables and names of foreign key columns to the parent tables. See the following figure.
   • The picklist for the "Select the first Parent Table" field is restricted to all tables of type Data (Public).
   • The picklist for the "Select the second Parent Table" field is restricted to tables of type Data (Public) with the following added restrictions, based on the choice of the first parent table.
   • The names of the Foreign Key columns ("Enter a Foreign Key Column name for the first Parent Table" field and "Enter a Foreign Key Column name for the second Parent Table" field) are verified to make sure that they are unique (that is, do not conflict with each other or the system column names).
7. Click Next on the Parent Table Specification dialog box.

   The Finish dialog box appears, which allows you to review the changes made before the objects are actually created. The Finish dialog box verifies that "The new Table can now be created" and asks you to make sure that the information about the Name, Project, Type of Table, and Parent Table 1 is correct.

8. Click Finish to generate the table.

   You then see the new table listed (User Name CX_X) in the Object List Editor (the Type is Extension, the Base Table is CX).

Table Wizard Actions

The following columns are generated by the Table Wizard.

• For all types of tables, the Table Wizard creates seven system columns and the P1 index on ROW_ID.
• For 1:1 Extension Tables, the Table Wizard sets Type of Table ='Extension' and creates the following:
  • PAR_ROW_ID column
    • User Key Sequence=1
    • Foreign Key Table=<Base Table Name>
  • U1 index comprised of PAR_ROW_ID(1) and CONFLICT_ID(2)
    • Unique/Cluster=TRUE
    • Type=User Key
    • User Primary Key=TRUE
• For M:1 Extension Tables, the Table Wizard sets Type of Table=Data (Public) and creates the following:
  • PAR_ROW_ID, TYPE, NAME columns
  • U1 index comprised of PAR_ROW_ID(1), TYPE (2), NAME (3), and CONFLICT_ID (4)
    • Unique/Cluster=TRUE
    • Type=User Key
    • User Primary Key=TRUE
  • M1 index on TYPE (1) and NAME (2)
    • Unique/Cluster=FALSE
    • Type=System
  • P1 index on ROWID
• For intersection tables, the Table Wizard sets the type of the table to Data(Intersection) and creates the following:
  • TYPE column for added user functionality
  • Two Foreign Key columns with names specified in the Table Wizard

    User Key Sequence=1 and 2

    Foreign Key Table=<Parent Table>

  • U1 index on the two Foreign Keys (1, 2), TYPE (3), and CONFLICT_ID (4)

    Unique/Cluster=TRUE

    Type=User Key

    User Primary Key=TRUE

  • F1 index on the Foreign Key to the second parent table

NOTE:  When a custom extension table is added using the Table Wizard, a U1 index is added to the table. However, the User Key column is blank and does not allow the definition of user keys. This is because there is no need to create user keys: they are only needed to resolve foreign keys while using EIM, and EIM does not work with foreign keys to custom tables.

Bookshelf Home | Contents | Index | Search | PDF