This page is for anyone using an ERD to define data structures. It explains the properties for relationships. 

Overview

Relationships are part of ERDs; see Understanding ERDs and Drawing ERDs. 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 the Teacher table includes an attribute called Department, and this contains the ame data as the SchoolDept table's unique identier (UID).

A tables unique identifier is its primary key, and where it occurs in another table, it is a foreign key.

To open relationship properties, in an ERD click on the relationship line. Relationships are not listed in the repository. 

Most of the properties of a relationship are automatically set by the ERD, so are read-only. You can add details to the description. 

For information about the properties toolbar, and about the sections Parent Details, Analysis Models, Description and Audit Summary, see Common Properties.  We recommend you always add a Description that explains the purpose of the item you are creating. 

For a full list of all the PhixFlow property tabs and windows, see Properties, Windows, Menus and Toolbars.

Basic Settings