Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table backend_dev.public.ksi_import_history Import KSI - historia | 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('ksi_import_history_id_seq'::regclass) |  |  | id importu
type | int4 | 10 |  |  |  |  |  | Typ dokumentu importowanego; 0 - wniosek o płtnośu263 , 1 - umowa, 2 - aneks, 3 - wniosek o płtnośu263 , 4 - kontrola
signature | varchar | 255 | √ |  | null |  |  | sygnatura dokumentu importowanego - jeżli istnieje dla danego typu
checksum | varchar | 255 | √ |  | null |  |  | suma kontrolna dokumentu importowanego - jeżli istnieje dla danego typu
import_date | timestamp | 29,6 |  |  |  |  |  | data importu dokumentu
event_date | timestamp | 29,6 |  |  |  |  |  | data zdarzenia wprowadzenia do historii importu dokumentu
login | varchar | 255 | √ |  | null |  |  | nazwa użtkownika wprowadzająego do historii importu
status | varchar | 255 | √ |  | null |  |  | status dokumentu w momencie zdarzenia wprowadzania do historii importu
id_proposals_folder | int8 | 19 |  |  |  |  |
proposals_folder.id | fk1cb235f8eec96b99
| teczka projektu dla której tworzona jest historia importu
Analyzed at Wed Nov 26 19:06 CET 2008

Indexes:

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

Close relationships within one two degrees of separation: