Oracle Designer Model, Release 6i
Deletion rules


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

Reference PropertyDeletion Rule
DATABASE_USER_REFERENCE Cascade delete, if DATABASE_USER deleted (Owning foreign key)
GENERAL_MODULE_REFERENCE Cascade delete, if GENERAL_MODULE deleted

Impact on child element types if ORACLE_USER_MODULE_ACCESS is deleted

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