1 //add user_id coloumn in underwrting general table ALTER TABLE `underwriting_general` ADD `user_id` BIGINT(50) UNSIGNED NOT NULL AFTER `id`; 2 // in status underwriting_questionnaire table ALTER TABLE `underwriting_questionnaire` CHANGE `status` `status` ENUM('N','Y') NOT NULL DEFAULT 'N' COMMENT 'N=NO Y=YES'; 3 // in status underwriting_questionnaire table ALTER TABLE `underwriting_questionnaire` CHANGE `status` `status` ENUM('N','Y') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'N=NO Y=YES'; 4 // in add column ssn in table underwriting_owners ALTER TABLE `underwriting_owners` ADD `ssn` VARCHAR(50) NOT NULL AFTER `last_name`;