Navigation:  NexusDB Guide > Management Tools > The Enterprise Manager > Creating and Restructuring Tables > Table Structure Window > Custom Descriptors >

Referential Integrity Descriptors

Previous pageReturn to chapter overviewNext page

NexusDB V3 Manual

Referential Integrity Descriptors

button_main button_prev button_next

NexusDB Manual V3 > Management Tools > The Enterprise Manager > Creating and Restructuring Tables > Table Structure Window > Custom Descriptors

 

clip0177

 

 

NOTE: when using the RI Descriptor Editor, keep in mind that you are editing a single table, and that the RI meta information is stored separately in each table, and not in a global repository. This means that to set up standard master/detail RI you will need to give the master table the Block Delete/Modify actions, and the detail table needs the Target required action. In other words, both tables need to be restructured.

 

To start creating Referential Integrity between tables, click Add.

 

You can now click field(s) in the Available Fields list, and move them to the Referencing Fields list. For each field in the Referencing Fields list, the Skip On Null checkbox can be set to skip the check if the field is NULL

 

Choose the Reference Type; most often, it will be Separate physical tables.

 

Choose another table in the database in the Target Table list, then choose the index that should be used in the Target Index list.

 

The Target Index Fields will be listed for your verification.

 

In the Actions list, check the actions you want when database operations are performed on the tables. In a typical master/detail relation, you would check the Block Delete and Block Modify actions. For each action in the Actions list, the Skip On Null checkbox can be set to skip the check if the RI field(s) are NULL

 

Don't forget to restructure the other table if a Target required action is required to block detail records to be inserted without a master record.

© Nexus Database Systems Pty Ltd.

nexus_logo