Table openpetra_trunk.public.p_acquisition
This table is used to describe how a partner first came into contact with the organisation. Which department entered them.

 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_acquisition_code_c varchar 16
p_partner.p_acquisition_code_c p_partner_fk1 R
pm_short_term_application.pm_st_recruit_efforts_c pm_short_term_application_fk21 R
This code identifies the method of aquisition.
p_acquisition_description_c varchar 160 This describes the method of aquisition.
p_valid_acquisition_l bool 1  √  true Defines if the acquisition code is still for use
p_deletable_l bool 1 true This defines if the acquisition code can be deleted. This can only be updated by the system manager. At the risk of serious operational integrity. Default to Yes
p_recruiting_effort_l bool 1  √  false This defines if the acquisition code listed represents a recruiting effort.
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c p_acquisition_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c p_acquisition_fkmd R
s_modification_id_c varchar 150  √  null

Table contained 18 rows at Mi Nov 09 18:02 MEZ 2011

Indexes:
Column(s) Type Sort Constraint Name
p_acquisition_code_c Primary key Asc p_acquisition_pk
s_created_by_c Performance Asc inx_p_acquisition_fkcr_key1
s_modified_by_c Performance Asc inx_p_acquisition_fkmd_key2
p_acquisition_code_c Must be unique Asc inx_p_acquisition_pk0

Close relationships  within of separation: