To add a simple column in the table in the Schema Extension
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>.
The following restrictions apply if the new column is a foreign key:
CCC-<database ID>-<4 digit sequential number>
CCC-<database ID>-<4 digit sequential number> <Name of referenced table>
To add a foreign key column in the table in Schema Extension
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.
To create a new column for a database view in the Schema Extension
To edit column properties
You can configure the following settings for a column.
|Name||Technical identifier for the column.|
|Data type||Permitted .Net data types are listed in a pop-up menu. These are represented internally as SQL data types.|
|Length||A length is only given for the .Net data type "String". A length of 38 is entered for a UID.|
|Column contains UIDs||Marks a column as a UID (table DialogColumn, column IsUID). This option is only permitted for columns with the .Net data type "String" and length 38.|
|Column contains unicode||Marks the column as unicode. This option is only permitted for .Net data types "String" and "Text".|
|Primary key||The primary key is used.|
|Compulsory field||Labels column as compulsory (table DialogColumn, column CustomMinLen).|
|Display name||Column name for displaying (table DialogColumn, column Caption).|
|Display in Filter Designer||The column is displayed in the Filter Designer or the Rule Editor for creating request.|
|Do not auto extend permissions||Permissions for predefined permissions groups are not issued automatically for this custom schema extension on a predefined table, even if the configuration parameter "Common\AutoExtendPermissions" is set.|
|Comment||Enter a comment, which provides information about using the new column.(table DialogColumn, column CustomComment).|
Specifies an initial value for the column. This is transferred to the existing data set in the extended table. The initial value for numerical data types is "0". The initial value for the data type "Bool" is "False".
|Sort order||The sort order specifies the position for displaying the column on the generic form and the custom tab of the default form. Columns with a value less than one are not displayed.|
|Foreign key||This is a foreign key column.|
|From table||Only for foreign key tables: references tables by foreign key relations.|
|Delete restrictions||Only for foreign keys: restrictions for testing referential integrity when an object is deleted.|
|Insert restrictions||Only for foreign keys: restrictions for testing referential integrity when an object is inserted.|
Only value types that are already in the One Identity Manager data model are permitted.
|.Net Data Types||SQL Server data type|
|String||Varchar/nVarchar and Char (only String(38))|
|DeleteNotRestricted (D)||Dependencies are not taken into account on deletion.|
|DeleteRestrict (DR)||The object can only be deleted when no more references to other objects exist.|
|DeleteCascade (DC)||All dependent objects are deleted when this object is deleted.|
|DeleteSetNULL (DS)||All links to other objects are deleted when the object is deleted (SetNULL).|
|InsertNotRestricted (I)||Dependencies are not taken into account on insertion.|
|InsertRestrict (IR)||Checks for the referenced object when the object is added.|