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=InnoD