Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table backend_dev.public.evaluation_annual_information_entry Badanie w informacji dot. działań za rok | 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('evaluation_annual_information_entry_id_seq'::regclass) |  |  | Identyfikator
cost | numeric | 17,2 | √ |  | null |  |  | Koszt badania
currency | int4 | 10 | √ |  | null |  |  | Waluta: PLN(0), EUR(1)
executor | varchar | 200 | √ |  | null |  |  | Nazwa wykonawcy badania
opinion | varchar | 5000 | √ |  | null |  |  | Uwagi
notice | varchar | 5000 | √ |  | null |  |  | Wdrożone rekomendacje/ Ocena użyteczności rekomendacji
annual_information_id | int8 | 19 |  |  |  |  |
evaluation_annual_information.id | fke16df8e269904e78
| Identyfikator informacji dot. działań za rok
analysis_id | int8 | 19 |  |  |  |  |
evaluation_analysis.id | fke16df8e211f2b060
| Identyfikator badania ewaluacyjnego
deadline | varchar | 1000 | √ |  | null |  |  | Termin realizacji
Analyzed at Wed Nov 26 19:06 CET 2008

Indexes:

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

Close relationships within one two degrees of separation: