Table openpetra_trunk.public.pm_staff_data
This table contains information regarding recruitment, home office, field office, etc. .

 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_site_key_n numeric 10 0
p_partner_field_of_service.p_commitment_site_key_n p_partner_field_of_service_fk4 R
The connection to the site
pm_key_n numeric 10
p_partner_field_of_service.p_commitment_key_n p_partner_field_of_service_fk4 R
Key to make editing these records easier
p_partner_key_n numeric 10 0
p_person.p_partner_key_n pm_staff_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_status_code_c varchar 40  √  null
pm_commitment_status.pm_code_c pm_staff_data_fk6 R
This is a field indicating the status of the commitment
pm_start_of_commitment_d date 13 This is the expected date their committment starts.
pm_start_date_approx_l bool 1  √  false Is the commitment start date an approximate date?
pm_end_of_commitment_d date 13  √  null This is the expected date their committment ends.
pm_office_recruited_by_n numeric 10
p_unit.p_partner_key_n pm_staff_data_fk2 R
The office that recruited the partner. This is a unit of type field, not of type office.
pm_home_office_n numeric 10 The home office of the person. This is a unit of type field, not of type office.
pm_receiving_field_n numeric 10
p_unit.p_partner_key_n pm_staff_data_fk4 R
The person's is serving for that field.
pm_receiving_field_office_n numeric 10  √  null
p_unit.p_partner_key_n pm_staff_data_fk5 R
The office they work at in the receiving field.
pm_staff_data_comments_c varchar 640  √  null Comments on commitment record.
pm_job_title_c varchar 400  √  null A free text field for a job title for a person. This is not the same as the person's role, however it may be auto generated from the roles.
pm_office_phone_ext_c varchar 50  √  null Phone extension of the person at this office
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c pm_staff_data_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c pm_staff_data_fkmd R
s_modification_id_c varchar 150  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
p_site_key_n + pm_key_n Primary key Asc/Asc pm_staff_data_pk
p_partner_key_n + pm_start_of_commitment_d + pm_end_of_commitment_d Must be unique Asc/Asc/Asc inx_pm_commitment_data_uk1
p_partner_key_n Performance Asc inx_pm_staff_data_fk1_key2
pm_office_recruited_by_n Performance Asc inx_pm_staff_data_fk2_key3
pm_home_office_n Performance Asc inx_pm_staff_data_fk3_key4
pm_receiving_field_n Performance Asc inx_pm_staff_data_fk4_key5
pm_receiving_field_office_n Performance Asc inx_pm_staff_data_fk5_key6
pm_status_code_c Performance Asc inx_pm_staff_data_fk6_key7
s_created_by_c Performance Asc inx_pm_staff_data_fkcr_key8
s_modified_by_c Performance Asc inx_pm_staff_data_fkmd_key9
p_site_key_n + pm_key_n Must be unique Asc/Asc inx_pm_staff_data_pk0
p_partner_key_n + pm_start_of_commitment_d + pm_end_of_commitment_d Must be unique Asc/Asc/Asc pm_commitment_data_uk
p_partner_key_n + pm_start_of_commitment_d + pm_end_of_commitment_d + pm_receiving_field_n Must be unique Asc/Asc/Asc/Asc pm_staff_data_k0

Close relationships  within of separation: