Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table backend_dev.public.contract Umowa | 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_id_seq'::regclass) |
contract_annex.contract_id | fk4c3b70e7249c812d
historical_contract_status.contract_id | fkd7ee624a249c812d
proposals_folder.contract_id | fk516d9aac249c812d
|  | Identyfikator umowy
historical | bool | 1 |  |  |  |  |  |
version_number | int4 | 10 |  |  |  |  |  | Wersja umowy
signature | varchar | 255 |  |  |  |  |  | Sygnatura
contract_status | int4 | 10 | √ |  | null |  |  | Status umowy
contract_number | varchar | 200 |  |  |  |  |  | Numer umowy/decyzji
confirmation_date | timestamp | 29,6 |  |  |  |  |  | Data zatwierdzenia
responsible_office_1 | varchar | 200 |  |  |  |  |  | Biuro odpowiedzialne 1
responsible_office_2 | varchar | 200 |  |  |  |  |  | Biuro odpowiedzialne 2
responsible_office_3 | varchar | 200 |  |  |  |  |  | Biuro odpowiedzialne 3
signing_date | timestamp | 29,6 | √ |  | null |  |  | Data podpisania umowy
description | varchar | 3000 | √ |  | null |  |  | Uwagi
registration_date | timestamp | 29,6 |  |  |  |  |  | Data rejestracji
registered_by | varchar | 255 |  |  |  |  |  | Osoba rejestrujaca
completed | bool | 1 | √ |  | null |  |  | Czy umowa jest kompletna
check_list_content_id | int4 | 10 |  |  |  |  |
document_content.id | fkde3511126218793d
| Identyfikator listy sprawdzającej
contract_note_id | int4 | 10 | √ |  | null |  |
contract_note.id | fkde351112feaaa375
| Identyfikator karty umowy
contract_content_id | int4 | 10 | √ |  | null |  |
document_content.id | fkde3511129baedd80
| Czy kontakt jest historyczny
proposals_folder_id | int8 | 19 | √ |  | null |  |
proposals_folder.id | fkde3511126c37c9d7
| Identyfikator teczki projektu
ksi_number | varchar | 200 | √ |  | null |  |  |
next_number | int4 | 10 | √ |  | null |  |  |
Analyzed at Wed Nov 26 19:06 CET 2008

Indexes:

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

Close relationships within one two degrees of separation: