Table openpetra_trunk.public.p_person
Details of a person. A person must also have a related FAMILY class p_partner record.

 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
pc_attendee.p_partner_key_n pc_attendee_fk2 R
pm_document.p_partner_key_n pm_document_fk1 R
pm_formal_education.p_partner_key_n pm_formal_education_fk1 R
pm_general_application.p_partner_key_n pm_general_application_fk1 R
pm_general_application.pm_placement_partner_key_n pm_general_application_fk9 R
pm_interview.p_partner_key_n pm_interview_fk1 R
pm_ownership.p_partner_key_n pm_ownership_fk1 R
pm_passport_details.p_partner_key_n pm_passport_details_fk1 R
pm_past_experience.p_partner_key_n pm_past_experience_fk1 R
pm_pers_office_specific_data.p_partner_key_n pm_pers_office_specific_data_fk1 R
pm_person_ability.p_partner_key_n pm_person_ability_fk1 R
pm_person_absence.p_partner_key_n pm_person_absence_fk1 R
pm_person_commitment_status.p_partner_key_n pm_person_commitment_status_fk1 R
pm_person_evaluation.p_partner_key_n pm_person_evaluation_fk1 R
pm_person_file.p_partner_key_n pm_person_file_fk1 R
pm_person_language.p_partner_key_n pm_person_language_fk1 R
pm_person_qualification.p_partner_key_n pm_person_qualification_fk1 R
pm_person_skill.p_partner_key_n pm_person_skill_fk1 R
pm_personal_data.p_partner_key_n pm_personal_data_fk1 R
pm_special_need.p_partner_key_n pm_special_need_fk1 R
pm_staff_data.p_partner_key_n pm_staff_data_fk1 R
p_partner.p_partner_key_n p_person_fk1 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_title_c varchar 64  √  null
p_first_name_c varchar 64  √  null
p_prefered_name_c varchar 64  √  null
p_middle_name_1_c varchar 64  √  null
p_middle_name_2_c varchar 64  √  null
p_middle_name_3_c varchar 64  √  null
p_family_name_c varchar 64  √  null
p_decorations_c varchar 64  √  null
p_date_of_birth_d date 13  √  null This is the date the rthe person was born
p_gender_c varchar 16  √  'Unknown'::character varying
p_marital_status_c varchar 4  √  'U'::character varying
p_occupation_code_c varchar 32  √  null
p_occupation.p_occupation_code_c p_person_fk5 R
p_believer_since_year_i int4 10  √  null This is the year the person became a Believer.
p_believer_since_comment_c varchar 1000  √  null Comment about the year or how the person became a believer
p_family_key_n numeric 10  √  0
p_family.p_partner_key_n p_person_fk2 R
A cross reference to the family record of this person. It should be set to ? (not 0 because such a record does not exist!) when there is no family record.
p_family_id_i int4 10  √  0 This field indicates the family id of the individual. ID's 0 and 1 are used for parents; 2, 3, 4 ... 9 are used for children.
p_field_key_n numeric 10  √  NULL::numeric
p_unit.p_partner_key_n p_person_fk4 R
This is the partner key of the field in which the partner (should be a Worker or ExWorker) is serving.
p_academic_title_c varchar 48  √  null A person's academic title such as BSc(Hons) or Prof. (eg. Herr Prof. Klaus Shmitt)
p_marital_status_since_d date 13  √  null
p_marital_status_comment_c varchar 512  √  null
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c p_person_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c p_person_fkmd R
s_modification_id_c varchar 150  √  null

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
p_partner_key_n Primary key Asc p_person_pk  
p_family_key_n Performance Asc inx_p_person_fk2_key1  
p_marital_status_c Performance Asc inx_p_person_fk3_key2  
p_field_key_n Performance Asc inx_p_person_fk4_key3  
p_occupation_code_c Performance Asc inx_p_person_fk5_key4  
s_created_by_c Performance Asc inx_p_person_fkcr_key5  
s_modified_by_c Performance Asc inx_p_person_fkmd_key6  
p_partner_key_n Must be unique Asc inx_p_person_pk0  
p_family_key_n + p_family_id_i Must be unique Asc/Asc inx_p_person_uq0 These unique columns are also nullable
p_family_key_n + p_family_id_i Must be unique Asc/Asc p_person_uq These unique columns are also nullable
p_family_name_c Performance Asc pers_family_name_k1  
p_first_name_c Performance Asc pers_first_name_k2  

Close relationships  within of separation: