[DB Add Table] hrm_ps_health

Coordinator
Feb 11, 2013 at 8:04 AM
CREATE TABLE `hrm_ps_health` (
  `HEALTH_SEQ` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `EMP_SEQ` int(11) DEFAULT NULL COMMENT 'Employee Id',
  `ISSUE_TYPE` varchar(20) DEFAULT NULL COMMENT 'R = Roundly รอบ 6 เดือน, Y = Yearly รอบปี',
  `SAVE_DATE` datetime DEFAULT NULL COMMENT 'วันตรวจ',
  `DESCRIPTION` varchar(255) DEFAULT NULL,
  `REMARK` varchar(500) DEFAULT NULL,
  `CREATED_BY` int(11) DEFAULT NULL,
  `CREATED_WHEN` datetime DEFAULT NULL,
  `UPDATED_BY` int(11) DEFAULT NULL,
  `UPDATED_WHEN` datetime DEFAULT NULL,
  `RECORD_STATUS` varchar(2) DEFAULT NULL,
  PRIMARY KEY (`HEALTH_SEQ`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;