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