Data Model - Steward Hub

In relational databases, relationships between tables may be missing. Steward Hub allows you to manually complete missing relationships and then add them to the source database.

Primary Keys (PK)

Primary keys module allows to add missing PKs to your tables.

Dashboard

On the dashboard you can see how many tables does not have a primary key, groupped by data source. Links allows to search most interesting tables faster by filtering searching results automatically. Create link allow to add keys manually, Suggestions link shows available key suggestions. Both options are described below.

Adding primary keys

There are two ways to add primary keys: manually or by approving suggestions.

Add keys manually

In manual mode you have tables without PK list with optional row count if table was profiled. Filters can help you search objects you want (1). Add key by clicking ellipsis on the right (2). A new window will be opened.

Now you can select columns (3) which will create new primary key. Click Save button (4) to create new PK.

Verify and approve suggestions

Second option is to verify and approve suggestions. If you have no suggestions available, try to refresh them first by clicking Refresh button in the ribbon (1). Select suggestions you want (2) and click Approve button (3). Suggested key name is editable so you can change it whenever you need. You can also reject some suggestions if you don't want to see them in the future.

Foreign Keys (FK)

Foreign keys submodule will be released later.

Further reading

Check out more Steward Hub modules.