[DB Add Table] hrm_ps_emp_health_check

Coordinator
Feb 11, 2013 at 7:03 AM
CREATE TABLE `hrm_ps_emp_health_check` (
  `health_check_seq` int(11) NOT NULL AUTO_INCREMENT,
  `emp_seq` int(11) NOT NULL,
  `round_type` varchar(8) NOT NULL COMMENT 'Yearly,Roundly',
  `round_number` int(11) NOT NULL,
  `round_date` datetime DEFAULT NULL,
  `round_year` int(10) NOT NULL,
  `body_weight` decimal(11,0) DEFAULT NULL,
  `body_height` decimal(10,0) DEFAULT NULL,
  `health_Glocox` decimal(10,0) DEFAULT NULL,
  `health_Cric_Acid` decimal(10,0) DEFAULT NULL,
  `health_Alk` decimal(10,0) DEFAULT NULL,
  `health_AST_or_S6OT` decimal(10,0) DEFAULT NULL,
  `health_ALT_or_S6PT` decimal(10,0) DEFAULT NULL,
  `health_Cholestoral` decimal(10,0) DEFAULT NULL,
  `health_HDL` decimal(10,0) DEFAULT NULL,
  `health_LDL` decimal(10,0) DEFAULT NULL,
  `health_T6` decimal(10,0) DEFAULT NULL,
  `health_HCT` decimal(10,0) DEFAULT NULL,
  `health_PIT` decimal(10,0) DEFAULT NULL,
  `health_CXK` tinyint(1) NOT NULL,
  `health_CK6` tinyint(1) NOT 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` char(1) DEFAULT NULL,
  PRIMARY KEY (`health_check_seq`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;