Oracle Designer Model, Release 6i
Deletion rules
Deletion rules on ENTITY_OBJECT_ATTRIBUTE reference properties, i.e. rule if referenced element is deleted
| Reference Property | Deletion Rule |
| CLASSIFIER_REFERENCE | Block attempt to delete CLASSIFIER |
| ENTITY_OBJECT_REFERENCE | Cascade delete, if ENTITY_OBJECT deleted (Owning foreign key) |
Impact on child element types if ENTITY_OBJECT_ATTRIBUTE is deleted
| Impact on children | Via child reference property |
| Nullify reference on WORKFLOW_ATTRIBUTE | WORKFLOW_ATTRIBUTE.CLASSIFIER_ATTRIBUTE_REFERENCE |
| Cascade delete ATTRIBUTE_DERIVATION_RULES | ATTRIBUTE_DERIVATION_RULE.CLASSIFIER_ATTRIBUTE_REFERENCE |
| Cascade delete BC4J_EVENT_ATT_MAPPINGS | BC4J_EVENT_ATT_MAPPING.EO_ATTRIBUTE_REFERENCE |
| Cascade delete CONTEXT_MAPPINGS | CONTEXT_MAPPING.CLASSIFIER_ATTRIBUTE_REFERENCE |
| Cascade delete CROSS_OBJ_RULE_IMPLEMENTS | CROSS_OBJ_RULE_IMPLEMENT.CLASSIFIER_ATTRIBUTE_REFERENCE |
| Cascade delete DATA_COMPONENTS | DATA_COMPONENT.CLASSIFIER_ATTRIBUTE_REFERENCE |
| Cascade delete DIAGRAM_ELEMENT_USAGES | DIAGRAM_ELEMENT_USAGE.CIELEMENT_REFERENCE |
| Cascade delete ELEMENT_RULE_USAGES | ELEMENT_RULE_USAGE.CIELEMENT_REFERENCE |
| Cascade delete INTEGRITY_RULES | INTEGRITY_RULE.CLASSIFIER_ATTRIBUTE_REFERENCE |
| Cascade delete JOIN_COMPONENTS | JOIN_COMPONENT.EO_ATTRIBUTE_FROM_REFERENCE |
| Cascade delete JOIN_COMPONENTS | JOIN_COMPONENT.EO_ATTRIBUTE_TO_REFERENCE |
| Cascade delete MAPPING_ELEMENTS | MAPPING_ELEMENT.SOURCE_CIELEMENT_REFERENCE |
| Cascade delete MAPPING_ELEMENTS | MAPPING_ELEMENT.TARGET_CIELEMENT_REFERENCE |
| Cascade delete MEMBER_COMPONENTS | MEMBER_COMPONENT.CLASSIFIER_ATTRIBUTE_REFERENCE |
| Cascade delete ROLE_QUALIFICATIONS | ROLE_QUALIFICATION.EO_ATTRIBUTE_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 |
| Block, if CONTEXT_MAPPINGS exist | CONTEXT_MAPPING.CLASSIFIER_ATT_FROM_REFERENCE |
| Block, if VIEW_OBJECT_ATTRIBUTES exist | VIEW_OBJECT_ATTRIBUTE.EO_ATTRIBUTE_REFERENCE |