Tables Relationships Utility Tables Constraints Anomalies Columns Donate

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

Generated by SchemaSpy on Wed Nov 26 19:04 CET 2008 |
Legend: |
Primary key columns
Columns with indexes
Related columns Constraint names Comments Legend

frontend.public contains 852 columns - click on heading to sort:

Table | Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
address | id | serial | 10 |  | √ | nextval('address_id_seq'::regclass) |
applicant.id_correspondence_address | id_correspondence_address_fk
applicant.id_registration_address | id_registration_address_fk
person.id_correspondence_address | person_correspondence_address
person.id_registration_address | person_registration_address
user_registration.id_correspondence_address | user_correspondence_address
user_registration.id_resident_address | user_resident_address
|  | Identyfikator
aggregate_value | id | serial | 10 |  | √ | nextval('aggregate_value_id_seq'::regclass) |  |  | Identyfikator
annex | id | serial | 10 |  | √ | nextval('annex_id_seq'::regclass) |
form_annex.id_annex | form_annex_annex
|  | Identyfikator
applicant | id | serial | 10 |  | √ | nextval('applicant_id_seq'::regclass) |
applicant_nip.id_applicant | applicant_fk
applicant_person_agreement.id_applicant | applicant_person_agreement_applicant
applicant_person_contact.id_applicant | applicant_person_contact_applicant
application_form_info.id_applicant | applicant_fk
assistance_de_minimis.id_applicant | assistance_de_minimis_applicant
|  | Identyfikator
applicant_nip | id | serial | 10 |  | √ | nextval('applicant_nip_id_seq'::regclass) |  |  | Identyfikator
applicant_person_agreement | id | serial | 10 |  | √ | nextval('applicant_person_agreement_id_seq'::regclass) |  |  | Identyfikator
applicant_person_contact | id | serial | 10 |  | √ | nextval('applicant_person_contact_id_seq'::regclass) |  |  | Identyfikator
application_form | id | serial | 10 |  | √ | nextval('application_form_id_seq'::regclass) |
applicant.id_form | application_form_fk
applicant.id_form_another_project | applicant_form_another_project
evaluation.id_form | evaluation_application
financial_installment.id_form | financial_installment_application_form
form_annex.id_form | form_annex_application
form_statement.id_form | form_statement_application
project.id_form | project_application_form
project_description.id_form | project_description
user_application_form.id_application_form | current_version_application_form
version_application_form.id_form | version_application_form_application_form
|  | Identyfikator
application_form_info | id | serial | 10 |  | √ | nextval('application_form_info_id_seq'::regclass) |  |  | Identyfikator
area_type | id | serial | 10 |  | √ | nextval('area_type_id_seq'::regclass) |
operation_area_type.id_area_type | operation_area_type_area_type
project_description.id_area_type | project_decription_area_type
suboperation_area_type.id_area_type | suboperation_area_type_area_type
|  | Identyfikator
assistance_de_minimis | id | serial | 10 |  | √ | nextval('assistance_de_minimis_id_seq'::regclass) |  |  | Identyfikator
city | id | serial | 10 |  | √ | nextval('city_id_seq'::regclass) |
address.id_city | address_city
project_location.id_city | id_city_fk
|  | Identyfikator
co_financing_amount | id | serial | 10 |  | √ | nextval('co_financing_amount_id_seq'::regclass) |  |  | Identyfikator
co_financing_key_result | id | serial | 10 |  | √ | nextval('co_financing_key_result_id_seq'::regclass) |  |  | Identyfikator
commune | id | serial | 10 |  | √ | nextval('commune_id_seq'::regclass) |
address.id_commune | address_commune
project_location.id_commune | commune_id_fk
|  | Identyfikator
contest_info | id | serial | 10 |  | √ | nextval('contest_info_id_seq'::regclass) |  |  | Identyfikator
description_of_public_procurement | id | serial | 10 |  | √ | nextval('description_of_public_procurement_id_seq'::regclass) |  |  | Identyfikator
district | id | serial | 10 |  | √ | nextval('district_id_seq'::regclass) |
address.id_district | address_district
commune.id_district | commune_district
project_location.id_district | district_id_fk
|  | Identyfikator
economy_sector | id | serial | 10 |  | √ | nextval('economy_sector_id_seq'::regclass) |
project.id_economy_sector | project_id_economy_sector_fkey
|  | Identyfikator
evaluation | id | serial | 10 |  | √ | nextval('evaluation_id_seq'::regclass) |  |  | Identyfikator
execution_audit | id | serial | 10 |  | √ | nextval('execution_audit_id_seq'::regclass) |  |  | Identyfikator
expense | id | serial | 10 |  | √ | nextval('expense_id_seq'::regclass) |
expense_year.id_expense | expense_value_expense
|  | Identyfikator
expense_year | id | serial | 10 |  | √ | nextval('expense_year_id_seq'::regclass) |  |  | Identyfikator
field_configuration | id | serial | 10 |  | √ | nextval('field_configuration_id_seq'::regclass) |
operation_field_configuration.id_field_configuration | operation_field_configuration_field_configuration
suboperation_field_configuration.id_field_configuration | suboperation_field_configuration_field_configuration
|  | Identyfikator
financial_installment | id | serial | 10 |  | √ | nextval('financial_installment_id_seq'::regclass) |
aggregate_value.id_financial_installment | aggregate_value_financial_installment
co_financing_amount.id_financial_installment | co_financing_amount_financial_installment
financing_source.id_financial_installment | financing_source_financial_installment
task.id_financial_installment | task_financial_installment
|  | Identyfikator
financing_source | id | serial | 10 |  | √ | nextval('financing_source_id_seq'::regclass) |  |  | Identyfikator
folder | id | serial | 10 |  | √ | nextval('folder_id_seq'::regclass) |
application_form.id_folder | application_folder
message.id_folder | message_folder
note.id_folder | note_folder
|  | Identyfikator
form_annex | id | serial | 10 |  | √ | nextval('form_annex_id_seq'::regclass) |  |  | Identyfikator
form_statement | id | serial | 10 |  | √ | nextval('form_statement_id_seq'::regclass) |  |  | Identyfikator
funding_form | id | serial | 10 |  | √ | nextval('funding_form_id_seq'::regclass) |
operation_funding_form.id_funding_form | operation_funding_form_id_funding_form_fkey
project.id_funding_form | project_id_funding_form_fkey
suboperation_funding_form.id_funding_form | suboperation_funding_form_id_funding_form_fkey
|  | Identyfikator
historical_beneficiary_status | id | bigserial | 19 |  | √ | nextval('historical_beneficiary_status_id_seq'::regclass) |  |  | Identyfikator
indicator_description | id | serial | 10 |  | √ | nextval('indicator_description_id_seq'::regclass) |
co_financing_key_result.id_indicator_description | key_description
indicator_type_key.id_indicator_description | id_indicator_type_key_description
indicator_type_product.id_indicator_description | id_indicator_type_product_description
indicator_type_realisation.id_indicator_description | id_indicator_type_realisation_description
indicator_type_result.id_indicator_description | id_indicator_type_result_description
pay_product_realization_indicator.id_indicator_description | fk8b5d916f7f288d99
pay_result_realization_indicator.id_indicator_description | fk8fd6c7ab7f288d99
|  | Identyfikator
indicator_type_key | id | serial | 10 |  | √ | nextval('indicator_type_key_id_seq'::regclass) |
indicator_type_key_year_value.id_indicator | indicator_type_key_year_value_indicator
|  | Identyfikator
indicator_type_key_year_value | id | serial | 10 |  | √ | nextval('indicator_type_key_year_value_id_seq'::regclass) |  |  | Identyfikator
indicator_type_product | id | serial | 10 |  | √ | nextval('indicator_type_product_id_seq'::regclass) |
indicator_type_product_year_value.id_indicator | indicator_type_product_year_value_indicator
|  | Identyfikator
indicator_type_product_year_value | id | serial | 10 |  | √ | nextval('indicator_type_product_year_value_id_seq'::regclass) |  |  | Identyfikator
indicator_type_realisation | id | serial | 10 |  | √ | nextval('indicator_type_realisation_id_seq'::regclass) |
indicator_type_realisation_year_value.id_indicator | indicator_type_realisation_year_value_indicator
|  | Identyfikator
indicator_type_realisation_year_value | id | serial | 10 |  | √ | nextval('indicator_type_realisation_year_value_id_seq'::regclass) |  |  | Identyfikator
indicator_type_result | id | serial | 10 |  | √ | nextval('indicator_type_result_id_seq'::regclass) |
indicator_type_result_year_value.id_indicator | indicator_type_result_year_value_indicator
|  | Identyfikator
indicator_type_result_year_value | id | serial | 10 |  | √ | nextval('indicator_type_result_year_value_id_seq'::regclass) |  |  | Identyfikator
intervention_category | id | serial | 10 |  | √ | nextval('intervention_category_id_seq'::regclass) |
operation_intervention_category.id_intervention_category | operation_intervention_category_intervention_category
project.id_intervention_category | project_intervention_category
suboperation_intervention_category.id_intervention_category | suboperation_intervention_category_intervention_category
|  | Identyfikator
ksi_legal_form | id | serial | 10 |  | √ | nextval('ksi_legal_form_id_seq'::regclass) |  |  | Identyfikator
legal_base | id | serial | 10 |  | √ | nextval('legal_base_id_seq'::regclass) |
operation_legal_base.id_legal_base | operation_legal_base_legal_base
public_assistance.id_legal_base | public_assistance_legal_base
public_assistance.id_legal_base_auto | public_assistance_legal_base_auto
public_assistance.id_legal_base_cross_finance | public_assistance_legal_base_cross_finance
suboperation_legal_base.id_legal_base | suboperation_legal_base_legal_base
|  | Identyfikator
legal_form | id | serial | 10 |  | √ | nextval('legal_form_id_seq'::regclass) |
applicant.id_legal_form | id_legal_form_fk
|  | Identyfikator
message | id | serial | 10 |  | √ | nextval('message_id_seq'::regclass) |
user_registration_message.id_message | message
|  | Identyfikator
note | id | serial | 10 |  | √ | nextval('note_id_seq'::regclass) |  |  | Identyfikator
operation | id | serial | 10 |  | √ | nextval('operation_id_seq'::regclass) |
indicator_description.id_operation | fka3b201cc4434bc24
operation_area_type.id_operation | operation_area_type_operation
operation_field_configuration.id_operation | operation_field_configuration_operation
operation_funding_form.id_operation | operation_funding_form_id_operation_fkey
operation_intervention_category.id_operation | operation_intervention_category_operation
operation_legal_base.id_operation | operation_legal_base_operation
operation_type_of_applicant.id_operation | operation_type_of_applicant_operation
operation_type_of_project.id_operation | operation_type_of_project_operation
project.id_operation | project_operation
suboperation.id_operation | suboperation_operation
|  | Identyfikator
operation_area_type | id | serial | 10 |  | √ | nextval('operation_area_type_id_seq'::regclass) |  |  | Identyfikator
operation_field_configuration | id | serial | 10 |  | √ | nextval('operation_field_configuration_id_seq'::regclass) |  |  | Identyfikator
operation_funding_form | id | serial | 10 |  | √ | nextval('operation_funding_form_id_seq'::regclass) |  |  | Identyfikator
operation_intervention_category | id | serial | 10 |  | √ | nextval('operation_intervention_category_id_seq'::regclass) |  |  | Identyfikator
operation_legal_base | id | serial | 10 |  | √ | nextval('operation_legal_base_id_seq'::regclass) |  |  | Identyfikator
operation_type_of_applicant | id | serial | 10 |  | √ | nextval('operation_type_of_applicant_id_seq'::regclass) |  |  | Identyfikator
operation_type_of_project | id | serial | 10 |  | √ | nextval('operation_type_of_project_id_seq'::regclass) |  |  | Identyfikator
page_skin | id | serial | 10 |  | √ | nextval('page_skin_id_seq'::regclass) |  |  | Identyfikator
pay_attachments_and_statements | id | bigserial | 19 |  | √ | nextval('pay_attachments_and_statements_id_seq'::regclass) |
pay_payment_attachment.attachments_and_statements_id | fkbfdf61f39abcac33
pay_payment_form.attachments_and_statements_id | fke2c2f1949abcac33
|  | Identyfikator
pay_beneficiary_information | id | bigserial | 19 |  | √ | nextval('pay_beneficiary_information_id_seq'::regclass) |
pay_payment_form.beneficiary_information_id | fke2c2f194266da59f
|  | Identyfikator
pay_expense | id | bigserial | 19 |  | √ | nextval('pay_expense_id_seq'::regclass) |
pay_period.expense_id | fk8dd13538ce0d0bcc
|  | Identyfikator
pay_expense_combination | id | bigserial | 19 |  | √ | nextval('pay_expense_combination_id_seq'::regclass) |
pay_payment_form.expense_combination | fke2c2f1941eb3f86d
pay_period_definition.expense_combination_id | fkd00f62ba2b445657
pay_task.expense_combination_id | fk51ab66bc2b445657
|  | Identyfikator
pay_financing_entry | id | bigserial | 19 |  | √ | nextval('pay_financing_entry_id_seq'::regclass) |  |  | Identyfikator
pay_financing_information | id | bigserial | 19 |  | √ | nextval('pay_financing_information_id_seq'::regclass) |
pay_financing_entry.financing_information_id | fkf93cd2b3a478705a
pay_payment_form.financing_information_id | fke2c2f194a478705a
|  | Identyfikator
pay_help | id | serial | 10 |  | √ | nextval('pay_help_id_seq'::regclass) |  |  | Identyfikator
pay_historical_payment_beneficiary_status | id | bigserial | 19 |  | √ | nextval('pay_historical_payment_beneficiary_status_id_seq'::regclass) |  |  | Identyfikator
pay_income | id | bigserial | 19 |  | √ | nextval('pay_income_id_seq'::regclass) |
pay_income_entry.income_id | fka63174935226cea7
pay_payment_form.income_id | fke2c2f1945226cea7
|  | Identyfikator
pay_income_entry | id | bigserial | 19 |  | √ | nextval('pay_income_entry_id_seq'::regclass) |  |  | Identyfikator dochodu
pay_invoice | id | bigserial | 19 |  | √ | nextval('pay_invoice_id_seq'::regclass) |  |  | Identyfikator
pay_material_financial_phase | id | bigserial | 19 |  | √ | nextval('pay_material_financial_phase_id_seq'::regclass) |  |  | Identyfikator
pay_material_financial_progress | id | bigserial | 19 |  | √ | nextval('pay_material_financial_progress_id_seq'::regclass) |
pay_material_financial_phase.material_financial_progress_id | fk80e2fae475df8a22
pay_payment_form.material_financial_progress_id | fke2c2f19475df8a22
|  | Identyfikator
pay_material_financial_target | id | bigserial | 19 |  | √ | nextval('pay_material_financial_target_id_seq'::regclass) |
pay_material_financial_progress.apartment_target_id | fkd62aec2454890423
pay_material_financial_progress.cross_financing_target_id | fkd62aec24e2297649
pay_material_financial_progress.ground_target_id | fkd62aec24cf6f6038
pay_material_financial_progress.lump_sum_target_id | fkd62aec24a754c1e9
|  | Identyfikator
pay_payment_attachment | id | bigserial | 19 |  | √ | nextval('pay_payment_attachment_id_seq'::regclass) |  |  | Identyfikator
pay_payment_form | id | bigserial | 19 |  | √ | nextval('pay_payment_form_id_seq'::regclass) |
pay_historical_payment_beneficiary_status.payment_form_id | fk923153a372c76184
pay_product_realization_indicator.payment_form_id | fk8b5d916f72c76184
pay_result_realization_indicator.payment_form_id | fk8fd6c7ab72c76184
pay_schedule_entry.payment_form_id | fka1ebc94172c76184
|  | Identyfikator
pay_period | id | bigserial | 19 |  | √ | nextval('pay_period_id_seq'::regclass) |
pay_invoice.period_id | fkc9a072966c100ac8
|  | Identyfikator
pay_period_definition | id | bigserial | 19 |  | √ | nextval('pay_period_definition_id_seq'::regclass) |
pay_period.period_definition_id | fk8dd13538a5e9feab
|  | Identyfikator
pay_person_info | id | bigserial | 19 |  | √ | nextval('pay_person_info_id_seq'::regclass) |
pay_beneficiary_information.beneficiary_person_id | fk1e0183b1c5e1a66
pay_beneficiary_information.financial_person_id | fk1e0183bf795030a
pay_beneficiary_information.realization_person_id | fk1e0183bb8f16b47
|  | Identyfikator
pay_product_realization_indicator | id | bigserial | 19 |  | √ | nextval('pay_product_realization_indicator_id_seq'::regclass) |  |  | Identyfikator
pay_project_information | id | bigserial | 19 |  | √ | nextval('pay_project_information_id_seq'::regclass) |
pay_payment_form.project_information_id | fke2c2f19495de1e37
|  | Identyfikator
pay_realization_progress | id | bigserial | 19 |  | √ | nextval('pay_realization_progress_id_seq'::regclass) |
pay_payment_form.realization_progress_id | fke2c2f19462ef1d1b
|  | Identyfikator
pay_realization_progress_entry | id | bigserial | 19 |  | √ | nextval('pay_realization_progress_entry_id_seq'::regclass) |
pay_realization_progress.built_real_state_expense_id | fke4c8207dee2de9b
pay_realization_progress.group_1_expense_id | fke4c8207d5aefab3b
pay_realization_progress.material_expense_id | fke4c8207d8b0576c5
pay_realization_progress.unbuilt_real_estate_expense_id | fke4c8207d480c6919
|  | Identyfikator
pay_result_realization_indicator | id | bigserial | 19 |  | √ | nextval('pay_result_realization_indicator_id_seq'::regclass) |  |  | Identyfikator
pay_schedule_entry | id | bigserial | 19 |  | √ | nextval('pay_schedule_entry_id_seq'::regclass) |
pay_schedule_quarter_amount.schedule_entry_id | fkd9b8495c47da0d61
|  | Identyfikator
pay_schedule_quarter_amount | id | bigserial | 19 |  | √ | nextval('pay_schedule_quarter_amount_id_seq'::regclass) |  |  | Identyfikator
pay_task | id | bigserial | 19 |  | √ | nextval('pay_task_id_seq'::regclass) |
pay_expense.task_id | fk6bef7c1ef5017c8
|  | Identyfikator
person | id | serial | 10 |  | √ | nextval('person_id_seq'::regclass) |
applicant_person_agreement.id_person | applicant_person_agreement_person
applicant_person_contact.id_person | applicant_person_contact_person
subject_partner.id_person | subject_partner_person
|  | Identyfikator
prerequisite_of_public_assistance | id | serial | 10 |  | √ | nextval('prerequisite_of_public_assistance_id_seq'::regclass) |  |  | Identyfikator
priority_axis | id | serial | 10 |  | √ | nextval('priority_axis_id_seq'::regclass) |
operation.id_priority_axis | operation_priority_axis
project.id_priority_axis | project_priority_axis
|  | Identyfikator
project | id | serial | 10 |  | √ | nextval('project_id_seq'::regclass) |
public_assistance.id_project | public_assistance_project
|  | Identyfikator
project_description | id | serial | 10 |  | √ | nextval('project_description_id_seq'::regclass) |
co_financing_key_result.id_project_description | key_results_co_finance_project_description
description_of_public_procurement.id_project_description | description_of_public_procurement
indicator_type_key.id_project_description | indicator_type_key_description
indicator_type_product.id_project_description | indicator_type_project_description
indicator_type_realisation.id_project_description | indicator_type_realisation_description
indicator_type_result.id_project_description | indicator_type_result_description
project_location.id_project_description | project_description_id_fk
|  | Identyfikator
project_location | id | serial | 10 |  | √ | nextval('project_location_id_seq'::regclass) |  |  | Identyfikator
province | id | serial | 10 |  | √ | nextval('province_id_seq'::regclass) |
address.id_province | address_province
|  | Identyfikator
public_assistance | id | serial | 10 |  | √ | nextval('public_assistance_id_seq'::regclass) |
prerequisite_of_public_assistance.id_public_assistance | prerequisite_of_public_assistance_public_assistance
|  | Identyfikator
ranking_list | id | serial | 10 |  | √ | nextval('ranking_list_id_seq'::regclass) |
evaluation.id_ranking_list | evaluation_LISTA_WIARYGODNOSCI
|  | Identyfikator
report | id | serial | 10 |  | √ | nextval('report_id_seq'::regclass) |
pay_payment_form.id_report | fke2c2f194200c2ce5
|  | Identyfikator
sec_operator | id | serial | 10 |  | √ | nextval('sec_operator_id_seq'::regclass) |
sec_operator_role.id_user | sec_operator_role_sec_operator
|  | Identyfikator
sec_operator_role | id | serial | 10 |  | √ | nextval('sec_operator_role_id_seq'::regclass) |  |  | Identyfikator
sec_permission | id | serial | 10 |  | √ | nextval('sec_permission_id_seq'::regclass) |
sec_permission_def.id_permission | sec_permission_def_sec_permission
|  | Identyfikator
sec_permission_def | id | serial | 10 |  | √ | nextval('sec_permission_def_id_seq'::regclass) |  |  | Identyfikator
sec_role | id | serial | 10 |  | √ | nextval('sec_role_id_seq'::regclass) |
sec_operator_role.id_role | sec_operator_role_sec_role
sec_permission_def.id_role | sec_permission_def_sec_role
sec_role.id_role_parent | sec_role_sec_role
|  | Identyfikator
sec_system | id | serial | 10 |  | √ | nextval('sec_system_id_seq'::regclass) |
sec_permission.id_system | sec_permission_sec_system
sec_role.id_system | sec_role_sec_system
|  | Identyfikator
statement | id | serial | 10 |  | √ | nextval('statement_id_seq'::regclass) |
form_statement.id_statement | form_statement_statement
|  | Identyfikator
subject | id | serial | 10 |  | √ | nextval('subject_id_seq'::regclass) |
applicant.id_subject | applicant_subject
subject_partner.id_subject | subject_partner_subject
|  | Identyfikator
subject_description | id | serial | 10 |  | √ | nextval('subject_description_id_seq'::regclass) |
subject.id_info_before_next_to_last_period | subject_subject_description_before_next_to_last
subject.id_info_last_period | subject_subject_descrition_last
subject.id_info_next_to_last_period | subject_subject_description_next_to_last
|  | Identyfikator
subject_partner | id | serial | 10 |  | √ | nextval('subject_partner_id_seq'::regclass) |  |  | Identyfikator
suboperation | id | serial | 10 |  | √ | nextval('suboperation_id_seq'::regclass) |
indicator_description.id_suboperation | fka3b201cc2698a538
project.id_suboperation | project_suboperation
suboperation_area_type.id_suboperation | suboperation_area_type_suboperation
suboperation_field_configuration.id_suboperation | suboperation_field_configuration_suboperation
suboperation_funding_form.id_suboperation | suboperation_funding_form_id_suboperation_fkey
suboperation_intervention_category.id_suboperation | suboperation_intervention_category_suboperation
suboperation_legal_base.id_suboperation | suboperation_legal_base_suboperation
suboperation_type_of_applicant.id_suboperation | suboperation_type_of_applicant_suboperation
suboperation_type_of_project.id_suboperation | suboperation_type_of_project_suboperation
|  | Identyfikator
suboperation_area_type | id | serial | 10 |  | √ | nextval('suboperation_area_type_id_seq'::regclass) |  |  | Identyfikator
suboperation_field_configuration | id | serial | 10 |  | √ | nextval('suboperation_field_configuration_id_seq'::regclass) |  |  | Identyfikator
suboperation_funding_form | id | serial | 10 |  | √ | nextval('suboperation_funding_form_id_seq'::regclass) |  |  | Identyfikator
suboperation_intervention_category | id | serial | 10 |  | √ | nextval('suboperation_intervention_category_id_seq'::regclass) |  |  | Identyfikator
suboperation_legal_base | id | serial | 10 |  | √ | nextval('suboperation_legal_base_id_seq'::regclass) |  |  | Identyfikator
suboperation_type_of_applicant | id | serial | 10 |  | √ | nextval('suboperation_type_of_applicant_id_seq'::regclass) |  |  | Identyfikator
suboperation_type_of_project | id | serial | 10 |  | √ | nextval('suboperation_type_of_project_id_seq'::regclass) |  |  | Identyfikator
task | id | serial | 10 |  | √ | nextval('task_id_seq'::regclass) |
expense.id_task | expense_task
task_aggregate_value.id_task | id_task_fk
|  | Identyfikator
task_aggregate_value | id | serial | 10 |  | √ | nextval('task_aggregate_value_id_seq'::regclass) |  |  | Identyfikator
type_of_applicant | id | serial | 10 |  | √ | nextval('type_of_applicant_id_seq'::regclass) |
applicant.id_type_of_applicant | applicant_type_of_applicant
operation_type_of_applicant.id_type_of_applicant | operation_type_of_applicant_type_of_applicant
suboperation_type_of_applicant.id_type_of_applicant | suboperation_type_of_applicant_type_of_applicant
|  | Identyfikator
type_of_project | id | serial | 10 |  | √ | nextval('type_of_project_id_seq'::regclass) |
operation_type_of_project.id_type_of_project | operation_type_of_project_type_of_project
project.id_type | project_type_of_project
suboperation_type_of_project.id_type_of_project | suboperation_type_of_project_type_of_project
|  | Identyfikator
type_of_record | id | serial | 10 |  | √ | nextval('type_of_record_id_seq'::regclass) |
applicant.id_type_of_record | id_type_of_record_fk
|  | Identyfikator
user_application_form | id | serial | 10 |  | √ | nextval('user_application_form_id_seq'::regclass) |
application_form.id_user_application_form | application_form_history
|  | Identyfikator
user_registration | id | serial | 10 |  | √ | nextval('user_registration_id_seq'::regclass) |
application_form.id_user | application_form_owner
folder.id_user | folder_user
user_application_form.id_user | user_version_user
user_registration_message.id_user_registration | user_registration
|  | Identyfikator
user_registration_message | id | serial | 10 |  | √ | nextval('user_registration_message_id_seq'::regclass) |  |  | Identyfikator
version_application_form | id | serial | 10 |  | √ | nextval('version_application_form_id_seq'::regclass) |
version_application_form.id_version_application_form | version_application_form_parent
|  | Identyfikator
user_registration | account_name | varchar | 200 | √ |  | null |  |  | Nazwa
pay_attachments_and_statements | accounts_documents_copy | int4 | 10 | √ |  | null |  |  | Potwierdzone za zgodność z oryginałem kopie faktur lub dokumentów księgowych i podobnej wartości dowodowej (H.1)
sec_operator | activation_code | varchar | 16 | √ |  | null |  |  | Kod aktywacji przez e-mail
annex | active | bool | 1 | √ |  | null |  |  | Aktywny - nieaktywny
area_type | active | bool | 1 | √ |  | null |  |  | Aktywny - nieaktywny
city | active | bool | 1 | √ |  | true |  |  | Aktywny - nieaktywny
commune | active | bool | 1 | √ |  | true |  |  | Aktywny - nieaktywny
district | active | bool | 1 | √ |  | true |  |  | Aktywny - nieaktywny
economy_sector | active | bool | 1 |  |  | true |  |  | Aktywny - nieaktywny
field_configuration | active | bool | 1 |  |  | false |  |  | Aktywny - nieaktywny
folder | active | bool | 1 | √ |  | true |  |  | Aktywny - nieaktywny
funding_form | active | bool | 1 |  |  | true |  |  | Aktywny - nieaktywny
indicator_description | active | bool | 1 | √ |  | null |  |  | Aktywny - nieaktywny
intervention_category | active | bool | 1 | √ |  | true |  |  | Aktywny - nieaktywny
legal_base | active | bool | 1 | √ |  | true |  |  | Aktywny - nieaktywny
legal_form | active | bool | 1 |  |  | true |  |  | Aktywny - nieaktywny
operation | active | bool | 1 | √ |  | true |  |  | Aktywny - nieaktywny
pay_help | active | bool | 1 | √ |  | null |  |  | Aktywna/nieaktywna
priority_axis | active | bool | 1 | √ |  | true |  |  | Aktywny - nieaktywny
province | active | bool | 1 | √ |  | true |  |  | Aktywny - nieaktywny
sec_permission_def | active | numeric | 1 | √ |  | null |  |  | Czy aktywne
statement | active | bool | 1 | √ |  | null |  |  | Aktywny - nieaktywny
subject_description | active | bool | 1 | √ |  | null |  |  | Aktywny - nieaktywny
suboperation | active | bool | 1 | √ |  | true |  |  | Aktywny - nieaktywny
type_of_applicant | active | bool | 1 | √ |  | true |  |  | Aktywny - nieaktywny
type_of_project | active | bool | 1 | √ |  | true |  |  | Aktywny - nieaktywny
type_of_record | active | bool | 1 | √ |  | true |  |  | Aktywny - nieaktywny
user_registration_message | active | bool | 1 | √ |  | true |  |  | Czy aktywne
project | agglomeration_under_15k_pe | bool | 1 | √ |  | null |  |  | Aglomeracja poniżej 15 tys. populacji - sekcja A.16
aggregate_value | aggregate_value | numeric | 15,2 | √ |  | null |  |  | Całkowita wartość
task_aggregate_value | aggregate_value | numeric | 15,2 | √ |  | null |  |  | Wartość
financing_source | aggregated_sum | numeric | 15,2 | √ |  | null |  |  |
financing_source | aggregated_sum_efi_amount | numeric | 15,2 | √ |  | null |  |  |
project_description | alternative_realization | varchar | 3072 | √ |  | null |  |  | Alternatywna realizacja - sekcja C.5
pay_schedule_quarter_amount | amount | numeric | 15,2 |  |  |  |  |  | Planowane wydatki kwalifikowane / Planowana kwota wnioskowana
project_description | amount_aard_2007_2013 | bool | 1 | √ |  | null |  |  | Kwota PROW 2007-2013 - sekcja C.4
project_description | amount_aard_2007_2013_value | numeric | 15,2 | √ |  | null |  |  | Kwota PROW 2007-2013 - wartość - sekcja C.4
subject_description | amount_of_assets_keur | numeric | 15,2 | √ |  | null |  |  | Suma aktywów (w tysiącach euro)
pay_material_financial_progress | apartment_target_id | int8 | 19 | √ |  | null |  |
pay_material_financial_target.id | fkd62aec2454890423
| Identyfikator wydatków poniesionych na mieszkalnictwo
subject | applicable | bool | 1 | √ |  | null |  |  |
application_form | applicant_name | varchar | 500 | √ |  | null |  |  | Nazwa wnioskodawcy
pay_payment_form | applicant_name | varchar | 500 | √ |  | null |  |  | Nazwa wnioskodawcy
historical_beneficiary_status | application_form_id | int4 | 10 |  |  |  |  |  | Identyfikator formularza aplikacyjnego
pay_payment_form | application_form_id | int4 | 10 |  |  |  |  |  | Identyfikator powiązanego wniosku aplikacyjnego
user_application_form | application_form_name | varchar | 200 | √ |  | null |  |  | Nazwa
project | applied_cross_financing | bool | 1 | √ |  | null |  |  | Zastosowany cross-finansing - sekcja A.6
project | apply_over_150k_people | bool | 1 | √ |  | false |  |  | Dotyczy powyżej 150tys. ludzi - sekcja A.17
project | assistance_another_amount | bool | 1 | √ |  | null |  |  | Pomoc - inna kwota - sekcja A.9
project | assistance_another_amount_value | numeric | 15,2 | √ |  | null |  |  | Pomoc - inna kwota - wartość - sekcja A.9
assistance_de_minimis | assistance_date | date | 13 | √ |  | null |  |  | Data udzielenia pomocy
applicant | assistance_de_minimis | bool | 1 | √ |  | null |  |  | Pomoc de minimis - sekcja B.11
applicant | assistance_de_minimis_amount | numeric | 15,2 | √ |  | null |  |  | Pomoc - de minimis - suma
applicant | assistance_new_workplaces | bool | 1 | √ |  | null |  |  | Pomoc - nowe miejsca pracy - sekcja B.12
applicant | assistance_new_workplaces_amount | numeric | 15,2 | √ |  | null |  |  | Pomoc - nowe miejsca pracy - kwota
applicant | assistance_new_workplaces_description | varchar | 2048 | √ |  | null |  |  | Pomoc - nowe miejsca pracy - opis - sekcja B.12
pay_realization_progress | assistance_qualified_expense | numeric | 15,2 | √ |  | null |  |  | Suma: całkowite wydatki kwalifikujące się do objęcia wsparciem (E.2)
pay_realization_progress_entry | assistance_qualified_expense | numeric | 15,2 | √ |  | null |  |  | Całkowite wydatki kwalifikujące się do objęcia wsparciem
assistance_de_minimis | assistance_value_euro | numeric | 15,2 | √ |  | null |  |  | Pomoc - wartość w euro
assistance_de_minimis | assistance_value_pln | numeric | 15,2 | √ |  | null |  |  | Pomoc - wartość w złotówkach
pay_payment_attachment | attachments_and_statements_id | int8 | 19 |  |  |  |  |
pay_attachments_and_statements.id | fkbfdf61f39abcac33
| Identyfikator załączników i oświadczeń
pay_payment_form | attachments_and_statements_id | int8 | 19 | √ |  | null |  |
pay_attachments_and_statements.id | fke2c2f1949abcac33
| Identyfikator załączników i oświadczeń
pay_product_realization_indicator | attained_compound_value | numeric | 18,3 | √ |  | null |  |  | Wartość wskaźnika osiągnieta od złożenia poprzedniego wniosku o płatnośc przez beneficjenta
pay_result_realization_indicator | attained_realization_end_value | numeric | 18,3 |  |  |  |  |  | Wartość wskaźnika osiągnieta w wyniku zrealizowania projektu
pay_product_realization_indicator | attained_realization_start_value | numeric | 18,3 | √ |  | null |  |  | Wartość wskaźnika osiągnieta od początku realizacji projektu
project | balanced_development_policy | bool | 1 | √ |  | null |  |  | Zasada zrównoważonego rozwoju - sekcja A.13
project | balanced_development_policy_justification | varchar | 2000 | √ |  | null |  |  | Zasada zrównoważonego rozwoju - uzasadnienie - sekcja A.13
pay_beneficiary_information | bank_account_number | varchar | 28 | √ |  | null |  |  | Numer konta bankowego (A.3)
pay_beneficiary_information | bank_account_owner | varchar | 200 | √ |  | null |  |  | Nazwa właściciela konta bankowego (A.3)
pay_attachments_and_statements | bank_documents_copy | int4 | 10 | √ |  | null |  |  | Oznaczone datą i potwierdzone za zgodność z oryginałem kopie wyciągów bankowych lub przelewów bankowych (H.1)
pay_beneficiary_information | bank_name | varchar | 100 | √ |  | null |  |  | Nazwa banku (A.3)
indicator_type_key | base_value | varchar | 40 | √ |  | null |  |  | Wartość bazowa
indicator_type_product | base_value | varchar | 40 | √ |  | null |  |  | Wartość bazowa
indicator_type_realisation | base_value | varchar | 40 | √ |  | null |  |  | Wartość bazowa
indicator_type_result | base_value | varchar | 40 | √ |  | null |  |  | Wartość bazowa
pay_product_realization_indicator | base_value | numeric | 18,3 |  |  |  |  |  | Wartość bazowa mierzona przed rozpoczęciem realizacji projektu
pay_result_realization_indicator | base_value | numeric | 18,3 |  |  |  |  |  | Wartość bazowa mierzona przed rozpoczęciem realizacji projektu
pay_payment_form | beneficiary_information_id | int8 | 19 | √ |  | null |  |
pay_beneficiary_information.id | fke2c2f194266da59f
| Identyfikator informacji o wnioskodawcy
pay_beneficiary_information | beneficiary_person_id | int8 | 19 | √ |  | null |  |
pay_person_info.id | fk1e0183b1c5e1a66
| Identyfikator danych beneficjenta (A.3)
pay_attachments_and_statements | beneficiary_statement | varchar | 500 | √ |  | null |  |  | Oświadczenie (H.2)
historical_beneficiary_status | beneficiary_status | int4 | 10 |  |  | 0 |  |  |
pay_financing_entry | brutto_amount | numeric | 17,2 | √ |  | null |  |  | kwota dokumnetu brutto (B.1)
pay_financing_information | brutto_sum | numeric | 17,2 |  |  |  |  |  | Kwota dokumnetu brutto suma ogółem w PLN (B.1)
financing_source | budget_dlsg_amount | numeric | 15,2 | √ |  | null |  |  | Budżet JST kwota
pay_realization_progress | built_real_state_expense_id | int8 | 19 | √ |  | null |  |
pay_realization_progress_entry.id | fke4c8207dee2de9b
| Identyfikator
execution_audit | category_type | int4 | 10 | √ |  | null |  |  |
project | certification_co_financing | bool | 1 | √ |  | null |  |  | Dofinansowanie certyfikacji - sekcja A.5
historical_beneficiary_status | change_date | timestamp | 29,6 |  |  |  |  |  | Data zmiany
pay_historical_payment_beneficiary_status | change_date | timestamp | 29,6 |  |  |  |  |  | Data zmiany statusu
sec_operator | change_date | timestamp | 29,6 | √ |  | null |  |  | Data zmiany
sec_operator_role | change_date | date | 13 | √ |  | null |  |  | Data zmiany
sec_permission | change_date | date | 13 | √ |  | null |  |  | Data zmiany
sec_permission_def | change_date | date | 13 | √ |  | null |  |  | Data zmiany
sec_role | change_date | date | 13 | √ |  | null |  |  | Data zmiany
sec_system | change_date | date | 13 | √ |  | null |  |  | Data zmiany
historical_beneficiary_status | changed_by | varchar | 200 |  |  |  |  |  | Osoba zmieniająca status
pay_historical_payment_beneficiary_status | changed_by | varchar | 255 | √ |  | null |  |  | Ostatnio modyfikowane przez
sec_operator | changed_by | varchar | 256 | √ |  | null |  |  | Ostatnio zmieniony przez
sec_operator_role | changed_by | varchar | 256 | √ |  | null |  |  | Zmieniono przez
sec_permission | changed_by | varchar | 256 | √ |  | null |  |  | Ostatnio zmieniony przez
sec_permission_def | changed_by | varchar | 256 | √ |  | null |  |  | Ostatnio zmieniony przez
sec_role | changed_by | varchar | 256 | √ |  | null |  |  | Zmieniono przez
sec_system | changed_by | varchar | 256 | √ |  | null |  |  | Zmieniono przez
application_form | checksum | varchar | 40 | √ |  | null |  |  | Suma kontrolna
pay_payment_form | checksum | varchar | 40 | √ |  | null |  |  | Suma kontrolna
form_annex | choice_type | int4 | 10 |  |  | 0 |  |  | Wybór
form_statement | choice_type | int4 | 10 |  |  | 0 |  |  | Wybór
co_financing_amount | choose_subtable | int4 | 10 | √ |  | null |  |  | Wybór podtabel - sekcja E.3(.1)
address | city | varchar | 100 | √ |  | null |  |  | Adres - miejscowość
pay_beneficiary_information | city | varchar | 100 | √ |  | null |  |  | Miasto (A.3)
project_location | city_code | varchar | 256 | √ |  | null |  |  | Miejscowość, kod pocztowy
project_description | co_financing_key_result_concerns | bool | 1 | √ |  | null |  |  | Wartość dofinansowania z RPO WZ przypadająca na kluczowe rezultaty - dotyczy/nie dotyczy - sekcja C.12
commune | code | varchar | 13 | √ |  | null |  |  | Kod
district | code | varchar | 8 | √ |  | null |  |  | Kod
province | code | varchar | 2 | √ |  | null |  |  | Kod
pay_project_information | cofinancing_amount | numeric | 15 | √ |  | null |  |  | Kwota dofinansowania (A.2)
pay_project_information | cofinancing_amount_inwords | varchar | 200 | √ |  | null |  |  | Kwota dofinansowania - słownie (A.2)
pay_project_information | cofinancing_date | timestamp | 29,6 | √ |  | null |  |  | Umowa/ decyzja z dnia (A.2)
pay_project_information | cofinancing_number | varchar | 30 | √ |  | null |  |  | Umowa/ decyzja o dofinansowaniu nr (A.2)
version_application_form | comment | varchar | 256 | √ |  | null |  |  | Komentarz
address | commune | varchar | 200 | √ |  | null |  |  | Adres - gmina
ksi_legal_form | company_type | int4 | 10 | √ |  | null |  |  | Typ firmy
subject | company_type | int4 | 10 |  |  | 0 |  |  | Typ przedsiębiorstwa
pay_financing_information | concerns_flag | bool | 1 | √ |  | null |  |  | Zestawienie dokumentów potwierdzających poniesienie wydatki objęte wnioskiem (B.1)
project_description | concerns_no | bool | 1 | √ |  | null |  |  | (Lokalizacja projektu) dotyczy/nie dotyczy - sekcja C.1
project | concerns_transport_operations | bool | 1 | √ |  | false |  |  | Czy projekt dotyczy działalności transportowej - sekcja A.10
pay_payment_form | conformity_community_policy | bool | 1 | √ |  | null |  |  | Czy projekt jest zgodny z zasadami polityk wspólnoty?
pay_payment_form | conformity_community_policy_explanation | varchar | 5000 | √ |  | null |  |  | Opis nieprawidłowości związanych z nieprzestrzeganiem polityk wspólnoty
project | constructive_completion_date | date | 13 | √ |  | null |  |  | Data rzeczowego zakończenia prac - sekcja A.11
message | content | varchar | 3000 | √ |  | null |  |  | Treść wiadomości
note | content | varchar | 500 | √ |  | null |  |  | Treść notatki
pay_help | content | varchar | 5000 |  |  |  |  |  | Treść
report | content | bytea | 2147483647 | √ |  | null |  |  | Treść raportu
statement | content | varchar | 1024 | √ |  | null |  |  | Treść oświadczenia
application_form | contest_number | varchar | 32 | √ |  | null |  |  | Numer konkursu - sekcja 0
contest_info | contest_number | varchar | 300 |  |  |  |  |  | Numer konkursu
pay_payment_form | contest_number | varchar | 32 | √ |  | null |  |  | Nazwa konkursu
contest_info | contest_operation | varchar | 200 | √ |  | null |  |  | Konkurs - działanie
contest_info | contest_suboperation | varchar | 200 |  |  |  |  |  | Konkurs - poddziałanie
pay_payment_form | correction_number | varchar | 20 | √ |  | null |  |  | Numer korekty
pay_payment_form | creation_date | timestamp | 29,6 | √ |  | null |  |  | Data utworzenia
version_application_form | creation_date | date | 13 | √ |  | null |  |  | Data utworzenia
pay_material_financial_progress | cross_financing_target_id | int8 | 19 | √ |  | null |  |
pay_material_financial_target.id | fkd62aec24e2297649
| Identyfikator wydatków związanych z cross-financing
page_skin | css_name | varchar | 256 | √ |  | null |  |  | Nazwa css
page_skin | current | bool | 1 | √ |  | null |  |  | Obecny
co_financing_amount | da | numeric | 15,2 | √ |  | null |  |  | Kwota decyzji - sekcja E.3(.1.1)
indicator_type_key | data_source | varchar | 256 | √ |  | null |  |  | Źródło danych
indicator_type_product | data_source | varchar | 256 | √ |  | null |  |  | Źródło danych
indicator_type_realisation | data_source | varchar | 256 | √ |  | null |  |  | Źródło danych
indicator_type_result | data_source | varchar | 256 | √ |  | null |  |  | Źródło danych
note | date | date | 13 | √ |  | null |  |  | Data
description_of_public_procurement | declaration_number | varchar | 30 | √ |  | null |  |  | Numer ogłoszenia
application_form | deletion_date | date | 13 | √ |  | null |  |  | Data usunięcia
version_application_form | deletion_date | date | 13 | √ |  | null |  |  | Data usunięcia
project_description | descr_justif_operation_cross_finance | varchar | 3072 | √ |  | null |  |  | Opis uzasadnienia działań cross-finansingu - sekcja C.9
historical_beneficiary_status | description | varchar | 3000 |  |  |  |  |  | Opis
indicator_description | description | varchar | 255 | √ |  | null |  |  | Opis
sec_permission | description | varchar | 256 | √ |  | null |  |  | Opis
sec_role | description | varchar | 2147483647 | √ |  | null |  |  | Opis
sec_system | description | varchar | 256 | √ |  | null |  |  | Opis
co_financing_amount | dic | numeric | 15,2 | √ |  | null |  |  | Suma zdyskontowanych kosztów inwestycyjnych - sekcja E.3(1..1)
address | district | varchar | 200 | √ |  | null |  |  | Adres - powiat
co_financing_amount | dnr | numeric | 15,2 | √ |  | null |  |  | Suma zdyskontowanych przychodów netto - sekcja E.3(.1.1)
pay_financing_entry | document_creation_date | timestamp | 29,6 | √ |  | null |  |  | Data wystawienia dokumentu (B.1)
pay_financing_entry | document_number | varchar | 20 | √ |  | null |  |  | Nr. dokumentu (B.1)
financial_installment | durability_assurance | varchar | 3072 | √ |  | null |  |  | Zapewnienie trwałości - sekcja F
co_financing_amount | ec | numeric | 15,2 | √ |  | null |  |  | Suma kosztów kwalifikowanych - sekcja E.3(.1.1)
applicant | email | varchar | 64 | √ |  | null |  |  | Email
pay_person_info | email | varchar | 64 | √ |  | null |  |  | Email
person | email | varchar | 64 | √ |  | null |  |  | Email
user_registration | email | varchar | 64 | √ |  | null |  |  | E-mail
subject_description | employment | numeric | 15,2 | √ |  | null |  |  | Zatrudnienie
project | equal_right_policy | bool | 1 | √ |  | null |  |  | Polityka równych szans - sekcja A.13
project | equal_right_policy_justification | varchar | 2000 | √ |  | null |  |  | Polityka równych szans - uzasadnienie - sekcja A.13
financing_source | erdf_amount | numeric | 15,2 | √ |  | null |  |  | Kwota erdf
evaluation | essential_acceptance | bool | 1 | √ |  | null |  |  |
evaluation | essential_points_quantity | int4 | 10 | √ |  | null |  |  |
co_financing_amount | eu_grant | numeric | 15,2 | √ |  | null |  |  | Dotacje UE (Kwota dotacji) - sekcja E.3(.1.1)
execution_audit | exception | text | 2147483647 | √ |  | null |  |  | Wyjątek
execution_audit | execution_date | timestamp | 29,6 | √ |  | null |  |  | Data (czas) wystąpienia
execution_audit | execution_details | varchar | 3000 | √ |  | null |  |  | Szczegóły
execution_audit | execution_name | varchar | 300 | √ |  | null |  |  | Nazwa
execution_audit | execution_status | int4 | 10 | √ |  | null |  |  | Status
pay_payment_form | expense_combination | int8 | 19 | √ |  | null |  |
pay_expense_combination.id | fke2c2f1941eb3f86d
| Informacje o wydatkach
pay_period_definition | expense_combination_id | int8 | 19 |  |  |  |  |
pay_expense_combination.id | fkd00f62ba2b445657
| Identyfikator zestawienia wydatków
pay_task | expense_combination_id | int8 | 19 |  |  |  |  |
pay_expense_combination.id | fk51ab66bc2b445657
| Identyfikator
pay_period | expense_id | int8 | 19 |  |  |  |  |
pay_expense.id | fk8dd13538ce0d0bcc
| Identyfikator wydatków
applicant | experience | varchar | 3072 | √ |  | null |  |  | Doświadczenie - sekcja B.10
applicant | fax_no | varchar | 30 | √ |  | null |  |  | Numer faksu
pay_person_info | fax_no | varchar | 30 | √ |  | null |  |  | Numer faksu
person | fax_no | varchar | 30 | √ |  | null |  |  | Numer faksu
co_financing_amount | feasibility_study_page | int4 | 10 | √ |  | null |  |  | Numer strony studium wykonywalności - sekcja E.3(.1.1)
field_configuration | field | varchar | 10 |  |  |  |  |  | Pole
project | financial_completion_date | date | 13 | √ |  | null |  |  | Data finansowego zakończenia prac - sekcja A.11
pay_beneficiary_information | financial_person_id | int8 | 19 | √ |  | null |  |
pay_person_info.id | fk1e0183bf795030a
| Identyfikator osoby w części dot. postępu finansowego (A.3)
pay_financing_entry | financing_information_id | int8 | 19 |  |  |  |  |
pay_financing_information.id | fkf93cd2b3a478705a
| Identyfikator informacji finansowej
pay_payment_form | financing_information_id | int8 | 19 | √ |  | null |  |
pay_financing_information.id | fke2c2f194a478705a
| Identyfikator
description_of_public_procurement | finish_date | date | 13 | √ |  | null |  |  | Data zakonczenia
task | finish_date | date | 13 | √ |  | null |  |  | Data rozpoczęcia zadania
address | flat_number | varchar | 8 | √ |  | null |  |  | Numer mieszkania
pay_beneficiary_information | flat_number | varchar | 8 | √ |  | null |  |  | Numer lokalu (A.3)
applicant | form_another_project | bool | 1 | √ |  | null |  |  | Dofinansowanie innego projektu - sekcja B.13
evaluation | formal_acceptance | bool | 1 | √ |  | null |  |  |
project_description | goals_and_conformance_with_rpo_wz | varchar | 3072 | √ |  | null |  |  | Cele i zgodność z RPO WZ - sekcja C.6
assistance_de_minimis | granting_institution | varchar | 100 | √ |  | null |  |  | Instytucja udzielająca pomocy
pay_material_financial_progress | ground_target_id | int8 | 19 | √ |  | null |  |
pay_material_financial_target.id | fkd62aec24cf6f6038
| Identyfikator zakupu gruntów
pay_realization_progress | group_1_expense_id | int8 | 19 | √ |  | null |  |
pay_realization_progress_entry.id | fke4c8207d5aefab3b
| Identyfikator
address | has_location_info | bool | 1 |  |  | true |  |  |
applicant | has_subject | bool | 1 | √ |  | null |  |  | pomocCharakterystyka podmiotu prowadzącego działalność gospodarczą - B.7
address | house_number | varchar | 8 | √ |  | null |  |  | Numer domu
pay_beneficiary_information | house_number | varchar | 8 | √ |  | null |  |  | Numer domu (A.3)
form_annex | id_annex | int4 | 10 | √ |  | null |  |
annex.id | form_annex_annex
| Identyfikator załącznika
applicant_nip | id_applicant | int4 | 10 |  |  |  |  |
applicant.id | applicant_fk
| Identyfikator wnioskodawcy
applicant_person_agreement | id_applicant | int4 | 10 | √ |  | null |  |
applicant.id | applicant_person_agreement_applicant
| Identyfikator wnioskodawcy
applicant_person_contact | id_applicant | int4 | 10 |  |  |  |  |
applicant.id | applicant_person_contact_applicant
| Identyfikator wnioskodawcy
application_form_info | id_applicant | int4 | 10 |  |  |  |  |
applicant.id | applicant_fk
| Identyfikator wnioskodawcy
assistance_de_minimis | id_applicant | int4 | 10 | √ |  | null |  |
applicant.id | assistance_de_minimis_applicant
| Identyfikator wnioskodawcy
user_application_form | id_application_form | int4 | 10 | √ |  | null |  |
application_form.id | current_version_application_form
| Identyfikator formularza aplikacyjnego
operation_area_type | id_area_type | int4 | 10 | √ |  | null |  |
area_type.id | operation_area_type_area_type
| Identyfikator typ obszaru
project_description | id_area_type | int4 | 10 | √ |  | null |  |
area_type.id | project_decription_area_type
| Identyfikator typu obszaru
suboperation_area_type | id_area_type | int4 | 10 | √ |  | null |  |
area_type.id | suboperation_area_type_area_type
| Identyfikator typu obszaru
address | id_city | int4 | 10 | √ |  | null |  |
city.id | address_city
| Identyfikator miejscowości
project_location | id_city | int4 | 10 | √ |  | null |  |
city.id | id_city_fk
| Identyfikator miejscowości
address | id_commune | int4 | 10 | √ |  | null |  |
commune.id | address_commune
| Identyfikator gminy
project_location | id_commune | int4 | 10 |  |  |  |  |
commune.id | commune_id_fk
| Identyfikator gminy
applicant | id_correspondence_address | int4 | 10 | √ |  | null |  |
address.id | id_correspondence_address_fk
| Identyfikator adresu (korespondencyjnego) - sekcja B.4
person | id_correspondence_address | int4 | 10 | √ |  | null |  |
address.id | person_correspondence_address
| Identyfikator adresu korespondencyjnego
user_registration | id_correspondence_address | int4 | 10 | √ |  | null |  |
address.id | user_correspondence_address
| Identyfikator adresu do korespondecji
address | id_district | int4 | 10 | √ |  | null |  |
district.id | address_district
| Identyfikator powiatu
commune | id_district | int4 | 10 | √ |  | null |  |
district.id | commune_district
| Identyfikator powiata
project_location | id_district | int4 | 10 |  |  |  |  |
district.id | district_id_fk
| Identyfikator powiatu
user_registration | id_doc_number | varchar | 16 | √ |  | null |  |  | Nieużywane
project | id_economy_sector | int4 | 10 | √ |  | null |  |
economy_sector.id | project_id_economy_sector_fkey
| Identyfikator działy gospodarki
expense_year | id_expense | int4 | 10 | √ |  | null |  |
expense.id | expense_value_expense
| Identyfikator wydatku
operation_field_configuration | id_field_configuration | int4 | 10 | √ |  | null |  |
field_configuration.id | operation_field_configuration_field_configuration
| Identyfikator konfiguracji (widoczności) pól
suboperation_field_configuration | id_field_configuration | int4 | 10 | √ |  | null |  |
field_configuration.id | suboperation_field_configuration_field_configuration
| Identyfikator
aggregate_value | id_financial_installment | int4 | 10 | √ |  | null |  |
financial_installment.id | aggregate_value_financial_installment
| Identyfikator montażu finansowego
co_financing_amount | id_financial_installment | int4 | 10 | √ |  | null |  |
financial_installment.id | co_financing_amount_financial_installment
| Identyfikator montażu finansowego
financing_source | id_financial_installment | int4 | 10 | √ |  | null |  |
financial_installment.id | financing_source_financial_installment
| Identyfikator montażu finansowego
task | id_financial_installment | int4 | 10 | √ |  | null |  |
financial_installment.id | task_financial_installment
| Identyfikator montażu finansowego
application_form | id_folder | int4 | 10 | √ |  | null |  |
folder.id | application_folder
| Identyfikator teczki projektu
message | id_folder | int4 | 10 | √ |  | null |  |
folder.id | message_folder
| Identyfikator
note | id_folder | int4 | 10 | √ |  | null |  |
folder.id | note_folder
| Identyfikator teczki proketu
applicant | id_form | int4 | 10 | √ |  | null |  |
application_form.id | application_form_fk
| Identyfikator wniosku
evaluation | id_form | int4 | 10 | √ |  | null |  |
application_form.id | evaluation_application
| Identyfikator wniosku
financial_installment | id_form | int4 | 10 | √ |  | null |  |
application_form.id | financial_installment_application_form
| Identyfikator wniosku
form_annex | id_form | int4 | 10 | √ |  | null |  |
application_form.id | form_annex_application
| Identyfikator wniosku
form_statement | id_form | int4 | 10 | √ |  | null |  |
application_form.id | form_statement_application
| Identyfikator wniosku
project | id_form | int4 | 10 | √ |  | null |  |
application_form.id | project_application_form
| Identyfikator wniosku
project_description | id_form | int4 | 10 | √ |  | null |  |
application_form.id | project_description
| Identyfikator wniosku
version_application_form | id_form | int4 | 10 | √ |  | null |  |
application_form.id | version_application_form_application_form
| Identyfikator wniosku
applicant | id_form_another_project | int4 | 10 | √ |  | null |  |
application_form.id | applicant_form_another_project
| Identyfikator
operation_funding_form | id_funding_form | int4 | 10 |  |  |  |  |
funding_form.id | operation_funding_form_id_funding_form_fkey
| Identyfikator formy finansowania
project | id_funding_form | int4 | 10 | √ |  | null |  |
funding_form.id | project_id_funding_form_fkey
| Identyfikator formy finansowania
suboperation_funding_form | id_funding_form | int4 | 10 |  |  |  |  |
funding_form.id | suboperation_funding_form_id_funding_form_fkey
| Identyfikator formy finansowania
indicator_type_key_year_value | id_indicator | int4 | 10 | √ |  | null |  |
indicator_type_key.id | indicator_type_key_year_value_indicator
| Identyfikator wskaźnika
indicator_type_product_year_value | id_indicator | int4 | 10 | √ |  | null |  |
indicator_type_product.id | indicator_type_product_year_value_indicator
| Identyfikator wskaźnika
indicator_type_realisation_year_value | id_indicator | int4 | 10 | √ |  | null |  |
indicator_type_realisation.id | indicator_type_realisation_year_value_indicator
| Identyfikator wskaźnika
indicator_type_result_year_value | id_indicator | int4 | 10 | √ |  | null |  |
indicator_type_result.id | indicator_type_result_year_value_indicator
| Identyfikator wskaźnika
co_financing_key_result | id_indicator_description | int4 | 10 | √ |  | null |  |
indicator_description.id | key_description
| Identyfikator opis wskaźnika
indicator_type_key | id_indicator_description | int4 | 10 | √ |  | null |  |
indicator_description.id | id_indicator_type_key_description
| Identyfikator
indicator_type_product | id_indicator_description | int4 | 10 | √ |  | null |  |
indicator_description.id | id_indicator_type_product_description
| Identyfikator
indicator_type_realisation | id_indicator_description | int4 | 10 | √ |  | null |  |
indicator_description.id | id_indicator_type_realisation_description
| Identyfikator
indicator_type_result | id_indicator_description | int4 | 10 | √ |  | null |  |
indicator_description.id | id_indicator_type_result_description
| Identyfikator
pay_product_realization_indicator | id_indicator_description | int4 | 10 | √ |  | null |  |
indicator_description.id | fk8b5d916f7f288d99
| Identyfikator opisu wskaźnika
pay_result_realization_indicator | id_indicator_description | int4 | 10 | √ |  | null |  |
indicator_description.id | fk8fd6c7ab7f288d99
| Identyfikator opisu wskaźnika
subject | id_info_before_next_to_last_period | int4 | 10 | √ |  | null |  |
subject_description.id | subject_subject_description_before_next_to_last
| Identyfikator okres przed przedostatni
subject | id_info_last_period | int4 | 10 | √ |  | null |  |
subject_description.id | subject_subject_descrition_last
| Identyfikator okres ostatni
subject | id_info_next_to_last_period | int4 | 10 | √ |  | null |  |
subject_description.id | subject_subject_description_next_to_last
| Identyfikator okres przedostatni
operation_intervention_category | id_intervention_category | int4 | 10 | √ |  | null |  |
intervention_category.id | operation_intervention_category_intervention_category
| Identyfikator kategorii interwencji
project | id_intervention_category | int4 | 10 | √ |  | null |  |
intervention_category.id | project_intervention_category
| Identyfikator kategorii interwencji
suboperation_intervention_category | id_intervention_category | int4 | 10 | √ |  | null |  |
intervention_category.id | suboperation_intervention_category_intervention_category
| Identyfikator kategorii interwencji
operation_legal_base | id_legal_base | int4 | 10 | √ |  | null |  |
legal_base.id | operation_legal_base_legal_base
| Identyfikator podstawy prawnej
public_assistance | id_legal_base | int4 | 10 | √ |  | null |  |
legal_base.id | public_assistance_legal_base
| Identyfikator podstawy prawnej
suboperation_legal_base | id_legal_base | int4 | 10 | √ |  | null |  |
legal_base.id | suboperation_legal_base_legal_base
| Identyfikator podstawa prawna
public_assistance | id_legal_base_auto | int4 | 10 | √ |  | null |  |
legal_base.id | public_assistance_legal_base_auto
| Identyfikator
public_assistance | id_legal_base_cross_finance | int4 | 10 | √ |  | null |  |
legal_base.id | public_assistance_legal_base_cross_finance
| Identyfikator podstawy prawnej - cross finansing
applicant | id_legal_form | int4 | 10 |  |  | 0 |  |
legal_form.id | id_legal_form_fk
| Identyfikator formy prawnej
ksi_legal_form | id_legal_form | int4 | 10 | √ |  | null |  |  | Indetyfikator podstawy prawnej
user_registration_message | id_message | int4 | 10 |  |  |  |  |
message.id | message
| Identyfikator wiadomości
indicator_description | id_operation | int4 | 10 | √ |  | null |  |
operation.id | fka3b201cc4434bc24
| Identyfikator
operation_area_type | id_operation | int4 | 10 | √ |  | null |  |
operation.id | operation_area_type_operation
| Identyfikator działania
operation_field_configuration | id_operation | int4 | 10 | √ |  | null |  |
operation.id | operation_field_configuration_operation
| Identyfikator działania
operation_funding_form | id_operation | int4 | 10 |  |  |  |  |
operation.id | operation_funding_form_id_operation_fkey
| Identyfikator działania
operation_intervention_category | id_operation | int4 | 10 | √ |  | null |  |
operation.id | operation_intervention_category_operation
| Identyfikator działania
operation_legal_base | id_operation | int4 | 10 | √ |  | null |  |
operation.id | operation_legal_base_operation
| Identyfikator działania
operation_type_of_applicant | id_operation | int4 | 10 | √ |  | null |  |
operation.id | operation_type_of_applicant_operation
| Identyfikator działania
operation_type_of_project | id_operation | int4 | 10 | √ |  | null |  |
operation.id | operation_type_of_project_operation
| Identyfikator działania
pay_payment_form | id_operation | int4 | 10 | √ |  | null |  |  | Identyfikator działania
project | id_operation | int4 | 10 | √ |  | null |  |
operation.id | project_operation
| Identyfikator działania
suboperation | id_operation | int4 | 10 | √ |  | null |  |
operation.id | suboperation_operation
| Identyfikator
user_registration | id_operator | int4 | 10 | √ |  | null |  |  | Identyfikator użytkownika
sec_permission_def | id_permission | int4 | 10 | √ |  | null |  |
sec_permission.id | sec_permission_def_sec_permission
| Identyfikator prawa dostępu
applicant_person_agreement | id_person | int4 | 10 | √ |  | null |  |
person.id | applicant_person_agreement_person
| Identyfikator osoby
applicant_person_contact | id_person | int4 | 10 |  |  |  |  |
person.id | applicant_person_contact_person
| Identyfikator Osoby
subject_partner | id_person | int4 | 10 | √ |  | null |  |
person.id | subject_partner_person
| Identyfikator osoby
operation | id_priority_axis | int4 | 10 | √ |  | null |  |
priority_axis.id | operation_priority_axis
| Identyfikator osi priorytetowej
project | id_priority_axis | int4 | 10 | √ |  | null |  |
priority_axis.id | project_priority_axis
| Identyfikator osi priorytetowej
public_assistance | id_project | int4 | 10 | √ |  | null |  |
project.id | public_assistance_project
| Identyfikator projektu
co_financing_key_result | id_project_description | int4 | 10 | √ |  | null |  |
project_description.id | key_results_co_finance_project_description
| Identyfikator opis projektu
description_of_public_procurement | id_project_description | int4 | 10 | √ |  | null |  |
project_description.id | description_of_public_procurement
| Identyfikator opis wskaźnika
indicator_type_key | id_project_description | int4 | 10 | √ |  | null |  |
project_description.id | indicator_type_key_description
| Identyfikator opis wskaźnika
indicator_type_product | id_project_description | int4 | 10 | √ |  | null |  |
project_description.id | indicator_type_project_description
| Identyfikator opis wskaźnika
indicator_type_realisation | id_project_description | int4 | 10 | √ |  | null |  |
project_description.id | indicator_type_realisation_description
| Identyfikator opis wskaźnika
indicator_type_result | id_project_description | int4 | 10 | √ |  | null |  |
project_description.id | indicator_type_result_description
| Identyfikator opis wskaźnika
project_location | id_project_description | int4 | 10 |  |  |  |  |
project_description.id | project_description_id_fk
| Identyfikator opis wskaźnika
address | id_province | int4 | 10 | √ |  | null |  |
province.id | address_province
| Identyfikator województwa
prerequisite_of_public_assistance | id_public_assistance | int4 | 10 | √ |  | null |  |
public_assistance.id | prerequisite_of_public_assistance_public_assistance
| Identyfikator pomocy publicznej
evaluation | id_ranking_list | int4 | 10 | √ |  | null |  |
ranking_list.id | evaluation_LISTA_WIARYGODNOSCI
| Identyfikator
applicant | id_registration_address | int4 | 10 | √ |  | null |  |
address.id | id_registration_address_fk
| Identyfikator adresu zameldowania
person | id_registration_address | int4 | 10 | √ |  | null |  |
address.id | person_registration_address
| Identyfikator adresu zameldowania
application_form | id_report | int4 | 10 | √ |  | null |  |  | Identyfikator raportu
pay_payment_form | id_report | int4 | 10 | √ |  | null |  |
report.id | fke2c2f194200c2ce5
| Identyfikator powiązanego dokumentu pdf
user_registration | id_resident_address | int4 | 10 | √ |  | null |  |
address.id | user_resident_address
| Identyfikator adresu zamieszkania
sec_operator_role | id_role | int4 | 10 | √ |  | null |  |
sec_role.id | sec_operator_role_sec_role
| Identyfikator roli
sec_permission_def | id_role | int4 | 10 | √ |  | null |  |
sec_role.id | sec_permission_def_sec_role
| Identyfikator roli
sec_role | id_role_parent | int4 | 10 | √ |  | null |  |
sec_role.id | sec_role_sec_role
| Identyfikator - rodzic
form_statement | id_statement | int4 | 10 | √ |  | null |  |
statement.id | form_statement_statement
| Identyfikator oświadczenia
application_form | id_status | int4 | 10 | √ |  | null |  |  | Identyfikator statusu
applicant | id_subject | int4 | 10 | √ |  | null |  |
subject.id | applicant_subject
| Identyfikator podmiotu
subject_partner | id_subject | int4 | 10 | √ |  | null |  |
subject.id | subject_partner_subject
| Identyfikator podmiotu
indicator_description | id_suboperation | int4 | 10 | √ |  | null |  |
suboperation.id | fka3b201cc2698a538
| Identyfikator poddziałania
pay_payment_form | id_suboperation | int4 | 10 | √ |  | null |  |  | Identyfikator poddziałania
project | id_suboperation | int4 | 10 | √ |  | null |  |
suboperation.id | project_suboperation
| Identyfikator poddziałania
suboperation_area_type | id_suboperation | int4 | 10 | √ |  | null |  |
suboperation.id | suboperation_area_type_suboperation
| Identyfikator poddziałania
suboperation_field_configuration | id_suboperation | int4 | 10 | √ |  | null |  |
suboperation.id | suboperation_field_configuration_suboperation
| Identyfikator poddziałania
suboperation_funding_form | id_suboperation | int4 | 10 |  |  |  |  |
suboperation.id | suboperation_funding_form_id_suboperation_fkey
| Identyfikator poddziałania
suboperation_intervention_category | id_suboperation | int4 | 10 | √ |  | null |  |
suboperation.id | suboperation_intervention_category_suboperation
| Identyfikator poddziałania
suboperation_legal_base | id_suboperation | int4 | 10 | √ |  | null |  |
suboperation.id | suboperation_legal_base_suboperation
| Identyfikator poddziałania
suboperation_type_of_applicant | id_suboperation | int4 | 10 | √ |  | null |  |
suboperation.id | suboperation_type_of_applicant_suboperation
| Identyfikator poddziałania
suboperation_type_of_project | id_suboperation | int4 | 10 | √ |  | null |  |
suboperation.id | suboperation_type_of_project_suboperation
| Identyfikator poddziałania
sec_permission | id_system | int4 | 10 | √ |  | null |  |
sec_system.id | sec_permission_sec_system
| Identyfikator systemu
sec_role | id_system | int4 | 10 | √ |  | null |  |
sec_system.id | sec_role_sec_system
| System
expense | id_task | int4 | 10 | √ |  | null |  |
task.id | expense_task
| Identyfikator zadania
task_aggregate_value | id_task | int4 | 10 | √ |  | null |  |
task.id | id_task_fk
| Identyfikator zadania
project | id_type | int4 | 10 | √ |  | null |  |
type_of_project.id | project_type_of_project
| Identyfikator typu
applicant | id_type_of_applicant | int4 | 10 | √ |  | null |  |
type_of_applicant.id | applicant_type_of_applicant
| Identyfikator typu adresu
operation_type_of_applicant | id_type_of_applicant | int4 | 10 | √ |  | null |  |
type_of_applicant.id | operation_type_of_applicant_type_of_applicant
| Identyfikator typu wnioskodawcy
suboperation_type_of_applicant | id_type_of_applicant | int4 | 10 | √ |  | null |  |
type_of_applicant.id | suboperation_type_of_applicant_type_of_applicant
| Identyfikator typu wnioskodawcy
operation_type_of_project | id_type_of_project | int4 | 10 | √ |  | null |  |
type_of_project.id | operation_type_of_project_type_of_project
| Identyfikator typu projektu
suboperation_type_of_project | id_type_of_project | int4 | 10 | √ |  | null |  |
type_of_project.id | suboperation_type_of_project_type_of_project
| Identyfikator typu obszaru
applicant | id_type_of_record | int4 | 10 | √ |  | null |  |
type_of_record.id | id_type_of_record_fk
| Identyfikator typu ewidencji
application_form | id_user | int4 | 10 | √ |  | null |  |
user_registration.id | application_form_owner
| Identyfikator użytkownika
folder | id_user | int4 | 10 | √ |  | null |  |
user_registration.id | folder_user
| Identyfikator użytkownika
sec_operator_role | id_user | int4 | 10 | √ |  | null |  |
sec_operator.id | sec_operator_role_sec_operator
| Identyfikator użytkownika
user_application_form | id_user | int4 | 10 | √ |  | null |  |
user_registration.id | user_version_user
| Identyfikator użytkownika
application_form | id_user_application_form | int4 | 10 | √ |  | null |  |
user_application_form.id | application_form_history
| Identyfikator użytkownik - formularz aplikacyjny
user_registration_message | id_user_registration | int4 | 10 |  |  |  |  |
user_registration.id | user_registration
| Identyfikator użytkownika
version_application_form | id_version_application_form | int4 | 10 | √ |  | null |  |
version_application_form.id | version_application_form_parent
| Identyfikator
project | impact_assessment | bool | 1 | √ |  | null |  |  | Ocena oddziaływania - sekcja A.14
contest_info | import_date | timestamp | 29,6 |  |  |  |  |  | Data importu
pay_income_entry | income_amount | numeric | 15,2 | √ |  | null |  |  | Kwota dochodu (D.1)
pay_income_entry | income_id | int8 | 19 |  |  |  |  |
pay_income.id | fka63174935226cea7
| Identyfikator dochodu (D.1)
pay_payment_form | income_id | int8 | 19 | √ |  | null |  |
pay_income.id | fke2c2f1945226cea7
| Identyfikator dochodów
subject_description | income_net | numeric | 15,2 | √ |  | null |  |  | Przychody netto
pay_income_entry | income_type | varchar | 200 | √ |  | null |  |  | Rodzaj dochodu (D.1)
subject_description | independent_subject | bool | 1 | √ |  | null |  |  | Podmiot niezależny
applicant_nip | index | int4 | 10 | √ |  | null |  |  |
indicator_type_key | indicator_year_value_sum | numeric | 15,3 | √ |  | null |  |  |
indicator_type_product | indicator_year_value_sum | numeric | 15,3 | √ |  | null |  |  |
indicator_type_realisation | indicator_year_value_sum | numeric | 15,3 | √ |  | null |  |  |
indicator_type_result | indicator_year_value_sum | numeric | 15,3 | √ |  | null |  |  |
project | influence_area_nature_2000 | varchar | 2048 | √ |  | null |  |  | Obszar oddziaływania Natura 2000 - sekcja A.15
pay_income | interest | numeric | 15,2 | √ |  | null |  |  | Odsetki narosłe od środków zaliczki od złożenia poprzedniego (D.1)
pay_project_information | is_agreement | bool | 1 | √ |  | null |  |  | Umowa/ decyzja (A.2)
project_description | justification_and_results | varchar | 5120 | √ |  | null |  |  | Uzasadnienie i rezultaty - sekcja sekcja C.8
project_description | justification_for_no_public_procurement | varchar | 2048 | √ |  | null |  |  | Uzasadnienie braku zamówień publicznych - sekcja C.16
applicant | krs_edg_concern | bool | 1 | √ |  | null |  |  | Dotyczy krs edg - sekcja B.4
ksi_legal_form | ksi_code | varchar | 20 |  |  |  |  |  | Kod KSI
ksi_legal_form | ksi_name | varchar | 1000 |  |  |  |  |  | Nazwa z KSI
page_skin | label_image | varchar | 256 | √ |  | null |  |  | Etykieta obrazka
operator_role_view | login | varchar | 16 | √ |  | null |  |  |
sec_operator | login | varchar | 16 | √ |  | null |  |  | Nazwa użytkownika
pay_material_financial_progress | lump_sum_target_id | int8 | 19 | √ |  | null |  |
pay_material_financial_target.id | fkd62aec24a754c1e9
| Identyfikator wydatków związanych z kosztami pośrednimi / ogólnym rozliczanymi ryczałtowo
pay_realization_progress | material_expense_id | int8 | 19 | √ |  | null |  |
pay_realization_progress_entry.id | fke4c8207d8b0576c5
| Identyfikator wydatków materialnych
pay_material_financial_phase | material_financial_progress_id | int8 | 19 | √ |  | null |  |
pay_material_financial_progress.id | fk80e2fae475df8a22
| Identyfikator postępu materialno-finansowego (E.1)
pay_payment_form | material_financial_progress_id | int8 | 19 | √ |  | null |  |
pay_material_financial_progress.id | fke2c2f19475df8a22
| Identyfikator postępu materialno-finansowego
pay_material_financial_phase | material_general_expense | numeric | 15,2 | √ |  | null |  |  | Wydatki ogółem przypisane zadaniom określonym w aktualnym harmonogramie rzeczowo-finansowym (E.1)
pay_material_financial_target | material_general_expense | numeric | 15,2 | √ |  | null |  |  | Wydatki ogółem przypisane zadaniom określonym w aktualnym harmonogramie rzeczowo-finansowym
pay_material_financial_progress | material_general_expense_total | numeric | 15,2 |  |  |  |  |  | Ogółem: wydatki ogółem przypisane zadaniom określonym w aktualnym harmonogramie rzeczowo-finansowym
pay_material_financial_phase | material_qualified_expense | numeric | 15,2 | √ |  | null |  |  | Wydatki kwalifikowane przypisane zadaniom określonym w aktualnym harmonogramie rzeczowo-finansowym (E.1)
pay_material_financial_target | material_qualified_expense | numeric | 15,2 | √ |  | null |  |  | Wydatki kwalifikowane przypisane zadaniom określonym w aktualnym harmonogramie rzeczowo-finansowym
pay_material_financial_progress | material_qualified_expense_total | numeric | 15,2 |  |  |  |  |  | Ogółem: wydatki kwalifikowane przypisane zadaniom określonym w aktualnym harmonogramie rzeczowo-finansowym
co_financing_amount | max_crpa | numeric | 23,10 | √ |  | null |  |  | Maksymalna stopa współfinansowania określona dla działania/poddziałania - sekcja E.3(.1.1)
co_financing_amount | max_ee | numeric | 15,2 | √ |  | null |  |  | Maksymalny wydatek kwalifikowany - sekcja E.3(.1.1)
co_financing_amount | max_level | numeric | 23,10 | √ |  | null |  |  | Maksymalny poziom dofinansowania dla projektu - sekcja E.3(.2)
operation | max_requested_level | numeric | 19,2 | √ |  | null |  |  | Maksymalny żądany poziom dofinansowania
suboperation | max_requested_level | numeric | 19,2 | √ |  | null |  |  |
co_financing_key_result | measurement_unit | varchar | 8 | √ |  | null |  |  | Jednostka miary
indicator_description | measurement_unit | varchar | 255 | √ |  | null |  |  | Jednostka miary
message | message_date | timestamp | 29,6 | √ |  | null |  |  | Data wiadomości
financial_installment | methods_of_promotion | varchar | 2048 | √ |  | null |  |  | Promocja projektu - Sposób promocji - sekcja G
annex | name | varchar | 256 | √ |  | null |  |  | Nazwa aneksu
applicant | name | varchar | 500 | √ |  | null |  |  | Nazwa - sekcja B.1
area_type | name | varchar | 256 | √ |  | null |  |  | Nazwa
city | name | varchar | 64 | √ |  | null |  |  | Nazwa miejscowości
co_financing_key_result | name | varchar | 32 | √ |  | null |  |  | Nazwa
commune | name | varchar | 64 | √ |  | null |  |  | Nazwa
district | name | varchar | 64 | √ |  | null |  |  | Nazwa powiatu
economy_sector | name | varchar | 1024 |  |  |  |  |  | Nazwa działu
expense | name | varchar | 250 | √ |  | null |  |  | Nazwa wydatku
folder | name | varchar | 64 | √ |  | null |  |  | Nazwa teczki
funding_form | name | varchar | 200 | √ |  | null |  |  | Nazwa formy
indicator_type_key | name | varchar | 32 | √ |  | null |  |  | Nazwa
indicator_type_product | name | varchar | 32 | √ |  | null |  |  | Nazwa
indicator_type_realisation | name | varchar | 32 | √ |  | null |  |  | Nazwa
indicator_type_result | name | varchar | 32 | √ |  | null |  |  | Nazwa
intervention_category | name | varchar | 256 | √ |  | null |  |  | Nazwa kategorii interwencji
legal_base | name | varchar | 1024 | √ |  | null |  |  | Nazwa
legal_form | name | varchar | 100 |  |  |  |  |  | Nazwa
operation | name | varchar | 256 | √ |  | null |  |  | Nazwa działania
operator_role_view | name | text | 2147483647 | √ |  | null |  |  |
page_skin | name | varchar | 256 | √ |  | null |  |  | Nazwa
pay_expense | name | varchar | 250 |  |  |  |  |  | Nazwa wydatku (C.2)
pay_material_financial_phase | name | varchar | 250 | √ |  | null |  |  | Nazwa zadania / etapu (E.1)
pay_payment_attachment | name | varchar | 200 | √ |  | null |  |  | Nazwa załącznika (H.1)
pay_payment_form | name | varchar | 500 |  |  |  |  |  | Nazwa
pay_person_info | name | varchar | 500 | √ |  | null |  |  | Nazwa
pay_task | name | varchar | 256 |  |  |  |  |  | Nazwa (C.1)
person | name | varchar | 64 | √ |  | null |  |  | Nazwa
priority_axis | name | varchar | 256 | √ |  | null |  |  | Nazwa osi
province | name | varchar | 64 | √ |  | null |  |  | Nazwa
ranking_list | name | varchar | 256 | √ |  | null |  |  | Nazwa
sec_permission | name | varchar | 32 | √ |  | null |  |  | Nazwa
sec_role | name | varchar | 32 | √ |  | null |  |  | Nazwa
sec_system | name | varchar | 32 | √ |  | null |  |  | Nazwa systemu
suboperation | name | varchar | 256 | √ |  | null |  |  | Nazwa poddziałania
task | name | varchar | 256 | √ |  | null |  |  | Nazwa
type_of_applicant | name | varchar | 384 | √ |  | null |  |  | Nazwa wnioskodawcy
type_of_project | name | varchar | 384 | √ |  | null |  |  | Nazwa projektu
type_of_record | name | varchar | 256 | √ |  | null |  |  | Nazwa ewidencji
user_registration | name | varchar | 64 | √ |  | null |  |  | Imię
version_application_form | name | varchar | 64 | √ |  | null |  |  | Nazwa
financing_source | national_budget | numeric | 15,2 | √ |  | null |  |  | Budżet krajowy
financing_source | national_public_contribution_amount | numeric | 15,2 | √ |  | null |  |  | Krajowy wkład publiczny - kwota
pay_financing_entry | netto_amount | numeric | 17,2 | √ |  | null |  |  | Kwota dokumentu netto (B.1)
pay_financing_information | netto_sum | numeric | 17,2 |  |  |  |  |  | Kwota dokumentu netto suma ogółem w PLN (B.1)
applicant_nip | nip | varchar | 30 |  |  |  |  |  | Nip
pay_financing_entry | nip | varchar | 10 | √ |  | null |  |  | NIP podmiotu, na który został wystawiony dokument (B.1)
person | nip | varchar | 16 | √ |  | null |  |  | Nip
user_registration | nip | varchar | 16 | √ |  | null |  |  | NIP
project | no_evaluation_justification | varchar | 3072 | √ |  | null |  |  | Uzasadnienie braku oceny - sekcja A.14
project | no_funding_effect_justification | varchar | 2000 | √ |  | null |  |  | Uzasadnienie A.12
project | no_funding_effect_type | int4 | 10 | √ |  | 0 |  |  | W przypadku kiedy projekt nie otrzyma dofinansowania ze środków RPO WZ - sekcja A.12
co_financing_amount | no_income_maximum_amount | numeric | 23,10 | √ |  | null |  |  | Maksymalny poziom dofinansowania dla projektu - sekcja E.3.1(.2)
co_financing_amount | no_income_requested_amount | numeric | 23,10 | √ |  | null |  |  | Wnioskowany poziom dofinansowania - sekcja E.3.1(.2)
co_financing_amount | no_income_requested_overall_amount | numeric | 15,2 | √ |  | null |  |  | Całkowita wnioskowana kwota dofinansowania - sekcja E.3.1(.2)
pay_expense | notice | varchar | 500 | √ |  | null |  |  | Uwagi (C.4)
annex | number | varchar | 8 | √ |  | null |  |  | Numer aneksu
economy_sector | number | varchar | 10 | √ |  | null |  |  | Numer działu
funding_form | number | varchar | 10 | √ |  | null |  |  | Numer formy
intervention_category | number | varchar | 8 | √ |  | null |  |  | Numer
operation | number | varchar | 8 | √ |  | null |  |  | Numer działania
pay_invoice | number | varchar | 10 |  |  |  |  |  | Numer faktury (C.4)
priority_axis | number | varchar | 8 | √ |  | null |  |  | Numer osi
statement | number | varchar | 8 | √ |  | null |  |  | Numer
suboperation | number | varchar | 8 | √ |  | null |  |  | Numer poddziałania
version_application_form | number | int4 | 10 | √ |  | null |  |  | Numer
applicant | number_edg | varchar | 100 | √ |  | null |  |  | Numer edg - sekcja B.4
person | number_edg | varchar | 32 | √ |  | null |  |  | Numer edg
applicant | number_krs | varchar | 100 | √ |  | null |  |  | Numer krs - sekcja B.4
person | number_krs | varchar | 32 | √ |  | null |  |  | Numer krs
person | occupation | varchar | 200 | √ |  | null |  |  | Stanowisko
historical_beneficiary_status | official_status | int4 | 10 |  |  | 0 |  |  | Status w officialu
application_form_info | operation_info | varchar | 200 | √ |  | null |  |  | Działania - info
pay_payment_form | operation_number | varchar | 8 | √ |  | null |  |  | Numer poddziałania
financing_source | other_aggregate_amount | numeric | 15,2 | √ |  | null |  |  | Inne kwota ogółem
financing_source | other_budgetary_amount | numeric | 15,2 | √ |  | null |  |  | Inne budżetowe - kwota
pay_attachments_and_statements | other_documents | int4 | 10 | √ |  | null |  |  | Inne dokumenty (H.1)
applicant | other_legal_form | varchar | 500 | √ |  | null |  |  | Inna forma prawna - sekcja B.1
financing_source | other_public_assistance_amount | numeric | 15,2 | √ |  | null |  |  | Inna pomoc publiczna - kwota
financial_installment | overall_budget_dlsg_amount_percent | numeric | 15,2 | √ |  | null |  |  | Procentowo z budżetu - sekcja E.4
financial_installment | overall_budget_dlsg_amount_sum | numeric | 15,2 | √ |  | null |  |  | Suma z budżetu - sekcja E.4
financial_installment | overall_efi_percent | numeric | 15,2 | √ |  | null |  |  | Suma EBI procentowo - sekcja E.4
financial_installment | overall_efi_sum | numeric | 15,2 | √ |  | null |  |  | Suma EBI suma - sekcja E.4
financial_installment | overall_erdf_amount_percent | numeric | 15,2 | √ |  | null |  |  | EFRR procentowo - sekcja E.4
financial_installment | overall_erdf_amount_sum | numeric | 15,2 | √ |  | null |  |  | EFRR suma - sekcja E.4
financial_installment | overall_financing_source_percent | numeric | 15,2 | √ |  | null |  |  |
financial_installment | overall_financing_source_sum | numeric | 15,2 | √ |  | null |  |  | Suma ogółem - sekcja E.4
financial_installment | overall_national_budget_percent | numeric | 15,2 | √ |  | null |  |  | Budżet państwa (cz. 34) procentowo - sekcja E.4
financial_installment | overall_national_budget_sum | numeric | 15,2 | √ |  | null |  |  | Budżet państwa (cz. 34) suma - sekcja E.4
financial_installment | overall_national_public_contribution_amount_percent | numeric | 15,2 | √ |  | null |  |  | Krajowy wkład publiczny procentowo - sekcja E.4
financial_installment | overall_national_public_contribution_amount_sum | numeric | 15,2 | √ |  | null |  |  | Krajowy wkład publiczny suma - sekcja E.4
financial_installment | overall_other_aggregate_amount_percent | numeric | 15,2 | √ |  | null |  |  | Inne ogółem procentowo - sekcja E.4
financial_installment | overall_other_aggregate_amount_sum | numeric | 15,2 | √ |  | null |  |  | Inne ogółem suma - sekcja E.4
financial_installment | overall_other_budgetary_amount_percent | numeric | 15,2 | √ |  | null |  |  | Inne budżetowe procentowo - sekcja E.4
financial_installment | overall_other_budgetary_amount_sum | numeric | 15,2 | √ |  | null |  |  | Inne budżetowe suma - sekcja E.4
financial_installment | overall_other_public_assistance_amount_percent | numeric | 15,2 | √ |  | null |  |  |
financial_installment | overall_other_public_assistance_amount_sum | numeric | 15,2 | √ |  | null |  |  | Inna pomoc publiczna - suma - sekcja E.4
financial_installment | overall_owns_capital_and_loans_dlsg_amount_percent | numeric | 23,10 | √ |  | null |  |  | Środki własne i pożyczki JST (inne niż z budżetu państwa i z funduszy celowych) procentowo - sekcja E.4
financial_installment | overall_owns_capital_and_loans_dlsg_amount_sum | numeric | 15,2 | √ |  | null |  |  | Środki własne i pożyczki JST (inne niż z budżetu państwa i z funduszy celowych) suma - sekcja E.4
financial_installment | overall_private_capital_amount_percent | numeric | 15,2 | √ |  | null |  |  | Środki prywatne, w tym kredyt - procentowo - sekcja E.4
financial_installment | overall_private_capital_amount_sum | numeric | 15,2 | √ |  | null |  |  | Środki prywatne, w tym kredyt - suma - sekcja E.4
financial_installment | overall_rpo_financing_percent | numeric | 15,2 | √ |  | null |  |  |
financial_installment | overall_rpo_financing_sum | numeric | 15,2 | √ |  | null |  |  | Dofinansowanie z RPO WZ - suma - sekcja E.4
expense | overall_sum | numeric | 15,2 | √ |  | null |  |  | Suma całkowita
financial_installment | overall_sum | numeric | 15,2 | √ |  | null |  |  | Całkowita wartość projektu - sekcja E.2
financing_source | owns_capital_and_loans_dlsg_amount | numeric | 15,2 | √ |  | null |  |  | Środki własne i pożyczki JST
subject_description | partner_subject | bool | 1 | √ |  | null |  |  | Podmiot partnerski
sec_operator | password | varchar | 32 | √ |  | null |  |  | Hasło
pay_project_information | payment_amount | numeric | 15,2 | √ |  | null |  |  | Płatność kwota (A.2)
pay_financing_entry | payment_date | timestamp | 29,6 | √ |  | null |  |  | Data zapłaty (B.1)
pay_financing_entry | payment_evidence | varchar | 200 | √ |  | null |  |  | Dowody wpłaty (B.1)
pay_historical_payment_beneficiary_status | payment_form_beneficiary_status | int4 | 10 |  |  |  |  |  | Status wniosku o płatność
pay_historical_payment_beneficiary_status | payment_form_id | int8 | 19 |  |  |  |  |
pay_payment_form.id | fk923153a372c76184
| Identyfikator
pay_product_realization_indicator | payment_form_id | int8 | 19 |  |  |  |  |
pay_payment_form.id | fk8b5d916f72c76184
| Identyfikator wniosku o płatność
pay_result_realization_indicator | payment_form_id | int8 | 19 |  |  |  |  |
pay_payment_form.id | fk8fd6c7ab72c76184
| Identyfikator wniosku o płatność
pay_schedule_entry | payment_form_id | int8 | 19 |  |  |  |  |
pay_payment_form.id | fka1ebc94172c76184
| Identyfikator wniosku o płatność
pay_payment_form | payment_form_status | int4 | 10 |  |  |  |  |  | Status
pay_payment_form | payment_form_type | int4 | 10 |  |  |  |  |  | Typ wniosku o płatnośc
pay_project_information | payment_type | int4 | 10 |  |  |  |  |  | Rodzaj płatnoci (A.2)
co_financing_amount | pd | numeric | 23,10 | √ |  | null |  |  | Poziom dofinansowania - sekcja E.3.1(.1)
pay_period_definition | period_date | timestamp | 29,6 |  |  |  |  |  | ... za okres (C.3)
pay_project_information | period_date | date | 13 | √ |  | null |  |  | Okres płatności (A.1)
pay_period | period_definition_id | int8 | 19 | √ |  | null |  |
pay_period_definition.id | fk8dd13538a5e9feab
| Identyfikator definicji okresu
pay_invoice | period_id | int8 | 19 |  |  |  |  |
pay_period.id | fkc9a072966c100ac8
| Identyfikator okresu
co_financing_key_result | period_value | numeric | 16,3 | √ |  | null |  |  | Wartość
applicant | pesel | varchar | 16 | √ |  | null |  |  | Numer pesel - sekcja B.6
person | pesel | varchar | 16 | √ |  | null |  |  | Pesel
user_registration | pesel | varchar | 16 | √ |  | null |  |  | PESEL
applicant | pesel_no_concern | bool | 1 | √ |  | null |  |  | Pesel - nie dotyczy
applicant | phone | varchar | 30 | √ |  | null |  |  | Telefon
pay_person_info | phone | varchar | 30 | √ |  | null |  |  | Numer telefonu
person | phone | varchar | 30 | √ |  | null |  |  | Telefon
user_registration | phone | varchar | 16 | √ |  | null |  |  | Telefon
person | phone_mobile | varchar | 30 | √ |  | null |  |  | Telefon komórkowy
user_registration | phone_mobile | varchar | 16 | √ |  | null |  |  | Numer tel. kom.
subject | pkd_code_2004 | varchar | 32 | √ |  | null |  |  | Kod pkd 2004
subject | pkd_code_2007 | varchar | 32 | √ |  | null |  |  | Kod pkd 2007
pay_payment_form | planned_realization_course | varchar | 5000 | √ |  | null |  |  | Planowany przebieg rzeczowy realizacji projektu od czasu złożenia kolejnego wniosku (E.3)
description_of_public_procurement | policy | varchar | 250 | √ |  | null |  |  | Polityka
address | postal_code | varchar | 10 | √ |  | null |  |  | Kod pocztowy
pay_beneficiary_information | postal_code | varchar | 6 | √ |  | null |  |  | Kod pocztowy (A.3)
pay_project_information | priority_axis | varchar | 255 | √ |  | null |  |  | Oś Priorytetowa (A.1)
financing_source | private_capital_amount | numeric | 15,2 | √ |  | null |  |  | Środki prywatne (kwota)
pay_payment_form | problems_info | varchar | 5000 | √ |  | null |  |  | Informacja napotkana na temat problemów napotkanych w trakcie realizacji projektu
pay_financing_entry | product_name | varchar | 100 | √ |  | null |  |  | Nazwa towaru lub usługi (B.1)
pay_payment_form | project_information_id | int8 | 19 | √ |  | null |  |
pay_project_information.id | fke2c2f19495de1e37
| Identyfikator informacji o projekcie
pay_project_information | project_name | varchar | 200 | √ |  | null |  |  | Nazwa projektu
pay_project_information | project_number | varchar | 25 | √ |  | null |  |  | Nr.projektu (A.1)
project_description | project_public_orders | bool | 1 | √ |  | null |  |  | Opis procedur - sekcja C.16
project_description | project_relations | varchar | 3072 | √ |  | null |  |  | Powiązania projektu - sekcja C.15
application_form | project_title | varchar | 256 | √ |  | null |  |  | Tytuł projektu - sekcja 0, B.13
application_form_info | project_title | varchar | 200 | √ |  | null |  |  | Tytuł projektu
pay_payment_form | project_title | varchar | 200 | √ |  | null |  |  | Tytuł projektu (A.1)
user_application_form | project_title | varchar | 256 | √ |  | null |  |  | Tytuł projektu
pay_realization_progress | proportion_percentage | numeric | 25,10 |  |  |  |  |  | Suma: procentowy stosunek wydatków (E.2)
pay_realization_progress_entry | proportion_percentage | numeric | 25,10 |  |  |  |  |  | Procentowy stosunek wydatków
pay_payment_form | proposals_folder_id | int4 | 10 |  |  |  |  |  | Identyfikator teczki projektu
address | province | varchar | 200 | √ |  | null |  |  | Adres - województwo
prerequisite_of_public_assistance | publ_resrc_trans_compet_disturb | bool | 1 | √ |  | null |  |  | Transfer zasobów publicznych - zakłócenie konkursu
prerequisite_of_public_assistance | publ_resrc_trans_compet_disturb_justif | varchar | 4000 | √ |  | null |  |  | Transfer zasobów publicznych - zakłócenie konkursu - uzasadnienie
prerequisite_of_public_assistance | publ_resrc_trans_econ_benefits | bool | 1 | √ |  | null |  |  | Transfer zasobów publicznych - korzyści ekonomiczne
prerequisite_of_public_assistance | publ_resrc_trans_econ_benefits_justif | varchar | 4000 | √ |  | null |  |  | Transfer zasobów publicznych - korzyści ekonomiczne - uzasadnienie
project | public_assistance | bool | 1 | √ |  | null |  |  | Pomoc publiczna - sekcja A.8
prerequisite_of_public_assistance | public_resource_transfer | bool | 1 | √ |  | null |  |  | Transfer zasobów publicznych
application_form | publication_date | timestamp | 29,6 | √ |  | null |  |  | Data publikacji - opublikowane WA, WOP do realizacji
pay_payment_form | publication_date | timestamp | 29,6 | √ |  | null |  |  | Data publikacji
financial_installment | qualified_aggregate_value | numeric | 15,2 | √ |  | null |  |  | Wartość wydatki kwalifikowalne (z wyłączeniem) - sekcja E.2
pay_expense | qualified_amount | numeric | 17,2 |  |  |  |  |  | Czesc kwalifikowana (C.2)
pay_invoice | qualified_amount | numeric | 17,2 |  |  |  |  |  | Część kwalifikowalna (C.4)
pay_expense | qualified_amount_left | numeric | 17,2 |  |  |  |  |  | Część kwalifikowalna / pozostało z projektu
pay_expense | qualified_amount_shift | numeric | 15,10 |  |  |  |  |  | Część kwalifikowalna / przesunięcia między wydatkami
pay_period | qualified_amount_sum | numeric | 17,2 |  |  |  |  |  | Część kwalifikowalna / suma z wniosku
pay_period_definition | qualified_amount_sum_all_periods | numeric | 17,2 |  |  |  |  |  | Część kwalifikowalna - suma po wszystkich okresach
financial_installment | qualified_certificate_aggregate_value | numeric | 15,2 | √ |  | null |  |  | Wartość Wydatki kwalifikowane dotyczące cross - financingu - sekcja E.2
financial_installment | qualified_cross_aggregate_value | numeric | 15,2 | √ |  | null |  |  | Wartość Wydatki na certyfikację - sekcja E.2
pay_financing_entry | qualified_expense_amount | numeric | 17,2 | √ |  | null |  |  | Kwota wydatków kwalifikowalnych (B.1)
pay_project_information | qualified_expense_amount | numeric | 15,2 | √ |  | null |  |  | Kwota wydatków kwlifikowalnych objętych wnioskiem (A.2)
pay_project_information | qualified_expense_percent | numeric | 5,2 | √ |  | null |  |  | % kwoty wydatków kwalifikowalnych (A.2)
pay_financing_information | qualified_expense_sum | numeric | 17,2 |  |  |  |  |  | Kwota wydatków kwalifikowalnych suma ogółem w PLN (B.1)
aggregate_value | qualified_expenses | numeric | 15,2 | √ |  | null |  |  | Wydatki kwalifikowalne
aggregate_value | qualified_expenses_certification | numeric | 15,2 | √ |  | null |  |  | Wydatki kwalifikowalne - certyfikacja
aggregate_value | qualified_expenses_cross_finance | numeric | 15,2 | √ |  | null |  |  | Wydatki kwalifikowalne - cross-financing
expense_year | qualified_part | numeric | 15,2 | √ |  | null |  |  | Część kwalifikowana
expense | qualified_part_sum | numeric | 15,2 | √ |  | null |  |  | Suma części kwalifikowanej
pay_expense | qualified_percent_amount | numeric | 5,2 |  |  |  |  |  | % całkowitej kwoty wydatków kwalifikowalnych
pay_expense_combination | qualified_percent_total_sum | numeric | 5,2 |  |  |  |  |  | Całkowita wartość wydatków kwalifikowalnych/ % całkowitej kwoty wydatków kwalifikowalnych
pay_expense | qualified_period_sum | numeric | 15,2 |  |  |  |  |  | część kwalifikowalna / suma wydatków z wszytkich wniosków o płatność
financial_installment | qualified_sum | numeric | 15,2 | √ |  | null |  |  | Wydatki kwalifikowane suma - E.2
aggregate_value | qualified_total_expenses | numeric | 15,2 | √ |  | null |  |  | Całkowite wydatki kwalifikowalne
pay_expense_combination | qualified_total_sum | numeric | 17,2 |  |  |  |  |  | Całkowita wartość wydatków kwalifikowalnych
expense_year | qualified_vat | numeric | 15,2 | √ |  | null |  |  | Vat kwalifikowany
pay_expense | qualified_vat_amount | numeric | 17,2 |  |  |  |  |  | VAT czesc kwalifikowana (C.2)
pay_invoice | qualified_vat_amount | numeric | 17,2 |  |  |  |  |  | VAT kwalifikowalny (C.4)
pay_expense | qualified_vat_amount_left | numeric | 17,2 |  |  |  |  |  | VAT kwalifikowalny / pozostało z projektu
pay_expense | qualified_vat_amount_shift | numeric | 15,10 |  |  |  |  |  | VAT kwalifikowalny / przesunięcia między wydatkami
pay_period | qualified_vat_amount_sum | numeric | 17,2 |  |  |  |  |  | VAT kwalifikowalny / suma z wniosku
pay_expense | qualified_vat_percent_amount | numeric | 5,2 |  |  |  |  |  | % całkowitej kwoty wydatków kwalifikowalnych
pay_expense | qualified_vat_period_sum | numeric | 15,2 |  |  |  |  |  | VAT kwalifikowalny / suma wydatków z wszytkich wniosków o płatność
expense | qualified_vat_rate | numeric | 15,2 | √ |  | null |  |  | Suma VAT kwalifikowanych
expense | qualified_vat_sum | numeric | 15,2 | √ |  | null |  |  | Suma vatu kwalifikowanego
pay_schedule_quarter_amount | quarter | int4 | 10 |  |  |  |  |  | Kwartał
co_financing_amount | r | numeric | 15,2 | √ |  | null |  |  | Wskaźnik luki finansowej - sekcja E.3.1(.1)
project_description | rating_measure_methods | varchar | 2048 | √ |  | null |  |  | Metody pomiaru wskaźników - sekcja C.14
user_registration_message | read | bool | 1 | √ |  | true |  |  | Czy przeczytane
project_description | realization_commune | bool | 1 | √ |  | null |  |  | Czy projekt jest realizowany w gminie - sekcja C.2
pay_material_financial_phase | realization_general_expense | numeric | 15,2 | √ |  | null |  |  | Wydatki ogółem od początku realizacji projektu (E.1)
pay_material_financial_target | realization_general_expense | numeric | 15,2 | √ |  | null |  |  | Wydatki ogółem od początku realizacji projektu
pay_realization_progress_entry | realization_general_expense | numeric | 15,2 | √ |  | null |  |  | Wydatki ogółem od początku realizacji projektu
pay_material_financial_progress | realization_general_expense_total | numeric | 15,2 |  |  |  |  |  | Ogółem: wydatki ogółem od początku realizacji projektu
pay_realization_progress | realization_general_expense_total | numeric | 15,2 | √ |  | null |  |  | Suma: wydatki ogółem od początku realizacji projektu
pay_material_financial_phase | realization_percentage | numeric | 6,2 |  |  |  |  |  | Procent realizacji (E.1)
pay_material_financial_target | realization_percentage | numeric | 6,2 |  |  |  |  |  | Procent realizacji
pay_product_realization_indicator | realization_percentage | numeric | 15,3 |  |  |  |  |  | Stopień realizacji wskaźnika (%)
pay_result_realization_indicator | realization_percentage | numeric | 15,3 |  |  |  |  |  | Stopień realizacji wskaźnika (%)
pay_material_financial_progress | realization_percentage_total | numeric | 6,2 |  |  |  |  |  | Ogółem: procent realizacji
pay_beneficiary_information | realization_person_id | int8 | 19 | √ |  | null |  |
pay_person_info.id | fk1e0183bb8f16b47
| Identyfikator osoby w części dot. przebiegu realizacji projketu (A.3)
pay_payment_form | realization_progress_id | int8 | 19 | √ |  | null |  |
pay_realization_progress.id | fke2c2f19462ef1d1b
| Identyfikator realizacji
pay_material_financial_phase | realization_qualified_expense | numeric | 15,2 | √ |  | null |  |  | Wydatki kwalifikowane od początku realizacji projektu (E.1)
pay_material_financial_target | realization_qualified_expense | numeric | 15,2 | √ |  | null |  |  | Wydatki kwalifikowane od początku realizacji projektu
pay_realization_progress | realization_qualified_expense | numeric | 15,2 | √ |  | null |  |  | Suma: wydatki kwalifikowane od początku realizacji projektu (E.2)
pay_realization_progress_entry | realization_qualified_expense | numeric | 15,2 | √ |  | null |  |  | Wydatki kwalifikowane od początku realizacji projektu
pay_material_financial_progress | realization_qualified_expense_total | numeric | 15,2 |  |  |  |  |  | Ogółem: wydatki kwalifikowane od początku realizacji projektu
project | realization_start_date | date | 13 | √ |  | null |  |  | Data rozpoczęcia realizacji - sekcja A.11
pay_material_financial_phase | realization_state | varchar | 1000 | √ |  | null |  |  | Stan realizacji (E.1)
pay_attachments_and_statements | reception_documents_copy | int4 | 10 | √ |  | null |  |  | Poświadczone za zgodność z oryginałem kopie dokumentów potwierdzające odbiór/ wykonanie prac (H.1)
pay_financing_entry | record_number | varchar | 30 | √ |  | null |  |  | Numer księgowy lub ewidencyjny (B.1)
contest_info | recruitment_end_date | date | 13 |  |  |  |  |  | Data zakonczenia naboru
contest_info | recruitment_name | varchar | 300 |  |  |  |  |  | Nazwa naboru
contest_info | recruitment_publ_cap_date | date | 13 |  |  |  |  |  |
contest_info | recruitment_start_date | date | 13 |  |  |  |  |  | Data rozpoczęcia naboru
pay_realization_progress | refer | bool | 1 | √ |  | null |  |  | Dotyczy/niedotyczy (E.2)
sec_operator | registered_by | varchar | 256 | √ |  | null |  |  | Dodano przez
sec_operator_role | registered_by | varchar | 256 | √ |  | null |  |  | Dodano przez
sec_permission | registered_by | varchar | 256 | √ |  | null |  |  | Dodano przez
sec_permission_def | registered_by | varchar | 256 | √ |  | null |  |  | Dodano przez
sec_role | registered_by | varchar | 256 | √ |  | null |  |  | Dodano przez
sec_system | registered_by | varchar | 256 | √ |  | null |  |  | Dodano przez
sec_operator | registration_date | timestamp | 29,6 | √ |  | null |  |  | Data dodania
sec_operator_role | registration_date | date | 13 | √ |  | null |  |  | Data dodania
sec_permission | registration_date | date | 13 | √ |  | null |  |  | Data dodania
sec_permission_def | registration_date | date | 13 | √ |  | null |  |  | Data dodania
sec_role | registration_date | date | 13 | √ |  | null |  |  | Data dodania
sec_system | registration_date | date | 13 | √ |  | null |  |  | Data dodania
subject | registration_date | date | 13 | √ |  | null |  |  | Data rejestracji
applicant | regon | varchar | 50 | √ |  | null |  |  | Numer regon - sekcja B.4, B.9
person | regon | varchar | 16 | √ |  | null |  |  | Regon
user_registration | regon | varchar | 16 | √ |  | null |  |  | REGON
subject_description | related_subject | bool | 1 | √ |  | null |  |  | Podmiot związany
pay_project_information | request_amount | numeric | 17,2 | √ |  | null |  |  | Wnioskowana kwota (A.2)
co_financing_amount | requested_de_minimis_amount | numeric | 15,2 | √ |  | null |  |  | Całkowita wnioskowana kwota de minimis - sekcja E.3.2
co_financing_amount | requested_de_minimis_amount_certificate | numeric | 15,2 | √ |  | null |  |  | Wnioskowana kwota de minimis certyfikacja - sekcja E.3.2
co_financing_amount | requested_de_minimis_amount_cross_finance | numeric | 15,2 | √ |  | null |  |  | Wnioskowana kwota de minimis - cross financing - sekcja E.3.2
co_financing_amount | requested_level | numeric | 23,10 | √ |  | null |  |  | Wnioskowany poziom - dofinansowania - sekcja E.3.2
co_financing_amount | requested_overall_amount | numeric | 15,2 | √ |  | null |  |  | Całkowita wnioskowana kwota dofinansowania - sekcja E.3(1 i 2)
co_financing_amount | requested_public_amount | numeric | 15,2 | √ |  | null |  |  | Wnioskowana kwota dofinansowania – pomoc publiczna lub pomoc de minimis (z wyłączeniem cross–financingu, certyfikacji) - sekcja E.3.2
co_financing_key_result | results_costs | numeric | 16,3 | √ |  | null |  |  | Nakłady na rezultaty
project_description | risk_factors | varchar | 4000 | √ |  | null |  |  | Czynniki ryzyka - sekcja C.17
person | role_in_project | varchar | 1000 | √ |  | null |  |  | Rola w projekcie
financing_source | rpo_financing | numeric | 15,2 | √ |  | null |  |  |
pay_schedule_quarter_amount | schedule_entry_id | int8 | 19 |  |  |  |  |
pay_schedule_entry.id | fkd9b8495c47da0d61
| Identyfikator
pay_schedule_entry | schedule_entry_type | int4 | 10 |  |  |  |  |  | Typ
pay_help | section | varchar | 255 | √ |  | null |  |  | Nazwa sekcji
prerequisite_of_public_assistance | selective_public_resource_transfer | bool | 1 | √ |  | null |  |  | Selektywny transfer zasobów publicznych
message | sender | varchar | 200 | √ |  | null |  |  | Nadawca
application_form | signature | varchar | 32 | √ |  | null |  |  | Sygnatura
pay_payment_form | signature | varchar | 32 |  |  |  |  |  | Sygnatura
assistance_de_minimis | source_data | varchar | 1024 | √ |  | null |  |  | Źródło danych
description_of_public_procurement | start_date | date | 13 | √ |  | null |  |  | Data rozpoczęcia
task | start_date | date | 13 | √ |  | null |  |  | Data rozpoczęcia zadania
sec_operator | status | numeric | 1 | √ |  | 1 |  |  | Status
sec_operator_role | status | numeric | 1 | √ |  | 1 |  |  | Status
sec_permission | status | numeric | 1 | √ |  | 1 |  |  | Status
sec_permission_def | status | numeric | 1 | √ |  | 1 |  |  | Status
sec_role | status | numeric | 1 | √ |  | 1 |  |  | Status
sec_system | status | numeric | 1 | √ |  | null |  |  | Status
application_form | status_change_date | timestamp | 29,6 | √ |  | null |  |  | Data zmiany
address | street | varchar | 64 | √ |  | null |  |  | Adres - ulica
pay_beneficiary_information | street | varchar | 64 | √ |  | null |  |  | Ulica (A.3)
description_of_public_procurement | subject | varchar | 500 | √ |  | null |  |  | Podmiot
note | subject | varchar | 100 | √ |  | null |  |  | Temat
subject_description | subject_25_investors | bool | 1 | √ |  | null |  |  | Podmiot 25 inwestorów
subject_description | subject_25_public | bool | 1 | √ |  | null |  |  | Podmiot 25 publiczny
project | subject_managing_product | varchar | 3000 | √ |  | null |  |  | Podmiot zarządzający produktem - sekcja A.7
subject | subject_partners | bool | 1 | √ |  | null |  |  | Podmiot partnerski
subject_description | subject_physical_relationship | bool | 1 | √ |  | null |  |  | Podmiot związek fizyczny
pay_payment_form | suboperation_number | varchar | 8 | √ |  | null |  |  | Numer poddziałania
expense_year | sum | numeric | 15,2 | √ |  | null |  |  | Suma
task | sum | numeric | 15,2 | √ |  | null |  |  | Suma
indicator_description | sum_type | int4 | 10 | √ |  | null |  |  | Typ sumowania
subject | supplement | varchar | 2048 | √ |  | null |  |  | Uzupełnienie
user_registration | surname | varchar | 64 | √ |  | null |  |  | Nazwisko
operator_role_view | system_id | int4 | 10 | √ |  | null |  |  |
pay_product_realization_indicator | target_value | numeric | 18,3 |  |  |  |  |  | Wartość docelowa wskaźnika
pay_result_realization_indicator | target_value | numeric | 18,3 |  |  |  |  |  | Wartość docelowa wskaźnika
pay_expense | task_id | int8 | 19 |  |  |  |  |
pay_task.id | fk6bef7c1ef5017c8
| Identyfikator zadania
message | title | varchar | 200 | √ |  | null |  |  | Tytuł
pay_expense_combination | total_expense_sum | numeric | 17,2 |  |  |  |  |  | Całkowita wartość wydatków kwalifikowalnych / suma wydatków z wszytkich wniosków o płatność
pay_expense_combination | total_left_amount | numeric | 17,2 |  |  |  |  |  | Całkowita wartość wydatków kwalifikowalnych / pozostało z projektu
pay_expense_combination | total_period_sum | numeric | 17,2 |  |  |  |  |  | Całkowita wartość wydatków kwalifikowalnych / suma z wniosku
pay_income | total_sum | numeric | 15,2 | √ |  | null |  |  | Suma ogółem w PLN (D.1)
indicator_description | type | int4 | 10 | √ |  | null |  |  | Typ wskaźnika
task | type | int4 | 10 | √ |  | null |  |  | Typ
pay_realization_progress | unbuilt_real_estate_expense_id | int8 | 19 | √ |  | null |  |
pay_realization_progress_entry.id | fke4c8207d480c6919
| Identyfikator
financial_installment | unqualified_aggregate_value | numeric | 15,2 | √ |  | null |  |  | Wartość wydatki niekwalifikowalne (z wyłączeniem) - sekcja E.2
financial_installment | unqualified_certificate_aggregate_value | numeric | 15,2 | √ |  | null |  |  | Wartość Wydatki niekwalifikowane dotyczące cross - financingu - sekcja E.2
financial_installment | unqualified_cross_aggregate_value | numeric | 15,2 | √ |  | null |  |  | Wydatki niekwalifikowane suma - E.2
aggregate_value | unqualified_expenses | numeric | 15,2 | √ |  | null |  |  | Wydatki niekwalifikowalne
aggregate_value | unqualified_expenses_certification | numeric | 15,2 | √ |  | null |  |  | Wydatki niekwalifikowalne - certyfikacja
aggregate_value | unqualified_expenses_cross_finance | numeric | 15,2 | √ |  | null |  |  | Wydatki niekwalifikowalne - cross-financing
expense_year | unqualified_part | numeric | 15,2 | √ |  | null |  |  | Część niekwalifikowana
expense | unqualified_part_sum | numeric | 15,2 | √ |  | null |  |  | Suma części niekwalifikowanej
financial_installment | unqualified_sum | numeric | 15,2 | √ |  | null |  |  | Wydatki niekwalifikowane suma - E.2
aggregate_value | unqualified_total_expenses | numeric | 15,2 | √ |  | null |  |  | Całkowite wydatki niekwalifikowalne
expense_year | unqualified_vat | numeric | 15,2 | √ |  | null |  |  | Vat niekwalifikowany
expense | unqualified_vat_rate | numeric | 15,2 | √ |  | null |  |  | Współczynnik VAT niekwalifikowanych
expense | unqualified_vat_sum | numeric | 15,2 | √ |  | null |  |  | Suma VAT niekwalifikowanych
pay_payment_form | user_registration_id | int4 | 10 |  |  |  |  |  | Identyfikator informacji o zalogowanym beneficjencie
indicator_type_key_year_value | value | numeric | 15,2 | √ |  | null |  |  | Wartość
indicator_type_product_year_value | value | numeric | 16,3 | √ |  | null |  |  | Wartość
indicator_type_realisation_year_value | value | numeric | 16,3 | √ |  | null |  |  | Wartość
indicator_type_result_year_value | value | numeric | 16,3 | √ |  | null |  |  | Wartość
pay_financing_entry | vat_amount | numeric | 17,2 | √ |  | null |  |  | W tym VAT (B.1)
pay_financing_information | vat_sum | numeric | 17,2 |  |  |  |  |  | W tym VAT suma ogółem w PLN (B.1)
project_description | venture_description | varchar | 5120 | √ |  | null |  |  | Opis przedsięwzięcia - sekcja C.7
pay_payment_form | version | int4 | 10 |  |  |  |  |  | Wersja
applicant | website_url | varchar | 64 | √ |  | null |  |  | Adres url - sekcja B.4
subject_description | women_employment | numeric | 15,2 | √ |  | null |  |  | Zatrudnienie kobiet
project | works_start_date | date | 13 | √ |  | null |  |  | Data rozpoczęcia prac - sekcja A.11
person | www | varchar | 100 | √ |  | null |  |  | Adres www
aggregate_value | year | int4 | 10 | √ |  | null |  |  | Rok
expense_year | year | int4 | 10 | √ |  | null |  |  | Rok
financing_source | year | int4 | 10 | √ |  | null |  |  | Rok
indicator_type_key | year | int4 | 10 | √ |  | null |  |  | Rok
indicator_type_key_year_value | year | int4 | 10 | √ |  | null |  |  | Rok
indicator_type_product | year | int4 | 10 | √ |  | null |  |  | Rok
indicator_type_product_year_value | year | int4 | 10 | √ |  | null |  |  | Rok
indicator_type_realisation | year | int4 | 10 | √ |  | null |  |  | Rok
indicator_type_realisation_year_value | year | int4 | 10 | √ |  | null |  |  | Rok
indicator_type_result | year | int4 | 10 | √ |  | null |  |  | Rok
indicator_type_result_year_value | year | int4 | 10 | √ |  | null |  |  | Rok
pay_schedule_entry | year | int4 | 10 |  |  |  |  |  | Rok
task_aggregate_value | year | int4 | 10 | √ |  | null |  |  | Rok