CREATE TABLE `hr_staff_payroll` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` int(11) NOT NULL,
  `basic_salary` decimal(10,2) NOT NULL,
  `first_aid` decimal(10,2) NOT NULL,
  `adjustment` decimal(10,2) NOT NULL,
  `mpf_percent_er` decimal(10,2) NOT NULL,
  `mpf_percent_ee` decimal(10,2) NOT NULL,
  `current_point` text COLLATE utf8_general_ci NOT NULL,
  `description` text COLLATE utf8_general_ci,
  `max_point` text COLLATE utf8_general_ci NOT NULL,
  `working_hour` decimal(10,2) NOT NULL,
  `effective_date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
