---
title: "Details of a Definition Structure"
slug: "details-of-a-definition-structure"
description: "Details of a Definition Structure explained for Test Modeller."
tags: ["Learning Portal", "Test Data Automation", "Test Data Automation 101"]
updated: 2024-09-27T14:46:44Z
published: 2024-09-27T14:46:44Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://knowledge.curiositysoftware.ie/llms.txt
> Use this file to discover all available pages before exploring further.

# Database Definition Structure Explained

[Embedded content](https://www.youtube.com/embed/7SMB2VGNy9k?&wmode=opaque&rel=0)

The definition structure shows the relationships between tables in the database, and lets you create soft-keys (foreign key relationships between tables that exist only in Enterprise Test Data, not in the DBMS.

### 1. Database Structure

Begin in the Definition Structure Details pane of the definition you want to work with, by clicking on Data Dictionary in the Master Data Management section of the Navigation Panel. Then select the Definitions Structure tab and select your definition.

![](https://cdn.document360.io/77f722a6-2d0a-49fa-8074-572515a6c4b8/Images/Documentation/image-1681806288848.png)

The Definition Structure Details pane opens. Superficially, this looks very similar to the Definition Details pane, however it has Child and Parent buttons next to each table, and a Relationships column. This shows the number of other tables each table is related to.

![](https://cdn.document360.io/77f722a6-2d0a-49fa-8074-572515a6c4b8/Images/Documentation/image-1681806294724.png)

Click on a table to expand it by clicking on the arrow button to the left of the table name. The Beneath it, the tables it is related to are displayed, and whether the relationship is a parent or child, and if it is a soft key relationship. In this case the Customer_Bank_Account relationship only exists in Quality Modeller. It doesn’t exist in the DBMS.

![](https://cdn.document360.io/77f722a6-2d0a-49fa-8074-572515a6c4b8/Images/Documentation/image-1681806304752.png)

Each relationship can be expanded, showing that table’s foreign keys, and you can keep on expanding deeper into the structure until all the relationships from the root table are shown.

![](https://cdn.document360.io/77f722a6-2d0a-49fa-8074-572515a6c4b8/Images/Documentation/image-1681806309424.png)

---

### 2. Creating a Soft Key

There are two places you can create a soft key. You can click on the green **Child** or **Parent** buttons,

![](https://cdn.document360.io/77f722a6-2d0a-49fa-8074-572515a6c4b8/Images/Documentation/image-1681806319339.png)

Or by selecting the table from the Content section, then in the Foreign Keys section of the Table Details pane, clicking on either of the buttons at the top right.

![](https://cdn.document360.io/77f722a6-2d0a-49fa-8074-572515a6c4b8/Images/Documentation/image-1681806344045.png)

The *New Foreign Key* box appears. Give the foreign key relationship a name, then select the Parent or Child table from the dropdown.

![](https://cdn.document360.io/77f722a6-2d0a-49fa-8074-572515a6c4b8/Images/Documentation/image-1681806348941.png)

Finally, click on the blue **Add column reference** button and select the Local and Referenced columns from the dropdowns, and click on OK.

![](https://cdn.document360.io/77f722a6-2d0a-49fa-8074-572515a6c4b8/Images/Documentation/image-1681806352825.png)

---

### 3. Deleting a Soft Key

From either the Definitions or Definitions Structure tabs, select the definition for your database connection, then, in the Content section, click on the table where you created the soft key. The Table Details pane opens. The Soft key column shows a tick if a relationship is a soft one, or a cross if it’s not. Click on the red X button to delete the relationship.

*Note that you can delete hard foreign keys (ones also found in the database) using this method. This doesn’t delete the key in the database, only in Quality Modeller.*

![](https://cdn.document360.io/77f722a6-2d0a-49fa-8074-572515a6c4b8/Images/Documentation/image-1681806365090.png)

Enterprise Test Data is Curiosity's next generation solution for Test Data Management. The all-in-one platform for enterprise test data needs. Understand complex data, remove sensitive information, and generate rich data for your entire organisation.

## Related

- [Using Databases in Enterprise Test Data](/using-databases-in-test-modeller.md)