SchemaSpy Analysis of shrdb.LAWRS - Constraints Generated by
SchemaSpy
8 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
SYS_C0011691 EJS_BLOB_TRIGGERS.TRIGGER_NAME
EJS_BLOB_TRIGGERS.TRIGGER_GROUP
EJS_TRIGGERS.TRIGGER_NAME
EJS_TRIGGERS.TRIGGER_GROUP
Restrict delete 
SYS_C0011692 EJS_CRON_TRIGGERS.TRIGGER_NAME
EJS_CRON_TRIGGERS.TRIGGER_GROUP
EJS_TRIGGERS.TRIGGER_NAME
EJS_TRIGGERS.TRIGGER_GROUP
Restrict delete 
SYS_C0011693 EJS_JOB_LISTENERS.JOB_NAME
EJS_JOB_LISTENERS.JOB_GROUP
EJS_JOB_DETAILS.JOB_NAME
EJS_JOB_DETAILS.JOB_GROUP
Restrict delete 
SYS_C0011694 EJS_SIMPLE_TRIGGERS.TRIGGER_NAME
EJS_SIMPLE_TRIGGERS.TRIGGER_GROUP
EJS_TRIGGERS.TRIGGER_NAME
EJS_TRIGGERS.TRIGGER_GROUP
Restrict delete 
SYS_C0011695 EJS_TRIGGERS.JOB_NAME
EJS_TRIGGERS.JOB_GROUP
EJS_JOB_DETAILS.JOB_NAME
EJS_JOB_DETAILS.JOB_GROUP
Restrict delete 
SYS_C0011696 ERS_PARM_AVAILVALUES_IDS.PID ERS_PARAMETERS.ID Cascade on delete 
SYS_C0011697 ERS_PARM_AVAILVALUES.PID ERS_PARAMETERS.ID Cascade on delete 
SYS_C0011698 EJS_TRIGGER_LISTENERS.TRIGGER_NAME
EJS_TRIGGER_LISTENERS.TRIGGER_GROUP
EJS_TRIGGERS.TRIGGER_NAME
EJS_TRIGGERS.TRIGGER_GROUP
Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected