Table backend_dev.public.pay_payment_form_official
Wniosek o Płatność

Generated by
SchemaSpy
Legend: SourceForge.net
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 of separation: