Table openpetra_trunk.public.pm_past_experience
This details any previous ministry experience the individual has.

 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 The connection to the site
pm_key_n numeric 10 Key to make editing these records easier
p_partner_key_n numeric 10 0
p_person.p_partner_key_n pm_past_experience_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_start_date_d date 13  √  null Start date of previous experience.
pm_end_date_d date 13  √  null End date of previous experience.
pm_prev_location_c varchar 60  √  null Location of previous work .
pm_prev_role_c varchar 60  √  null Describes role played in previous work.
pm_category_c varchar 60  √  null Category/area of previous work
pm_other_organisation_c varchar 50  √  null Worked with which organisation before (if other than our organisation).
pm_past_exp_comments_c varchar 640  √  null Comments on previous experience.
pm_prev_work_here_l bool 1  √  false Indicates if past experience was with this organisation.
pm_prev_work_l bool 1  √  false Indicates whether the individual has previous worked with similar organisations.
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c pm_past_experience_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c pm_past_experience_fkmd R
s_modification_id_c varchar 150  √  null

Table contained 38.085 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_past_experience_pk
p_partner_key_n Performance Asc inx_pm_past_experience_fk1_key1
s_created_by_c Performance Asc inx_pm_past_experience_fkcr_key2
s_modified_by_c Performance Asc inx_pm_past_experience_fkmd_key3
p_site_key_n + pm_key_n Must be unique Asc/Asc inx_pm_past_experience_pk0
p_partner_key_n + pm_end_date_d + pm_start_date_d + pm_prev_location_c Must be unique Asc/Asc/Asc/Asc pm_past_exp_k0
p_partner_key_n + pm_end_date_d + pm_start_date_d + pm_prev_location_c Must be unique Asc/Asc/Asc/Asc pm_past_experience_uk

Close relationships  within of separation: