Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table backend_dev.public.contract_data Informacje dotyczące 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_data_id_seq'::regclass) |
contract_note.contract_data_id | fke17332ffd5c1e875
|  | Identyfikator informacji ogólnych
priority_axis_number | varchar | 264 |  |  |  |  |  | Numer osi priorytetowej
operation_number | varchar | 264 |  |  |  |  |  | Numer działania
suboperation_number | varchar | 264 |  |  |  |  |  | Numer poddziałania
project_title | varchar | 200 |  |  |  |  |  | Tytuł projektu
contract_number | varchar | 200 |  |  |  |  |  | Numer umowy/decyzji
signature | varchar | 200 |  |  |  |  |  | Sygnatura umowy
deposit_date | timestamp | 29,6 | √ |  | null |  |  | Data wniesienia zabezpieczenia
signing_date | timestamp | 29,6 |  |  |  |  |  | Data podpisania umowy
description | varchar | 3000 | √ |  | null |  |  | Uwagi
Analyzed at Wed Nov 26 19:06 CET 2008

Indexes:

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

Close relationships within one two degrees of separation: