| Table p_partner_action |
|
Description: A particular action which has been or needs to be applied to a Partner |
| PRIMARY KEY | ||
|
p_partner_key_n
bigint NOT NULL | Partner key of Partner to which action applies | p_partner, p_partner_reminder |
|
p_action_number_i
integer NOT NULL | Sequential identifier for this action for this partner | |
|
s_group_unit_key_n
bigint default: 0 NOT NULL | Field that the group belongs to | s_group |
|
p_process_code_c
varchar (60) | Process that the action is part of | p_action |
|
p_action_code_c
varchar (60) | Action to be applied to Partner | p_action |
|
p_action_freeform_c
varchar (400) | Action to be applied to Partner (freetext) | |
|
p_perform_by_date_d
date | Date by which action should be performed. Reminders could be set up based on this | |
|
p_action_complete_l
boolean | Has the action already been completed? | |
|
p_action_complete_date_d
date | When was the action completed? | |
|
p_user_to_perform_action_c
varchar (20) | Who should perform this action? | s_user |
|
p_group_to_perform_action_c
varchar (20) | Which group should perform this action? | s_group |
|
p_user_that_performed_action_c
varchar (20) | Who actually performed this action? | s_user |
|
p_contact_id_i
bigint | Part of FK link to p_partner_reminder so can link this action to a reminder | p_partner_reminder |
|
p_reminder_id_i
integer | Part of FK link to p_partner_reminder so can link this action to a reminder | p_partner_reminder |
|
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_action_fk1: p_partner_key_n => p_partner p_partner_action_fk2: p_process_code_c;p_action_code_c => p_action p_partner_action_fk3: p_user_to_perform_action_c => s_user p_partner_action_fk4: p_group_to_perform_action_c;s_group_unit_key_n => s_group p_partner_action_fk5: p_user_that_performed_action_c => s_user p_partner_action_fk6: p_partner_key_n;p_contact_id_i;p_reminder_id_i => p_partner_reminder p_partner_action_fkcr: s_created_by_c => s_user p_partner_action_fkmd: s_modified_by_c => s_user | ||