Skip to main content

Custom Relationships

GeneTegra lets you define Custom Relationships, or Object Property definitions between two Classes.

Custom Relationships can be defined

  1. When a relational database Mediator is generated, essentially defining virtual foreign keys at the database level. Note:** Only 1:1 equals relationships are allowed.
  2. Whan an integrated Mediator is generated, defining the Object Property relationships between any two Classes in the underlying Mediators.
  3. When a Query is created, defining query-level Object Property relationships betwen any two Classes in the Mediator or between a Class and a Data Set in the Query.

Starting Mediator without any Custom Relationships

Customize Relationships: Add track-item to link s_sample to trackitem when S_SAMPLEID = TRACKITEMID.

All Custom Relationships are shown at the bottom of the screen.

Custom Relationships are displayed with a link icon and the constraint is displayed underneath.

Details Coming Soon

Check back later for more details about Custom Relationships.