Table Relations

Top  Previous  Next

The most common type of a Relation is a Table Relation (or just Relation).  It is a Relation between two Tables.  It is usually used to enforce referential integrity between the Parent Table and the Child Table.  Referential integrity is enforced by the database and means that certain child Columns must form a reference to a row in the Parent Table.

Relations are represented in a Diagram with a Relation Graphic object.  A Relation Graphic Template is provided so that you can categorize your Relations and easily change the appearance of all of them.

You can toggle the display of all Table Relations in the Diagram's Relation Display Options Property Page.  You can also toggle the display of any individual Relation by selecting the Relation, then selecting the Graphic tab in the Property Browser, and toggling the Display checkbox.

See Also

Migration, Unification, and Rolenaming

Relation Property Pages

Diagram Relation Graphics

Oracle Manual - Referential Integrity