Tables Relationships Utility Tables Constraints Anomalies Columns Donate

Table frontend.public.application_form Formularz aplikacyjny - (zapisz wersje) | 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('application_form_id_seq'::regclass) |
applicant.id_form | application_form_fk
applicant.id_form_another_project | applicant_form_another_project
evaluation.id_form | evaluation_application
financial_installment.id_form | financial_installment_application_form
form_annex.id_form | form_annex_application
form_statement.id_form | form_statement_application
project.id_form | project_application_form
project_description.id_form | project_description
user_application_form.id_application_form | current_version_application_form
version_application_form.id_form | version_application_form_application_form
|  | Identyfikator
signature | varchar | 32 | √ |  | null |  |  | Sygnatura
checksum | varchar | 40 | √ |  | null |  |  | Suma kontrolna
project_title | varchar | 256 | √ |  | null |  |  | Tytuł projektu - sekcja 0, B.13
publication_date | timestamp | 29,6 | √ |  | null |  |  | Data publikacji - opublikowane WA, WOP do realizacji
deletion_date | date | 13 | √ |  | null |  |  | Data usunięcia
contest_number | varchar | 32 | √ |  | null |  |  | Numer konkursu - sekcja 0
applicant_name | varchar | 500 | √ |  | null |  |  | Nazwa wnioskodawcy
id_status | int4 | 10 | √ |  | null |  |  | Identyfikator statusu
id_folder | int4 | 10 | √ |  | null |  |
folder.id | application_folder
| Identyfikator teczki projektu
id_report | int4 | 10 | √ |  | null |  |  | Identyfikator raportu
id_user | int4 | 10 | √ |  | null |  |
user_registration.id | application_form_owner
| Identyfikator użytkownika
id_user_application_form | int4 | 10 | √ |  | null |  |
user_application_form.id | application_form_history
| Identyfikator użytkownik - formularz aplikacyjny
status_change_date | timestamp | 29,6 | √ |  | null |  |  | Data zmiany
Analyzed at Wed Nov 26 19:04 CET 2008

Indexes:

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

Close relationships within one two degrees of separation: