...
| Insert excerpt | ||||||||
|---|---|---|---|---|---|---|---|---|
|
...
...
Relationships are not listed in the repository. You can access relationship properties from an ERD. Click on the relationship arrow to open its properties. For example, the relationship arrow in the screenshot below is called has-teacher.
...
see 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 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.
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 | ||
|---|---|---|
|
...
...
...
...
...
Enter the name for this relationship.
Relationships between the same two tables must have the unique names.
...
...
...