Steward Hub–Data Model

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)

The Primary Keys module allows you to add missing PKs to your tables.

Dashboard

On the dashboard, you can see how many tables do not have a primary key, grouped by data source. Links allow you to search for the most interesting tables faster by filtering search results automatically. The Create link allows you to add keys manually, and the 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 a list of tables without PKs with an optional row count if the table was profiled. Filters can help you search for the objects you want (1). Add a key by clicking the ellipsis on the right (2). A new window will be opened.

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

Verify and approve suggestions

The second option is to verify and approve suggestions. If you have no suggestions available, try to refresh them first by clicking the Refresh button in the ribbon (1). Select the suggestions you want (2) and click the Approve button (3). The 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)

The Foreign Keys submodule will be released later.