SchemaSpy Analysis of shrdb.LAWRS - Constraints | Generated by SchemaSpy |
8 Foreign Key Constraints: |
|
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 |