Edit a Relationship

Edit a Relationship

To edit a Relationship between 2 Model Objects, access the Relationship overview page for the target Model Object of the Relationship:

Click on the Context menu of the Relationship and select the Edit Relationship menu:

The Edit Relationship side panel window is opened with the possibility to update all the information:

If you change the Role name, the corresponding Foreign(s) Key(s) name will change accordingly.

For example, if you update a Role name from Customer to Cus, the Foreign Key name will change from FK_Customer_Customer_AccountNumber to FK_Customer_Cus_AccountNumber.

  • Description: Role description
  • BK Behavior: This can be set to setToUnknown, createEmbryo, or logErrorAndRefuse. Please refer to the article Handle missing Foreign Key in a Relationship for more details.
  • Historization Type (optional): Can be one of the following values

    1. -: The Term is not historization relevant.
    2. SCD0: We load the term once and never change it, even if the source data changes.
    3. SCD1: The value of this Term can be updated.
    4. SCD2: If new arriving data has changed for any term configured as SCD2, the status of the existing current row is set to close, and the ValidTo column is set to the transaction date. A new row is added to the table with the status open, and ValidFrom set to the transaction date.

Click on the SAVE button.

A notification confirms the correct update:

Demonstration video