CREATE TABLE `staff` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login_id` varchar(50) COLLATE utf8_general_ci NOT NULL,
  `surname` varchar(45) COLLATE utf8_general_ci DEFAULT NULL,
  `firstname` varchar(45) COLLATE utf8_general_ci DEFAULT NULL,
  `position` int(11) DEFAULT NULL,
  `marital_status` int(11) DEFAULT NULL,
  `is_full_time` int(11) DEFAULT NULL,
  `responsibility` varchar(45) COLLATE utf8_general_ci DEFAULT NULL,
  `tel` varchar(45) COLLATE utf8_general_ci DEFAULT NULL,
  `first_aids_no` varchar(45) COLLATE utf8_general_ci DEFAULT NULL,
  `first_aids_date` datetime DEFAULT NULL,
  `kg_date` datetime DEFAULT NULL,
  `kg_no` varchar(45) COLLATE utf8_general_ci DEFAULT NULL,
  `entry_date` datetime DEFAULT NULL,
  `turnover_date` datetime DEFAULT NULL,
  `seniority_before_entry` int(11) DEFAULT NULL,
  `address` varchar(200) COLLATE utf8_general_ci DEFAULT NULL,
  `photo` varchar(200) COLLATE utf8_general_ci DEFAULT NULL,
  `religion` varchar(45) COLLATE utf8_general_ci DEFAULT NULL,
  `religion_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
