Table openpetra_trunk.public.pm_application_forms
This table contains the list of forms sent or received during the application process.

 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
p_partner_key_n numeric 10 0
pm_application_forms_file.p_partner_key_n pm_application_forms_file_fk2 R
pm_general_application.p_partner_key_n pm_application_forms_fk1 R
This is the partner key assigned to each partner. It consists of the fund id followed by a computer generated six digit number.
pm_application_key_i int4 10 0
pm_application_forms_file.pm_application_key_i pm_application_forms_file_fk2 R
pm_general_application.pm_application_key_i pm_application_forms_fk1 R
Key to uniquely identify application
pm_registration_office_n numeric 10 0
pm_application_forms_file.pm_registration_office_n pm_application_forms_file_fk2 R
pm_general_application.pm_registration_office_n pm_application_forms_fk1 R
Partner key of office by which application was entered.
pt_form_name_c varchar 32
pm_application_forms_file.pt_form_name_c pm_application_forms_file_fk2 R
pt_app_form_types.pt_form_name_c pm_application_forms_fk2 R
Indicates the name of the form.
pm_form_sent_l bool 1  √  false Indicates if the form was sent.
pm_form_received_l bool 1  √  false Indicates if this form was received.
pm_form_delete_flag_l bool 1  √  false This field will not appear on the screen but will be updated when someone chooses to delete a record. Rather that an actual deletion, the record will be 'marked' for deletion after an agreed upon interval.
pm_form_edited_l bool 1 false Indicates if the form was edited.
pm_form_sent_date_d date 13  √  null Date the form was sent.
pm_form_received_date_d date 13  √  null Date the form was received.
pm_reference_partner_key_n numeric 10  √  null
p_partner.p_partner_key_n pm_application_forms_fk3 R
This is the reference partner for this application form.
pm_comment_c varchar 1000  √  null Comments
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c pm_application_forms_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c pm_application_forms_fkmd R
s_modification_id_c varchar 150  √  null

Table contained 1.558.146 rows at Do Nov 10 18:00 MEZ 2011

Indexes:
Column(s) Type Sort Constraint Name
p_partner_key_n + pm_application_key_i + pm_registration_office_n + pt_form_name_c Primary key Asc/Asc/Asc/Asc pm_application_forms_pk
p_partner_key_n Performance Asc af_partner_k0
s_created_by_c Performance Asc inx_m_application_forms_fkcr_key4
s_modified_by_c Performance Asc inx_m_application_forms_fkmd_key5
p_partner_key_n + pm_application_key_i + pm_registration_office_n Performance Asc/Asc/Asc inx_pm_application_forms_fk1_key1
pt_form_name_c Performance Asc inx_pm_application_forms_fk2_key2
pm_reference_partner_key_n Performance Asc inx_pm_application_forms_fk3_key3
p_partner_key_n + pm_application_key_i + pm_registration_office_n + pt_form_name_c Must be unique Asc/Asc/Asc/Asc inx_pm_application_forms_pk0

Close relationships  within of separation: