Oracle Designer Model, Release 6i
Deletion rules


Deletion rules on MODULE_PROGRAM_DATUM reference properties, i.e. rule if referenced element is deleted

Reference PropertyDeletion Rule
PROGRAM_DATUM_REFERENCE Block attempt to delete PROGRAM_DATUM
GENERAL_MODULE_REFERENCE Cascade delete, if GENERAL_MODULE deleted (Owning foreign key)
PLSQL_MODULE_REFERENCE Cascade delete, if PLSQL_MODULE deleted (Owning foreign key)

Impact on child element types if MODULE_PROGRAM_DATUM is deleted

Impact on childrenVia child reference property
Cascade delete DIAGRAM_ELEMENT_USAGES DIAGRAM_ELEMENT_USAGE.CIELEMENT_REFERENCE