File manager - Edit - /home/autoph/public_html/ltms-upload/plugins/dropzone/min/db.zip
Back
PK t}�Z��mv pef_evaluation_behavioral.txtnu �[��� CREATE TABLE `pef_evaluation_behavioral` ( `id` int(11) NOT NULL, `pcp_id` int(11) NOT NULL, `emp_record_id` int(11) NOT NULL, `factor_id` int(11) NOT NULL, `assigned_weight` varchar(7) NOT NULL, `assigned_score` varchar(7) NOT NULL, `assigned_wp` varchar(7) NOT NULL, `notes` varchar(200) NOT NULL, `factor_code_name` varchar(15) NOT NULL, `deleted` int(1) NOT NULL DEFAULT 0, `time_stamp` timestamp(6) NOT NULL DEFAULT current_timestamp(6) ON UPDATE current_timestamp(6), PRIMARY KEY (`id`) )ENGINE=InnoDPK t}�Z�QN� pef_evaluation_data.txtnu �[��� 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; PK t}�Z��mv pef_evaluation_behavioral.txtnu �[��� PK t}�Z�QN� i pef_evaluation_data.txtnu �[��� PK � �
| ver. 1.4 |
.
| PHP 8.1.32 | Generation time: 0 |
proxy
|
phpinfo
|
Settings