Description:
Foundations - a type of ORGANISATION for fundraising proposals.

PRIMARY KEY
p_partner_key_n bigint NOT NULL	ORGANISATION key of the foundation.	p_organisation

p_owner_1_key_n bigint	The Financial Development person who handles appeals to this foundation. Anyone else must get permission from the owner to contact the foundation.	p_partner
p_owner_2_key_n bigint	A second F.D. person who may do business with the foundation.	p_partner
p_key_contact_name_c varchar (70)	Name of the contact for this Foundation
p_key_contact_title_c varchar (70)	The contact person's title.
p_key_contact_email_c varchar (120)	Contact email address
p_key_contact_phone_c varchar (40)	Contact's phone number
p_contact_partner_n bigint	Not part of original specification - provided in case contact does ever need to be a full Partner.	p_partner
p_special_requirements_c varchar (700)
p_proposal_formatting_c varchar (700)
p_proposal_submission_type_c varchar (30)	A lookup table would go with this. e.g. EMAIL, LETTER.	p_proposal_submission_type
p_special_instructions_c varchar (700)
p_review_frequency_c varchar (20)	(Monthly \| Quarterly \| Annually) These are the only ones we use now.
p_submit_frequency_c varchar (30)	(Annually \| Bi-Annually \| No Restrictions) This is a static list.
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_foundation_contact_fk1: p_contact_partner_n => p_partner p_foundation_fk1: p_partner_key_n => p_organisation p_foundation_fkcr: s_created_by_c => s_user p_foundation_fkmd: s_modified_by_c => s_user p_foundation_owner_fk1: p_owner_1_key_n => p_partner p_foundation_submission_fk1: p_proposal_submission_type_c => p_proposal_submission_type p_foundation_owner_fk2: p_owner_2_key_n => p_partner
REFERENCED BY p_foundation_proposal, p_foundation_proposal_detail, p_foundation_deadline