Table frontend.public.application_form
Formularz aplikacyjny - (zapisz wersje)

 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 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 of separation: