数据库

CREATE TABLE `plague_prevention_register` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `emp_name` varchar(50) NOT NULL COMMENT '员工姓名',
  `have_gone_high_risk_areas` tinyint(2) NOT NULL COMMENT '近14日内，是否有中高风险地区居住史或旅行史（1是或0否）',
  `have_contact_susceptible_person` tinyint(2) NOT NULL COMMENT '近14日内，是否有接触过中高风险地区人员或新型冠状病毒感染的肺炎病例人员（1是或0否）',
  `health_code_status` tinyint(2) NOT NULL COMMENT '健康码情况 （绿码，黄码，红码）字典表：HEALTH_CODE_STATUS',
  `health_anomalous_cause` varchar(100) NOT NULL COMMENT '健康码异常原因',
  `is_sick` tinyint(2) NOT NULL COMMENT '是否出现乏力、发热、咳嗽、呼吸困难等（1是或0否）',
  `is_temperature_normal` tinyint(2) NOT NULL COMMENT '体温是否超过37.2°C（1是或0否）',
  `attendance` tinyint(2) NOT NULL COMMENT '当日出勤情况（出勤，居家隔离，集中隔离，居家办公，请假）字典表：ATTENDANCE_STATUS',
  `is_travel_other_city` tinyint(2) NOT NULL COMMENT '本日是否出行前往异地省市（1是或0否）',
  `travel_city_name` varchar(20) DEFAULT NULL COMMENT '前往城市',
  `travel_reason` varchar(100) DEFAULT NULL COMMENT '出行原因',
  `travel_way` tinyint(2) DEFAULT NULL COMMENT '出行方式（自驾，公交，大巴，火车，飞机，轮船）字典表：TRAVEL_WAY',
  `travel_info` varchar(100) DEFAULT NULL COMMENT '出行信息',
  `acid_test_result` tinyint(2) DEFAULT NULL COMMENT '48小时内核酸检测结果（0阴性，1阳性）',
  `remark` varchar(100) DEFAULT NULL COMMENT '特殊情况备注（可选）',
  `emp_records_id` int(11) NOT NULL COMMENT '员工花名册id',
  `item_id` int(11) NOT NULL COMMENT '项目id',
  `location` varchar(100) NOT NULL COMMENT '当前所在城市',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='防疫登记表';

INSERT INTO easy_prod0715.sys_dict_type (dict_name,dict_type,status,create_by,create_time,update_by,update_time,remark) VALUES
	 ('健康码状态','HEALTH_CODE_STATUS','0','admin','2022-10-19 14:07:56','admin','2022-10-19 14:09:10','健康码状态'),
	 ('出勤方式','TRAVEL_WAY','0','admin','2022-10-19 14:08:28','admin','2022-10-19 14:14:00','出勤方式'),
	 ('出勤状态','ATTENDANCE_STATUS','0','admin','2022-10-19 14:08:46','admin','2022-10-19 14:14:11','出勤状态');

INSERT INTO easy_prod0715.sys_dict_data (dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,dict_category) VALUES
	 (1,'绿码','1','HEALTH_CODE_STATUS',NULL,NULL,'N','0','admin','2022-10-19 14:10:01','admin','2022-10-19 14:12:14','绿码',NULL),
	 (2,'橙/黄码','2','HEALTH_CODE_STATUS',NULL,NULL,'N','0','admin','2022-10-19 14:10:19','admin','2022-10-19 14:12:22','黄码',NULL),
	 (3,'红码','3','HEALTH_CODE_STATUS',NULL,NULL,'N','0','admin','2022-10-19 14:10:30','admin','2022-10-19 14:12:17','红码',NULL);

INSERT INTO easy_prod0715.sys_dict_data (dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,dict_category) VALUES
	 (1,'自驾','1','TRAVEL_WAY',NULL,NULL,'N','0','admin','2022-10-19 14:10:54','admin','2022-10-19 14:11:28','自驾',NULL),
	 (2,'公交','2','TRAVEL_WAY',NULL,NULL,'N','0','admin','2022-10-19 14:11:09','admin','2022-10-19 14:11:34','公交',NULL),
	 (3,'大巴','3','TRAVEL_WAY',NULL,NULL,'N','0','admin','2022-10-19 14:11:22','admin','2022-10-19 14:11:37','大巴',NULL),
	 (4,'火车','4','TRAVEL_WAY',NULL,NULL,'N','0','admin','2022-10-19 14:11:48','',NULL,'火车',NULL),
	 (5,'飞机','5','TRAVEL_WAY',NULL,NULL,'N','0','admin','2022-10-19 14:12:00','',NULL,'飞机',NULL),
	 (6,'轮船','6','TRAVEL_WAY',NULL,NULL,'N','0','admin','2022-10-19 14:12:08','admin','2022-10-20 15:01:13','轮船',NULL);

INSERT INTO easy_prod0715.sys_dict_data (dict_sort,dict_label,dict_value,dict_type,css_class,list_class,is_default,status,create_by,create_time,update_by,update_time,remark,dict_category) VALUES
	 (1,'出勤','1','ATTENDANCE_STATUS',NULL,NULL,'N','0','admin','2022-10-19 14:14:33','',NULL,'出勤',NULL),
	 (2,'居家隔离','2','ATTENDANCE_STATUS',NULL,NULL,'N','0','admin','2022-10-19 14:14:48','',NULL,'居家隔离',NULL),
	 (3,'集中隔离','3','ATTENDANCE_STATUS',NULL,NULL,'N','0','admin','2022-10-19 14:14:58','',NULL,'集中隔离',NULL),
	 (4,'居家办公','4','ATTENDANCE_STATUS',NULL,NULL,'N','0','admin','2022-10-19 14:15:08','',NULL,'居家办公',NULL),
	 (5,'请假','5','ATTENDANCE_STATUS',NULL,NULL,'N','0','admin','2022-10-19 14:15:16','',NULL,'请假',NULL);