Table openpetra_trunk.public.p_partner
This is the main table of the partner system. Partners can be individuals, families, organisations (churches, businesses), fields, cost centers, and others. These represent various classes of partners.

 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 0
a_ap_supplier.p_partner_key_n a_ap_supplier_fk1 R
a_ar_invoice.p_partner_key_n a_ar_invoice_fk1 R
a_email_destination.p_partner_key_n a_email_destination_fk1 R
a_ep_match.a_recipient_ledger_number_n a_ep_match_fk4 R
a_ep_match.p_donor_key_n a_ep_match_fk8 R
a_ep_match.p_recipient_key_n a_ep_match_fk2 R
a_gift.p_donor_key_n a_gift_fk4 R
a_gift_detail.a_recipient_ledger_number_n a_gift_detail_fk5 R
a_gift_detail.p_recipient_key_n a_gift_detail_fk3 R
a_motivation_detail.p_recipient_key_n a_motivation_detail_fk4 R
a_recurring_gift.p_donor_key_n a_recurring_gift_fk4 R
a_recurring_gift_detail.a_recipient_ledger_number_n a_recurring_gift_detail_fk5 R
a_recurring_gift_detail.p_recipient_key_n a_recurring_gift_detail_fk3 R
a_valid_ledger_number.a_ilt_processing_centre_n a_valid_ledger_number_fk3 R
a_valid_ledger_number.p_partner_key_n a_valid_ledger_number_fk2 R
m_extract.p_partner_key_n m_extract_fk2 R
p_bank.p_contact_partner_key_n p_bank_fk2 R
p_bank.p_partner_key_n p_bank_fk1 R
p_church.p_contact_partner_key_n p_church_fk3 R
p_church.p_partner_key_n p_church_fk1 R
p_customised_greeting.p_partner_key_n p_customised_greeting_fk1 R
p_data_label_value_application.p_value_partner_key_n p_data_label_value_application_fk3 R
p_data_label_value_partner.p_partner_key_n p_data_label_value_partner_fk1 R
p_data_label_value_partner.p_value_partner_key_n p_data_label_value_partner_fk3 R
p_family.p_partner_key_n p_family_fk1 R
p_file_info.p_partner_key_n p_file_info_fk1 R
p_form_letter_insert.p_partner_key_n p_form_letter_insert_fk2 R
p_foundation.p_contact_partner_n p_foundation_contact_fk1 R
p_foundation_proposal.p_partner_submitted_by_n p_proposal_submitted_fk3 R
p_organisation.p_contact_partner_key_n p_organisation_fk3 R
p_organisation.p_partner_key_n p_organisation_fk1 R
p_partner_action.p_partner_key_n p_partner_action_fk1 R
p_partner_attribute.p_partner_key_n p_partner_attribute_fk1 R
p_partner_banking_details.p_partner_key_n p_partner_banking_link_fk1 R
p_partner_comment.p_partner_key_n p_partner_comment_fk1 R
p_partner_contact.p_partner_key_n p_partner_contact_fk1 R
p_partner_contact_file.p_partner_key_n p_partner_contact_file_fk1 R
p_partner_field_of_service.p_partner_key_n p_partner_field_of_service_fk1 R
p_partner_file.p_partner_key_n p_partner_file_fk1 R
p_partner_graphic.p_partner_key_n p_partner_graphic_fk1 R
p_partner_interest.p_partner_key_n p_partner_interest_fk1 R
p_partner_location.p_partner_key_n p_partner_location_fk1 R
p_partner_merge.p_merge_from_n p_partner_merge_fk1 R
p_partner_merge.p_merge_to_n p_partner_merge_fk2 R
p_partner_relationship.p_partner_key_n p_partner_relationship_fk1 R
p_partner_relationship.p_relation_key_n p_partner_relationship_fk2 R
p_partner_reminder.p_partner_key_n p_partner_reminder_fk1 R
p_partner_set_partner.p_partner_key_n p_partner_set_partner_fk2 R
p_partner_short_code.p_partner_key_n p_partner_short_code_fk1 R
p_partner_state.p_partner_key_n p_partner_state_fk1 R
p_partner_tax_deductible_pct.p_partner_key_n p_partner_tax_deductible_pct_fk1 R
p_partner_type.p_partner_key_n p_partner_type_fk3 R
p_person.p_partner_key_n p_person_fk1 R
p_recent_partners.p_partner_key_n p_recent_partners_fk2 R
p_subscription.p_gift_from_key_n p_subscription_fk3 R
p_subscription.p_partner_key_n p_subscription_fk2 R
p_tax.p_partner_key_n p_tax_fk1 R
p_unit.p_partner_key_n p_unit_fk1 R
p_unit.p_primary_office_n p_unit_fk7 R
p_venue.p_contact_partner_key_n p_venue_fk3 R
p_venue.p_partner_key_n p_venue_fk1 R
ph_booking.p_contact_key_n ph_booking_fk1 R
pm_application_forms.pm_reference_partner_key_n pm_application_forms_fk3 R
pm_document.pm_contact_partner_key_n pm_document_fk3 R
pm_document_file.p_partner_key_n pm_document_file_fk2 R
pm_job_assignment.p_partner_key_n pm_job_assignment_fk1 R
pm_short_term_application.pm_st_party_contact_n pm_short_term_application_fk6 R
s_user.p_partner_key_n s_user_fk1 R
s_volume_partner_group_partner.p_partner_key_n s_volume_partner_group_ptn_fk2 R
This is the partner key assigned to each partner. It consists of the fund id followed by a computer generated six digit number.
p_partner_class_c varchar 24  √  null
p_partner_classes.p_partner_class_c p_partner_fk7 R
This defines what type of partner this is. The classes that may be assigned are PERSON, FAMILY, CHURCH, ORGANISATION, UNIT, VENUE and BANK.
p_addressee_type_code_c varchar 24  √  'DEFAULT'::character varying
p_addressee_type.p_addressee_type_code_c p_partner_fk4 R
This is a sub-class of the partner class.
p_partner_short_name_c varchar 160  √  null Name of the person or organisation. If a person, more name info is stored in p_person.
p_partner_short_name_loc_c varchar 160  √  null An alternative name for a partner - mainly for entering the local language equivalent.
p_printed_name_c varchar 160  √  null Partner name how it should appear as printed version (to be used if mechanism to build short name from first and last name does not work e.g. in case of different surnames for husband and wife)
p_language_code_c varchar 20  √  '99'::character varying
p_language.p_language_code_c p_partner_fk2 R
Identifies the preferred language of the partner.
p_key_information_c varchar 500  √  null Important information about this partner that users need to be aware of.
p_comment_c varchar 10000  √  null Additional information about the partner that is important to store in the database.
p_acquisition_code_c varchar 16  √  null
p_acquisition.p_acquisition_code_c p_partner_fk1 R
This code identifies the method of aquisition.
p_status_code_c varchar 16  √  null
p_partner_status.p_status_code_c p_partner_fk3 R
This code describes the status of a partner. Eg, Active, Deceased etc
p_status_change_d date 13  √  ('now'::text)::date This is the date the status of the partner was last updated.
p_status_change_reason_c varchar 400  √  null Why was the status changed?
p_deleted_partner_l bool 1  √  false Yes if this partner has been deleted.
p_finance_comment_c varchar 510  √  null This is the finance details comment.
p_receipt_letter_frequency_c varchar 24  √  null How often the partner receives a receipt letter.
p_receipt_each_gift_l bool 1  √  true Flags whether each gift given by a user is receipted
p_email_gift_statement_l bool 1  √  false Flag whether to include this partner when running the Recipient Gift Email report
p_anonymous_donor_l bool 1  √  false Yes if the donor wants to remain anonymous. Names of anonymous donors will not appear on recipient gift statements.
p_no_solicitations_l bool 1  √  false Yes if not ok to solicit the partner for funds.
p_child_indicator_l bool 1  √  false Inicates if this partner has been assigned as a child unit to another unit.
p_restricted_i int4 10  √  0 Restricts use of the partner record to the user in p_user_id_c if 2 or the group in p_group_id_c if 1.
p_user_id_c varchar 40  √  null The Petra user that the partner record is restricted to if p_restricted_i is 2.
p_group_id_c varchar 40  √  null The group of Petra users that the partner record is restricted to if p_restricted_i is 1.
p_previous_name_c varchar 512  √  null
p_first_contact_code_c varchar 60  √  null
p_first_contact.p_first_contact_code_c p_partner_fk8 R
How did this Partner first hear about us?
p_first_contact_freeform_c varchar 400  √  null How did this Partner first hear about us (freetext)?
p_intranet_id_c varchar 200  √  null Intranet ID. Needed for making the link to the International Website, e.g. for using the Online Address Book.
p_timezone_c varchar 100  √  null Timezone that applies to the partner (address does not necessarily determine that). This refers to data in the International Address Book.
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c p_partner_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c p_partner_fkmd R
s_modification_id_c varchar 150  √  null

Table contained 105.248 rows at Do Nov 10 18:00 MEZ 2011

Indexes:
Column(s) Type Sort Constraint Name
p_partner_key_n Primary key Asc p_partner_pk
p_acquisition_code_c Performance Asc inx_p_partner_fk1_key2
p_language_code_c Performance Asc inx_p_partner_fk2_key3
p_status_code_c Performance Asc inx_p_partner_fk3_key4
p_addressee_type_code_c Performance Asc inx_p_partner_fk4_key5
p_partner_class_c Performance Asc inx_p_partner_fk7_key6
p_first_contact_code_c Performance Asc inx_p_partner_fk8_key7
s_created_by_c Performance Asc inx_p_partner_fkcr_key8
s_modified_by_c Performance Asc inx_p_partner_fkmd_key9
p_partner_key_n Must be unique Asc inx_p_partner_pk1
p_partner_key_n Performance Asc inx_s_user_fk1_ref0
p_partner_short_name_c Performance Asc p_short_name_k0

Close relationships  within of separation: