CREATE TABLE `pms_db`.`pef_evaluation_data` (`id` INT(11) NOT NULL AUTO_INCREMENT , `pcp_id` INT(11) NOT NULL , `emp_record_id` INT(11) NOT NULL , `pef_year` INT(4) NOT NULL , `pef_semester` VARCHAR(3) NOT NULL , `evaluated_by` INT(11) NOT NULL , `comp_id` INT(11) NOT NULL , `dealer_id` INT(11) NOT NULL , `mon_a` VARCHAR(7) NOT NULL , `mon_b` INT NOT NULL , `mon_c` INT NOT NULL , `mon_d` INT NOT NULL , `mon_e` INT NOT NULL , `mon_f` INT NOT NULL , `part_one_nr` VARCHAR(7) NOT NULL , `part_one_percent` VARCHAR(7) NOT NULL , `part_one_adj` VARCHAR(25) NOT NULL , `part_one_wp` VARCHAR(7) NOT NULL , `part_two_nr` VARCHAR(7) NOT NULL , `part_two_percent` VARCHAR(7) NOT NULL , `part_two_adj` VARCHAR(7) NOT NULL , `part_two_wp` VARCHAR(7) NOT NULL , `per_overall_wp` VARCHAR(7) NOT NULL , `per_overall_adj` VARCHAR(25) NOT NULL , `part_three_strength` VARCHAR(200) NOT NULL , `part_three_improvement` VARCHAR(200) NOT NULL , `part_three_competency` INT(1) NOT NULL COMMENT '1=none, \r\n2=particular, \r\n3=2 or more' , `part_three_competency_notes` VARCHAR(150) NOT NULL , `part_three_suitability` INT(1) NOT NULL COMMENT '1=very suitable, 2=suitable, \r\n3=not potential' , `part_three_suitability_notes` VARCHAR(150) NOT NULL , `part_three_potential` INT(1) NOT NULL COMMENT '1=just right, 2=moderate, \r\n3=high potential' , `rated_by` INT(11) NOT NULL , `rated_date` VARCHAR(21) NOT NULL , `emp_confirm_by` INT(11) NOT NULL , `emp_confirm_date` VARCHAR(21) NOT NULL , `emp_confirm_agreement` INT(1) NOT NULL COMMENT '1=agre, 2=w/ reservation, 3=disagree' , `emp_confirm_notes` VARCHAR(250) NOT NULL , `next_head_approval_id` INT(11) NOT NULL , `next_head_approval_date` VARCHAR(21) NOT NULL , `next_head_notes` VARCHAR(200) NOT NULL , `deleted` INT(1) NOT NULL DEFAULT '0' , PRIMARY KEY (`id`)) ENGINE = InnoDB;