| Table p_consent_history | 
| 
Description: Keeps track of all data changes for GDPR  | 
| PRIMARY KEY | ||
| 
p_entry_id_i
 
bigint default: 0 NOT NULL  | Incremental key for entrys | |
| 
p_partner_key_n
 
bigint default: 0 NOT NULL  | Key for partner | p_partner | 
| 
p_type_c
 
varchar (128) NOT NULL  | Type for Data saved | |
| 
p_value_c
 
varchar (1024)  | Value for type key | |
| 
p_consent_date_d
 
date NOT NULL  | Date the consent was given | |
| 
p_channel_code_c
 
varchar (40) NOT NULL  | Code of channel | p_consent_channel | 
| 
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_consent_history_fk1: p_partner_key_n => p_partner p_consent_history_fk2: p_channel_code_c => p_consent_channel p_consent_history_fkcr: s_created_by_c => s_user p_consent_history_fkmd: s_modified_by_c => s_user  | ||
REFERENCED BY p_consent_history_permission  | ||