Oracle Designer Model, Release 6i
Deletion rules
Deletion rules on COLUMN reference properties, i.e. rule if referenced element is deleted
| Reference Property | Deletion Rule |
| DOMAIN_REFERENCE | Block attempt to delete DOMAIN |
| SEQUENCE_REFERENCE | Block attempt to delete SEQUENCE |
| ORACLE_OBJECT_TYPE_REFERENCE | Cascade delete, if ORACLE_OBJECT_TYPE deleted (Owning foreign key) |
| TABLE_REFERENCE | Cascade delete, if RELATION_DEFINITION deleted (Owning foreign key) |
| SOURCE_ATTRIBUTE_REFERENCE | Nullify reference, if ATTRIBUTE deleted |
| CLUSTER_COLUMN_REFERENCE | Nullify reference, if CLUSTER_COLUMN deleted |
| COLUMN_DENORMALISED_FROM | Nullify reference, if COLUMN deleted |
| BASE_COLUMN_REFERENCE | Nullify reference, if COLUMN deleted |
| CONSTRAINT_DENORMALISED_VIA | Nullify reference, if JOIN_CONSTRAINT deleted |
| ORACLE_TYPE_REFERENCE | Nullify reference, if ORACLE_TYPE deleted |
| RELATION_SELECTION_REFERENCE | Nullify reference, if RELATION_SELECTION deleted |
| SCOPE_TABLE_REFERENCE | Nullify reference, if TABLE_DEFINITION deleted |
Impact on child element types if COLUMN is deleted
| Impact on children | Via child reference property |
| Nullify reference on COLUMN | COLUMN.BASE_COLUMN_REFERENCE |
| Nullify reference on COLUMN | COLUMN.COLUMN_DENORMALISED_FROM |
| Nullify reference on KEY_COMPONENT | KEY_COMPONENT.FOREIGN_COLUMN_REFERENCE2 |
| Nullify reference on MODULE_ARGUMENT | MODULE_ARGUMENT.COLUMN_REFERENCE |
| Nullify reference on PROGRAM_DATUM | PROGRAM_DATUM.COLUMN_REFERENCE |
| Cascade delete ATTRIBUTE_QUALIFIERS | ATTRIBUTE_QUALIFIER.COLUMN_REFERENCE |
| Cascade delete ATTRIBUTE_VALUES | ATTRIBUTE_VALUE.COLUMN_REFERENCE |
| Cascade delete COLUMN_STORAGES | COLUMN_STORAGE.COLUMN_REFERENCE |
| Cascade delete DIAGRAM_ELEMENT_USAGES | DIAGRAM_ELEMENT_USAGE.CIELEMENT_REFERENCE |
| Cascade delete DOCUMENT_ATTACHMENTS | DOCUMENT_ATTACHMENT.ELEMENT_REFERENCE |
| Cascade delete EXTENDED_STRUCTURE_ELEMENTS | EXTENDED_STRUCTURE_ELEMENT.PART_OF_REFERENCE |
| Cascade delete EXTENDED_STRUCTURE_ELEMENTS | EXTENDED_STRUCTURE_ELEMENT.USE_OF_REFERENCE |
| Cascade delete INDEX_ENTRIES | INDEX_ENTRY.COLUMN_REFERENCE |
| Cascade delete KEY_COMPONENTS | KEY_COMPONENT.COLUMN_REFERENCE |
| Cascade delete MAPPING_ELEMENTS | MAPPING_ELEMENT.SOURCE_CIELEMENT_REFERENCE |
| Cascade delete MAPPING_ELEMENTS | MAPPING_ELEMENT.TARGET_CIELEMENT_REFERENCE |
| Cascade delete PARTITION_KEY_ENTRIES | PARTITION_KEY_ENTRY.COLUMN_REFERENCE |
| Cascade delete PREFERENCE_SET_USAGES | PREFERENCE_SET_USAGE.CIELEMENT_REFERENCE |
| Cascade delete USER_PREFERENCES | USER_PREFERENCE.CIELEMENT_REFERENCE |
| Block, if DATASTRUCTURE_ITEMS exist | DATASTRUCTURE_ITEM.COLUMN_REFERENCE |
| Block, if DATA_BOUND_ITEMS exist | DATA_BOUND_ITEM.COLUMN_REFERENCE |
| Block, if KEY_COMPONENTS exist | KEY_COMPONENT.FOREIGN_COLUMN_REFERENCE |
| Block, if TABLES_ENTITIES exist | TABLE_ENTITY.COLUMN_REFERENCE |
| Block, if TRIGGER_COLUMN_USAGES exist | TRIGGER_COLUMN_USAGE.COLUMN_REFERENCE |