Relationship

This page is for anyone using an ERD to define a data structure. It explains the properties for relationships. 

Overview

Relationships are part of ERDs; see Understanding ERDs and Adding Content to an ERD. They represent the connection between a primary key attribute in one table and an attribute in another table. For example, the relationship line in the screenshot below shows that Teacher.Department contains the same data as the primary key SchoolDept.UID.

A table's unique identifier is its primary key, and where it occurs in another table, it is a foreign key.

The screenshot above shows that a relationship line has a one termination at the primary key and an arrow pointing to the foreign key. This line represents the 1 and many ends of the relationship.

PhixFlow automatically sets the properties for a relationship, except the description. To add a relationship description, click on the relationship line to open its properties. Relationships are not listed in the repository. 

 Properties Tab

Parent Details

If this item is within or belongs to another, it's parent name is shown here. See the Common Properties page, Parent Details section for more details.

Basic Settings

The following settings are read-only. they are set automatically from the ERD.

FieldDescription
Relationship NameThe name of the relationship
From TableThe name of the source table for the relationship.
Primary Key AttributeThe source attribute.
To TableThe name of the destination table for the relationship.
Foreign Key AttributeThe destination attribute.

Description

We recommend that you always enter a description to explain the purpose of this item.

 Audit Tab

Audit Summary

See the Common Properties page, Audit Summary section.

Sections on this page

Learn More

For links to all pages in this topic, see Entity Relationship Diagrams.


Terminology changes in progress

As part of the redesign of PhixFlow, we are changing the following terms:

dashboard → screen   
stream → table
stream attributes → attributes
stream item → record
stream set → recordset
stream view → view
stream item action → record-action 
stream action → table-action
driver class → database driver