SchemaSpy Analysis of oc312.public - Constraints Generated by
SchemaSpy
138 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
dataset_fk_dataset_item_status dataset.dataset_item_status_id dataset_item_status.dataset_item_status_id Restrict delete 
discrepancy_note_asn_u_id_fkey discrepancy_note.assigned_user_id user_account.user_id Restrict delete 
discrepancy_note_owner_id_fkey discrepancy_note.owner_id user_account.user_id Restrict delete 
discrepancy_note_study_id_fkey discrepancy_note.study_id study.study_id Restrict delete 
dn_discrepancy_note_type_id_fk discrepancy_note.discrepancy_note_type_id discrepancy_note_type.discrepancy_note_type_id Restrict delete 
dn_event_crf_map_dn_id_fkey dn_event_crf_map.discrepancy_note_id discrepancy_note.discrepancy_note_id Restrict delete 
dn_evnt_crf_map_evnt_crf_id_fk dn_event_crf_map.event_crf_id event_crf.event_crf_id Restrict delete 
dn_item_data_map_dn_id_fkey dn_item_data_map.discrepancy_note_id discrepancy_note.discrepancy_note_id Restrict delete 
dn_itm_data_map_itm_data_id_fk dn_item_data_map.item_data_id item_data.item_data_id Restrict delete 
dn_resolution_status_id_fkey discrepancy_note.resolution_status_id resolution_status.resolution_status_id Restrict delete 
dn_sem_study_event_id_fkey dn_study_event_map.study_event_id study_event.study_event_id Restrict delete 
dn_ssm_study_subject_id_fkey dn_study_subject_map.study_subject_id study_subject.study_subject_id Restrict delete 
dn_study_event_map_dn_id_fkey dn_study_event_map.discrepancy_note_id discrepancy_note.discrepancy_note_id Restrict delete 
dn_study_subject_map_dn_id_fk dn_study_subject_map.discrepancy_note_id discrepancy_note.discrepancy_note_id Restrict delete 
dn_subject_map_dn_id_fkey dn_subject_map.discrepancy_note_id discrepancy_note.discrepancy_note_id Restrict delete 
dn_subject_map_subject_id_fkey dn_subject_map.subject_id subject.subject_id Restrict delete 
fk_answer_reference_item item_data.item_id item.item_id Restrict delete 
fk_archived_reference_dataset archived_dataset_file.dataset_id dataset.dataset_id Restrict delete 
fk_archived_reference_export_f archived_dataset_file.export_format_id export_format.export_format_id Restrict delete 
fk_audit_ev_reference_audit_ev audit_event_context.audit_id audit_event.audit_id Restrict delete 
fk_audit_lo_ref_audit_lo audit_event_values.audit_id audit_event.audit_id Restrict delete 
fk_audit_user_login_id audit_user_login.user_account_id user_account.user_id Restrict delete 
fk_completi_fk_comple_status completion_status.status_id status.status_id Restrict delete 
fk_crf_crf_user_user_acc crf.owner_id user_account.user_id Restrict delete 
fk_crf_fk_crf_fk_status crf.status_id status.status_id Restrict delete 
fk_crf_metadata item_group_metadata.crf_version_id crf_version.crf_version_id Restrict delete 
fk_crf_vers_crf_versi_user_acc crf_version.owner_id user_account.user_id Restrict delete 
fk_crf_vers_fk_crf_ve_status crf_version.status_id status.status_id Restrict delete 
fk_dataset__ref_event_event_de dataset_crf_version_map.event_definition_crf_id event_definition_crf.event_definition_crf_id Restrict delete 
fk_dataset_crf_ref_dataset dataset_crf_version_map.dataset_id dataset.dataset_id Restrict delete 
fk_dataset_fk_datase_status dataset.status_id status.status_id Restrict delete 
fk_dataset_fk_datase_study dataset.study_id study.study_id Restrict delete 
fk_dataset_fk_datase_user_acc dataset.owner_id user_account.user_id Restrict delete 
fk_dataset_ref_study_grp_class dataset_study_group_class_map.study_group_class_id study_group_class.study_group_class_id Restrict delete 
fk_dataset_reference_dataset dataset_filter_map.dataset_id dataset.dataset_id Restrict delete 
fk_dataset_reference_filter dataset_filter_map.filter_id filter.filter_id Restrict delete 
fk_dataset_study_ref_dataset dataset_study_group_class_map.dataset_id dataset.dataset_id Restrict delete 
fk_dc_compu_fk_dc_com_dc_event dc_computed_event.dc_event_id dc_event.dc_event_id Restrict delete 
fk_dc_event_fk_dc_eve_decision dc_event.decision_condition_id decision_condition.decision_condition_id Restrict delete 
fk_dc_primi_fk_dc_pri_decision dc_primitive.decision_condition_id decision_condition.decision_condition_id Restrict delete 
fk_dc_primi_fk_dc_pri_item dc_primitive.dynamic_value_item_id item.item_id Restrict delete 
fk_dc_primi_fk_item_i_item dc_primitive.item_id item.item_id Restrict delete 
fk_dc_secti_fk_dc_sec_dc_event dc_section_event.dc_event_id dc_event.dc_event_id Restrict delete 
fk_dc_send__dc_send_e_dc_event dc_send_email_event.dc_event_id dc_event.dc_event_id Restrict delete 
fk_dc_subst_fk_dc_sub_dc_event dc_substitution_event.dc_event_id dc_event.dc_event_id Restrict delete 
fk_dc_subst_fk_dc_sub_item dc_substitution_event.item_id item.item_id Restrict delete 
fk_dc_summa_fk_dc_sum_dc_compu dc_summary_item_map.dc_summary_event_id dc_computed_event.dc_summary_event_id Restrict delete 
fk_dc_summa_fk_dc_sum_item dc_summary_item_map.item_id item.item_id Restrict delete 
fk_decision_fk_decisi_crf_vers decision_condition.crf_version_id crf_version.crf_version_id Restrict delete 
fk_decision_fk_decisi_status decision_condition.status_id status.status_id Restrict delete 
fk_decision_fk_decisi_user_acc decision_condition.owner_id user_account.user_id Restrict delete 
fk_event_cr_fk_event__completi event_crf.completion_status_id completion_status.completion_status_id Restrict delete 
fk_event_cr_fk_event__status event_crf.status_id status.status_id Restrict delete 
fk_event_cr_fk_event__study_ev event_crf.study_event_id study_event.study_event_id Restrict delete 
fk_event_cr_fk_event__user_acc event_crf.owner_id user_account.user_id Restrict delete 
fk_event_cr_reference_study_su event_crf.study_subject_id study_subject.study_subject_id Restrict delete 
fk_event_de_fk_study__status event_definition_crf.status_id status.status_id Restrict delete 
fk_event_de_reference_study_ev event_definition_crf.study_event_definition_id study_event_definition.study_event_definition_id Restrict delete 
fk_event_de_study_crf_user_acc event_definition_crf.owner_id user_account.user_id Restrict delete 
fk_filter_c_reference_crf_vers filter_crf_version_map.crf_version_id crf_version.crf_version_id Restrict delete 
fk_filter_c_reference_filter filter_crf_version_map.filter_id filter.filter_id Restrict delete 
fk_filter_fk_query__status filter.status_id status.status_id Restrict delete 
fk_filter_fk_query__user_acc filter.owner_id user_account.user_id Restrict delete 
fk_group_class_study_group study_group.study_group_class_id study_group_class.study_group_class_id Null on delete 
fk_item item_group_metadata.item_id item.item_id Restrict delete 
fk_item_dat_fk_item_d_status item_data.status_id status.status_id Restrict delete 
fk_item_dat_fk_item_d_user_acc item_data.owner_id user_account.user_id Restrict delete 
fk_item_fk_item_f_item_ref item.item_reference_type_id item_reference_type.item_reference_type_id Restrict delete 
fk_item_fk_item_i_item_dat item.item_data_type_id item_data_type.item_data_type_id Restrict delete 
fk_item_fk_item_s_status item.status_id status.status_id Restrict delete 
fk_item_fk_item_u_user_acc item.owner_id user_account.user_id Restrict delete 
fk_item_gro_fk_item_g_status item_group.status_id status.status_id Restrict delete 
fk_item_gro_fk_item_g_user_acc item_group.owner_id user_account.user_id Restrict delete 
fk_item_group item_group_metadata.item_group_id item_group.item_group_id Restrict delete 
fk_item_group_crf item_group.crf_id crf.crf_id Restrict delete 
fk_item_id item_form_metadata.item_id item.item_id Restrict delete 
fk_item_reference_subject item_data.event_crf_id event_crf.event_crf_id Restrict delete 
fk_old_status_id study.old_status_id status.status_id Restrict delete 
fk_person_role_study_id study_user_role.study_id study.study_id Restrict delete 
fk_priv_id role_privilege_map.priv_id privilege.priv_id Restrict delete 
fk_project__reference_study2 study_subject.study_id study.study_id Restrict delete 
fk_response_fk_respon_response response_set.response_type_id response_type.response_type_id Restrict delete 
fk_role_id role_privilege_map.role_id user_role.role_id Restrict delete 
fk_rs_id item_form_metadata.response_set_id response_set.response_set_id Restrict delete 
fk_sec_id item_form_metadata.section_id section.section_id Restrict delete 
fk_section_fk_sectio_status section.status_id status.status_id Restrict delete 
fk_section_fk_sectio_user_acc section.owner_id user_account.user_id Restrict delete 
fk_section_version section.crf_version_id crf_version.crf_version_id Restrict delete 
fk_source_study_id crf.source_study_id study.study_id Restrict delete 
fk_study_ev_fk_study__status study_event.status_id status.status_id Restrict delete 
fk_study_ev_fk_study__study study_event_definition.study_id study.study_id Restrict delete 
fk_study_ev_fk_study__study_ev study_event.study_event_definition_id study_event_definition.study_event_definition_id Restrict delete 
fk_study_ev_fk_study__user_acc study_event.owner_id user_account.user_id Restrict delete 
fk_study_ev_fk_studye_status study_event_definition.status_id status.status_id Restrict delete 
fk_study_ev_fk_studye_user_acc study_event_definition.owner_id user_account.user_id Restrict delete 
fk_study_ev_reference_study_su study_event.study_subject_id study_subject.study_subject_id Restrict delete 
fk_study_fk_study__status study.status_id status.status_id Restrict delete 
fk_study_fk_study__user_acc study.owner_id user_account.user_id Restrict delete 
fk_study_gr_fk_study__group_ty study_group_class.group_class_type_id group_class_types.group_class_type_id Restrict delete 
fk_study_gr_fk_study__status study_group_class.status_id status.status_id Restrict delete 
fk_study_gr_fk_study__user_acc study_group_class.owner_id user_account.user_id Restrict delete 
fk_study_inst_reference event_definition_crf.crf_id crf.crf_id Restrict delete 
fk_study_module_study_id study_module_status.study_id study.study_id Restrict delete 
fk_study_reference_instrument event_definition_crf.study_id study.study_id Restrict delete 
fk_study_reference_subject study_subject.subject_id subject.subject_id Null on delete 
fk_study_su_fk_study__status study_subject.status_id status.status_id Restrict delete 
fk_study_su_fk_study__user_acc study_subject.owner_id user_account.user_id Restrict delete 
fk_study_type study.type_id study_type.study_type_id Restrict delete 
fk_study_us_fk_study__status study_user_role.status_id status.status_id Restrict delete 
fk_study_us_study_use_user_acc study_user_role.owner_id user_account.user_id Restrict delete 
fk_subject__fk_sub_gr_user_acc subject_group_map.owner_id user_account.user_id Restrict delete 
fk_subject__fk_subjec_group_ro subject_group_map.study_group_id study_group.study_group_id Restrict delete 
fk_subject__fk_subjec_status subject_group_map.status_id status.status_id Restrict delete 
fk_subject__fk_subjec_study_gr subject_group_map.study_group_class_id study_group_class.study_group_class_id Restrict delete 
fk_subject__subject_g_study_su subject_group_map.study_subject_id study_subject.study_subject_id Restrict delete 
fk_subject_fk_subjec_status subject.status_id status.status_id Restrict delete 
fk_subject_fk_subjec_user_acc subject.owner_id user_account.user_id Restrict delete 
fk_subject_referenc_instrument event_crf.crf_version_id crf_version.crf_version_id Restrict delete 
fk_user_acc_fk_user_f_user_acc user_account.owner_id user_account.user_id Restrict delete 
fk_user_acc_ref_user__user_typ user_account.user_type_id user_type.user_type_id Restrict delete 
fk_user_acc_status_re_status user_account.status_id status.status_id Restrict delete 
fk_versioni_fk_versio_crf_vers versioning_map.crf_version_id crf_version.crf_version_id Restrict delete 
fk_versioni_fk_versio_item versioning_map.item_id item.item_id Restrict delete 
fk_versioni_reference_instrume crf_version.crf_id crf.crf_id Restrict delete 
fk_versioning_study_inst event_definition_crf.default_version_id crf_version.crf_version_id Null on delete 
has_father subject.father_id subject.subject_id Null on delete 
has_mother subject.mother_id subject.subject_id Null on delete 
oc_qrtz_blob_triggers_trg_fkey oc_qrtz_blob_triggers.trigger_name
oc_qrtz_blob_triggers.trigger_group
oc_qrtz_triggers.trigger_name
oc_qrtz_triggers.trigger_group
Restrict delete 
oc_qrtz_cron_triggers_trg_fkey oc_qrtz_cron_triggers.trigger_name
oc_qrtz_cron_triggers.trigger_group
oc_qrtz_triggers.trigger_name
oc_qrtz_triggers.trigger_group
Restrict delete 
oc_qrtz_job_listeners_job_fkey oc_qrtz_job_listeners.job_name
oc_qrtz_job_listeners.job_group
oc_qrtz_job_details.job_name
oc_qrtz_job_details.job_group
Restrict delete 
oc_qrtz_simple_trigs_trg_fkey oc_qrtz_simple_triggers.trigger_name
oc_qrtz_simple_triggers.trigger_group
oc_qrtz_triggers.trigger_name
oc_qrtz_triggers.trigger_group
Restrict delete 
oc_qrtz_trigger_lsnrs_trg_fkey oc_qrtz_trigger_listeners.trigger_name
oc_qrtz_trigger_listeners.trigger_group
oc_qrtz_triggers.trigger_name
oc_qrtz_triggers.trigger_group
Restrict delete 
oc_qrtz_triggers_job_name_fkey oc_qrtz_triggers.job_name
oc_qrtz_triggers.job_group
oc_qrtz_job_details.job_name
oc_qrtz_job_details.job_group
Restrict delete 
project_is_contained_within_pa study.parent_study_id study.study_id Null on delete 
scd_meta_fk_control_meta_id scd_item_metadata.control_item_form_metadata_id item_form_metadata.item_form_metadata_id Restrict delete 
scd_meta_fk_scd_form_meta_id scd_item_metadata.scd_item_form_metadata_id item_form_metadata.item_form_metadata_id Restrict delete 
study_param_value_param_fkey study_parameter_value.parameter study_parameter.handle Restrict delete 
study_param_value_study_id_fk study_parameter_value.study_id study.study_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected