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.

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.

There are additional properties that you can optionally configure for the streams, stream attributes and relationships. In a diagram, you can double-click on a table name, attribute or relationship to open its properties. Alternatively, you can find the item in the repository.

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



Draft image - needs better example and the repo needs to reflect the streams and relationships in the diagram

Properties

Insert excerpt
_standard_settings
_standard_settings
nopaneltrue

Basic Settings

FieldDescription
NameEnter the name .
Stream AThe name of the source stream for the relationship.
Stream Attribute AThe source attribute.
Stream BThe name of the destination stream for the relationship.
Stream Attribute BThe destination attribute.


Suggestion for Dev: Properties should list the ERDs the relationship is on its on so you can open it easily