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 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 Teacher.Department contains the same data as the primary key SchoolDept.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.
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
| Field | Description | |
|---|---|---|
| Description | Editable | DescriptionWe recommend that you always enter a description to explain the purpose of this item. |
| Table A | Read-only | 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. |
See the Common Properties page, Audit Summary section.
Audit TabAudit Summary