Table openpetra_trunk.public.p_partner_state
A particular state in which the Partner is or has been. The Partner may be in more than one state at one time if there are two different processes relating to 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_partner_key_n numeric 10
p_partner.p_partner_key_n p_partner_state_fk1 R
Partner key of Partner to which state applies
p_state_index_i int4 10 Unique identifier of this state for this partner
p_process_code_c varchar 60  √  null
p_state.p_process_code_c p_partner_state_fk2 R
Process that the state applies to
p_state_code_c varchar 60  √  null
p_state.p_state_code_c p_partner_state_fk2 R
State of the Partner within the process
p_state_freeform_c varchar 400  √  null State of the Partner (freetext)
p_state_start_date_d date 13  √  null When did the Partner enter this state?
p_state_end_date_d date 13  √  null When will/did the Partner exit this state?
p_state_complete_l bool 1  √  null Has the Partner left this state?
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c p_partner_state_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c p_partner_state_fkmd R
s_modification_id_c varchar 150  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
p_partner_key_n + p_state_index_i Primary key Asc/Asc p_partner_state_pk
p_partner_key_n Performance Asc inx_p_partner_state_fk1_key1
p_process_code_c + p_state_code_c Performance Asc/Asc inx_p_partner_state_fk2_key2
s_created_by_c Performance Asc inx_p_partner_state_fkcr_key3
s_modified_by_c Performance Asc inx_p_partner_state_fkmd_key4
p_partner_key_n + p_state_index_i Must be unique Asc/Asc inx_p_partner_state_pk0

Close relationships  within of separation: