...
Relationships are part of ERDs; see Understanding ERDs and Defining Data Structures using ERDsCreating an ERD. They represent the connection between a primary key attribute in one table stream and an attribute in another tablestream. For example, the relationship line in the screenshot below shows that Teacher.Department contains the same data as the primary key SchoolDept.UID.
A tablestream's unique identifier is its primary key, and where it occurs in another tablestream, 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.
...
The following settings are read-only.
| Field | Description |
|---|---|
| Table Stream A | The name of the source table stream for the relationship. |
| Table Stream Attribute A | The source attribute. |
| Table Stream B | The name of the destination table stream for the relationship. |
| Table Stream Attribute B | The destination attribute. |
...