For more information about specific syntax, see the reference information that is included with each database product. Syntax definitions for some database vendors or versions might differ from the following descriptions.
Property | Description |
---|---|
Name | Specifies a name for the object. |
Label | Type a label. This label is displayed in visual diagrams. |
Identifying | Specifies that the relationship is an identifying relationship. An identifying relationship is one in which one of the child entities is also a dependent entity. |
Non-Identifying | Specifies that the relationship is not an identifying relationship. A non-identifying relationship is one in which both entities are independent. |
Enforced | Specifies that the relationship is not an implicit relationship. For DB2® for Linux®, UNIX®, and Windows® or DB2 for iSeries® that support informational constraints, this option results in the generation of a foreign key clause with ENFORCED = FALSE. For databases that do not support information constraints, the foreign key clauses are not generated. |
Deferrable | Specifies whether constraint checking is deferred until the end of a transaction. This option is only available for databases that support deferred constraint checking. |
Schema or Owner | Shows the relational schema or the entity under which this object was created. |
Property | Description |
---|---|
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:
|
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:
|
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. |
Property | Description |
---|---|
On Update | Specifies an action on the child table when an UPDATE action is taken on the parent table. |
On Delete | Specifies an action on the child table when a DELETE action is taken on the parent table. |