Table (Child) |
Shows the
child table for this relationship. |
Table (Parent) |
Shows the
parent table for this relationship. |
Inverse Verb Phrase |
Specifies
a verb phrase that describes the relationship
from the perspective of the child table. For example: RESUME "is owned
by"
EMPLOYEE. |
Verb Phrase |
Specifies a verb phrase that describes the relationship
from the perspective of the parent table. For example: EMPLOYEE "owns"
RESUME. |
Cardinality (Child) |
Specifies 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) |
Specifies 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) |
Modifies foreign key
columns for the child table. |
Unique
constraint or Index (Parent) |
Select a
unique constraint or index for the parent table. |