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 Creating an ERD. They represent the connection between a primary key attribute in one stream and an attribute in another stream. For example, the relationship line in the screenshot below shows that Teacher.Department contains the same data as the primary key SchoolDept.UID.
A stream's unique identifier is its primary key, and where it occurs in another stream, it is a foreign key.
Image Modified
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
| Insert excerpt |
|---|
| _parent |
|---|
| _parent |
|---|
| nopanel | true |
|---|
|
Basic Settings
The following settings are read-only.
| Field | Description |
|---|
| Stream A | The name of the source stream for the relationship. |
| Stream Attribute A | The source attribute. |
| Stream B | The name of the destination stream for the relationship. |
| Stream Attribute B | The destination attribute. |
| Insert excerpt |
|---|
| _description |
|---|
| _description |
|---|
| nopanel | true |
|---|
|