Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table backend_dev.public.proposal Proposal - wniosek aplikacyjny (po publikacji) po stronie officiala | 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('proposal_id_seq'::regclass) |
ctrl_control.id_proposal | fk8c2e33894d642b0e
ctrl_fraud.id_proposal | fke2bf13904d642b0e
deposit.proposal_id | fk5ca7169e673bd700
historical_proposal_status.proposal_id | fke4522c6a673bd700
legal_opinion.proposal_id | fkee90f3fc673bd700
proposals_folder.proposal_id | fk516d9aac673bd700
|  | Identyfikator
proposal_status | int4 | 10 |  |  |  |  |  | Status wniosku
version_number | int4 | 10 |  |  |  |  |  | Numer wersji
signature | varchar | 32 | √ |  | null |  |  | Podpis
registration_date | timestamp | 29,6 | √ |  | null |  |  | Data rejestracji
publication_date | timestamp | 29,6 | √ |  | null |  |  | Data publikacji
rejection_date | timestamp | 29,6 | √ |  | null |  |  | Data odrzucenia wniosku
historical | bool | 1 |  |  |  |  |  | Czy historyczny
application_form_id | int4 | 10 |  |  |  |  |  | Identyfikator formularza aplikacyjnego
checksum | varchar | 40 |  |  |  |  |  | Suma kontrolna
project_title | varchar | 256 |  |  |  |  |  | Tytuł projektu
operation_number | varchar | 8 |  |  |  |  |  | Numer działania
applicant_name | varchar | 500 |  |  |  |  |  | Nazwa wnioskodawcy
cofinancing_amount | numeric | 15,2 |  |  |  |  |  | Wartość dofinansowania
aplicant_email | varchar | 100 |  |  |  |  |  | Email wnioskodawcy
contest_number | varchar | 100 |  |  |  |  |  | Numer konkursu
change_date | timestamp | 29,6 |  |  |  |  |  | Data zmiany
changed_by | varchar | 255 |  |  |  |  |  | Zmienione przez
is_deposit_allowed | bool | 1 | √ |  | null |  |  |
document_content_id | int4 | 10 |  |  |  |  |
document_content.id | fkc4d26af2d96dedd7
| Identyfikator dokumentu załącznika
formal_opinion_id | int8 | 19 | √ |  | null |  |
formal_opinion.id | fkc4d26af284dd83a4
| Identyfikator oceny formalnej
proposals_folder_id | int8 | 19 | √ |  | null |  |
proposals_folder.id | fkc4d26af26c37c9d7
| Identyfikator teczki wniosków
legal_opinion_id | int8 | 19 | √ |  | null |  |
legal_opinion.id | fkc4d26af234b931fa
| Identyfikator oceny prawnej
merits_opinion_id | int8 | 19 | √ |  | null |  |
merits_opinion.id | fkc4d26af28ba93026
| Identyfikator oceny merytorycznej
ksi_number | varchar | 200 | √ |  | null |  |  |
Analyzed at Wed Nov 26 19:06 CET 2008

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id | Primary key | Asc | proposal_pkey
application_form_id | Must be unique | Asc | proposal_application_form_id_key
document_content_id | Must be unique | Asc | proposal_document_content_id_key

Close relationships within one two degrees of separation: