CREATE TABLE `staff_spouse` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` varchar(50) COLLATE utf8_general_ci DEFAULT NULL,
  `name` varchar(45) COLLATE utf8_general_ci DEFAULT NULL,
  `hkid` varchar(45) COLLATE utf8_general_ci DEFAULT NULL,
  `tel` varchar(45) COLLATE utf8_general_ci DEFAULT NULL,
  `place_of_birth` varchar(45) COLLATE utf8_general_ci DEFAULT NULL,
  `nationality` varchar(45) COLLATE utf8_general_ci DEFAULT NULL,
  `religion` varchar(45) COLLATE utf8_general_ci DEFAULT NULL,
  `educational` varchar(45) COLLATE utf8_general_ci DEFAULT NULL,
  `profession` varchar(45) COLLATE utf8_general_ci DEFAULT NULL,
  `ccc_no` varchar(45) COLLATE utf8_general_ci DEFAULT NULL,
  `ccc_date` datetime DEFAULT NULL,
  `ten_years` datetime DEFAULT NULL,
  `fifteen_years` datetime DEFAULT NULL,
  `retirement_date` datetime DEFAULT NULL,
  `business_trip` varchar(45) COLLATE utf8_general_ci DEFAULT NULL,
  `business_trip_date` datetime DEFAULT NULL,
  `business_trip_back_date` varchar(45) COLLATE utf8_general_ci DEFAULT NULL,
  `mother_name` varchar(45) COLLATE utf8_general_ci DEFAULT NULL,
  `file_no` varchar(45) COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
