ALTER TABLE `applicant_choice` CHANGE `transDate` `transDate` DATE NOT NULL 