Customer Mailing List - SSN - Potential Database issue
Closed this issue · 3 comments
khan-ibrahim commented
Potential database issue for customer. eclipse-stuff 5aed7e0.
Use case
Log in as Employee 123, click "Customer Mailing"
Issue
No SSN column in customerDao
Customer Mailing list has an SSN column. Currently populated with customerID values.
khan-ibrahim commented
Note:
TA’s code recognizes “SSN” as the same thing as “ID”. We have them as two separate things in the database.
shortland commented
Implemented SocialSecurity Column in the CustomerData table.
ALTER TABLE `CustomerData` ADD `SocialSecurity` INT(9) DEFAULT NULL AFTER `CustomerID`;Will need to refactor some code as a result of this...