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 |