Oracle Designer Model, Release 6i
Deletion rules
Deletion rules on TRANSITION reference properties, i.e. rule if referenced element is deleted
| Reference Property | Deletion Rule |
| SOURCE_ACTIVITY_REFERENCE | Cascade delete, if ACTIVITY_DEFINITION deleted (Owning foreign key) |
| TARGET_ACTIVITY_REFERENCE | Cascade delete, if ACTIVITY_DEFINITION deleted |
| TARGET_ACT_USAGE_REFERENCE | Cascade delete, if ACTIVITY_USAGE deleted |
| SOURCE_ACT_USAGE_REFERENCE | Cascade delete, if ACTIVITY_USAGE deleted (Owning foreign key) |
| SOURCE_EVENT_REFERENCE | Cascade delete, if EVENT_CLASSIFIER deleted (Owning foreign key) |
| TARGET_EVENT_REFERENCE | Cascade delete, if EVENT_CLASSIFIER deleted |
| SOURCE_OBJECT_STATE_REFERENCE | Cascade delete, if OBJECT_STATE deleted (Owning foreign key) |
| TARGET_OBJECT_STATE_REFERENCE | Cascade delete, if OBJECT_STATE deleted |
| TARGET_PSEUDOSTATE_REFERENCE | Cascade delete, if PSEUDOSTATE deleted |
| SOURCE_PSEUDOSTATE_REFERENCE | Cascade delete, if PSEUDOSTATE deleted (Owning foreign key) |
| TRIGGER_EVENT_REFERENCE | Nullify reference, if EVENT_CLASSIFIER deleted |
| EVENT_PUBLICATION_REFERENCE | Nullify reference, if EVENT_PUBLICATION deleted |
| EVENT_SUBSCRIPTION_REFERENCE | Nullify reference, if EVENT_SUBSCRIPTION deleted |
| NAMED_RULE_REFERENCE | Nullify reference, if NAMED_RULE deleted |
| TRANSITION_REFERENCE | Nullify reference, if TRANSITION deleted |
Impact on child element types if TRANSITION is deleted
| Impact on children | Via child reference property |
| Nullify reference on TRANSITION | TRANSITION.TRANSITION_REFERENCE |
| Cascade delete DIAGRAM_ELEMENT_USAGES | DIAGRAM_ELEMENT_USAGE.CIELEMENT_REFERENCE |
| Cascade delete ELEMENT_RULE_USAGES | ELEMENT_RULE_USAGE.CIELEMENT_REFERENCE |
| Cascade delete TAGGED_VALUES | TAGGED_VALUE.ELEMENT_REFERENCE |
| Cascade delete UML_DEPENDENCY_CLIENTS | UML_DEPENDENCY_CLIENT.CLIENT_ELEMENT_REFERENCE |
| Cascade delete UML_DEPENDENCY_SUPPLIERS | UML_DEPENDENCY_SUPPLIER.SUPPLIER_ELEMENT_REFERENCE |