Work That the New Table Wizard Performs

If you use the New Table Wizard to create a custom extension table, then this wizard adds a U1 index to the table. The User Key column is empty. Siebel CRM does not support creating a user key on a custom table.

For all tables, the New Table Wizard creates seven system columns and a P1 index on ROW_ID.

For a one-to-one extension table, the wizard sets the Type property to Extension and does the following work:

• Creates a column for PAR_ROW_ID

  • Sets the User Key Sequence property to 1

  • Sets the Foreign Key Table property to BASE_TABLE_NAME

• Creates a U1 index that includes PAR_ROW_ID(1) and CONFLICT_ID(2)

  • Sets the Unique and Cluster properties to TRUE

  • Sets the Type property to User Key

  • Sets the User Primary Key property to TRUE

  For a many-to-one extension table, the New Table Wizard sets the Type property to Data (Public) and does the following work:

• Creates the following columns:

  • PAR_ROW_ID

  • TYPE

  • NAME

• Creates a U1 index that includes PAR_ROW_ID(1), TYPE (2), NAME (3), and CONFLICT_ID (4)

  • Sets the Unique and Cluster properties to TRUE

  • Sets the Type property to User Key

  • Sets the User Primary Key property to TRUE

• Creates an M1 index on TYPE (1) and NAME (2)

  • Sets the Unique and Cluster properties to FALSE

  • Sets the Type property to System

  For an intersection table, the New Table Wizard sets the Type property to Data(Intersection) and does the following work:

• Creates a TYPE column for added user functionality

• Creates two Foreign Key columns using names you defined in the wizard

  • Sets the User Key Sequence property to 1 and 2

  • Sets the Foreign Key Table property to Parent Table

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

  • Sets the Unique and Cluster properties to TRUE

  • Sets the Type property to User Key

  • Sets the User Primary Key property to TRUE

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