Adding a unique key constraint to a table definition

  1. Select System > Agency Personalization > Schema Manager.
  2. In the Enhancement Product Families tree, browse to the Constraints node for table definition that you want to add the unique key constraint to.
  3. Click the Constraints node.
  4. Click Add above the grid.
  5. Select UniqueKey from the Type list.
    Infor Public Sector shows elements to define a unique key constraint, and changes the name to U_[TABLENAME] and the common ID to [TableNname]_??_Unique. Both of these names follow an Infor Public Sector naming scheme that is meant to ensure consistency.
  6. In the Name field, type additional information to the right of the name to further identify this specific unique key constraint.
    Infor Public Sector automatically begins the name of every unique key constraint with U_[TABLENAME]. You must type more information, typically the name of the column that the constraint is for, to ensure uniqueness and to help identify the unique key constraint from others in your system.
  7. In the Common ID field, replace the ?? with additional information to further identify this specific unique key constraint.
    Infor Public Sector automatically enters [TableNname]_??_Unique for every unique key constraint you add. You must replace ?? with additional information, such as the name of the column the constraint is for, to further identify the constraint from others in your system. You can also completely replace the common ID with one devised from your own naming scheme.
  8. Type a description of the unique key constraint in the Description field.
    Descriptions, such as Unique key for [TABLE_NAME] on [COLUMN_NAME], can help you identify the purpose of the constraint. The information you type should be helpful to anyone who will be setting up and maintaining Infor Public Sector.
  9. Under Linked Columns, click Add above the grid.
    Linking a column to a constraint tells Infor Public Sector which column the constraint applies to. Without this link, the constraint is useless.
  10. Enter the column that you want to link the constraint to in the Column field.
    Click the popup button to the right of the Column field, select a column from the list that is displayed, and click Select. The list includes all columns from the current table.
  11. Click Save to save the link.
    Infor Public Sector shows the link in the Linked Columns grid.
  12. Click Save.
    Infor Public Sector assigns a key value to the constraint and adds the constraint to the table definition. The new constraint is displayed in the Constraints grid. Note that changing or deleting an existing constraint will cause errors wherever it has already been used. If you change or delete a constraint, you must update any references to it throughout your system.