Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This page is for data modellers or application designers. It explains the properties for relations.

Overview

Check whether or not you can see relationship properties.

Under the hood Need to decide where to put this...

Relationship diagrams are important because they tell PhixFlow how data in different tables is connected. Once you have defined these relationships, you can create data views that combine attributes from different fields.

Need example. 

When you create a relationship diagram, for each table (stream) and relationship, PhixFlow creates items in the repository; see the diagram below.

...

Properties

Relations are not listed in the repository. You can access relations properties from an ERD. Click on the relationship arrow to open its properties.

...

For example,

...

the

...

relationship arrow in the

...

The relationship properties are described on this page. 

See also:

Panel
borderColor#7da054
titleColorwhite
titleBGColor#7da054
borderStylesolid
titleSections on this page

Table of Contents
indent12px
stylenone

Image Removed

...

Properties

screenshot below is called has-teacher.

Image Added

Insert excerpt
_standard_settings
_standard_settings
nopaneltrue

Basic Settings

FieldDescription
Name

Enter the name for this relationship.

Relationships between the same two tables must have the unique names.

Stream AThe name of the source

...

table for the relationship.
Stream Attribute AThe source attribute. 
Stream BThe name of the destination

...

table for the relationship.
Stream Attribute BThe destination attribute.

...