Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table backend_dev.public.pay_payment_form_official Wniosek o Płatność | 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('pay_payment_form_official_id_seq'::regclass) |
pay_historical_payment_status.payment_form_id | fk4df1d3897d69d204
pay_payment_invoice.payment_form_official_id | fk19076c5df45fedd4
|  | Identyfikator
signature | varchar | 32 | √ |  | null |  |  | Sygnatura
correction_number | varchar | 32 | √ |  | null |  |  | Numer korekty
checksum | varchar | 40 | √ |  | null |  |  | Suma kontrolna
project_title | varchar | 200 | √ |  | null |  |  | Tytuł projektu
contest_number | varchar | 32 | √ |  | null |  |  | Numer konkursu
applicant_name | varchar | 500 | √ |  | null |  |  | Nazwa beneficjenta
operation_number | varchar | 255 | √ |  | null |  |  | Numer działania
suboperation_number | varchar | 255 | √ |  | null |  |  | Number poddziałania
period_date | timestamp | 29,6 | √ |  | null |  |  | Okres wniosku o płatność
form_number | varchar | 32 | √ |  | null |  |  | Sygnatura wniosku o płatność
receive_date | timestamp | 29,6 |  |  |  |  |  | Data pobrania
registration_date | timestamp | 29,6 | √ |  | null |  |  | Data rejestracji
publication_date | timestamp | 29,6 | √ |  | null |  |  | Data publikacji
receive_person | varchar | 100 | √ |  | null |  |  | Osoba pobierająca wniosek
app_payment_form_id | int8 | 19 |  |  |  |  |  | Identyfikator
payment_form_status | int4 | 10 |  |  |  |  |  | Status wniosku o płatność
bank_transfer_date | timestamp | 29,6 | √ |  | null |  |  | Data wykonania przelewu
payment_form_type | int4 | 10 |  |  |  |  |  | Typ wniosku o płatność
opinion_id | int8 | 19 | √ |  | null |  |
pay_payment_opinion.id | fk4d39613658a59682
| Identyfikator oceny
document_content_id | int4 | 10 |  |  |  |  |
document_content.id | fk4d396136d96dedd7
| Identyfikator załącznika
proposals_folder_id | int8 | 19 | √ |  | null |  |
proposals_folder.id | fk4d3961366c37c9d7
| Identyfikator teczki projektu
financing_source_id | int8 | 19 | √ |  | null |  |
pay_financing_source_official.id | fk4d396136a3c4fc86
| Identyfikator źródła finansowania
project_information_id | int8 | 19 | √ |  | null |  |
pay_project_information_official.id | fk4d39613651a2340
| Identyfikator informacji o projekcie
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 | pay_payment_form_official_pkey
app_payment_form_id | Must be unique | Asc | pay_payment_form_official_app_payment_form_id_key
document_content_id | Must be unique | Asc | pay_payment_form_official_document_content_id_key

Close relationships within one two degrees of separation: