Table p_foundation
Diagram PartnerClasses 
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
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