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

1. Start the Launchpad and log in to the One Identity Manager database.

2. Open the Launchpad and select the One Identity Manager Schema Extension entry. This starts the Schema Extension program.

3. Click Next on the start page.

4. On the Database connection page, check the connection data for the One Identity Manager database.

5. On the Select method page, select New table.

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

7. On the Configure columns of table page, create the new columns. For more information, see Defining columns.

Related topics

• Table types and default columns in the One Identity Manager data model
• Extending tables
• Creating new assignment tables
• Creating database views with read-only type
• Creating database views with Union type