SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for w_kqjcxxb
-- ----------------------------
DROP TABLE IF EXISTS `w_kqjcxxb`;
CREATE TABLE `w_kqjcxxb`  (
  `ID_` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
  `REF_ID_` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '外键',
  `F_xm` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',
  `F_gw` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '岗位',
  `F_dkrq` datetime(0) NULL DEFAULT NULL COMMENT '打卡日期',
  `F_form_data_rev_` bigint(37) NULL DEFAULT 0 COMMENT '表单数据版本',
  `F_sbdksjaa` datetime(0) NULL DEFAULT NULL COMMENT '上班打卡时间',
  `F_xbdksjaa` datetime(0) NULL DEFAULT NULL COMMENT '下班打卡时间',
  PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '考勤基础信息表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of w_kqjcxxb
-- ----------------------------
INSERT INTO `w_kqjcxxb` VALUES ('1435797846648897536', '0', '超级管理员', '管理员', '2021-09-01 00:00:00', 1, '2021-09-01 10:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846665674752', '0', '超级管理员', '管理员', '2021-09-02 00:00:00', 0, '2021-09-12 09:10:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846669869056', '0', '超级管理员', '管理员', '2021-09-03 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846674063360', '0', '超级管理员', '管理员', '2021-09-04 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846674063361', '0', '超级管理员', '管理员', '2021-09-05 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846678257664', '0', '超级管理员', '管理员', '2021-09-06 00:00:00', 0, '2021-09-01 09:10:00', '2021-09-01 17:40:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846682451968', '0', '超级管理员', '管理员', '2021-09-07 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846682451969', '0', '超级管理员', '管理员', '2021-09-08 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846686646272', '0', '超级管理员', '管理员', '2021-09-09 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846690840576', '0', '超级管理员', '管理员', '2021-09-10 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 17:50:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846690840577', '0', '超级管理员', '管理员', '2021-09-11 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846695034880', '0', '超级管理员', '管理员', '2021-09-12 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846699229184', '0', '超级管理员', '管理员', '2021-09-13 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846699229185', '0', '超级管理员', '管理员', '2021-09-14 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846703423488', '0', '超级管理员', '管理员', '2021-09-15 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846703423489', '0', '超级管理员', '管理员', '2021-09-16 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846707617792', '0', '超级管理员', '管理员', '2021-09-17 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846711812096', '0', '超级管理员', '管理员', '2021-09-18 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846711812097', '0', '超级管理员', '管理员', '2021-09-19 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846716006400', '0', '超级管理员', '管理员', '2021-09-20 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846720200704', '0', '超级管理员', '管理员', '2021-09-21 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846720200705', '0', '超级管理员', '管理员', '2021-09-22 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846724395008', '0', '超级管理员', '管理员', '2021-09-23 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846724395009', '0', '超级管理员', '管理员', '2021-09-24 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846728589312', '0', '超级管理员', '管理员', '2021-09-25 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846732783616', '0', '超级管理员', '管理员', '2021-09-26 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846732783617', '0', '超级管理员', '管理员', '2021-09-27 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846736977920', '0', '超级管理员', '管理员', '2021-09-28 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846736977921', '0', '超级管理员', '管理员', '2021-09-29 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846741172224', '0', '超级管理员', '管理员', '2021-09-30 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846741172225', '0', '游客账号', '员工', '2021-09-01 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846745366528', '0', '游客账号', '员工', '2021-09-02 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846749560832', '0', '游客账号', '员工', '2021-09-03 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846749560833', '0', '游客账号', '员工', '2021-09-04 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846753755136', '0', '游客账号', '员工', '2021-09-05 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846753755137', '0', '游客账号', '员工', '2021-09-06 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846757949440', '0', '游客账号', '员工', '2021-09-07 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846762143744', '0', '游客账号', '员工', '2021-09-08 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846762143745', '0', '游客账号', '员工', '2021-09-09 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846766338048', '0', '游客账号', '员工', '2021-09-10 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846766338049', '0', '游客账号', '员工', '2021-09-11 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846770532352', '0', '游客账号', '员工', '2021-09-12 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846774726656', '0', '游客账号', '员工', '2021-09-13 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846774726657', '0', '游客账号', '员工', '2021-09-14 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846778920960', '0', '游客账号', '员工', '2021-09-15 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846778920961', '0', '游客账号', '员工', '2021-09-16 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846783115264', '0', '游客账号', '员工', '2021-09-17 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846787309568', '0', '游客账号', '员工', '2021-09-18 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846787309569', '0', '游客账号', '员工', '2021-09-19 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846791503872', '0', '游客账号', '员工', '2021-09-20 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846791503873', '0', '游客账号', '员工', '2021-09-21 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846795698176', '0', '游客账号', '员工', '2021-09-22 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846799892480', '0', '游客账号', '员工', '2021-09-23 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846799892481', '0', '游客账号', '员工', '2021-09-24 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846804086784', '0', '游客账号', '员工', '2021-09-25 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846804086785', '0', '游客账号', '员工', '2021-09-26 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846808281088', '0', '游客账号', '员工', '2021-09-27 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846812475392', '0', '游客账号', '员工', '2021-09-28 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846812475393', '0', '游客账号', '员工', '2021-09-29 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');
INSERT INTO `w_kqjcxxb` VALUES ('1435797846816669696', '0', '游客账号', '员工', '2021-09-30 00:00:00', 0, '2021-09-01 09:00:00', '2021-09-01 18:00:00');

SET FOREIGN_KEY_CHECKS = 1;