| Insert excerpt | ||||||||
|---|---|---|---|---|---|---|---|---|
|
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 Entity Relationship Diagrams and Adding Data and Tables to an ERD. They represent the connection between a primary key attribute in one table and an attribute in another table. For example, the 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.
Status
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 | _parent | _parent | nopanel | true
Parent Details
The following settings are read-only. They are set automatically from the ERD.
| Field | Description |
|---|---|
| Foreign Key Table | The name of the destination table for the relationship. |
| Foreign Key Table Attribute | The destination attribute. |
Basic Settings
The following settings are read-only. they 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
Target Table (This field is called Primary Key Table in PhixFlow version 11.2 and older) | The name of the |
| source table for the relationship. |
Foreign Key Attribute
Target Attribute (This field is called Primary Key Table Attribute in PhixFlow version 11.2 and older) | The source attribute. |
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
| Live Search | ||||||||
|---|---|---|---|---|---|---|---|---|
|
| Panel | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
|
Learn More
Understanding ERDsFor links to all pages in this topic, see Entity Relationship Diagrams.Insert excerpt