SchemaSpy Analysis of frontend.public - Constraints Generated by
SchemaSpy
168 Foreign Key Constraints:
SourceForge.net

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