Use this task to create a simple table in the One Identity Manager schema.
Technical details
-
The technical identifier for the table is automatically formed according to the CCC<Table name> schema.
-
The following columns are generated automatically:
-
Primary key column
The primary key column is automatically transferred as the UID. The name of the primary key column is formed according to the UID_CCC<table name>.
-
X columns (XUserInserted, XUserUpdated, XDateInserted, XDateUpdated, XTouched, XObjectKey, XMarkedForDeletion)
-
To create a simple table in the Schema Extension
-
Start the Launchpad and log in to the One Identity Manager database.
-
Open the Launchpad and select the One Identity Manager Schema Extension entry. This starts the Schema Extension program.
-
Click Next on the start page.
-
On the Database connection page, check the connection data for the One Identity Manager database.
-
On the Select method page, select New table.
-
On the Create new table page, enter the following information.
Table 167: Table properties Property Description Table
A technical name for the table.
Display name
Displays table name The display name is used, for example, to identify the table in a database search or for error output.
Description
Comments on using the table.
-
On the Configure columns of table page, create the new columns. For more information, see Defining columns.
.
to configure more column properties.