SQL statements: Right to erasure

Individuals have the right to ask your organization to delete any personal information about them that your organization holds. The following table lists personal data that is stored in HCL Commerce and shows how to delete the data by using an SQL query.
Transaction Server
Type of personal data SQL query and database table
Address 
DELETE FROM ADDRESS WHERE MEMBER_ID=?;
Birth date 
DELETE FROM USERDEMO WHERE USERS_ID = ?;
Browsing Behavior 
DELETE FROM DMUSERBHVR WHERE DMUSERBHVR.PERSONALIZATIONID IN (?PERSONALIZATIONID?)
Challenge answer 
DELETE FROM USERREG WHERE USERS_ID = ?;
Currency 
DELETE FROM USERS WHERE USERS_ID = ?;
Demographics 
DELETE FROM USERDEMO WHERE USERS_ID = ?;
Email Address or IBMid 
DELETE FROM ADDRESS WHERE MEMBER_ID=?;
Gender 
DELETE FROM USERDEMO WHERE USERS_ID = ?;
Income 
DELETE FROM USERDEMO WHERE USERS_ID = ?;
Language 
DELETE FROM USERS WHERE USERS_ID = ?;
Logon ID 
DELETE FROM USERREG WHERE USERS_ID = ?;
Name 
DELETE FROM ADDRESS WHERE MEMBER_ID=?;
Order History 
DELETE FROM ORDERS WHERE MEMBER_ID =?;
Password (for shoppers and CSRs) 
DELETE FROM USERREG WHERE USERS_ID = ?;
Phone Number 
DELETE FROM ADDRESS WHERE MEMBER_ID=?;
Referral URL 
DELETE FROM DMUSERBHVR WHERE DMUSERBHVR.PERSONALIZATIONID IN (?PERSONALIZATIONID?)
Search History 
DELETE FROM DMUSERBHVR WHERE DMUSERBHVR.PERSONALIZATIONID IN (?PERSONALIZATIONID?)

Inventory PBC

Type of personal data SQL query and database table
Contact 
DELETE EMAIL, PHONE, NAME FROM CONTACT WHERE ID = ?;
Secondary Contact 
DELETE SECONDARY_CONTACT FROM CONTACT WHERE ID = ?;
Received Inventory Comment 
DELETE CREATED_BY FROM RECEIVEDINVENTORYCOMMENT WHERE ID = ?;
Expected Inventory Comment 
DELETE CREATED_BY FROM EXPECTEDINVENTORYCOMMENT WHERE ID = ?;

Quote PBC

Type of personal data SQL query and database table
Creator 
DELETE CREATOR FROM QUOTE WHERE ID = ?;
Buyer 
 DELETE BUYER FROM QUOTE WHERE ID = ?;
Seller 
DELETE SELLER FROM QUOTE WHERE ID = ?;
Created By 
DELETE CREATED_BY FROM COMMENTS WHERE ID = ?;