Table p_foundation_proposal_detail

Description:
A proposal may be for more than one project or key ministry.

PRIMARY KEY
p_foundation_partner_key_n bigint NOT NULL		p_foundation_proposal, p_foundation
p_foundation_proposal_key_i integer NOT NULL		p_foundation_proposal
p_proposal_detail_id_i integer NOT NULL

p_key_ministry_key_n bigint	Used when the proposal is for a key ministry	p_unit
p_project_ledger_number_i integer	Ledger is part of the primary key for motivations.	a_motivation_detail
p_project_motivation_group_c varchar (16)	Used when the proposal is for a project	a_motivation_detail
p_project_motivation_detail_c varchar (16)	Used when the proposal is for a project	a_motivation_detail
p_area_partner_key_n bigint	The area that the project or key ministry is for	p_unit
p_field_partner_key_n bigint	The field that the project or key ministry is for if it applies	p_unit
s_date_created_d date default: CURRENT_DATE	The date the record was created.
s_created_by_c varchar (20)	User ID of who created this record.	s_user
s_date_modified_d date	The date the record was modified.
s_modified_by_c varchar (20)	User ID of who last modified this record.	s_user
s_modification_id_t timestamp default: CURRENT_TIMESTAMP	This identifies the current version of the record.
FOREIGN KEY p_area_fk1: p_area_partner_key_n => p_unit p_detail_proposal_fk1: p_foundation_partner_key_n;p_foundation_proposal_key_i => p_foundation_proposal p_field_fk1: p_field_partner_key_n => p_unit p_proposal_ministry_fk1: p_key_ministry_key_n => p_unit p_proposal_motivation_fk1: p_project_ledger_number_i;p_project_motivation_group_c;p_project_motivation_detail_c => a_motivation_detail p_detail_proposal_fk2: p_foundation_partner_key_n => p_foundation p_foundation_proposal_detail_fkcr: s_created_by_c => s_user p_foundation_proposal_detail_fkmd: s_modified_by_c => s_user