Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table frontend.public.pay_project_information Wniosek o Płatność - informacje o projekcie | 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_project_information_id_seq'::regclass) |
pay_payment_form.project_information_id | fke2c2f19495de1e37
|  | Identyfikator
period_date | date | 13 | √ |  | null |  |  | Okres płatności (A.1)
priority_axis | varchar | 255 | √ |  | null |  |  | Oś Priorytetowa (A.1)
project_name | varchar | 200 | √ |  | null |  |  | Nazwa projektu
project_number | varchar | 25 | √ |  | null |  |  | Nr.projektu (A.1)
is_agreement | bool | 1 | √ |  | null |  |  | Umowa/ decyzja (A.2)
cofinancing_number | varchar | 30 | √ |  | null |  |  | Umowa/ decyzja o dofinansowaniu nr (A.2)
cofinancing_date | timestamp | 29,6 | √ |  | null |  |  | Umowa/ decyzja z dnia (A.2)
cofinancing_amount | numeric | 15 | √ |  | null |  |  | Kwota dofinansowania (A.2)
cofinancing_amount_inwords | varchar | 200 | √ |  | null |  |  | Kwota dofinansowania - słownie (A.2)
qualified_expense_percent | numeric | 5,2 | √ |  | null |  |  | % kwoty wydatków kwalifikowalnych (A.2)
payment_type | int4 | 10 |  |  |  |  |  | Rodzaj płatnoci (A.2)
payment_amount | numeric | 15,2 | √ |  | null |  |  | Płatność kwota (A.2)
qualified_expense_amount | numeric | 15,2 | √ |  | null |  |  | Kwota wydatków kwlifikowalnych objętych wnioskiem (A.2)
request_amount | numeric | 17,2 | √ |  | null |  |  | Wnioskowana kwota (A.2)
Analyzed at Wed Nov 26 19:04 CET 2008

Indexes:

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

Close relationships within one two degrees of separation: