Using the Database Manager table CRM Details tab

The Tables tab in the Database Manager list view enables the administrator to manage database tables and perform table related tasks.

The CRM Details tab in the Detail pane displays table properties and enables the administrator to modify Display Name and Description fields.

Note: Only the system administrator and users with the required permissions can access these features. These features are not available in Oracle environments.

To access the table CRM Details tab:

  1. Select Administration > Database Manager > Tables on the navigation bar. The Tables list view is displayed.
  2. Click the CRM Details tab in the Detail pane.
    Note: If the Detail pane is not displayed, click Detail in the list view toolbar.
  3. View or modify this information:
    Table Name
    The name of the table.
    Note: The value in this field cannot be modified.
    Display Name
    The name of the table to be displayed in the Query Builder.
    Description
    The description of the table.
    Primary Key
    Indicates if this field is a primary key for the table. Each table contains at least one field that is used to ensure each record in the table is unique.
    Note: The value in this field cannot be modified.
    Secondary Key
    Indicates if this field is a secondary key for an associated table. The secondary key is the primary key in the associated table.
    Note: The value in this field cannot be modified.
    Default Global Path
    The subscription ID (account ID) used by the Synchronization server to determine the accounts wherein records are logged.
    Note: The value in this field cannot be modified.
    Create Date
    The date on which the table is created.
    Note: The value in this field cannot be modified.
    Enabled Field Level Security
    If this check box is selected, the access to the fields on the Table tab is restricted, and the Field Security field is set to Yes.
    Note: You can select this check box only if the table has a SECCODEID field. After this check box is selected and the data is saved, the setting cannot be changed.
    Association
    The primary table associated from the list.
    Note: The value in this field cannot be modified.
    Type
    The relationship between the new table and the primary table. Possible values:
    • One-to-one: A single record in one table is connected with only one related record in another table. For example, a contact is related to only one account.
    • One-to-many: A single record in one table is connected with one or more related records in another table. For example, more than one contact can be associated with an account. However, one contact is always associated.
    Note: The value in this field cannot be modified.
    Modify Date
    The date on which the table is last modified.
    Note: The value in this field cannot be modified.
  4. Click Save.