Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Insert excerpt | ||||||||
---|---|---|---|---|---|---|---|---|
|
This page is for data modellers or application designersanyone using an ERD to define a data structure. It explains the properties for relationsrelationships.
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.
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 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
|
Image Removed
Draft image - needs better example and the repo needs to reflect the streams and relationships in the diagramProperties
Stream ARelationships 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.
Image Added
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.
Insert excerpt | ||||||||
---|---|---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Basic Settings
The following settings are read-only. they are set automatically from the ERD.
Field | Description |
---|---|
Relationship Name |
The name of the relationship | |
From Table | The name of the source |
table for the relationship. |
Primary Key Attribute |
The source attribute. |
To Table | The name of the destination |
table for the relationship. |
Foreign Key Attribute |
The destination attribute. |
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Live Search | ||||||||
---|---|---|---|---|---|---|---|---|
|
Panel | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
|
Learn More
For links to all pages in this topic, see Entity Relationship Diagrams.
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|