Create the unique and attribute subtables

Applies to User Roles:

System Administrator

You must use the Windows client whenever you need to add or edit a new field/key in a database dictionary table.

To create the unique and attribute subtables:

  1. Name the unique and attribute files.
    1. Search for the dbdict from which you want to create subtables. In this example, the device dbdict is used.
    2. Scroll down the Type column to locate an array of structures.

      Note: An array of structures is identified by an Array field type with a field of the same name.

    3. Type Structure directly below the Array field. The Structure field name is indented. In this example, the array of structures is features.
    4. Locate the features field of Type Structure.
    5. Insert your cursor in the Type column for the features structure field.
    6. Click Edit Field/Key.
    7. In the field.window dialog box, type a name for the attribute file. The standard naming convention for the attribute file is: dbdict + array + attr. In this example, the attribute file is named devicefeaturesattr.

      Note: No spaces or special characters are allowed in the subtable names.

    8. In the field.window dialog box, type a name for the unique file. The standard naming convention for the unique file is: dbdict + array + uniq. In this example, the unique file is named devicefeaturesuniq.

      Note: If the attribute file field is left blank, only the unique subtable will be created.

    9. Click OK.
  2. Designate unique fields in the array of structure.
    1. Locate the field you want to designate as unique. In this example, the unique field is feature.id.
    2. Insert your cursor in the Type column for the field you want to designate as unique.
    3. Click Edit Field/Key.
    4. Click the Unique in Structured Array check box.
    5. Click OK.
    6. Repeat steps a – e for each field you want to designate as unique.
  3. From the database dictionary, click OK.

Service Manager updates the dbdict and creates the unique and attribute subtables from the array of structures.

Related topics

Adding a key
Alias fields
Arrays
Arrayed structures
Methods for deleting database dictionary records
Deleting a key
Methods for updating database dictionary records
Modifying a key
Organization of arrays of structures in the database dictionary
Structures
Database dictionary

Access the Database Dictionary utility
Add an array
Designate unique fields in the array of structures
Open a database dictionary
Regen a database dictionary
View the unique and attribute subtables

Example: Arrayed structure