Database Editor Properties - Foreign Key

This chapter is composed of :

1. Introduction
2. Foreign Key
   1. Properties
      1. Name
      2. Foreign Table Name
      3. Local Table Name
      4. Foreign Cardinality
      5. Local Cardinality
      6. On Update
      7. On Delete
      8. Add
      9. Remove
   2. OK

1. Introduction

In this section you will learn how to use Database Editor Foreign Key properties.

2. Foreign Key

Select a Database Foreign Key, right-click and select :

Properties.

or

Double Click on a Database Foreign Key :

or

Double Click on the corresponding association :

2.1. Properties

Database Foreign Key properties.

2.1.1. Name

Foreign Key Name.

This name should be unique among your Database Foreign Keys in your current Database Table.

2.1.2. Foreign Table Name

Foreign Database Primary Key Table name.

2.1.3. Local Table Name

Current Database Table name.

2.1.4. Foreign Cardinality

The Foreign Primary Key exists or does not exist.

This value is immutable.

2.1.5. Local Cardinality

If the Primary Key exists, the foreign could reference the Primary Key.

This value is mutable.

2.1.6. On Update

On Update Foreign Key behaviour.

This value is inherited from the Database Schema properties.

2.1.7. On Delete

On Delete Foreign Key behaviour.

This value is inherited from the Database Schema properties.

2.1.8. Add

Use the Add button.

Select the Foreign Database Primary Column you require to be part of your current Database Foreign Key definition.

The Foreign Primary key Column is added to your Foreign Key Columns definition array.

Then select the local Database Column mapped to the Foreign Primary Key Column.

2.1.9. Remove

Select a Database Column.

Then use the Remove button.

The selected Database Column will be removed from your current Database Foreign Key.

2.2. OK

Once you have decided to update your Database Foreign Key, click the OK button.

The update will be done.

A detailed output will be displayed in the DatabaseConsole.