Table Definition Dialog - Intergraph Smart Instrumentation - Help

Intergraph Smart Instrumentation Help

Language
English
Product
Intergraph Smart Instrumentation
Search by Category
Help
Smart Instrumentation Version
13.1

This dialog enables you to:

  • Modify the table primary value and foreign key definitions

  • Clear the current definition of the table columns

  • Save the changes that you make to the table structure using the existing structure definition or create a new definition.

Changing the settings in this dialog alters the relation between the tables. We therefore recommend that you do not change these settings unless it is absolutely necessary and you are familiar with the Smart Instrumentation database structure.

Table List

Highlight the table for which you want to modify the definitions. All the column definitions of the selected table appear after you double-click the table name or select Definition to define or select a definition name.

Domain, Plant, Area, Unit

Select the required level: Domain, Plant, Area, or Unit. Note that after you select a table in the Table List data window, the appropriate option button becomes automatically active. This default selection indicates the level of the table in the target domain. As all Smart Instrumentation tables are defined on a specific PAU level, the value of the primary value field of a specific table is unique on that specified level. For example, the primary value field of the COMPONENT table is CMPT_NAME. If you define the COMPONENT table on the Area level, the CMPT_NAME field becomes unique on the Area level. This means that on the Area level there cannot be more than one row with the same value in the CMPT_NAME field.

Column Definition

This data window contains all the column definitions of the selected table. The column definitions appear after you double-click the table name in the Table List or select Definition to define or select a definition name in the Definition Names dialog.

To modify the definition of a column, drag it to the Key Definition data window.

Column Name

The column names of the selected table are shown here. Note that the columns can appear in four different colors as follows:

  • Red - Primary Value field (must be defined)

  • Blue - Foreign Key field

  • Black - Regular field

  • Pink - Reference field which is defined as a regular field (that is, not used to get linked data)

Type

The column data type is displayed here, for example, numeric, character, and so forth.

Reference Table

This column contains the reference table names which are linked with the currently selected table.

Visible

The software uses this column for the Import Utility only; it is not used with the Merger Utility.

Default

Select to apply the default value (space, zero, or asterisk) to every field during the import process.

Level Key

Type the name of the field that the Merger Utility needs to create during the import process before creating the corresponding fields in the Column Name data field. Make sure you select the Define parameters for level key check box when you do this.

Key Definition

This data window contains the columns for which you want to modify the definitions. To modify the definition of a column, drag the required column from the Column Definition data window and drop it in this data window.

Key Name

The name of the current column that is being defined. Note that this field is not accessible for editing.

Reference Table

If required, select from the drop-down list the reference table associated with the current column.

Reference Column

Select the appropriate Primary Value field from this list.

Reference Key

Select the reference table Primary Key if it is different from the field name in the Key Name field.

Local

In Smart Instrumentation, each column has a numeric address which is used in the Smart Instrumentation database for information access. Select to make the currently defined column address unique in the target database (that is, locally) or clear the box to make it unique in Smart Instrumentation.

Primary key

Select this option button to define the currently selected column as the Primary Key.

Foreign key

Select this option button to define the currently selected column as the Foreign Key. Selecting this option opens the Foreign KeyList pop-up window where you can select a Foreign Key definition and drag it to the Key Definition data window.

Define parameters for level key

Select when available to apply the level key definitions to the selected table or clear this box to discard the fields specified in the Level Key data field of the Column Definition data window.

Clear

Resets the primary key settings for the selected table.

Delete Key

Clears the Key Definition data window without applying the new key settings.

Apply

Applies the new primary key settings to the selected table.

Save

Saves your selection of the table keys in the Merger Utility.

Save As

Saves the current key definitions under a different definition name.

Definition

Opens the Definition Names dialog where you can insert a new definition or view or delete the column definition of the table you selected in Table List. Note that you cannot make any definitions in the TableDefinition dialog until you define a new key or select an existing one from the Definition Names dialog.