Tables Relationships Utility Tables Constraints Anomalies Columns Donate

SchemaSpy Analysis of backend_dev.public - Constraints | Generated by SchemaSpy

97 Foreign Key Constraints: |

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