Tables Relationships Utility Tables Constraints Anomalies Columns Donate

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

168 Foreign Key Constraints: |

Constraint Name | Child Column | Parent Column
--- | --- | ---
address_city | address.id_city | city.id
address_commune | address.id_commune | commune.id
address_district | address.id_district | district.id
address_province | address.id_province | province.id
aggregate_value_financial_installment | aggregate_value.id_financial_installment | financial_installment.id
applicant_application_form | applicant.id_form | application_form.id
applicant_fk | application_form_info.id_applicant | applicant.id
applicant_form_another_project | applicant.id_form_another_project | application_form.id
applicant_person_agreement_applicant | applicant_person_agreement.id_applicant | applicant.id
applicant_person_agreement_person | applicant_person_agreement.id_person | person.id
applicant_person_contact_applicant | applicant_person_contact.id_applicant | applicant.id
applicant_person_contact_person | applicant_person_contact.id_person | person.id
applicant_subject | applicant.id_subject | subject.id
applicant_type_of_applicant | applicant.id_type_of_applicant | type_of_applicant.id
application_folder | application_form.id_folder | folder.id
application_form_fk | applicant.id_form | application_form.id
application_form_history | application_form.id_user_application_form | user_application_form.id
application_form_owner | application_form.id_user | user_registration.id
assistance_de_minimis_applicant | assistance_de_minimis.id_applicant | applicant.id
co_financing_amount_financial_installment | co_financing_amount.id_financial_installment | financial_installment.id
commune_district | commune.id_district | district.id
commune_id_fk | project_location.id_commune | commune.id
current_version_application_form | user_application_form.id_application_form | application_form.id
description_of_public_procurement | description_of_public_procurement.id_project_description | project_description.id
district_id_fk | project_location.id_district | district.id
evaluation_application | evaluation.id_form | application_form.id
evaluation_LISTA_WIARYGODNOSCI | evaluation.id_ranking_list | ranking_list.id
expense_task | expense.id_task | task.id
expense_value_expense | expense_year.id_expense | expense.id
financial_installment_application_form | financial_installment.id_form | application_form.id
financing_source_financial_installment | financing_source.id_financial_installment | financial_installment.id
fk1e0183b1c5e1a66 | pay_beneficiary_information.beneficiary_person_id | pay_person_info.id
fk1e0183bb8f16b47 | pay_beneficiary_information.realization_person_id | pay_person_info.id
fk1e0183bf795030a | pay_beneficiary_information.financial_person_id | pay_person_info.id
fk51ab66bc2b445657 | pay_task.expense_combination_id | pay_expense_combination.id
fk631ad5674801eae3 | operation.id_priority_axis | priority_axis.id
fk688b1f274434bc24 | suboperation.id_operation | operation.id
fk6bef7c1ef5017c8 | pay_expense.task_id | pay_task.id
fk80e2fae475df8a22 | pay_material_financial_phase.material_financial_progress_id | pay_material_financial_progress.id
fk8b5d916f72c76184 | pay_product_realization_indicator.payment_form_id | pay_payment_form.id
fk8b5d916f7f288d99 | pay_product_realization_indicator.id_indicator_description | indicator_description.id
fk8dd13538a5e9feab | pay_period.period_definition_id | pay_period_definition.id
fk8dd13538ce0d0bcc | pay_period.expense_id | pay_expense.id
fk8fd6c7ab72c76184 | pay_result_realization_indicator.payment_form_id | pay_payment_form.id
fk8fd6c7ab7f288d99 | pay_result_realization_indicator.id_indicator_description | indicator_description.id
fk923153a372c76184 | pay_historical_payment_beneficiary_status.payment_form_id | pay_payment_form.id
fka1ebc94172c76184 | pay_schedule_entry.payment_form_id | pay_payment_form.id
fka3b201cc2698a538 | indicator_description.id_suboperation | suboperation.id
fka3b201cc4434bc24 | indicator_description.id_operation | operation.id
fka63174935226cea7 | pay_income_entry.income_id | pay_income.id
fkbfdf61f39abcac33 | pay_payment_attachment.attachments_and_statements_id | pay_attachments_and_statements.id
fkc9a072966c100ac8 | pay_invoice.period_id | pay_period.id
fkd00f62ba2b445657 | pay_period_definition.expense_combination_id | pay_expense_combination.id
fkd62aec2454890423 | pay_material_financial_progress.apartment_target_id | pay_material_financial_target.id
fkd62aec24a754c1e9 | pay_material_financial_progress.lump_sum_target_id | pay_material_financial_target.id
fkd62aec24cf6f6038 | pay_material_financial_progress.ground_target_id | pay_material_financial_target.id
fkd62aec24e2297649 | pay_material_financial_progress.cross_financing_target_id | pay_material_financial_target.id
fkd9b8495c47da0d61 | pay_schedule_quarter_amount.schedule_entry_id | pay_schedule_entry.id
fke2c2f1941eb3f86d | pay_payment_form.expense_combination | pay_expense_combination.id
fke2c2f194200c2ce5 | pay_payment_form.id_report | report.id
fke2c2f194266da59f | pay_payment_form.beneficiary_information_id | pay_beneficiary_information.id
fke2c2f1945226cea7 | pay_payment_form.income_id | pay_income.id
fke2c2f19462ef1d1b | pay_payment_form.realization_progress_id | pay_realization_progress.id
fke2c2f19475df8a22 | pay_payment_form.material_financial_progress_id | pay_material_financial_progress.id
fke2c2f19495de1e37 | pay_payment_form.project_information_id | pay_project_information.id
fke2c2f1949abcac33 | pay_payment_form.attachments_and_statements_id | pay_attachments_and_statements.id
fke2c2f194a478705a | pay_payment_form.financing_information_id | pay_financing_information.id
fke4c8207d480c6919 | pay_realization_progress.unbuilt_real_estate_expense_id | pay_realization_progress_entry.id
fke4c8207d5aefab3b | pay_realization_progress.group_1_expense_id | pay_realization_progress_entry.id
fke4c8207d8b0576c5 | pay_realization_progress.material_expense_id | pay_realization_progress_entry.id
fke4c8207dee2de9b | pay_realization_progress.built_real_state_expense_id | pay_realization_progress_entry.id
fkf93cd2b3a478705a | pay_financing_entry.financing_information_id | pay_financing_information.id
folder_user | folder.id_user | user_registration.id
form_annex_annex | form_annex.id_annex | annex.id
form_annex_application | form_annex.id_form | application_form.id
form_statement_application | form_statement.id_form | application_form.id
form_statement_statement | form_statement.id_statement | statement.id
id_city_fk | project_location.id_city | city.id
id_correspondence_address_fk | applicant.id_correspondence_address | address.id
id_indicator_type_key_description | indicator_type_key.id_indicator_description | indicator_description.id
id_indicator_type_product_description | indicator_type_product.id_indicator_description | indicator_description.id
id_indicator_type_realisation_description | indicator_type_realisation.id_indicator_description | indicator_description.id
id_indicator_type_result_description | indicator_type_result.id_indicator_description | indicator_description.id
id_legal_form_fk | applicant.id_legal_form | legal_form.id
id_registration_address_fk | applicant.id_registration_address | address.id
id_task_fk | task_aggregate_value.id_task | task.id
id_type_of_record_fk | applicant.id_type_of_record | type_of_record.id
indicator_description_operation | indicator_description.id_operation | operation.id
indicator_type_key_description | indicator_type_key.id_project_description | project_description.id
indicator_type_key_year_value_indicator | indicator_type_key_year_value.id_indicator | indicator_type_key.id
indicator_type_product_year_value_indicator | indicator_type_product_year_value.id_indicator | indicator_type_product.id
indicator_type_project_description | indicator_type_product.id_project_description | project_description.id
indicator_type_realisation_description | indicator_type_realisation.id_project_description | project_description.id
indicator_type_realisation_year_value_indicator | indicator_type_realisation_year_value.id_indicator | indicator_type_realisation.id
indicator_type_result_description | indicator_type_result.id_project_description | project_description.id
indicator_type_result_year_value_indicator | indicator_type_result_year_value.id_indicator | indicator_type_result.id
key_description | co_financing_key_result.id_indicator_description | indicator_description.id
key_results_co_finance_project_description | co_financing_key_result.id_project_description | project_description.id
message | user_registration_message.id_message | message.id
message_folder | message.id_folder | folder.id
note_folder | note.id_folder | folder.id
operation_area_type_area_type | operation_area_type.id_area_type | area_type.id
operation_area_type_operation | operation_area_type.id_operation | operation.id
operation_field_configuration_field_configuration | operation_field_configuration.id_field_configuration | field_configuration.id
operation_field_configuration_operation | operation_field_configuration.id_operation | operation.id
operation_funding_form_id_funding_form_fkey | operation_funding_form.id_funding_form | funding_form.id
operation_funding_form_id_operation_fkey | operation_funding_form.id_operation | operation.id
operation_intervention_category_intervention_category | operation_intervention_category.id_intervention_category | intervention_category.id
operation_intervention_category_operation | operation_intervention_category.id_operation | operation.id
operation_legal_base_legal_base | operation_legal_base.id_legal_base | legal_base.id
operation_legal_base_operation | operation_legal_base.id_operation | operation.id
operation_priority_axis | operation.id_priority_axis | priority_axis.id
operation_type_of_applicant_operation | operation_type_of_applicant.id_operation | operation.id
operation_type_of_applicant_type_of_applicant | operation_type_of_applicant.id_type_of_applicant | type_of_applicant.id
operation_type_of_project_operation | operation_type_of_project.id_operation | operation.id
operation_type_of_project_type_of_project | operation_type_of_project.id_type_of_project | type_of_project.id
person_correspondence_address | person.id_correspondence_address | address.id
person_registration_address | person.id_registration_address | address.id
prerequisite_of_public_assistance_public_assistance | prerequisite_of_public_assistance.id_public_assistance | public_assistance.id
project_application_form | project.id_form | application_form.id
project_decription_area_type | project_description.id_area_type | area_type.id
project_description | project_description.id_form | application_form.id
project_description_id_fk | project_location.id_project_description | project_description.id
project_id_economy_sector_fkey | project.id_economy_sector | economy_sector.id
project_id_funding_form_fkey | project.id_funding_form | funding_form.id
project_intervention_category | project.id_intervention_category | intervention_category.id
project_operation | project.id_operation | operation.id
project_priority_axis | project.id_priority_axis | priority_axis.id
project_suboperation | project.id_suboperation | suboperation.id
project_type_of_project | project.id_type | type_of_project.id
public_assistance_legal_base | public_assistance.id_legal_base | legal_base.id
public_assistance_legal_base_auto | public_assistance.id_legal_base_auto | legal_base.id
public_assistance_legal_base_cross_finance | public_assistance.id_legal_base_cross_finance | legal_base.id
public_assistance_project | public_assistance.id_project | project.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
subject_partner_person | subject_partner.id_person | person.id
subject_partner_subject | subject_partner.id_subject | subject.id
subject_subject_description_before_next_to_last | subject.id_info_before_next_to_last_period | subject_description.id
subject_subject_description_next_to_last | subject.id_info_next_to_last_period | subject_description.id
subject_subject_descrition_last | subject.id_info_last_period | subject_description.id
suboperation_area_type_area_type | suboperation_area_type.id_area_type | area_type.id
suboperation_area_type_suboperation | suboperation_area_type.id_suboperation | suboperation.id
suboperation_field_configuration_field_configuration | suboperation_field_configuration.id_field_configuration | field_configuration.id
suboperation_field_configuration_suboperation | suboperation_field_configuration.id_suboperation | suboperation.id
suboperation_funding_form_id_funding_form_fkey | suboperation_funding_form.id_funding_form | funding_form.id
suboperation_funding_form_id_suboperation_fkey | suboperation_funding_form.id_suboperation | suboperation.id
suboperation_intervention_category_intervention_category | suboperation_intervention_category.id_intervention_category | intervention_category.id
suboperation_intervention_category_suboperation | suboperation_intervention_category.id_suboperation | suboperation.id
suboperation_legal_base_legal_base | suboperation_legal_base.id_legal_base | legal_base.id
suboperation_legal_base_suboperation | suboperation_legal_base.id_suboperation | suboperation.id
suboperation_operation | suboperation.id_operation | operation.id
suboperation_type_of_applicant_suboperation | suboperation_type_of_applicant.id_suboperation | suboperation.id
suboperation_type_of_applicant_type_of_applicant | suboperation_type_of_applicant.id_type_of_applicant | type_of_applicant.id
suboperation_type_of_project_suboperation | suboperation_type_of_project.id_suboperation | suboperation.id
suboperation_type_of_project_type_of_project | suboperation_type_of_project.id_type_of_project | type_of_project.id
task_financial_installment | task.id_financial_installment | financial_installment.id
user_correspondence_address | user_registration.id_correspondence_address | address.id
user_registration | user_registration_message.id_user_registration | user_registration.id
user_resident_address | user_registration.id_resident_address | address.id
user_version_user | user_application_form.id_user | user_registration.id
version_application_form_application_form | version_application_form.id_form | application_form.id
version_application_form_parent | version_application_form.id_version_application_form | version_application_form.id

Check Constraints:

Table | Constraint Name | Constraint
--- | --- | ---
None detected