Assigning Primary Keys in an Onboarded Schema

If you have a Data Source without Primary Keys and you want to be able to create Foreign Key relationships, you can assign Primary Keys in the Schema. Follow the instructions below to edit a Schema and assign Primary Keys. For instructions on creating Foreign Keys, see Creating or Changing Foreign Keys.

1. In the Anzo application, expand the Onboard menu and click Structured Data. Anzo displays the Data Sources screen, which lists any existing sources. For example:

   

2. Click the Schemas tab to view the list of all schemas. (You can also access a schema by selecting the data source that contains the schema.) The image below shows a view of the Schemas tab:

   

3. Click the schema for which you want to assign primary keys. Anzo displays the Tables tab for the data source that contains the schema. For example:

   

4. In the table details, find the column that you want to label as the Primary Key. Hover your pointer over the column name to display additional icons. Edit and Delete icons replace the data type under the column name. For example:

   

5. Click the edit icon (). The Edit dialog box is displayed. For example:

   

6. On the Edit screen, select the Primary Key checkbox. Then click Save to save the change. The column is now the Primary Key for the table, and a key icon is displayed next to the column name. For example:

   

Repeat the steps above to assign primary keys for additional tables. For instructions on creating foreign keys, see Creating or Changing Foreign Keys.