Identity Manager 8.0 - Configuration Guide

Defining Columns

On the Define columns page in the Schema Extension, you can see which columns already exits for the selected table and how many resources are free for new columns.

If the table you are extending is a simple table (table type "T") or a base table (table type "B") then you can decide whether to create a simple or a foreign key column.

If the table to be extended is a "V" (view) type, only the custom columns of the underlying base table (type "B") are shown in the selection menu. You can only select custom columns from the base table that are not yet used in the view.

The following functions are available to you:

Table 310: Functions

Icon	Meaning
	Adds a new column.
	Deletes a newly inserted column definition.
	Displays the configuration options for column properties.

Detailed information about this topic

• Creating a Simple Column
• Creating a Foreign Key Column
• Creating New Columns for Database Views
• Configuring Column Properties

Related Topics

• Mapping Table Definitions
• Mapping Column Definitions

Creating a Simple Column

To add a simple column in the table in the Schema Extension

1. Click on the Define column page.
2. Select Simple column.
3. Enter the name of the column in Column name.

   If a custom table is extended,you can give it any name. If a default table is extended, the column must begin with the prefix "CCC". The column name is formatted as CCC_<column name>.

4. Click OK.
5. Configure more column properties.

Related Topics

• Creating a Foreign Key Column
• Creating New Columns for Database Views
• Configuring Column Properties

Creating a Foreign Key Column

The following restrictions apply if the new column is a foreign key:

• The name of the new column must be unique in the table.
• The referenced table has a one column primary key.
• The value type and some other properties are taken from the referenced table primary key column.
• Validation of referential integrity is done by DLL or triggered.
• The table and column relations are created automatically. Column relations follow the naming convention:

  CCC-<database ID>-<4 digit sequential number>

• If a database view is extended by a foreign key, the column relations following the naming convention:

  CCC-<database ID>-<4 digit sequential number> <Name of referenced table>

• If a column is referenced from a base table (table type "B"), the table and column relations are also created for the underlying base table.

To add a foreign key column in the table in Schema Extension

1. Click on the Define column page.
2. Select Foreign key column.
3. Select the referenced table in From table.
4. Enter the name of the column from the referenced table in Column name.
5. Click OK.
6. Configure more column properties.

Related Topics

• Creating a Simple Column
• Creating New Columns for Database Views
• Configuring Column Properties
• Mapping Table Relations

Creating New Columns for Database Views

If the table to be extended is a "V" (view) type, only the custom columns of the underlying base table (type "B") are shown in the selection menu. You can only select custom columns from the base table that are not yet used in the view.

• First extend the base table by a new column (simple column or foreign key column).
• Then you extend the database view with the new columns.

To create a new column for a database view in the Schema Extension

1. Click on the Configure columns page.
2. Select the base table column to be inserted into the database view from Base column.
3. Enter the name of the column in Column name.
4. Click OK.
5. Configure more column properties.

Related Topics

• Creating a Simple Column
• Creating a Foreign Key Column
• Configuring Column Properties
• Database Views of Type “View“