Adding a primary 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 the table definition to which you want to add the primary key constraint.
  3. Click the Constraints node.
  4. Click Add.
  5. Select PrimaryKey from the Type list.
    Elements to define a primary key constraint are displayed, and the name is changed to PK_[TABLENAME] and the common ID to [TableName]PrimaryKey. Names follow a naming scheme to ensure consistency.
  6. Type a description of the primary key constraint in the Description field.
    Descriptions, such as Primary key for [TABLENAME], can help you identify the purpose of the constraint. The information you type should be helpful to those who will be setting up and maintaining Infor Public Sector.
  7. Enter any other information about the primary key constraint.
    You can type additional information in the Name and Common ID fields to further identify this constraint, such as the name of the column that the constraint is for. You can use the Identity Seed field to indicate the number that Infor Public Sector uses for the first record added to the table. The default is 1000. Use Identity Step to indicate the increment Infor Public Sector uses to determine each succeeding record. The default is 1. The defaults specify that the first record has a primary key of 1000, the second 1001, then 1002, and so on.
  8. Under Linked Columns, click Add.
    Linking a column to a constraint which column the constraint applies to. Without this link, the constraint is useless. Depending on a table's type, the correct column is automatically linked to the primary key constraint when you first define the table.
  9. 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.
  10. Click Save to save the link.
    Infor Public Sector shows the link in the Linked Columns grid.
  11. Click Save to save the constraint.
    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.