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 Defining Data Structures using 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 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.
To open relationship properties, in an ERD click on the relationship line. Relationships are not listed in the repository.
It would help to repeat here that the crow's foot line ending indicates the many end of a one-to-many or many-to-one.
Most of the properties of a relationship are automatically set by the ERD, so are read-only. You can add details to the description.
Properties
If this item is within or belongs to another, it's parent name is shown here. See the Common Properties page, Parent Details section for more details.Parent Details
Basic Settings
The following settings are read-only.
| Field | Description |
|---|---|
| Table A | The name of the source table for the relationship. |
| Table Attribute A | The source attribute. |
| Table B | The name of the destination table for the relationship. |
| Table Attribute B | The destination attribute. |
We recommend that you always enter a description to explain the purpose of this item.Description
See the Common Properties page, Audit Summary section.
Audit TabAudit Summary