You can manually add primary keys and foreign keys to tables to establish relationships between tables for data subset operations. When you manually add keys, you do not need to run a primary key discovery profile.
When you add keys, you define constraints for data subset operations in the project. You do not update the source database.
You can add the following types of keys:
Logical Primary Key
You can add one column or column combination as the primary key for a table. Use the unique percentage value in the profile results to determine which column to add as the primary key. A unique percentage of 100 indicates that all values in the column are unique.
Add a column or column combination as a foreign key in a table. When you define a constraint, you define a foreign key in a table and relate it to a column in a parent table.