Table openpetra_trunk.public.p_foundation_proposal_detail
A proposal may be for more than one project or key ministry.

 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_foundation_partner_key_n numeric 10
p_foundation_proposal.p_foundation_partner_key_n p_detail_proposal_fk1 R
p_foundation.p_partner_key_n p_detail_proposal_fk2 R
p_foundation_proposal_key_i int4 10
p_foundation_proposal.p_foundation_proposal_key_i p_detail_proposal_fk1 R
p_proposal_detail_id_i int4 10
p_key_ministry_key_n numeric 10  √  null
p_unit.p_partner_key_n p_proposal_ministry_fk1 R
Used when the proposal is for a key ministry
p_project_ledger_number_i int4 10  √  null
a_motivation_detail.a_ledger_number_i p_proposal_motivation_fk1 R
Ledger is part of the primary key for motivations.
p_project_motivation_group_c varchar 16  √  null
a_motivation_detail.a_motivation_group_code_c p_proposal_motivation_fk1 R
Used when the proposal is for a project
p_project_motivation_detail_c varchar 16  √  null
a_motivation_detail.a_motivation_detail_code_c p_proposal_motivation_fk1 R
Used when the proposal is for a project
p_area_partner_key_n numeric 10  √  null
p_unit.p_partner_key_n p_area_fk1 R
The area that the project or key ministry is for
p_field_partner_key_n numeric 10  √  null
p_unit.p_partner_key_n p_field_fk1 R
The field that the project or key ministry is for if it applies
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c p_foundation_proposal_detail_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c p_foundation_proposal_detail_fkmd R
s_modification_id_c varchar 150  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
p_foundation_partner_key_n + p_foundation_proposal_key_i + p_proposal_detail_id_i Primary key Asc/Asc/Asc p_proposal_detail_pk
p_project_ledger_number_i + p_project_motivation_group_c + p_project_motivation_detail_c Performance Asc/Asc/Asc inx__proposal_motivation_fk1_key8
s_created_by_c Performance Asc inx_ion_proposal_detail_fkcr_key5
s_modified_by_c Performance Asc inx_ion_proposal_detail_fkmd_key6
p_area_partner_key_n Performance Asc inx_p_area_fk1_key1
p_foundation_partner_key_n + p_foundation_proposal_key_i Performance Asc/Asc inx_p_detail_proposal_fk1_key2
p_foundation_partner_key_n Performance Asc inx_p_detail_proposal_fk2_key4
p_field_partner_key_n Performance Asc inx_p_field_fk1_key3
p_foundation_partner_key_n + p_foundation_proposal_key_i + p_proposal_detail_id_i Must be unique Asc/Asc/Asc inx_p_proposal_detail_pk0
p_key_ministry_key_n Performance Asc inx_p_proposal_ministry_fk1_key7

Close relationships  within of separation: