| Table p_partner_state |
|
Description: 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. |
| PRIMARY KEY | ||
|
p_partner_key_n
bigint NOT NULL | Partner key of Partner to which state applies | p_partner |
|
p_state_index_i
integer NOT NULL | Unique identifier of this state for this partner | |
|
p_process_code_c
varchar (60) | Process that the state applies to | p_state |
|
p_state_code_c
varchar (60) | State of the Partner within the process | p_state |
|
p_state_freeform_c
varchar (400) | State of the Partner (freetext) | |
|
p_state_start_date_d
date | When did the Partner enter this state? | |
|
p_state_end_date_d
date | When will/did the Partner exit this state? | |
|
p_state_complete_l
boolean | Has the Partner left this state? | |
|
s_date_created_d
date default: CURRENT_DATE | The date the record was created. | |
|
s_created_by_c
varchar (20) | User ID of who created this record. | s_user |
|
s_date_modified_d
date | The date the record was modified. | |
|
s_modified_by_c
varchar (20) | User ID of who last modified this record. | s_user |
|
s_modification_id_t
timestamp default: CURRENT_TIMESTAMP | This identifies the current version of the record. | |
FOREIGN KEY p_partner_state_fk1: p_partner_key_n => p_partner p_partner_state_fk2: p_process_code_c;p_state_code_c => p_state p_partner_state_fkcr: s_created_by_c => s_user p_partner_state_fkmd: s_modified_by_c => s_user | ||