Table (Child) |
Shows the child table for this relationship. |
Table (Parent) |
Shows the parent table for this relationship. |
Inverse Verb Phrase |
Type a verb phrase that describes the relationship from
the perspective of the child table. For example: RESUME "is owned by" EMPLOYEE. |
Verb Phrase |
Type a verb phrase that describes the relationship from
the perspective of the parent table. For example: EMPLOYEE "owns" RESUME. |
Cardinality (Child) |
Specify a cardinality value for the child table. You
can select one of the following options:- 0..1: Zero or one
- 1: One
- *: Many
- 1..*: One to Many
|
Cardinality (Parent) |
Specify a cardinality value for the parent table. The
values that are available in the list change depending on whether the relationship
is an identifying or a non-identifying relationship. You can select:- 1 (Mandatory): One. Designates the relationship as a mandatory relationship.
- 0 (Optional): Zero or One. This option is only available if the relationship
is a non-identifying relationship. Designates the relationship as an optional
relationship.
|
Key columns (Child) |
Use the grid to add, remove, or reorder foreign key
columns for the child table. |
Unique constraint or Index (Parent) |
Select a unique constraint or index for the parent table. |