This dialog allows you to perform the following activities:
-
Modify the target table primary key 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.
To open this dialog, select Service > Target Table Definition or select Table Definition on the Link Properties dialog.
Changing the settings on 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.
If you open this dialog from the Link Properties dialog, you can only modify the definition for the tables associated with the import
link.
Table list
Allows you to select the target 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
These options allows you to select the required plant hierarchy level, that is Domain, Plant, Area, or Unit. Note that after you select a table in the Table List pane, the appropriate 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 key field of a specific table is unique on that specified level. For example, the primary key 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 pane contains all the column definitions of the selected table (the actual table definition). 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 working area.
Column Name
Displays the column names of the selected target table. The columns can appear in four different colors:
Red
Primary key 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
Displays the column data type here, for example, numeric, character, and so forth.
Reference Table
Contains the reference table names which are linked with the currently selected table.
Visible
Makes the data column visible in the Import Link window. For some columns (for example, primary key columns) the Import Utility automatically clears the Visible box. To avoid import failure, we recommend that you do not make the columns visible.
Default
Applies the default value (space, zero, or asterisk) to every field during the import process.
Key Level
Defines the connection between the columns that comprise a primary key or a foreign key where the uniqueness of the key value is determined by more than one level in a hierarchy. For example, to identify a wire uniquely, you must also specify the cable set and the cable to which the wire belongs; in this case, the key level is CABLE_ID;SET_ID;WIRE_ID.
Key Definition
This pane is a working area displaying 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 pane and drop it in the working area.
Key Name
The name of the current column that is being defined. This field is not available for editing.
Reference Table
If required, select from the list box the reference table associated with the current column.
Reference Column
Allows you to select the appropriate primary key from this list.
Reference Key
Allows you to 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
Allows you to define the currently selected column as the primary key.
Foreign Key
Allows you to define the currently selected column as the foreign key. Selecting this option opens the Foreign Key List pop-up window where you can select a foreign key definition and drag it to the Key definition working area.
Define parameters for key levels
Allows you to apply the key level definitions to the selected table or clear this box to discard the fields specified under Key Level in the Column definition pane.
Clear
Resets the primary key settings for the selected table and removes the key definitions from the working area.
You must clear the working area to enable the Save and Save As buttons.
Delete Key
Deletes the key definition displayed in the Key definition working area without applying the new key settings.
Apply
Applies the new primary key settings to the selected table and clears the Key definition working area.
Definition
Opens the Definition Names dialog where you can insert a new definition, view, or delete the column definition of the table you selected in Table List.
You cannot make any changes on the Table Definition dialog until you select a definition on the Definition Names dialog and display the key definitions in the working area.