Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table frontend.public.pay_realization_progress Wniosek o Płatność - Postęp rzeczowo-finansowy realizacji projektu (E.2) - suma | Generated by SchemaSpy

Related columns Constraint names Comments Legend |
Legend: |
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | bigserial | 19 |  | √ | nextval('pay_realization_progress_id_seq'::regclass) |
pay_payment_form.realization_progress_id | fke2c2f19462ef1d1b
|  | Identyfikator
refer | bool | 1 | √ |  | null |  |  | Dotyczy/niedotyczy (E.2)
realization_general_expense_total | numeric | 15,2 | √ |  | null |  |  | Suma: wydatki ogółem od początku realizacji projektu
realization_qualified_expense | numeric | 15,2 | √ |  | null |  |  | Suma: wydatki kwalifikowane od początku realizacji projektu (E.2)
assistance_qualified_expense | numeric | 15,2 | √ |  | null |  |  | Suma: całkowite wydatki kwalifikujące się do objęcia wsparciem (E.2)
proportion_percentage | numeric | 25,10 |  |  |  |  |  | Suma: procentowy stosunek wydatków (E.2)
built_real_state_expense_id | int8 | 19 | √ |  | null |  |
pay_realization_progress_entry.id | fke4c8207dee2de9b
| Identyfikator
material_expense_id | int8 | 19 | √ |  | null |  |
pay_realization_progress_entry.id | fke4c8207d8b0576c5
| Identyfikator wydatków materialnych
group_1_expense_id | int8 | 19 | √ |  | null |  |
pay_realization_progress_entry.id | fke4c8207d5aefab3b
| Identyfikator
unbuilt_real_estate_expense_id | int8 | 19 | √ |  | null |  |
pay_realization_progress_entry.id | fke4c8207d480c6919
| Identyfikator
Analyzed at Wed Nov 26 19:04 CET 2008

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id | Primary key | Asc | pay_realization_progress_pkey

Close relationships within one two degrees of separation: