NexusDB Manual V3 > Management Tools > The Enterprise Manager > Creating and Restructuring Tables > Table Structure Window > Custom Descriptors
|
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.