Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table backend_dev.public.contract_note Karta umowy | 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('contract_note_id_seq'::regclass) |
contract.contract_note_id | fkde351112feaaa375
contract_annex.contract_note_id | fk4c3b70e7feaaa375
note_document_content.id_contract_note | fke52bb60273183ff5
realization_location.contract_note_id | fkf2511acefeaaa375
|  | Identyfikator karty umowy
realization_location_description | varchar | 255 | √ |  | null |  |  | Identyfikator miejsca realizacji projektu
project_durability_id | int4 | 10 | √ |  | null |  |
project_durability.id | fke17332ffc8ad6f37
| Identyfikator harmonogramu projektu
beneficiary_data_id | int4 | 10 | √ |  | null |  |
beneficiary_data.id | fke17332ff372529ef
| Identyfikator informacji o beneficjencie
financial_assistance_id | int4 | 10 | √ |  | null |  |
financial_assistance.id | fke17332ff9f4171e1
| Identyfikator pomocy publicznej i deminimis
realization_period_id | int4 | 10 | √ |  | null |  |
realization_period.id | fke17332ff5b13cf91
| Identyfikator okresu realizacji projektu
advanced_payment_data_id | int4 | 10 | √ |  | null |  |
advance_payment_data.id | fke17332ff5117fde
| Identyfikator danych dotyczacych zaliczki
contract_data_id | int4 | 10 | √ |  | null |  |
contract_data.id | fke17332ffd5c1e875
| Identyfikator informacji ogólnych
financial_plan_id | int4 | 10 | √ |  | null |  |
financial_plan.id | fke17332ff1e8a4557
| Identyfikator planu finansowego
Analyzed at Wed Nov 26 19:06 CET 2008

Indexes:

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

Close relationships within one two degrees of separation: