ALTER TABLE `applicants` ADD `expectation_from_organization` TEXT NULL DEFAULT NULL AFTER `average_score`;



Create Table

CREATE TABLE `trainee_profile` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `section` varchar(256) DEFAULT NULL,
  `father_name` varchar(255) DEFAULT NULL,
  `mother_name` varchar(255) DEFAULT NULL,
  `spouse_name` varchar(255) DEFAULT NULL,
  `number_of_child` int(10) DEFAULT NULL,
  `employment_type` enum('Permanent','Probation','Contractual') DEFAULT NULL,
  `payment_method` enum('Bank','Bkash') DEFAULT NULL,
  `bkash_number` varchar(100) DEFAULT NULL,
  `account_number` varchar(255) DEFAULT NULL,
  `account_title` varchar(255) DEFAULT NULL,
  `bank_name` varchar(255) DEFAULT NULL,
  `branch` varchar(255) DEFAULT NULL,
  `routing_number` varchar(100) DEFAULT NULL,
  `emergency_contact_person` varchar(100) DEFAULT NULL,
  `relation_with_person` varchar(255) DEFAULT NULL,
  `person_number` varchar(100) DEFAULT NULL,
  `person_address` text DEFAULT NULL,
  `referee_name` varchar(255) DEFAULT NULL,
  `relation_referee` enum('Brother','Sister','Colleague','Other') DEFAULT NULL,
  `number_referees` varchar(100) DEFAULT NULL,
  `whatsapp_number` varchar(255) DEFAULT NULL,
  `android_mobile_configuration` varchar(255) DEFAULT NULL,
  `computer_proficiency` enum('High','Medium','Low') DEFAULT NULL,
  `english_proficiency` enum('High','Medium','Low') DEFAULT NULL,
  `fb_page_link` varchar(255) DEFAULT NULL,
  `vaccine_status` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4;

// 30 jun 22 

CREATE TABLE trainee_exit ( id INT(11) NOT NULL AUTO_INCREMENT , user_id INT(11) NOT NULL , exit_reason TEXT NOT NULL , status ENUM('Pending','Approved','Rejected') NOT NULL DEFAULT 'Pending' , created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , PRIMARY KEY (id)) ENGINE = InnoDB;

ALTER TABLE `trainee_exit`  ADD `mentioned_about_salary` ENUM('Yes','No') NOT NULL  AFTER `user_id`,  ADD `mentioned_field_job` ENUM('Yes','No') NOT NULL  AFTER `mentioned_about_salary`,  ADD `mentioned_target` ENUM('Yes','No') NOT NULL  AFTER `mentioned_field_job`,  ADD `mentioned_responsibilities` ENUM('Yes','No') NOT NULL  AFTER `mentioned_target`,  ADD `mentioned_inactive_policy` ENUM('Yes','No') NOT NULL  AFTER `mentioned_responsibilities`,  ADD `interest_in_job` TEXT NULL DEFAULT NULL  AFTER `mentioned_inactive_policy`,  ADD `improvement_suggetions` TEXT NULL DEFAULT NULL  AFTER `interest_in_job`;