SchemaSpy Analysis of testdb.public - Constraints Generated by
SchemaSpy
46 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
act_fk_athrz_procedef act_ru_identitylink.proc_def_id_ act_re_procdef.id_ Restrict delete 
act_fk_batch_job_def act_ru_batch.batch_job_def_id_ act_ru_jobdef.id_ Restrict delete 
act_fk_batch_monitor_job_def act_ru_batch.monitor_job_def_id_ act_ru_jobdef.id_ Restrict delete 
act_fk_batch_seed_job_def act_ru_batch.seed_job_def_id_ act_ru_jobdef.id_ Restrict delete 
act_fk_bytearr_depl act_ge_bytearray.deployment_id_ act_re_deployment.id_ Restrict delete 
act_fk_case_exe_case_def act_ru_case_execution.case_def_id_ act_re_case_def.id_ Restrict delete 
act_fk_case_exe_case_inst act_ru_case_execution.case_inst_id_ act_ru_case_execution.id_ Restrict delete 
act_fk_case_exe_parent act_ru_case_execution.parent_id_ act_ru_case_execution.id_ Restrict delete 
act_fk_case_sentry_case_exec act_ru_case_sentry_part.case_exec_id_ act_ru_case_execution.id_ Restrict delete 
act_fk_case_sentry_case_inst act_ru_case_sentry_part.case_inst_id_ act_ru_case_execution.id_ Restrict delete 
act_fk_dec_req act_re_decision_def.dec_req_id_ act_re_decision_req_def.id_ Restrict delete 
act_fk_event_exec act_ru_event_subscr.execution_id_ act_ru_execution.id_ Restrict delete 
act_fk_exe_parent act_ru_execution.parent_id_ act_ru_execution.id_ Restrict delete 
act_fk_exe_procdef act_ru_execution.proc_def_id_ act_re_procdef.id_ Restrict delete 
act_fk_exe_procinst act_ru_execution.proc_inst_id_ act_ru_execution.id_ Restrict delete 
act_fk_exe_super act_ru_execution.super_exec_ act_ru_execution.id_ Restrict delete 
act_fk_ext_task_error_details act_ru_ext_task.error_details_id_ act_ge_bytearray.id_ Restrict delete 
act_fk_ext_task_exe act_ru_ext_task.execution_id_ act_ru_execution.id_ Restrict delete 
act_fk_inc_cause act_ru_incident.cause_incident_id_ act_ru_incident.id_ Restrict delete 
act_fk_inc_exe act_ru_incident.execution_id_ act_ru_execution.id_ Restrict delete 
act_fk_inc_job_def act_ru_incident.job_def_id_ act_ru_jobdef.id_ Restrict delete 
act_fk_inc_procdef act_ru_incident.proc_def_id_ act_re_procdef.id_ Restrict delete 
act_fk_inc_procinst act_ru_incident.proc_inst_id_ act_ru_execution.id_ Restrict delete 
act_fk_inc_rcause act_ru_incident.root_cause_incident_id_ act_ru_incident.id_ Restrict delete 
act_fk_job_exception act_ru_job.exception_stack_id_ act_ge_bytearray.id_ Restrict delete 
act_fk_memb_group act_id_membership.group_id_ act_id_group.id_ Restrict delete 
act_fk_memb_user act_id_membership.user_id_ act_id_user.id_ Restrict delete 
act_fk_task_case_def act_ru_task.case_def_id_ act_re_case_def.id_ Restrict delete 
act_fk_task_case_exe act_ru_task.case_execution_id_ act_ru_case_execution.id_ Restrict delete 
act_fk_task_exe act_ru_task.execution_id_ act_ru_execution.id_ Restrict delete 
act_fk_task_procdef act_ru_task.proc_def_id_ act_re_procdef.id_ Restrict delete 
act_fk_task_procinst act_ru_task.proc_inst_id_ act_ru_execution.id_ Restrict delete 
act_fk_tenant_memb act_id_tenant_member.tenant_id_ act_id_tenant.id_ Restrict delete 
act_fk_tenant_memb_group act_id_tenant_member.group_id_ act_id_group.id_ Restrict delete 
act_fk_tenant_memb_user act_id_tenant_member.user_id_ act_id_user.id_ Restrict delete 
act_fk_tskass_task act_ru_identitylink.task_id_ act_ru_task.id_ Restrict delete 
act_fk_var_batch act_ru_variable.batch_id_ act_ru_batch.id_ Restrict delete 
act_fk_var_bytearray act_ru_variable.bytearray_id_ act_ge_bytearray.id_ Restrict delete 
act_fk_var_case_exe act_ru_variable.case_execution_id_ act_ru_case_execution.id_ Restrict delete 
act_fk_var_case_inst act_ru_variable.case_inst_id_ act_ru_case_execution.id_ Restrict delete 
act_fk_var_exe act_ru_variable.execution_id_ act_ru_execution.id_ Restrict delete 
act_fk_var_procinst act_ru_variable.proc_inst_id_ act_ru_execution.id_ Restrict delete 
fkev0msagl6aloybhfdrqd0lu2q rsrv_route.c_target_location rsrv_location.c_pk Restrict delete 
fkh6pwflfvy0ek6nt9odqahmng0 rsrv_route.c_source_location rsrv_location.c_pk Restrict delete 
fklxix4fythi8yy6eornb00m6ud rsrv_action.c_route_id rsrv_route.c_pk Restrict delete 
fksb26oisxtw8yc72ur7d0pqxym rsrv_route_details.c_route_id rsrv_route.c_pk Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected