Table |
Name of the table in the data model. |
Usage type |
The table's usage type provides the basis for reports and the selection of tasks for daily maintenance.
Permitted values are:
-
Work tables: The table is a work table and contains transaction data.
-
Historical transaction data: The table contains transaction data to create histories.
-
Configuration: The table contains data for the system configuration.
-
Materialized data: The table contains materialized data. This is recreated through DBQueue Processor calculations.
-
Read-only data: The table contains read-only data.
-
User data: The table contains user data. |
Display name (singular) |
Display name for a single record in the table. Translate the given text using the button. |
Display name (plural) |
Displays table name The display name is used, for example, to identify the table in a database search or for error output. Translate the given text using the button. |
Display template |
The display template is used to specify the form in which objects will be represented, for example in the administration tool result list or in reports. Translate the given text using the button.For more information, see Display template for displaying a list.
NOTE: You do not need to enter a display template for many-to-many tables. For these tables, the viDB.DLL forms the display template from the foreign keys. |
Display template (long) |
Additional display template for individual tables containing the object's full name. |
Hierarchy path |
Enter the foreign key columns here that should be used as a basis for displaying tables hierarchically, for example, on assignment forms. For more information, see Hierarchical display of data on assignment forms.
Example:
An Active Directory user account (ADSAccount table) is typically displayed on an assignment form below its Active Directory container (UID_ADSContainer column). The Active Directory container (ADSContainer table) is, on the other hand, displayed underneath its Active Directory domain (UID_ADSDomain column). The path for the hierarchy structure is entered as follows:
Table |
Hierarchy path |
ADSAccount |
UID_ADSContainer,UID_ADSDomain |
ADSContainer |
UID_ADSDomain |
An alternative list for objects that do not have values in all foreign key columns can be given after a pipe (|).
Example:
(UID_ADSContainer,UID_ADSDomain|UID_ADSDomain) |
Remarks |
Text field for additional explanation. |
Cache information |
Loading behavior for tables in the Designer. This data is only required for system tables. Cache information for a table is composed of the sort order and loading behavior.
Permitted values are:
-
Base table: The table is loaded before the user interface.
-
User table: The table is only filled for the current user.
-
Data table: The table is loaded in the background after the user interface is loaded.
-
Proxy: The table is displayed as a view of the original table in the Designer. The data is loaded but cannot be modified.
-
Load BLOBS: Columns with larger data sets (BLOB columns) are loaded.
-
No caching: The table is not loaded in the Designer. |
Disabled by preprocessor |
If a table is disabled by a preprocessor condition, the option is set by the Database Compiler. For more information, see Conditional compilation using preprocessor conditions. |
Preprocessor condition |
You can add preprocessor conditions to tables. The table is therefore only available together with its columns when the preprocessor condition is fulfilled. For more information, see Conditional compilation using preprocessor conditions. |
Deferred deletion [days] |
Number of days to defer the delete operation. If the value is 0, it is deleted immediately. For more information, see Specifying deferred deletion for objects. |
Script (deferred deletion) |
Script in VB.Net syntax to determine an object-specific deferred deletion. For more information, see Specifying deferred deletion for objects. |
Icon |
Icon representing the table in the administration tool interface. |
Background color |
Color used to display the control for this table in the schema overview. |
Proxy view |
Reference to database view, type Proxy, which uses the table content.
Example:
The database view UNSRoot is used to map the ADSDomain and LDAPDomain tables in the Unified Namespace.
For more information, see Database views of the proxy type. |
Extensions to proxy view |
List of columns as SQL text. These are used in the database view's SELECT statement that is selected under Proxy view. For example, use the extensions to the proxy view if columns are doubly mapped or if additional proxy view need to be filled.
Example:
The view UNSRoot expects the target system type as input in the UID_DPRNameSpace column. This column is not in the ADSDomain and LDAPDomain tables.
The proxy view extension is defined as follows:
Table |
Extension to proxy view |
ADSDomain |
'ADS-DPRNameSpace-ADS' as UID_DPRNameSpace |
LDPDomain |
'LDP-DPRNameSpace-LDAP' as UID_DPRNameSpace |
For more information, see Database views of the proxy type. |
Logical disk store |
The table's logical disk store. Associated tables are grouped together in logical disk stores. In the default installation, logical disk stores are predefined for the table in each module of One Identity Manager and the system tables. You cannot change the assignments. You can create your own logical disk storage for grouping custom tables. Supporting file groups |
Scope hierarchy |
Comma delimited list of all foreign key columns required for displaying objects in the scope hierarchy in the Synchronization Editor. List of all columns that lead to tables made available by the parent object. |
Identity object path for table lookup support |
Path to the identity object (UID_Person) for finding the identity object within the table lookup search for user accounts and email addresses. The resulting data is mapped in QBMSplittedLookup.SplittedElement. If the value no is entered, no identity can be determined for groups or BaseTree derivatives, for example.
Example:
In the case of Exchange Online mailboxes (O3EMailbox table), the identity is determined through the Azure Active Directory user accounts.
Enter the path to the identities object as follows: FK(UID_AADUser).UID_Person |
Export for SPML schema |
This option determines whether the table should be exported for the SPML schema. |
Many-to-many table |
Label for assignment tables (many-to-many tables). Assignment tables are tables used to create relations between two other tables. For more information, see Table types and default columns in the One Identity Manager data model. |
Many-to-all table |
Marks assignment tables, which have a dynamic foreign key as partner. For more information, see Table types and default columns in the One Identity Manager data model. |
No DB Transport |
Tables labeled with this option cannot be excluded from a custom configuration package. These tables are excluded from data transport. |
Condition for transport |
Condition for selecting transportable objects. An empty condition means that all object are transferred. |
Single-user mode for transport |
Condition determines the transferable objects that require the database to be in single user mode when they are imported. If the condition is empty, single-user mode is not required. |
Assign by event |
Specifies how assignments and deletions are handled in tables. This option only applies to assignment tables (many-to-many tables) in the application data model.
-
If the option is not set, assignments, and deletions are dealt with directly by the DBQueue Processor.
-
If the option is set, tasks for the HandleObjectComponent process component are set up in the Job queue. These tasks then carry out the relevant operations. This makes it possible to link specific processes directly to the Assign and Remove events. You must implement this behavior on a custom basis. |
Retain in memory |
Specifies whether the table contents for the data connection can be buffered. The threshold is defined in the Common | ResidentTableLimit configuration parameter. |
Module GUID permitted |
Specifies whether a primary key with a Globally Unique Identifier module (GUID module) is permitted for objects. For more information, see Working with a globally unique identifier module. |
Module GUID required |
Specifies whether a primary key with a Globally Unique Identifier module (GUID module) is required for objects. For more information, see Working with a globally unique identifier module. |
Type |
Table type. For more information, see Table types in One Identity Manager. |
Base table |
Only for database views: Reference to base tables that a view is based on. |
Condition for view definition |
Only for database views: Limiting condition for creating the database view as WHERE clause for database queries. |
Insert values |
Specify default settings for a column that is assigned when a new data set is added. The values are entered in VB.Net syntax. |
Selection script |
Only for database views: Selection script as VB.Net expression to determine at runtime, whether the object passed belongs to this database view. |
Script (OnLoaded) |
Script in VB.Net syntax that is run after the object is loaded. For more information, see Table scripts. |
Script (OnSaving) |
Script in VB.Net syntax that is run before the object is saved. For more information, see Table scripts. |
Script (OnSaved) |
Script in VB.Net syntax that is run after the object is saved. For more information, see Table scripts. |
Script (OnDiscarding) |
Script in VB.Net syntax that is run before the object is discarded. For more information, see Table scripts. |
Script (OnDiscarded) |
Script in VB.Net syntax that is run after the object is discarded. For more information, see Table scripts. |
Number of rows |
Number of rows in the table The number of rows in the table is determined once a day by maintenance tasks. The data material can help to plan capacities and maintenance work on the database. |
Basic record lengths |
Maximum length of the data record with (clustered) main indexes. Only the reference is saved for LOBs. The LOB content itself is stored in the HEAP. The basic record length is determined once a day by maintenance tasks. The data material can help to plan capacities and maintenance work on the database. |
Table size |
The size of the table in MB. The size of the table in the database is determined once a day by maintenance tasks. The data material can help to plan capacities and maintenance work on the database. |
Layout information |
(Only for internal use) Information about the layout in the Designer. |
Primary key 1 |
(Only for internal use) Name of the table's first primary key column. The sort order of primary key 1 and primary key 2 corresponds to the physical order in the schema. |
Primary key 2 |
(Only for internal use) Name of the table's second primary key column. The sort order of primary key 1 and primary key 2 corresponds to the physical order in the schema. |
Synchronization mode |
Permitted directions of synchronization and handling methods for this table if synchronization is set up automatically between two One Identity Manager databases. |
Columns for alternative rules |
Comma delimited list of columns to be used for creating alternative object matching rules in an automatically created synchronization project. If the One Identity Manager connector cannot identify a system object through the primary object matching rule, it applies the alternative rules to determine a matching system object. For more information about this, see the One Identity Manager User Guide for the One Identity Manager Connector. |
CLR type for project generator |
.NET class used to consider special cases when generating a synchronization project between two One Identity Manager databases. |