Oracle Designer Model, Release 6i
Deletion rules
Deletion rules on OBJECT_STATE reference properties, i.e. rule if referenced element is deleted
| Reference Property | Deletion Rule |
| BUSINESS_OBJECT_REFERENCE | Cascade delete, if BUSINESS_OBJECT deleted (Owning foreign key) |
| CLASSIFIER_REFERENCE | Cascade delete, if CLASSIFIER deleted (Owning foreign key) |
| WORKFLOW_ITEM_TYPE_REFERENCE | Cascade delete, if WORKFLOW_ITEM_TYPE deleted (Owning foreign key) |
| WORKFLOW_MESS_TYPE_REFERENCE | Cascade delete, if WORKFLOW_MESSAGE_TYPE deleted (Owning foreign key) |
| ICON_FILE_REFERENCE | Nullify reference, if PRIMARY_ACCESS_FILE deleted |
Impact on child element types if OBJECT_STATE is deleted
| Impact on children | Via child reference property |
| Cascade delete DIAGRAM_ELEMENT_USAGES | DIAGRAM_ELEMENT_USAGE.CIELEMENT_REFERENCE |
| Cascade delete ELEMENT_RULE_USAGES | ELEMENT_RULE_USAGE.CIELEMENT_REFERENCE |
| Cascade delete EVENT_CLASSIFIERS | EVENT_CLASSIFIER.OBJECT_STATE_REFERENCE |
| Cascade delete STATE_DEPENDENCIES | STATE_DEPENDENCY.OBJECT_STATE_OF_REFERENCE |
| Cascade delete STATE_DEPENDENCIES | STATE_DEPENDENCY.OBJECT_STATE_ON_REFERENCE |
| Cascade delete STATE_RULES | STATE_RULE.OBJECT_STATE_REFERENCE |
| Cascade delete TAGGED_VALUES | TAGGED_VALUE.ELEMENT_REFERENCE |
| Cascade delete TRANSITIONS | TRANSITION.SOURCE_OBJECT_STATE_REFERENCE |
| Cascade delete TRANSITIONS | TRANSITION.TARGET_OBJECT_STATE_REFERENCE |
| Cascade delete UML_DEPENDENCY_CLIENTS | UML_DEPENDENCY_CLIENT.CLIENT_ELEMENT_REFERENCE |
| Cascade delete UML_DEPENDENCY_SUPPLIERS | UML_DEPENDENCY_SUPPLIER.SUPPLIER_ELEMENT_REFERENCE |