Oracle Designer Model, Release 6i
Deletion rules
Deletion rules on ASSOCIATION reference properties, i.e. rule if referenced element is deleted
| Reference Property | Deletion Rule |
| ASSOCIATION_REFERENCE | Nullify reference, if ASSOCIATION deleted |
| BUSINESS_OBJECT_REFERENCE | Nullify reference, if BUSINESS_OBJECT deleted |
| ENTITY_OBJECT_REFERENCE | Nullify reference, if ENTITY_OBJECT deleted |
| GENERIC_CLASS_REFERENCE | Nullify reference, if GENERIC_CLASS deleted |
| ICON_FILE_REFERENCE | Nullify reference, if PRIMARY_ACCESS_FILE deleted |
Impact on child element types if ASSOCIATION is deleted
| Impact on children | Via child reference property |
| Nullify reference on ASSOCIATION | ASSOCIATION.ASSOCIATION_REFERENCE |
| Cascade delete ASSOCIATION_ENDS | ASSOCIATION_END.ASSOCIATION_REFERENCE |
| Cascade delete DIAGRAM_ELEMENT_USAGES | DIAGRAM_ELEMENT_USAGE.CIELEMENT_REFERENCE |
| Cascade delete ELEMENT_RULE_USAGES | ELEMENT_RULE_USAGE.CIELEMENT_REFERENCE |
| Cascade delete FILE_USAGES | FILE_USAGE.ASSOCIATION_REFERENCE |
| Cascade delete FOLDER_MEMBERS | FOLDER_MEMBER.MEMBER_OBJECT |
| Cascade delete SET_MEMBER_ITEMS | SET_MEMBER_ITEM.ELEMENT_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 |