Table openpetra_trunk.public.p_foundation
Foundations - a type of ORGANISATION for fundraising proposals.

 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_partner_key_n numeric 10
p_foundation_deadline.p_foundation_partner_key_n p_foundation_deadline_fk1 R
p_foundation_proposal.p_foundation_partner_key_n p_proposal_status_fk1 R
p_foundation_proposal_detail.p_foundation_partner_key_n p_detail_proposal_fk2 R
p_organisation.p_partner_key_n p_foundation_fk1 R
ORGANISATION key of the foundation.
p_owner_1_key_n numeric 10  √  null The Financial Development person who handles appeals to this foundation. Anyone else must get permission from the owner to contact the foundation.
p_owner_2_key_n numeric 10  √  null A second F.D. person who may do business with the foundation.
p_key_contact_name_c varchar 70  √  null Name of the contact for this Foundation
p_key_contact_title_c varchar 70  √  null The contact person's title.
p_key_contact_email_c varchar 120  √  null Contact email address
p_key_contact_phone_c varchar 40  √  null Contact's phone number
p_contact_partner_n numeric 10  √  null
p_partner.p_partner_key_n p_foundation_contact_fk1 R
Not part of original specification - provided in case contact does ever need to be a full Partner.
p_special_requirements_c varchar 700  √  null
p_proposal_formatting_c varchar 700  √  null
p_proposal_submission_type_c varchar 30  √  null
p_proposal_submission_type.p_submission_type_code_c p_foundation_submission_fk1 R
A lookup table would go with this. e.g. EMAIL, LETTER.
p_special_instructions_c varchar 700  √  null
p_review_frequency_c varchar 20  √  null (Monthly | Quarterly | Annually) These are the only ones we use now.
p_submit_frequency_c varchar 30  √  null (Annually | Bi-Annually | No Restrictions) This is a static list.
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c p_foundation_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c p_foundation_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_partner_key_n Primary key Asc p_foundation_pk
p_proposal_submission_type_c Performance Asc inx_oundation_submission_fk1_key4
p_contact_partner_n Performance Asc inx_p_foundation_contact_fk1_key1
s_created_by_c Performance Asc inx_p_foundation_fkcr_key2
s_modified_by_c Performance Asc inx_p_foundation_fkmd_key3
p_partner_key_n Must be unique Asc inx_p_foundation_pk0

Close relationships  within of separation: