Develop > Document Engine > Work order example overview > Add key fields to a table

Add key fields to a table

Use the dbdict utility to add keys to a new table. After you create a table named EXWorkOrder, you need to add keys to the table. Keys are used to enable indexed searches as well as ensure data consistency.

To add keys to a table, follow these steps:

  1. From the Database Dictionary, click the Keys tab.
  2. Select the first available entry for a new key field.
  3. Click the New Field/Key.
  4. Enter the following information for each key you create or edit.

    Field Description
    ID Type: unique
    RelatedID Type: no nulls
    RelatedCIs Type: nulls & duplicates
    assignee.name Type: nulls & duplicates
  5. Click OK.