Modify a Table Definition - Intergraph Smart Instrumentation - Help

Select Service > Target Table Definition.

OR

On the Link Properties dialog, select Table Definition.

On the Target Table Definition dialog, under Table List, select the table whose column definitions you want to modify.

• The automatically selected option button beneath the Table List pane indicates the plant hierarchy level of the table in the target domain.

• If you open the Table Definition dialog from the Link Properties dialog, you can only modify the definition for the source tables to which the import link is assigned.

Select Definition.

On the Definition Names dialog, do one of the following:

• In the Description data window, select an existing definition.

• Select Insert to add a new definition in the Description data window and then select Edit to type the new definition name.

• For each table there is one shipped definition called Default. You can use the Default definition as a basis for creating new definitions. We recommend that you do not modify the Default definition itself.

• For certain tables, apart from the Default definition, there are a number of other shipped definitions. You must select a definition that is appropriate for the type of association of the items that you are going to import. For example, when importing terminal strips, several definitions exist for the PANEL_STRIP table because you might have some panels with direct connections to strips, and other panels that include items above the strip, such as a panel–rack–wiring equipment–strip association. In this case, you need to create several import links, each with an appropriate definition for its association.

Select OK to return to the Table Definition dialog.

In the Column Definition section, do the following:

1. Select Visible for each column you want to display in the Import Link window.

2. Select Default for each column to import the default value (space, zero or asterisk) whenever the column value is not defined.

For some columns, for example, primary keys, the Import Utility automatically clears the Visible check box. To avoid import failure, we recommend that you do not make these table columns visible.

To set the type of the table column selected under Key Definition, do one of the following:

• Accept the displayed key definition.

• Select Primary key to use this column as a primary key.

• Select Foreign key to use this column as a foreign key.

Selecting Foreign key opens the Foreign Key List pop-up window. If you do not intend to modify the foreign key definition, close the Foreign Key List pop-up window.

If you need to modify the definition of a foreign key, from the Foreign Key List pop-up window, drag the appropriate foreign key to the Key definition working area.

To link the selected table column to a reference table, do the following:

1. From the Reference Table list, select the appropriate reference table.

2. From the Reference Column list, select the appropriate primary key.

   

   • If the current key is a foreign key, the value under Reference Column is a column name in the reference table specified under Reference Table.

   • If the current key is not a foreign key, the value under Reference Column is a column name in the current table.

From the Reference Key list, do one of the following:

• Accept the given default values (recommended).

• Select the appropriate reference key if required.

To determine the way the current key will be numbered in the target database (note that this is an internal value which is not accessible to you), do one of the following:

• Select the Local check box to follow the previous- level numbering to make the currently defined table column address unique in the target database.

• Clear the Local check box to follow the global numbering in Smart Instrumentation.

To modify the definition of the additional column of the current table, do the following:

1. Drag the appropriate table columns from the Column definition pane to the Key definition working area.

2. If needed, select Define parameters for Level Key to specify the columns for automatic creating during the import process. This way, in the Column definition pane, the Import Utility creates the table columns specified under Level Key before creating the corresponding table columns under Column Name.

3. In the Column definition pane, select to display the Level Key fields.

4. Under Level Key, do one of the following:

   • Type the names of the table columns to be created by the Import Utility during the import process before it creates the corresponding table columns under Column Name.

   • Clear Define parameters for Level Key to discard the table columns specified under Level Key.

Select Apply.

When prompted, select Yes to confirm the changes and clear the Key definition working area.

Select Save to save your selection of table keys.

Select Close to close the Table Definition dialog.