Configuration Guide

10.5 HotFix 3

Back Next

Foreign Key Relationship Base Objects

A foreign key relationship base object is an entity base object with a foreign key to another entity base object.

You must have an entity base object and add a foreign key column to convert to a foreign key relationship base object.

When you create a foreign key relationship base object, you select the entity base object to add a foreign key column to.

Field	Description
FK Constraint Entity BO 1	Select FK entity base object from the list.
Existing BO Column to Use	Name of existing base object column used for the foreign key, or choose to create a new column.
FK Column Display Name 1	Name of FK column as it will be displayed in the Hub Console.
FK Column Physical Name 1	Actual name of FK column in the database. The Hub Console suggests a physical name for the table based on the display name that you enter.
FK Column Represents	Choose Entity1 or Entity2, depending on what the FK Column represents in the relationship.

To use foreign key relationships, create the entity base objects you want to relate. Use foreign key relationships when you have a one-to-many relationship between entities.

When you create the foreign key relationship, you need to add a foreign key column for each entity you want to relate to.

Rename Saved Search

Table of Contents

Configuration Guide

Configuration Guide

Foreign Key Relationship Base Objects

Foreign Key Relationship Base Objects