Table openpetra_trunk.public.pm_personal_data
This table contains personal data about our staff, eg. tax id.

 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
p_person.p_partner_key_n pm_personal_data_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.
pm_height_cm_i int4 10  √  null The person's height in cm
pm_weight_kg_n numeric 5,2  √  null The person's weight in kg
pm_eye_colour_c varchar 40  √  null The person's eye colour
pm_hair_colour_c varchar 40  √  null The person's hair colour
pm_facial_hair_c varchar 60  √  null Information about the person's facial hair, e.g. beard, mustache
pm_physical_desc_c varchar 500  √  null Further physical information about the person like tatoos, piercings, scars or marks
pm_blood_type_c varchar 20  √  null The person's blood type
pm_ethnic_origin_c varchar 60  √  null Ethnic Origin
pm_life_question_1_c varchar 200  √  null Proof of life question 1
pm_life_answer_1_c varchar 200  √  null Answer to proof of life question 1
pm_life_question_2_c varchar 200  √  null Proof of life question 2
pm_life_answer_2_c varchar 200  √  null Answer to proof of life question 2
pm_life_question_3_c varchar 200  √  null Proof of life question 3
pm_life_answer_3_c varchar 200  √  null Answer to proof of life question 3
pm_life_question_4_c varchar 200  √  null Proof of life question 4
pm_life_answer_4_c varchar 200  √  null Answer to proof of life question 4
pm_personal_fld1_c varchar 50  √  null User defined field-1 for personal information (not in use any longer, replaced by p_data_label_value_partner)
pm_personal_fld2_c varchar 50  √  null User defined field-2 for personal information (not in use any longer, replaced by p_data_label_value_partner)
pm_personal_fld3_c varchar 50  √  null User defined field-3 for personal information (not in use any longer, replaced by p_data_label_value_partner)
pm_personal_fld4_c varchar 50  √  null User defined field-4 for personal information (not in use any longer, replaced by p_data_label_value_partner)
pm_personal_fld5_c varchar 50  √  null User defined field-5 for personal information (not in use any longer, replaced by p_data_label_value_partner)
pm_personal_fld6_c varchar 50  √  null User defined field-6 for personal information (not in use any longer, replaced by p_data_label_value_partner)
pm_driving_license_number_c varchar 50  √  null Driving Licence Number
pm_internal_driver_license_l bool 1  √  false This field indicates if the person has approval to drive for us.
pm_gen_driver_license_l bool 1  √  false This field indicates if the person is a licensed driver.
pm_driver_status_c varchar 32  √  null
pt_driver_status.pt_code_c pm_personal_data_fk2 R
Indicates the level of driving ability.
p_language_code_c varchar 20  √  null
p_language.p_language_code_c pm_personal_data_fk3 R
Name of the person's first language.
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c pm_personal_data_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c pm_personal_data_fkmd R
s_modification_id_c varchar 150  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
p_partner_key_n Primary key Asc pm_personal_data_pk
pm_driver_status_c Performance Asc inx_pm_personal_data_fk2_key1
p_language_code_c Performance Asc inx_pm_personal_data_fk3_key2
s_created_by_c Performance Asc inx_pm_personal_data_fkcr_key3
s_modified_by_c Performance Asc inx_pm_personal_data_fkmd_key4
p_partner_key_n Must be unique Asc inx_pm_personal_data_pk0

Close relationships  within of separation: