SchemaSpy Analysis of backend_dev.public - Constraints Generated by
SchemaSpy
97 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column
fk19076c5dd96dedd7 pay_payment_invoice.document_content_id document_content.id
fk19076c5df45fedd4 pay_payment_invoice.payment_form_official_id pay_payment_form_official.id
fk1cb235f8eec96b99 ksi_import_history.id_proposals_folder proposals_folder.id
fk1ea6f8e311f2b060 evaluation_analysis_attachment.analysis_id evaluation_analysis.id
fk1ea6f8e3d96dedd7 evaluation_analysis_attachment.document_content_id document_content.id
fk2282dfdd6c37c9d7 folders_attachment.proposals_folder_id proposals_folder.id
fk2282dfddd96dedd7 folders_attachment.document_content_id document_content.id
fk23f41f16d96dedd7 rep_report.document_content_id document_content.id
fk2f4769292921a229 project_durability_content.durability_content_id document_content.id
fk2f47692929b7675f project_durability_content.id_project_durability project_durability.id
fk38264a3b5a2df78f meeting.contest_id contest.id
fk38264a3bd96dedd7 meeting.document_content_id document_content.id
fk38b735141e7b980f contest.recruitment_id recruitment.id
fk43dd3b1e34f4e2af document_template.filecontent_id document_content.id
fk43dd3b1e99884eaf document_template.category_id template_category.id
fk49c400202cb6207c evaluation_zgse_attachment.task_id evaluation_zgse_task.id
fk49c40020d96dedd7 evaluation_zgse_attachment.document_content_id document_content.id
fk4c3b70e7249c812d contract_annex.contract_id contract.id
fk4c3b70e7d96dedd7 contract_annex.document_content_id document_content.id
fk4c3b70e7feaaa375 contract_annex.contract_note_id contract_note.id
fk4d39613651a2340 pay_payment_form_official.project_information_id pay_project_information_official.id
fk4d39613658a59682 pay_payment_form_official.opinion_id pay_payment_opinion.id
fk4d3961366c37c9d7 pay_payment_form_official.proposals_folder_id proposals_folder.id
fk4d396136a3c4fc86 pay_payment_form_official.financing_source_id pay_financing_source_official.id
fk4d396136d96dedd7 pay_payment_form_official.document_content_id document_content.id
fk4df1d3897d69d204 pay_historical_payment_status.payment_form_id pay_payment_form_official.id
fk4ebfc86fd96dedd7 ctrl_document.document_content_id document_content.id
fk516d9aac249c812d proposals_folder.contract_id contract.id
fk516d9aac673bd700 proposals_folder.proposal_id proposal.id
fk5579693d6c37c9d7 applicant_person_agreement.proposals_folder_id proposals_folder.id
fk5579693d727865eb applicant_person_agreement.official_registration_id official_registration.id
fk591edcb2c04bf2d6 pay_payment_opinion.file_content_id document_content.id
fk5a169ba42cb6207c evaluation_zgse_meeting_attachment.task_id evaluation_zgse_task.id
fk5a169ba4d96dedd7 evaluation_zgse_meeting_attachment.document_content_id document_content.id
fk5b7526b36c37c9d7 official_message.proposals_folder_id proposals_folder.id
fk5ca7169e673bd700 deposit.proposal_id proposal.id
fk5ca7169ed96dedd7 deposit.document_content_id document_content.id
fk636d48d22cb6207c evaluation_zgse_person.task_id evaluation_zgse_task.id
fk6f79e4bf11f2b060 evaluation_plan_entry.analysis_id evaluation_analysis.id
fk6f79e4bfa1c43e13 evaluation_plan_entry.plan_id evaluation_plan.id
fk85b1c71c11f2b060 evaluation_recommendation.analysis_id evaluation_analysis.id
fk8c2e33894d642b0e ctrl_control.id_proposal proposal.id
fk8c2e338968560cc3 ctrl_control.control_proceedings_document_id ctrl_document.id
fk8c2e3389c8b41048 ctrl_control.control_program_document_id ctrl_document.id
fk90e30d8d633519eb official_registration.official_localization_id official_localization.id
fk98f3b729405eb31c ranking_entry.ranking_list_id ranking_list.id
fk9c331421d559fdef rep_task_content.task_id rep_task.id
fk9c331421d96dedd7 rep_task_content.document_content_id document_content.id
fk9f45addfe0e684a4 control_year.id_control ctrl_control.id
fka4f796f1c0bb883 annual_financial_source.id_financial_source financial_source.id
fkb08f24f6a1c43e13 evaluation_plan_attachment.plan_id evaluation_plan.id
fkb08f24f6d96dedd7 evaluation_plan_attachment.document_content_id document_content.id
fkc4d26af234b931fa proposal.legal_opinion_id legal_opinion.id
fkc4d26af26c37c9d7 proposal.proposals_folder_id proposals_folder.id
fkc4d26af284dd83a4 proposal.formal_opinion_id formal_opinion.id
fkc4d26af28ba93026 proposal.merits_opinion_id merits_opinion.id
fkc4d26af2d96dedd7 proposal.document_content_id document_content.id
fkd365cf075a2df78f ranking_list.contest_id contest.id
fkd7ee624a249c812d historical_contract_status.contract_id contract.id
fkd8ee64d61e8a4557 aggregate_year_expense.financial_plan_id financial_plan.id
fkdd2ab9117aa27507 ctrl_control_document.id_control_document ctrl_document.id
fkdd2ab911e0e684a4 ctrl_control_document.id_control ctrl_control.id
fkde3511126218793d contract.check_list_content_id document_content.id
fkde3511126c37c9d7 contract.proposals_folder_id proposals_folder.id
fkde3511129baedd80 contract.contract_content_id document_content.id
fkde351112feaaa375 contract.contract_note_id contract_note.id
fke16df8e211f2b060 evaluation_annual_information_entry.analysis_id evaluation_analysis.id
fke16df8e269904e78 evaluation_annual_information_entry.annual_information_id evaluation_annual_information.id
fke17332ff1e8a4557 contract_note.financial_plan_id financial_plan.id
fke17332ff372529ef contract_note.beneficiary_data_id beneficiary_data.id
fke17332ff5117fde contract_note.advanced_payment_data_id advance_payment_data.id
fke17332ff5b13cf91 contract_note.realization_period_id realization_period.id
fke17332ff9f4171e1 contract_note.financial_assistance_id financial_assistance.id
fke17332ffc8ad6f37 contract_note.project_durability_id project_durability.id
fke17332ffd5c1e875 contract_note.contract_data_id contract_data.id
fke2bf139021136943 ctrl_fraud.id_fraud_identifier ctrl_fraud_identifier.id
fke2bf13904d642b0e ctrl_fraud.id_proposal proposal.id
fke2bf1390e0e684a4 ctrl_fraud.id_control ctrl_control.id
fke4522c6a673bd700 historical_proposal_status.proposal_id proposal.id
fke52bb60273183ff5 note_document_content.id_contract_note contract_note.id
fkeafe9dbe7aa27507 ctrl_other_document.id_control_document ctrl_document.id
fkeafe9dbee0e684a4 ctrl_other_document.id_control ctrl_control.id
fkedb14a2c6c37c9d7 folders_note.proposals_folder_id proposals_folder.id
fkee90f3fc673bd700 legal_opinion.proposal_id proposal.id
fkee90f3fcd96dedd7 legal_opinion.document_content_id document_content.id
fkf2511acefeaaa375 realization_location.contract_note_id contract_note.id
fkf569fd8911f2b060 evaluation_offer_attachment.analysis_id evaluation_analysis.id
fkf569fd89d96dedd7 evaluation_offer_attachment.document_content_id document_content.id
fkf8c35b3d3f05f9a3 ctrl_control_plan_control.id_control_plan ctrl_control_plan.id
fkf8c35b3de9a95381 ctrl_control_plan_control.id_control control_year.id
sec_operator_role_sec_operator sec_operator_role.id_user sec_operator.id
sec_operator_role_sec_role sec_operator_role.id_role sec_role.id
sec_permission_def_sec_permission sec_permission_def.id_permission sec_permission.id
sec_permission_def_sec_role sec_permission_def.id_role sec_role.id
sec_permission_sec_system sec_permission.id_system sec_system.id
sec_role_sec_role sec_role.id_role_parent sec_role.id
sec_role_sec_system sec_role.id_system sec_system.id

Check Constraints:

Table Constraint Name Constraint
None detected