Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table frontend.public.project_description Opis projektu - sekcja C | 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 | 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
id_form | int4 | 10 | √ |  | null |  |
application_form.id | project_description
| Identyfikator wniosku
id_area_type | int4 | 10 | √ |  | null |  |
area_type.id | project_decription_area_type
| Identyfikator typu obszaru
concerns_no | bool | 1 | √ |  | null |  |  | (Lokalizacja projektu) dotyczy/nie dotyczy - sekcja C.1
realization_commune | bool | 1 | √ |  | null |  |  | Czy projekt jest realizowany w gminie - sekcja C.2
amount_aard_2007_2013 | bool | 1 | √ |  | null |  |  | Kwota PROW 2007-2013 - sekcja C.4
amount_aard_2007_2013_value | numeric | 15,2 | √ |  | null |  |  | Kwota PROW 2007-2013 - wartość - sekcja C.4
alternative_realization | varchar | 3072 | √ |  | null |  |  | Alternatywna realizacja - sekcja C.5
goals_and_conformance_with_rpo_wz | varchar | 3072 | √ |  | null |  |  | Cele i zgodność z RPO WZ - sekcja C.6
venture_description | varchar | 5120 | √ |  | null |  |  | Opis przedsięwzięcia - sekcja C.7
justification_and_results | varchar | 5120 | √ |  | null |  |  | Uzasadnienie i rezultaty - sekcja sekcja C.8
descr_justif_operation_cross_finance | varchar | 3072 | √ |  | null |  |  | Opis uzasadnienia działań cross-finansingu - sekcja C.9
rating_measure_methods | varchar | 2048 | √ |  | null |  |  | Metody pomiaru wskaźników - sekcja C.14
project_relations | varchar | 3072 | √ |  | null |  |  | Powiązania projektu - sekcja C.15
project_public_orders | bool | 1 | √ |  | null |  |  | Opis procedur - sekcja C.16
justification_for_no_public_procurement | varchar | 2048 | √ |  | null |  |  | Uzasadnienie braku zamówień publicznych - sekcja C.16
co_financing_key_result_concerns | bool | 1 | √ |  | null |  |  | Wartość dofinansowania z RPO WZ przypadająca na kluczowe rezultaty - dotyczy/nie dotyczy - sekcja C.12
risk_factors | varchar | 4000 | √ |  | null |  |  | Czynniki ryzyka - sekcja C.17
Analyzed at Wed Nov 26 19:04 CET 2008

Indexes:

Column(s) | Type | Sort | Constraint Name | Anomalies
--- | --- | --- | --- | ---
id | Primary key | Asc | project_description_pkey |
id_form | Must be unique | Asc | project_description_id_form_unique | This unique column is also nullable

Close relationships within one two degrees of separation: