checkinsystem_test_data.sql

/*
 Navicat MySQL Data Transfer

 Source Server         : aliyun
 Source Server Type    : MySQL
 Source Server Version : 50734
 Source Host           : localhost:3306
 Source Schema         : checkinsystem

 Target Server Type    : MySQL
 Target Server Version : 50734
 File Encoding         : 65001

 Date: 25/06/2021 17:12:43
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for attendinfo
-- ----------------------------
DROP TABLE IF EXISTS `attendinfo`;
CREATE TABLE `attendinfo` (
  `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '记录号',
  `Stu_id` varchar(11) NOT NULL COMMENT '学号',
  `Code` varchar(20) NOT NULL COMMENT '课程代码',
  `Time` datetime DEFAULT NULL COMMENT '记录时间',
  `Attendance` enum('缺勤','出勤','请假') DEFAULT NULL COMMENT '出勤情况',
  PRIMARY KEY (`Id`) USING BTREE,
  UNIQUE KEY `Id` (`Id`) USING BTREE,
  KEY `ai_fk_ls` (`Code`,`Stu_id`) USING BTREE,
  KEY `in_code_id` (`Code`,`Stu_id`),
  CONSTRAINT `ai_fk_ls` FOREIGN KEY (`Code`, `Stu_id`) REFERENCES `lessonstudent` (`Code`, `Id`)
) ENGINE=InnoDB AUTO_INCREMENT=610 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of attendinfo
-- ----------------------------
BEGIN;
INSERT INTO `attendinfo` VALUES (15, '17081223323', 'BBBS.100001', '2021-04-23 15:38:29', '出勤');
INSERT INTO `attendinfo` VALUES (16, '17233036523', 'BBBS.100001', '2021-04-23 15:38:29', '出勤');
INSERT INTO `attendinfo` VALUES (17, '17279240585', 'BBBS.100001', '2021-04-23 15:38:29', '出勤');
INSERT INTO `attendinfo` VALUES (18, '17439589453', 'BBBS.100001', '2021-04-23 15:38:29', '缺勤');
INSERT INTO `attendinfo` VALUES (19, '17688932082', 'BBBS.100001', '2021-04-23 15:38:29', '请假');
INSERT INTO `attendinfo` VALUES (20, '17977749826', 'BBBS.100001', '2021-04-23 15:38:29', '出勤');
INSERT INTO `attendinfo` VALUES (21, '18034620973', 'BBBS.100001', '2021-04-23 15:38:29', '请假');
INSERT INTO `attendinfo` VALUES (22, '18091786225', 'BBBS.100001', '2021-04-23 15:38:29', '出勤');
INSERT INTO `attendinfo` VALUES (23, '18641907766', 'BBBS.100001', '2021-04-23 15:38:29', '缺勤');
INSERT INTO `attendinfo` VALUES (24, '18745712355', 'BBBS.100001', '2021-04-23 15:38:29', '缺勤');
INSERT INTO `attendinfo` VALUES (25, '18949769032', 'BBBS.100001', '2021-04-23 15:38:29', '出勤');
INSERT INTO `attendinfo` VALUES (26, '19039727092', 'BBBS.100001', '2021-04-23 15:38:29', '出勤');
INSERT INTO `attendinfo` VALUES (27, '19656946957', 'BBBS.100001', '2021-04-23 15:38:29', '请假');
INSERT INTO `attendinfo` VALUES (28, '19687866438', 'BBBS.100001', '2021-04-23 15:38:29', '请假');
INSERT INTO `attendinfo` VALUES (29, '19854931373', 'BBBS.100001', '2021-04-23 15:38:29', '出勤');
INSERT INTO `attendinfo` VALUES (30, '19997902569', 'BBBS.100001', '2021-04-23 15:38:29', '出勤');
INSERT INTO `attendinfo` VALUES (31, '20098081168', 'BBBS.100001', '2021-04-23 15:38:29', '缺勤');
INSERT INTO `attendinfo` VALUES (32, '20193122526', 'BBBS.100001', '2021-04-23 15:38:29', '出勤');
INSERT INTO `attendinfo` VALUES (33, '20527549014', 'BBBS.100001', '2021-04-23 15:38:29', '出勤');
INSERT INTO `attendinfo` VALUES (34, '20924733513', 'BBBS.100001', '2021-04-23 15:38:29', '出勤');
INSERT INTO `attendinfo` VALUES (35, '20989521282', 'BBBS.100001', '2021-04-23 15:38:29', '出勤');
INSERT INTO `attendinfo` VALUES (36, '17081223323', 'BBBS.100001', '2021-05-07 16:25:08', '出勤');
INSERT INTO `attendinfo` VALUES (37, '17233036523', 'BBBS.100001', '2021-05-07 16:25:08', '出勤');
INSERT INTO `attendinfo` VALUES (38, '17279240585', 'BBBS.100001', '2021-05-07 16:25:08', '出勤');
INSERT INTO `attendinfo` VALUES (39, '17439589453', 'BBBS.100001', '2021-05-07 16:25:08', '缺勤');
INSERT INTO `attendinfo` VALUES (40, '17688932082', 'BBBS.100001', '2021-05-07 16:25:08', '缺勤');
INSERT INTO `attendinfo` VALUES (41, '17977749826', 'BBBS.100001', '2021-05-07 16:25:08', '请假');
INSERT INTO `attendinfo` VALUES (42, '18034620973', 'BBBS.100001', '2021-05-07 16:25:08', '请假');
INSERT INTO `attendinfo` VALUES (43, '18091786225', 'BBBS.100001', '2021-05-07 16:25:08', '请假');
INSERT INTO `attendinfo` VALUES (44, '18641907766', 'BBBS.100001', '2021-05-07 16:25:08', '请假');
INSERT INTO `attendinfo` VALUES (45, '18745712355', 'BBBS.100001', '2021-05-07 16:25:08', '请假');
INSERT INTO `attendinfo` VALUES (46, '18949769032', 'BBBS.100001', '2021-05-07 16:25:08', '出勤');
INSERT INTO `attendinfo` VALUES (47, '19039727092', 'BBBS.100001', '2021-05-07 16:25:08', '缺勤');
INSERT INTO `attendinfo` VALUES (48, '19656946957', 'BBBS.100001', '2021-05-07 16:25:08', '缺勤');
INSERT INTO `attendinfo` VALUES (49, '19687866438', 'BBBS.100001', '2021-05-07 16:25:08', '出勤');
INSERT INTO `attendinfo` VALUES (50, '19854931373', 'BBBS.100001', '2021-05-07 16:25:08', '出勤');
INSERT INTO `attendinfo` VALUES (51, '19997902569', 'BBBS.100001', '2021-05-07 16:25:08', '出勤');
INSERT INTO `attendinfo` VALUES (52, '20098081168', 'BBBS.100001', '2021-05-07 16:25:08', '缺勤');
INSERT INTO `attendinfo` VALUES (53, '20193122526', 'BBBS.100001', '2021-05-07 16:25:08', '请假');
INSERT INTO `attendinfo` VALUES (54, '20527549014', 'BBBS.100001', '2021-05-07 16:25:08', '请假');
INSERT INTO `attendinfo` VALUES (55, '20924733513', 'BBBS.100001', '2021-05-07 16:25:08', '请假');
INSERT INTO `attendinfo` VALUES (56, '20989521282', 'BBBS.100001', '2021-05-07 16:25:08', '请假');
INSERT INTO `attendinfo` VALUES (57, '17081223323', 'BBBS.100001', '2021-05-14 15:58:30', '出勤');
INSERT INTO `attendinfo` VALUES (58, '17233036523', 'BBBS.100001', '2021-05-14 15:58:30', '出勤');
INSERT INTO `attendinfo` VALUES (59, '17279240585', 'BBBS.100001', '2021-05-14 15:58:30', '出勤');
INSERT INTO `attendinfo` VALUES (60, '17439589453', 'BBBS.100001', '2021-05-14 15:58:30', '缺勤');
INSERT INTO `attendinfo` VALUES (61, '17688932082', 'BBBS.100001', '2021-05-14 15:58:30', '请假');
INSERT INTO `attendinfo` VALUES (62, '17977749826', 'BBBS.100001', '2021-05-14 15:58:30', '缺勤');
INSERT INTO `attendinfo` VALUES (63, '18034620973', 'BBBS.100001', '2021-05-14 15:58:30', '请假');
INSERT INTO `attendinfo` VALUES (64, '18091786225', 'BBBS.100001', '2021-05-14 15:58:30', '请假');
INSERT INTO `attendinfo` VALUES (65, '18641907766', 'BBBS.100001', '2021-05-14 15:58:30', '出勤');
INSERT INTO `attendinfo` VALUES (66, '18745712355', 'BBBS.100001', '2021-05-14 15:58:30', '出勤');
INSERT INTO `attendinfo` VALUES (67, '18949769032', 'BBBS.100001', '2021-05-14 15:58:30', '出勤');
INSERT INTO `attendinfo` VALUES (68, '19039727092', 'BBBS.100001', '2021-05-14 15:58:30', '出勤');
INSERT INTO `attendinfo` VALUES (69, '19656946957', 'BBBS.100001', '2021-05-14 15:58:30', '出勤');
INSERT INTO `attendinfo` VALUES (70, '19687866438', 'BBBS.100001', '2021-05-14 15:58:30', '出勤');
INSERT INTO `attendinfo` VALUES (71, '19854931373', 'BBBS.100001', '2021-05-14 15:58:30', '缺勤');
INSERT INTO `attendinfo` VALUES (72, '19997902569', 'BBBS.100001', '2021-05-14 15:58:30', '出勤');
INSERT INTO `attendinfo` VALUES (73, '20098081168', 'BBBS.100001', '2021-05-14 15:58:30', '缺勤');
INSERT INTO `attendinfo` VALUES (74, '20193122526', 'BBBS.100001', '2021-05-14 15:58:30', '出勤');
INSERT INTO `attendinfo` VALUES (75, '20527549014', 'BBBS.100001', '2021-05-14 15:58:30', '缺勤');
INSERT INTO `attendinfo` VALUES (76, '20924733513', 'BBBS.100001', '2021-05-14 15:58:30', '缺勤');
INSERT INTO `attendinfo` VALUES (77, '20989521282', 'BBBS.100001', '2021-05-14 15:58:30', '出勤');
INSERT INTO `attendinfo` VALUES (78, '17081223323', 'BBBS.100001', '2021-06-23 15:40:44', '出勤');
INSERT INTO `attendinfo` VALUES (79, '17233036523', 'BBBS.100001', '2021-06-23 15:40:44', '出勤');
INSERT INTO `attendinfo` VALUES (80, '17279240585', 'BBBS.100001', '2021-06-23 15:40:44', '出勤');
INSERT INTO `attendinfo` VALUES (81, '17439589453', 'BBBS.100001', '2021-06-23 15:40:44', '请假');
INSERT INTO `attendinfo` VALUES (82, '17688932082', 'BBBS.100001', '2021-06-23 15:40:44', '缺勤');
INSERT INTO `attendinfo` VALUES (83, '17977749826', 'BBBS.100001', '2021-06-23 15:40:44', '请假');
INSERT INTO `attendinfo` VALUES (84, '18034620973', 'BBBS.100001', '2021-06-23 15:40:44', '出勤');
INSERT INTO `attendinfo` VALUES (85, '18091786225', 'BBBS.100001', '2021-06-23 15:40:44', '出勤');
INSERT INTO `attendinfo` VALUES (86, '18641907766', 'BBBS.100001', '2021-06-23 15:40:44', '出勤');
INSERT INTO `attendinfo` VALUES (87, '18745712355', 'BBBS.100001', '2021-06-23 15:40:44', '出勤');
INSERT INTO `attendinfo` VALUES (88, '18949769032', 'BBBS.100001', '2021-06-23 15:40:44', '出勤');
INSERT INTO `attendinfo` VALUES (89, '19039727092', 'BBBS.100001', '2021-06-23 15:40:44', '出勤');
INSERT INTO `attendinfo` VALUES (90, '19656946957', 'BBBS.100001', '2021-06-23 15:40:44', '出勤');
INSERT INTO `attendinfo` VALUES (91, '19687866438', 'BBBS.100001', '2021-06-23 15:40:44', '出勤');
INSERT INTO `attendinfo` VALUES (92, '19854931373', 'BBBS.100001', '2021-06-23 15:40:44', '出勤');
INSERT INTO `attendinfo` VALUES (93, '19997902569', 'BBBS.100001', '2021-06-23 15:40:44', '出勤');
INSERT INTO `attendinfo` VALUES (94, '20098081168', 'BBBS.100001', '2021-06-23 15:40:44', '出勤');
INSERT INTO `attendinfo` VALUES (95, '20193122526', 'BBBS.100001', '2021-06-23 15:40:44', '出勤');
INSERT INTO `attendinfo` VALUES (96, '20527549014', 'BBBS.100001', '2021-06-23 15:40:44', '出勤');
INSERT INTO `attendinfo` VALUES (97, '20924733513', 'BBBS.100001', '2021-06-23 15:40:44', '出勤');
INSERT INTO `attendinfo` VALUES (98, '20989521282', 'BBBS.100001', '2021-06-23 15:40:44', '出勤');
INSERT INTO `attendinfo` VALUES (99, '17008164334', 'BBBS.100002', '2021-03-10 12:59:35', '出勤');
INSERT INTO `attendinfo` VALUES (100, '17081223323', 'BBBS.100002', '2021-03-10 12:59:35', '出勤');
INSERT INTO `attendinfo` VALUES (101, '17156899188', 'BBBS.100002', '2021-03-10 12:59:35', '请假');
INSERT INTO `attendinfo` VALUES (102, '17165103782', 'BBBS.100002', '2021-03-10 12:59:35', '缺勤');
INSERT INTO `attendinfo` VALUES (103, '18011440603', 'BBBS.100002', '2021-03-10 12:59:35', '缺勤');
INSERT INTO `attendinfo` VALUES (104, '18026738672', 'BBBS.100002', '2021-03-10 12:59:35', '缺勤');
INSERT INTO `attendinfo` VALUES (105, '18034620973', 'BBBS.100002', '2021-03-10 12:59:35', '出勤');
INSERT INTO `attendinfo` VALUES (106, '18641907766', 'BBBS.100002', '2021-03-10 12:59:35', '出勤');
INSERT INTO `attendinfo` VALUES (107, '19039727092', 'BBBS.100002', '2021-03-10 12:59:35', '请假');
INSERT INTO `attendinfo` VALUES (108, '19100454727', 'BBBS.100002', '2021-03-10 12:59:35', '出勤');
INSERT INTO `attendinfo` VALUES (109, '19147811984', 'BBBS.100002', '2021-03-10 12:59:35', '缺勤');
INSERT INTO `attendinfo` VALUES (110, '19307130203', 'BBBS.100002', '2021-03-10 12:59:35', '请假');
INSERT INTO `attendinfo` VALUES (111, '20000556491', 'BBBS.100002', '2021-03-10 12:59:35', '缺勤');
INSERT INTO `attendinfo` VALUES (112, '20060097449', 'BBBS.100002', '2021-03-10 12:59:35', '出勤');
INSERT INTO `attendinfo` VALUES (113, '20098081168', 'BBBS.100002', '2021-03-10 12:59:35', '缺勤');
INSERT INTO `attendinfo` VALUES (114, '20102985227', 'BBBS.100002', '2021-03-10 12:59:35', '出勤');
INSERT INTO `attendinfo` VALUES (115, '17008164334', 'BBBS.100002', '2021-04-03 12:30:10', '出勤');
INSERT INTO `attendinfo` VALUES (116, '17081223323', 'BBBS.100002', '2021-04-03 12:30:10', '出勤');
INSERT INTO `attendinfo` VALUES (117, '17156899188', 'BBBS.100002', '2021-04-03 12:30:10', '请假');
INSERT INTO `attendinfo` VALUES (118, '17165103782', 'BBBS.100002', '2021-04-03 12:30:10', '缺勤');
INSERT INTO `attendinfo` VALUES (119, '18011440603', 'BBBS.100002', '2021-04-03 12:30:10', '出勤');
INSERT INTO `attendinfo` VALUES (120, '18026738672', 'BBBS.100002', '2021-04-03 12:30:10', '出勤');
INSERT INTO `attendinfo` VALUES (121, '18034620973', 'BBBS.100002', '2021-04-03 12:30:10', '出勤');
INSERT INTO `attendinfo` VALUES (122, '18641907766', 'BBBS.100002', '2021-04-03 12:30:10', '缺勤');
INSERT INTO `attendinfo` VALUES (123, '19039727092', 'BBBS.100002', '2021-04-03 12:30:10', '请假');
INSERT INTO `attendinfo` VALUES (124, '19100454727', 'BBBS.100002', '2021-04-03 12:30:10', '缺勤');
INSERT INTO `attendinfo` VALUES (125, '19147811984', 'BBBS.100002', '2021-04-03 12:30:10', '缺勤');
INSERT INTO `attendinfo` VALUES (126, '19307130203', 'BBBS.100002', '2021-04-03 12:30:10', '出勤');
INSERT INTO `attendinfo` VALUES (127, '20000556491', 'BBBS.100002', '2021-04-03 12:30:10', '出勤');
INSERT INTO `attendinfo` VALUES (128, '20060097449', 'BBBS.100002', '2021-04-03 12:30:10', '出勤');
INSERT INTO `attendinfo` VALUES (129, '20098081168', 'BBBS.100002', '2021-04-03 12:30:10', '缺勤');
INSERT INTO `attendinfo` VALUES (130, '20102985227', 'BBBS.100002', '2021-04-03 12:30:10', '请假');
INSERT INTO `attendinfo` VALUES (131, '17008164334', 'BBBS.100002', '2021-05-14 12:40:15', '出勤');
INSERT INTO `attendinfo` VALUES (132, '17081223323', 'BBBS.100002', '2021-05-14 12:40:15', '缺勤');
INSERT INTO `attendinfo` VALUES (133, '17156899188', 'BBBS.100002', '2021-05-14 12:40:15', '出勤');
INSERT INTO `attendinfo` VALUES (134, '17165103782', 'BBBS.100002', '2021-05-14 12:40:15', '出勤');
INSERT INTO `attendinfo` VALUES (135, '18011440603', 'BBBS.100002', '2021-05-14 12:40:15', '出勤');
INSERT INTO `attendinfo` VALUES (136, '18026738672', 'BBBS.100002', '2021-05-14 12:40:15', '请假');
INSERT INTO `attendinfo` VALUES (137, '18034620973', 'BBBS.100002', '2021-05-14 12:40:15', '请假');
INSERT INTO `attendinfo` VALUES (138, '18641907766', 'BBBS.100002', '2021-05-14 12:40:15', '缺勤');
INSERT INTO `attendinfo` VALUES (139, '19039727092', 'BBBS.100002', '2021-05-14 12:40:15', '出勤');
INSERT INTO `attendinfo` VALUES (140, '19100454727', 'BBBS.100002', '2021-05-14 12:40:15', '出勤');
INSERT INTO `attendinfo` VALUES (141, '19147811984', 'BBBS.100002', '2021-05-14 12:40:15', '出勤');
INSERT INTO `attendinfo` VALUES (142, '19307130203', 'BBBS.100002', '2021-05-14 12:40:15', '出勤');
INSERT INTO `attendinfo` VALUES (143, '20000556491', 'BBBS.100002', '2021-05-14 12:40:15', '缺勤');
INSERT INTO `attendinfo` VALUES (144, '20060097449', 'BBBS.100002', '2021-05-14 12:40:15', '出勤');
INSERT INTO `attendinfo` VALUES (145, '20098081168', 'BBBS.100002', '2021-05-14 12:40:15', '出勤');
INSERT INTO `attendinfo` VALUES (146, '20102985227', 'BBBS.100002', '2021-05-14 12:40:15', '缺勤');
INSERT INTO `attendinfo` VALUES (147, '17008164334', 'BBBS.100002', '2021-06-17 15:59:35', '出勤');
INSERT INTO `attendinfo` VALUES (148, '17081223323', 'BBBS.100002', '2021-06-17 15:59:35', '出勤');
INSERT INTO `attendinfo` VALUES (149, '17156899188', 'BBBS.100002', '2021-06-17 15:59:35', '请假');
INSERT INTO `attendinfo` VALUES (150, '17165103782', 'BBBS.100002', '2021-06-17 15:59:35', '请假');
INSERT INTO `attendinfo` VALUES (151, '18011440603', 'BBBS.100002', '2021-06-17 15:59:35', '出勤');
INSERT INTO `attendinfo` VALUES (152, '18026738672', 'BBBS.100002', '2021-06-17 15:59:35', '缺勤');
INSERT INTO `attendinfo` VALUES (153, '18034620973', 'BBBS.100002', '2021-06-17 15:59:35', '请假');
INSERT INTO `attendinfo` VALUES (154, '18641907766', 'BBBS.100002', '2021-06-17 15:59:35', '出勤');
INSERT INTO `attendinfo` VALUES (155, '19039727092', 'BBBS.100002', '2021-06-17 15:59:35', '出勤');
INSERT INTO `attendinfo` VALUES (156, '19100454727', 'BBBS.100002', '2021-06-17 15:59:35', '出勤');
INSERT INTO `attendinfo` VALUES (157, '19147811984', 'BBBS.100002', '2021-06-17 15:59:35', '缺勤');
INSERT INTO `attendinfo` VALUES (158, '19307130203', 'BBBS.100002', '2021-06-17 15:59:35', '出勤');
INSERT INTO `attendinfo` VALUES (159, '20000556491', 'BBBS.100002', '2021-06-17 15:59:35', '请假');
INSERT INTO `attendinfo` VALUES (160, '20060097449', 'BBBS.100002', '2021-06-17 15:59:35', '缺勤');
INSERT INTO `attendinfo` VALUES (161, '20098081168', 'BBBS.100002', '2021-06-17 15:59:35', '请假');
INSERT INTO `attendinfo` VALUES (162, '20102985227', 'BBBS.100002', '2021-06-17 15:59:35', '缺勤');
INSERT INTO `attendinfo` VALUES (163, '17008164334', 'BBBS.100003', '2021-03-21 16:10:16', '出勤');
INSERT INTO `attendinfo` VALUES (164, '17081223323', 'BBBS.100003', '2021-03-21 16:10:16', '出勤');
INSERT INTO `attendinfo` VALUES (165, '17156899188', 'BBBS.100003', '2021-03-21 16:10:16', '缺勤');
INSERT INTO `attendinfo` VALUES (166, '17165103782', 'BBBS.100003', '2021-03-21 16:10:16', '缺勤');
INSERT INTO `attendinfo` VALUES (167, '18011440603', 'BBBS.100003', '2021-03-21 16:10:16', '出勤');
INSERT INTO `attendinfo` VALUES (168, '18300290007', 'BBBS.100003', '2021-03-21 16:10:16', '出勤');
INSERT INTO `attendinfo` VALUES (169, '18307110276', 'BBBS.100003', '2021-03-21 16:10:16', '缺勤');
INSERT INTO `attendinfo` VALUES (170, '18641907766', 'BBBS.100003', '2021-03-21 16:10:16', '缺勤');
INSERT INTO `attendinfo` VALUES (171, '19039727092', 'BBBS.100003', '2021-03-21 16:10:16', '缺勤');
INSERT INTO `attendinfo` VALUES (172, '19100454727', 'BBBS.100003', '2021-03-21 16:10:16', '出勤');
INSERT INTO `attendinfo` VALUES (173, '19147811984', 'BBBS.100003', '2021-03-21 16:10:16', '请假');
INSERT INTO `attendinfo` VALUES (174, '19307130203', 'BBBS.100003', '2021-03-21 16:10:16', '出勤');
INSERT INTO `attendinfo` VALUES (175, '20000556491', 'BBBS.100003', '2021-03-21 16:10:16', '缺勤');
INSERT INTO `attendinfo` VALUES (176, '20060097449', 'BBBS.100003', '2021-03-21 16:10:16', '出勤');
INSERT INTO `attendinfo` VALUES (177, '20098081168', 'BBBS.100003', '2021-03-21 16:10:16', '缺勤');
INSERT INTO `attendinfo` VALUES (178, '17008164334', 'BBBS.100003', '2021-04-08 15:45:58', '出勤');
INSERT INTO `attendinfo` VALUES (179, '17081223323', 'BBBS.100003', '2021-04-08 15:45:58', '出勤');
INSERT INTO `attendinfo` VALUES (180, '17156899188', 'BBBS.100003', '2021-04-08 15:45:58', '缺勤');
INSERT INTO `attendinfo` VALUES (181, '17165103782', 'BBBS.100003', '2021-04-08 15:45:58', '缺勤');
INSERT INTO `attendinfo` VALUES (182, '18011440603', 'BBBS.100003', '2021-04-08 15:45:58', '出勤');
INSERT INTO `attendinfo` VALUES (183, '18300290007', 'BBBS.100003', '2021-04-08 15:45:58', '出勤');
INSERT INTO `attendinfo` VALUES (184, '18307110276', 'BBBS.100003', '2021-04-08 15:45:58', '出勤');
INSERT INTO `attendinfo` VALUES (185, '18641907766', 'BBBS.100003', '2021-04-08 15:45:58', '缺勤');
INSERT INTO `attendinfo` VALUES (186, '19039727092', 'BBBS.100003', '2021-04-08 15:45:58', '请假');
INSERT INTO `attendinfo` VALUES (187, '19100454727', 'BBBS.100003', '2021-04-08 15:45:58', '请假');
INSERT INTO `attendinfo` VALUES (188, '19147811984', 'BBBS.100003', '2021-04-08 15:45:58', '缺勤');
INSERT INTO `attendinfo` VALUES (189, '19307130203', 'BBBS.100003', '2021-04-08 15:45:58', '出勤');
INSERT INTO `attendinfo` VALUES (190, '20000556491', 'BBBS.100003', '2021-04-08 15:45:58', '缺勤');
INSERT INTO `attendinfo` VALUES (191, '20060097449', 'BBBS.100003', '2021-04-08 15:45:58', '出勤');
INSERT INTO `attendinfo` VALUES (192, '20098081168', 'BBBS.100003', '2021-04-08 15:45:58', '缺勤');
INSERT INTO `attendinfo` VALUES (193, '17008164334', 'BBBS.100003', '2021-06-08 16:22:34', '出勤');
INSERT INTO `attendinfo` VALUES (194, '17081223323', 'BBBS.100003', '2021-06-08 16:22:34', '出勤');
INSERT INTO `attendinfo` VALUES (195, '17156899188', 'BBBS.100003', '2021-06-08 16:22:34', '缺勤');
INSERT INTO `attendinfo` VALUES (196, '17165103782', 'BBBS.100003', '2021-06-08 16:22:34', '缺勤');
INSERT INTO `attendinfo` VALUES (197, '18011440603', 'BBBS.100003', '2021-06-08 16:22:34', '请假');
INSERT INTO `attendinfo` VALUES (198, '18300290007', 'BBBS.100003', '2021-06-08 16:22:34', '出勤');
INSERT INTO `attendinfo` VALUES (199, '18307110276', 'BBBS.100003', '2021-06-08 16:22:34', '请假');
INSERT INTO `attendinfo` VALUES (200, '18641907766', 'BBBS.100003', '2021-06-08 16:22:34', '出勤');
INSERT INTO `attendinfo` VALUES (201, '19039727092', 'BBBS.100003', '2021-06-08 16:22:34', '出勤');
INSERT INTO `attendinfo` VALUES (202, '19100454727', 'BBBS.100003', '2021-06-08 16:22:34', '缺勤');
INSERT INTO `attendinfo` VALUES (203, '19147811984', 'BBBS.100003', '2021-06-08 16:22:34', '缺勤');
INSERT INTO `attendinfo` VALUES (204, '19307130203', 'BBBS.100003', '2021-06-08 16:22:34', '请假');
INSERT INTO `attendinfo` VALUES (205, '20000556491', 'BBBS.100003', '2021-06-08 16:22:34', '缺勤');
INSERT INTO `attendinfo` VALUES (206, '20060097449', 'BBBS.100003', '2021-06-08 16:22:34', '缺勤');
INSERT INTO `attendinfo` VALUES (207, '20098081168', 'BBBS.100003', '2021-06-08 16:22:34', '缺勤');
INSERT INTO `attendinfo` VALUES (208, '17008164334', 'BBBS.100003', '2021-06-23 16:14:06', '出勤');
INSERT INTO `attendinfo` VALUES (209, '17081223323', 'BBBS.100003', '2021-06-23 16:14:06', '出勤');
INSERT INTO `attendinfo` VALUES (210, '17156899188', 'BBBS.100003', '2021-06-23 16:14:06', '出勤');
INSERT INTO `attendinfo` VALUES (211, '17165103782', 'BBBS.100003', '2021-06-23 16:14:06', '缺勤');
INSERT INTO `attendinfo` VALUES (212, '18011440603', 'BBBS.100003', '2021-06-23 16:14:06', '缺勤');
INSERT INTO `attendinfo` VALUES (213, '18300290007', 'BBBS.100003', '2021-06-23 16:14:06', '出勤');
INSERT INTO `attendinfo` VALUES (214, '18307110276', 'BBBS.100003', '2021-06-23 16:14:06', '出勤');
INSERT INTO `attendinfo` VALUES (215, '18641907766', 'BBBS.100003', '2021-06-23 16:14:06', '出勤');
INSERT INTO `attendinfo` VALUES (216, '19039727092', 'BBBS.100003', '2021-06-23 16:14:06', '缺勤');
INSERT INTO `attendinfo` VALUES (217, '19100454727', 'BBBS.100003', '2021-06-23 16:14:06', '请假');
INSERT INTO `attendinfo` VALUES (218, '19147811984', 'BBBS.100003', '2021-06-23 16:14:06', '缺勤');
INSERT INTO `attendinfo` VALUES (219, '19307130203', 'BBBS.100003', '2021-06-23 16:14:06', '出勤');
INSERT INTO `attendinfo` VALUES (220, '20000556491', 'BBBS.100003', '2021-06-23 16:14:06', '缺勤');
INSERT INTO `attendinfo` VALUES (221, '20060097449', 'BBBS.100003', '2021-06-23 16:14:06', '出勤');
INSERT INTO `attendinfo` VALUES (222, '20098081168', 'BBBS.100003', '2021-06-23 16:14:06', '出勤');
INSERT INTO `attendinfo` VALUES (223, '17008164334', 'DATA.100001', '2021-03-21 15:34:19', '出勤');
INSERT INTO `attendinfo` VALUES (224, '17081223323', 'DATA.100001', '2021-03-21 15:34:19', '出勤');
INSERT INTO `attendinfo` VALUES (225, '17156899188', 'DATA.100001', '2021-03-21 15:34:19', '请假');
INSERT INTO `attendinfo` VALUES (226, '17165103782', 'DATA.100001', '2021-03-21 15:34:19', '缺勤');
INSERT INTO `attendinfo` VALUES (227, '17206429873', 'DATA.100001', '2021-03-21 15:34:19', '缺勤');
INSERT INTO `attendinfo` VALUES (228, '18011440603', 'DATA.100001', '2021-03-21 15:34:19', '缺勤');
INSERT INTO `attendinfo` VALUES (229, '18026738672', 'DATA.100001', '2021-03-21 15:34:19', '出勤');
INSERT INTO `attendinfo` VALUES (230, '18034620973', 'DATA.100001', '2021-03-21 15:34:19', '出勤');
INSERT INTO `attendinfo` VALUES (231, '18091786225', 'DATA.100001', '2021-03-21 15:34:19', '出勤');
INSERT INTO `attendinfo` VALUES (232, '18107333919', 'DATA.100001', '2021-03-21 15:34:19', '缺勤');
INSERT INTO `attendinfo` VALUES (233, '18300290007', 'DATA.100001', '2021-03-21 15:34:19', '出勤');
INSERT INTO `attendinfo` VALUES (234, '18307110276', 'DATA.100001', '2021-03-21 15:34:19', '出勤');
INSERT INTO `attendinfo` VALUES (235, '18928477036', 'DATA.100001', '2021-03-21 15:34:19', '出勤');
INSERT INTO `attendinfo` VALUES (236, '19039727092', 'DATA.100001', '2021-03-21 15:34:19', '请假');
INSERT INTO `attendinfo` VALUES (237, '19100454727', 'DATA.100001', '2021-03-21 15:34:19', '出勤');
INSERT INTO `attendinfo` VALUES (238, '19147811984', 'DATA.100001', '2021-03-21 15:34:19', '出勤');
INSERT INTO `attendinfo` VALUES (239, '19260808212', 'DATA.100001', '2021-03-21 15:34:19', '缺勤');
INSERT INTO `attendinfo` VALUES (240, '19307130203', 'DATA.100001', '2021-03-21 15:34:19', '出勤');
INSERT INTO `attendinfo` VALUES (241, '19490589977', 'DATA.100001', '2021-03-21 15:34:19', '缺勤');
INSERT INTO `attendinfo` VALUES (242, '19818219604', 'DATA.100001', '2021-03-21 15:34:19', '缺勤');
INSERT INTO `attendinfo` VALUES (243, '19854931373', 'DATA.100001', '2021-03-21 15:34:19', '请假');
INSERT INTO `attendinfo` VALUES (244, '20000556491', 'DATA.100001', '2021-03-21 15:34:19', '缺勤');
INSERT INTO `attendinfo` VALUES (245, '20060097449', 'DATA.100001', '2021-03-21 15:34:19', '缺勤');
INSERT INTO `attendinfo` VALUES (246, '20098081168', 'DATA.100001', '2021-03-21 15:34:19', '出勤');
INSERT INTO `attendinfo` VALUES (247, '20102985227', 'DATA.100001', '2021-03-21 15:34:19', '出勤');
INSERT INTO `attendinfo` VALUES (248, '20114218819', 'DATA.100001', '2021-03-21 15:34:19', '出勤');
INSERT INTO `attendinfo` VALUES (249, '17008164334', 'DATA.100001', '2021-03-28 09:55:18', '缺勤');
INSERT INTO `attendinfo` VALUES (250, '17081223323', 'DATA.100001', '2021-03-28 09:55:18', '缺勤');
INSERT INTO `attendinfo` VALUES (251, '17156899188', 'DATA.100001', '2021-03-28 09:55:18', '请假');
INSERT INTO `attendinfo` VALUES (252, '17165103782', 'DATA.100001', '2021-03-28 09:55:18', '出勤');
INSERT INTO `attendinfo` VALUES (253, '17206429873', 'DATA.100001', '2021-03-28 09:55:18', '缺勤');
INSERT INTO `attendinfo` VALUES (254, '18011440603', 'DATA.100001', '2021-03-28 09:55:18', '出勤');
INSERT INTO `attendinfo` VALUES (255, '18026738672', 'DATA.100001', '2021-03-28 09:55:18', '缺勤');
INSERT INTO `attendinfo` VALUES (256, '18034620973', 'DATA.100001', '2021-03-28 09:55:18', '请假');
INSERT INTO `attendinfo` VALUES (257, '18091786225', 'DATA.100001', '2021-03-28 09:55:18', '缺勤');
INSERT INTO `attendinfo` VALUES (258, '18107333919', 'DATA.100001', '2021-03-28 09:55:18', '出勤');
INSERT INTO `attendinfo` VALUES (259, '18300290007', 'DATA.100001', '2021-03-28 09:55:18', '出勤');
INSERT INTO `attendinfo` VALUES (260, '18307110276', 'DATA.100001', '2021-03-28 09:55:18', '出勤');
INSERT INTO `attendinfo` VALUES (261, '18928477036', 'DATA.100001', '2021-03-28 09:55:18', '请假');
INSERT INTO `attendinfo` VALUES (262, '19039727092', 'DATA.100001', '2021-03-28 09:55:18', '缺勤');
INSERT INTO `attendinfo` VALUES (263, '19100454727', 'DATA.100001', '2021-03-28 09:55:18', '缺勤');
INSERT INTO `attendinfo` VALUES (264, '19147811984', 'DATA.100001', '2021-03-28 09:55:18', '缺勤');
INSERT INTO `attendinfo` VALUES (265, '19260808212', 'DATA.100001', '2021-03-28 09:55:18', '出勤');
INSERT INTO `attendinfo` VALUES (266, '19307130203', 'DATA.100001', '2021-03-28 09:55:18', '出勤');
INSERT INTO `attendinfo` VALUES (267, '19490589977', 'DATA.100001', '2021-03-28 09:55:18', '缺勤');
INSERT INTO `attendinfo` VALUES (268, '19818219604', 'DATA.100001', '2021-03-28 09:55:18', '缺勤');
INSERT INTO `attendinfo` VALUES (269, '19854931373', 'DATA.100001', '2021-03-28 09:55:18', '请假');
INSERT INTO `attendinfo` VALUES (270, '20000556491', 'DATA.100001', '2021-03-28 09:55:18', '出勤');
INSERT INTO `attendinfo` VALUES (271, '20060097449', 'DATA.100001', '2021-03-28 09:55:18', '缺勤');
INSERT INTO `attendinfo` VALUES (272, '20098081168', 'DATA.100001', '2021-03-28 09:55:18', '缺勤');
INSERT INTO `attendinfo` VALUES (273, '20102985227', 'DATA.100001', '2021-03-28 09:55:18', '出勤');
INSERT INTO `attendinfo` VALUES (274, '20114218819', 'DATA.100001', '2021-03-28 09:55:18', '缺勤');
INSERT INTO `attendinfo` VALUES (275, '17008164334', 'DATA.100001', '2021-04-23 09:58:59', '出勤');
INSERT INTO `attendinfo` VALUES (276, '17081223323', 'DATA.100001', '2021-04-23 09:58:59', '缺勤');
INSERT INTO `attendinfo` VALUES (277, '17156899188', 'DATA.100001', '2021-04-23 09:58:59', '出勤');
INSERT INTO `attendinfo` VALUES (278, '17165103782', 'DATA.100001', '2021-04-23 09:58:59', '缺勤');
INSERT INTO `attendinfo` VALUES (279, '17206429873', 'DATA.100001', '2021-04-23 09:58:59', '出勤');
INSERT INTO `attendinfo` VALUES (280, '18011440603', 'DATA.100001', '2021-04-23 09:58:59', '出勤');
INSERT INTO `attendinfo` VALUES (281, '18026738672', 'DATA.100001', '2021-04-23 09:58:59', '缺勤');
INSERT INTO `attendinfo` VALUES (282, '18034620973', 'DATA.100001', '2021-04-23 09:58:59', '出勤');
INSERT INTO `attendinfo` VALUES (283, '18091786225', 'DATA.100001', '2021-04-23 09:58:59', '缺勤');
INSERT INTO `attendinfo` VALUES (284, '18107333919', 'DATA.100001', '2021-04-23 09:58:59', '缺勤');
INSERT INTO `attendinfo` VALUES (285, '18300290007', 'DATA.100001', '2021-04-23 09:58:59', '出勤');
INSERT INTO `attendinfo` VALUES (286, '18307110276', 'DATA.100001', '2021-04-23 09:58:59', '出勤');
INSERT INTO `attendinfo` VALUES (287, '18928477036', 'DATA.100001', '2021-04-23 09:58:59', '缺勤');
INSERT INTO `attendinfo` VALUES (288, '19039727092', 'DATA.100001', '2021-04-23 09:58:59', '出勤');
INSERT INTO `attendinfo` VALUES (289, '19100454727', 'DATA.100001', '2021-04-23 09:58:59', '缺勤');
INSERT INTO `attendinfo` VALUES (290, '19147811984', 'DATA.100001', '2021-04-23 09:58:59', '缺勤');
INSERT INTO `attendinfo` VALUES (291, '19260808212', 'DATA.100001', '2021-04-23 09:58:59', '出勤');
INSERT INTO `attendinfo` VALUES (292, '19307130203', 'DATA.100001', '2021-04-23 09:58:59', '出勤');
INSERT INTO `attendinfo` VALUES (293, '19490589977', 'DATA.100001', '2021-04-23 09:58:59', '出勤');
INSERT INTO `attendinfo` VALUES (294, '19818219604', 'DATA.100001', '2021-04-23 09:58:59', '缺勤');
INSERT INTO `attendinfo` VALUES (295, '19854931373', 'DATA.100001', '2021-04-23 09:58:59', '请假');
INSERT INTO `attendinfo` VALUES (296, '20000556491', 'DATA.100001', '2021-04-23 09:58:59', '请假');
INSERT INTO `attendinfo` VALUES (297, '20060097449', 'DATA.100001', '2021-04-23 09:58:59', '缺勤');
INSERT INTO `attendinfo` VALUES (298, '20098081168', 'DATA.100001', '2021-04-23 09:58:59', '出勤');
INSERT INTO `attendinfo` VALUES (299, '20102985227', 'DATA.100001', '2021-04-23 09:58:59', '缺勤');
INSERT INTO `attendinfo` VALUES (300, '20114218819', 'DATA.100001', '2021-04-23 09:58:59', '缺勤');
INSERT INTO `attendinfo` VALUES (301, '17008164334', 'DATA.100001', '2021-06-07 10:22:45', '出勤');
INSERT INTO `attendinfo` VALUES (302, '17081223323', 'DATA.100001', '2021-06-07 10:22:45', '出勤');
INSERT INTO `attendinfo` VALUES (303, '17156899188', 'DATA.100001', '2021-06-07 10:22:45', '请假');
INSERT INTO `attendinfo` VALUES (304, '17165103782', 'DATA.100001', '2021-06-07 10:22:45', '缺勤');
INSERT INTO `attendinfo` VALUES (305, '17206429873', 'DATA.100001', '2021-06-07 10:22:45', '缺勤');
INSERT INTO `attendinfo` VALUES (306, '18011440603', 'DATA.100001', '2021-06-07 10:22:45', '出勤');
INSERT INTO `attendinfo` VALUES (307, '18026738672', 'DATA.100001', '2021-06-07 10:22:45', '缺勤');
INSERT INTO `attendinfo` VALUES (308, '18034620973', 'DATA.100001', '2021-06-07 10:22:45', '请假');
INSERT INTO `attendinfo` VALUES (309, '18091786225', 'DATA.100001', '2021-06-07 10:22:45', '缺勤');
INSERT INTO `attendinfo` VALUES (310, '18107333919', 'DATA.100001', '2021-06-07 10:22:45', '出勤');
INSERT INTO `attendinfo` VALUES (311, '18300290007', 'DATA.100001', '2021-06-07 10:22:45', '出勤');
INSERT INTO `attendinfo` VALUES (312, '18307110276', 'DATA.100001', '2021-06-07 10:22:45', '出勤');
INSERT INTO `attendinfo` VALUES (313, '18928477036', 'DATA.100001', '2021-06-07 10:22:45', '出勤');
INSERT INTO `attendinfo` VALUES (314, '19039727092', 'DATA.100001', '2021-06-07 10:22:45', '缺勤');
INSERT INTO `attendinfo` VALUES (315, '19100454727', 'DATA.100001', '2021-06-07 10:22:45', '缺勤');
INSERT INTO `attendinfo` VALUES (316, '19147811984', 'DATA.100001', '2021-06-07 10:22:45', '缺勤');
INSERT INTO `attendinfo` VALUES (317, '19260808212', 'DATA.100001', '2021-06-07 10:22:45', '缺勤');
INSERT INTO `attendinfo` VALUES (318, '19307130203', 'DATA.100001', '2021-06-07 10:22:45', '出勤');
INSERT INTO `attendinfo` VALUES (319, '19490589977', 'DATA.100001', '2021-06-07 10:22:45', '出勤');
INSERT INTO `attendinfo` VALUES (320, '19818219604', 'DATA.100001', '2021-06-07 10:22:45', '缺勤');
INSERT INTO `attendinfo` VALUES (321, '19854931373', 'DATA.100001', '2021-06-07 10:22:45', '请假');
INSERT INTO `attendinfo` VALUES (322, '20000556491', 'DATA.100001', '2021-06-07 10:22:45', '缺勤');
INSERT INTO `attendinfo` VALUES (323, '20060097449', 'DATA.100001', '2021-06-07 10:22:45', '缺勤');
INSERT INTO `attendinfo` VALUES (324, '20098081168', 'DATA.100001', '2021-06-07 10:22:45', '出勤');
INSERT INTO `attendinfo` VALUES (325, '20102985227', 'DATA.100001', '2021-06-07 10:22:45', '缺勤');
INSERT INTO `attendinfo` VALUES (326, '20114218819', 'DATA.100001', '2021-06-07 10:22:45', '请假');
INSERT INTO `attendinfo` VALUES (327, '17008164334', 'DATA.100001', '2021-06-23 16:35:13', '缺勤');
INSERT INTO `attendinfo` VALUES (328, '17081223323', 'DATA.100001', '2021-06-23 16:35:13', '缺勤');
INSERT INTO `attendinfo` VALUES (329, '17156899188', 'DATA.100001', '2021-06-23 16:35:13', '出勤');
INSERT INTO `attendinfo` VALUES (330, '17165103782', 'DATA.100001', '2021-06-23 16:35:13', '缺勤');
INSERT INTO `attendinfo` VALUES (331, '17206429873', 'DATA.100001', '2021-06-23 16:35:13', '出勤');
INSERT INTO `attendinfo` VALUES (332, '18011440603', 'DATA.100001', '2021-06-23 16:35:13', '缺勤');
INSERT INTO `attendinfo` VALUES (333, '18026738672', 'DATA.100001', '2021-06-23 16:35:13', '出勤');
INSERT INTO `attendinfo` VALUES (334, '18034620973', 'DATA.100001', '2021-06-23 16:35:13', '缺勤');
INSERT INTO `attendinfo` VALUES (335, '18091786225', 'DATA.100001', '2021-06-23 16:35:13', '缺勤');
INSERT INTO `attendinfo` VALUES (336, '18107333919', 'DATA.100001', '2021-06-23 16:35:13', '缺勤');
INSERT INTO `attendinfo` VALUES (337, '18300290007', 'DATA.100001', '2021-06-23 16:35:13', '出勤');
INSERT INTO `attendinfo` VALUES (338, '18307110276', 'DATA.100001', '2021-06-23 16:35:13', '出勤');
INSERT INTO `attendinfo` VALUES (339, '18928477036', 'DATA.100001', '2021-06-23 16:35:13', '缺勤');
INSERT INTO `attendinfo` VALUES (340, '19039727092', 'DATA.100001', '2021-06-23 16:35:13', '出勤');
INSERT INTO `attendinfo` VALUES (341, '19100454727', 'DATA.100001', '2021-06-23 16:35:13', '缺勤');
INSERT INTO `attendinfo` VALUES (342, '19147811984', 'DATA.100001', '2021-06-23 16:35:13', '出勤');
INSERT INTO `attendinfo` VALUES (343, '19260808212', 'DATA.100001', '2021-06-23 16:35:13', '出勤');
INSERT INTO `attendinfo` VALUES (344, '19307130203', 'DATA.100001', '2021-06-23 16:35:13', '出勤');
INSERT INTO `attendinfo` VALUES (345, '19490589977', 'DATA.100001', '2021-06-23 16:35:13', '请假');
INSERT INTO `attendinfo` VALUES (346, '19818219604', 'DATA.100001', '2021-06-23 16:35:13', '缺勤');
INSERT INTO `attendinfo` VALUES (347, '19854931373', 'DATA.100001', '2021-06-23 16:35:13', '出勤');
INSERT INTO `attendinfo` VALUES (348, '20000556491', 'DATA.100001', '2021-06-23 16:35:13', '缺勤');
INSERT INTO `attendinfo` VALUES (349, '20060097449', 'DATA.100001', '2021-06-23 16:35:13', '出勤');
INSERT INTO `attendinfo` VALUES (350, '20098081168', 'DATA.100001', '2021-06-23 16:35:13', '缺勤');
INSERT INTO `attendinfo` VALUES (351, '20102985227', 'DATA.100001', '2021-06-23 16:35:13', '出勤');
INSERT INTO `attendinfo` VALUES (352, '20114218819', 'DATA.100001', '2021-06-23 16:35:13', '缺勤');
INSERT INTO `attendinfo` VALUES (353, '17008164334', 'DATA.100008', '2021-04-23 08:00:01', '出勤');
INSERT INTO `attendinfo` VALUES (354, '17081223323', 'DATA.100008', '2021-04-23 08:00:01', '缺勤');
INSERT INTO `attendinfo` VALUES (355, '17156899188', 'DATA.100008', '2021-04-23 08:00:01', '缺勤');
INSERT INTO `attendinfo` VALUES (356, '17206429873', 'DATA.100008', '2021-04-23 08:00:01', '请假');
INSERT INTO `attendinfo` VALUES (357, '18011440603', 'DATA.100008', '2021-04-23 08:00:01', '缺勤');
INSERT INTO `attendinfo` VALUES (358, '18300290007', 'DATA.100008', '2021-04-23 08:00:01', '请假');
INSERT INTO `attendinfo` VALUES (359, '18307110276', 'DATA.100008', '2021-04-23 08:00:01', '出勤');
INSERT INTO `attendinfo` VALUES (360, '18928477036', 'DATA.100008', '2021-04-23 08:00:01', '缺勤');
INSERT INTO `attendinfo` VALUES (361, '19100454727', 'DATA.100008', '2021-04-23 08:00:01', '缺勤');
INSERT INTO `attendinfo` VALUES (362, '19260808212', 'DATA.100008', '2021-04-23 08:00:01', '出勤');
INSERT INTO `attendinfo` VALUES (363, '19307130203', 'DATA.100008', '2021-04-23 08:00:01', '出勤');
INSERT INTO `attendinfo` VALUES (364, '20000556491', 'DATA.100008', '2021-04-23 08:00:01', '出勤');
INSERT INTO `attendinfo` VALUES (365, '20060097449', 'DATA.100008', '2021-04-23 08:00:01', '缺勤');
INSERT INTO `attendinfo` VALUES (366, '20279114441', 'DATA.100008', '2021-04-23 08:00:01', '请假');
INSERT INTO `attendinfo` VALUES (367, '17008164334', 'DATA.100008', '2021-05-17 08:02:22', '出勤');
INSERT INTO `attendinfo` VALUES (368, '17081223323', 'DATA.100008', '2021-05-17 08:02:22', '缺勤');
INSERT INTO `attendinfo` VALUES (369, '17156899188', 'DATA.100008', '2021-05-17 08:02:22', '出勤');
INSERT INTO `attendinfo` VALUES (370, '17206429873', 'DATA.100008', '2021-05-17 08:02:22', '缺勤');
INSERT INTO `attendinfo` VALUES (371, '18011440603', 'DATA.100008', '2021-05-17 08:02:22', '缺勤');
INSERT INTO `attendinfo` VALUES (372, '18300290007', 'DATA.100008', '2021-05-17 08:02:22', '出勤');
INSERT INTO `attendinfo` VALUES (373, '18307110276', 'DATA.100008', '2021-05-17 08:02:22', '出勤');
INSERT INTO `attendinfo` VALUES (374, '18928477036', 'DATA.100008', '2021-05-17 08:02:22', '缺勤');
INSERT INTO `attendinfo` VALUES (375, '19100454727', 'DATA.100008', '2021-05-17 08:02:22', '请假');
INSERT INTO `attendinfo` VALUES (376, '19260808212', 'DATA.100008', '2021-05-17 08:02:22', '缺勤');
INSERT INTO `attendinfo` VALUES (377, '19307130203', 'DATA.100008', '2021-05-17 08:02:22', '出勤');
INSERT INTO `attendinfo` VALUES (378, '20000556491', 'DATA.100008', '2021-05-17 08:02:22', '出勤');
INSERT INTO `attendinfo` VALUES (379, '20060097449', 'DATA.100008', '2021-05-17 08:02:22', '出勤');
INSERT INTO `attendinfo` VALUES (380, '20279114441', 'DATA.100008', '2021-05-17 08:02:22', '出勤');
INSERT INTO `attendinfo` VALUES (381, '17008164334', 'DATA.100008', '2021-06-14 09:10:11', '缺勤');
INSERT INTO `attendinfo` VALUES (382, '17081223323', 'DATA.100008', '2021-06-14 09:10:11', '出勤');
INSERT INTO `attendinfo` VALUES (383, '17156899188', 'DATA.100008', '2021-06-14 09:10:11', '缺勤');
INSERT INTO `attendinfo` VALUES (384, '17206429873', 'DATA.100008', '2021-06-14 09:10:11', '请假');
INSERT INTO `attendinfo` VALUES (385, '18011440603', 'DATA.100008', '2021-06-14 09:10:11', '缺勤');
INSERT INTO `attendinfo` VALUES (386, '18300290007', 'DATA.100008', '2021-06-14 09:10:11', '出勤');
INSERT INTO `attendinfo` VALUES (387, '18307110276', 'DATA.100008', '2021-06-14 09:10:11', '出勤');
INSERT INTO `attendinfo` VALUES (388, '18928477036', 'DATA.100008', '2021-06-14 09:10:11', '出勤');
INSERT INTO `attendinfo` VALUES (389, '19100454727', 'DATA.100008', '2021-06-14 09:10:11', '请假');
INSERT INTO `attendinfo` VALUES (390, '19260808212', 'DATA.100008', '2021-06-14 09:10:11', '缺勤');
INSERT INTO `attendinfo` VALUES (391, '19307130203', 'DATA.100008', '2021-06-14 09:10:11', '出勤');
INSERT INTO `attendinfo` VALUES (392, '20000556491', 'DATA.100008', '2021-06-14 09:10:11', '缺勤');
INSERT INTO `attendinfo` VALUES (393, '20060097449', 'DATA.100008', '2021-06-14 09:10:11', '请假');
INSERT INTO `attendinfo` VALUES (394, '20279114441', 'DATA.100008', '2021-06-14 09:10:11', '缺勤');
INSERT INTO `attendinfo` VALUES (395, '17008164334', 'DATA.100008', '2021-06-23 16:47:37', '请假');
INSERT INTO `attendinfo` VALUES (396, '17081223323', 'DATA.100008', '2021-06-23 16:47:37', '缺勤');
INSERT INTO `attendinfo` VALUES (397, '17156899188', 'DATA.100008', '2021-06-23 16:47:37', '出勤');
INSERT INTO `attendinfo` VALUES (398, '17206429873', 'DATA.100008', '2021-06-23 16:47:37', '出勤');
INSERT INTO `attendinfo` VALUES (399, '18011440603', 'DATA.100008', '2021-06-23 16:47:37', '缺勤');
INSERT INTO `attendinfo` VALUES (400, '18300290007', 'DATA.100008', '2021-06-23 16:47:37', '出勤');
INSERT INTO `attendinfo` VALUES (401, '18307110276', 'DATA.100008', '2021-06-23 16:47:37', '出勤');
INSERT INTO `attendinfo` VALUES (402, '18928477036', 'DATA.100008', '2021-06-23 16:47:37', '出勤');
INSERT INTO `attendinfo` VALUES (403, '19100454727', 'DATA.100008', '2021-06-23 16:47:37', '缺勤');
INSERT INTO `attendinfo` VALUES (404, '19260808212', 'DATA.100008', '2021-06-23 16:47:37', '缺勤');
INSERT INTO `attendinfo` VALUES (405, '19307130203', 'DATA.100008', '2021-06-23 16:47:37', '出勤');
INSERT INTO `attendinfo` VALUES (406, '20000556491', 'DATA.100008', '2021-06-23 16:47:37', '请假');
INSERT INTO `attendinfo` VALUES (407, '20060097449', 'DATA.100008', '2021-06-23 16:47:37', '缺勤');
INSERT INTO `attendinfo` VALUES (408, '20279114441', 'DATA.100008', '2021-06-23 16:47:37', '请假');
COMMIT;

-- ----------------------------
-- Table structure for lessoninfo
-- ----------------------------
DROP TABLE IF EXISTS `lessoninfo`;
CREATE TABLE `lessoninfo` (
  `Code` varchar(20) NOT NULL COMMENT '课程代码',
  `Name` varchar(20) NOT NULL COMMENT '课程名',
  `num` int(4) DEFAULT '0',
  `Times` int(11) NOT NULL DEFAULT '0' COMMENT '出勤统计次数',
  `Place` varchar(10) DEFAULT NULL COMMENT '上课地点',
  PRIMARY KEY (`Code`) USING BTREE,
  UNIQUE KEY `Code` (`Code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of lessoninfo
-- ----------------------------
BEGIN;
INSERT INTO `lessoninfo` VALUES ('BBBS.100001', '摸鱼学', 21, 5, 'HGX507');
INSERT INTO `lessoninfo` VALUES ('BBBS.100002', '统计学', 16, 4, 'H4107');
INSERT INTO `lessoninfo` VALUES ('BBBS.100003', '英语口译', 15, 13, 'H2209');
INSERT INTO `lessoninfo` VALUES ('DATA.100001', '数据库及实现', 26, 5, 'H4105');
INSERT INTO `lessoninfo` VALUES ('DATA.100002', '统计学基础I', 0, 0, 'H4106');
INSERT INTO `lessoninfo` VALUES ('DATA.100003', '最优化方法', 0, 0, 'H4101');
INSERT INTO `lessoninfo` VALUES ('DATA.100004', '随机过程', 0, 0, 'H4306');
INSERT INTO `lessoninfo` VALUES ('DATA.100005', '社交网络挖掘', 0, 0, 'H3408');
INSERT INTO `lessoninfo` VALUES ('DATA.100006', '计算机视觉', 0, 0, 'H4103');
INSERT INTO `lessoninfo` VALUES ('DATA.100007', '神经网络与深度学习', 0, 0, 'HGX506');
INSERT INTO `lessoninfo` VALUES ('DATA.100008', '图数据管理与挖掘', 14, 4, 'H4105');
COMMIT;

-- ----------------------------
-- Table structure for lessonstudent
-- ----------------------------
DROP TABLE IF EXISTS `lessonstudent`;
CREATE TABLE `lessonstudent` (
  `Code` varchar(20) NOT NULL COMMENT '课程代码',
  `Id` varchar(11) NOT NULL COMMENT '学生学号',
  PRIMARY KEY (`Code`,`Id`) USING BTREE,
  KEY `ls_fk_si` (`Id`) USING BTREE,
  CONSTRAINT `ls_fk_li` FOREIGN KEY (`Code`) REFERENCES `lessoninfo` (`Code`),
  CONSTRAINT `ls_fk_si` FOREIGN KEY (`Id`) REFERENCES `studentinfo` (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of lessonstudent
-- ----------------------------
BEGIN;
INSERT INTO `lessonstudent` VALUES ('BBBS.100002', '17008164334');
INSERT INTO `lessonstudent` VALUES ('BBBS.100003', '17008164334');
INSERT INTO `lessonstudent` VALUES ('DATA.100001', '17008164334');
INSERT INTO `lessonstudent` VALUES ('DATA.100008', '17008164334');
INSERT INTO `lessonstudent` VALUES ('BBBS.100001', '17081223323');
INSERT INTO `lessonstudent` VALUES ('BBBS.100002', '17081223323');
INSERT INTO `lessonstudent` VALUES ('BBBS.100003', '17081223323');
INSERT INTO `lessonstudent` VALUES ('DATA.100001', '17081223323');
INSERT INTO `lessonstudent` VALUES ('DATA.100008', '17081223323');
INSERT INTO `lessonstudent` VALUES ('BBBS.100002', '17156899188');
INSERT INTO `lessonstudent` VALUES ('BBBS.100003', '17156899188');
INSERT INTO `lessonstudent` VALUES ('DATA.100001', '17156899188');
INSERT INTO `lessonstudent` VALUES ('DATA.100008', '17156899188');
INSERT INTO `lessonstudent` VALUES ('BBBS.100002', '17165103782');
INSERT INTO `lessonstudent` VALUES ('BBBS.100003', '17165103782');
INSERT INTO `lessonstudent` VALUES ('DATA.100001', '17165103782');
INSERT INTO `lessonstudent` VALUES ('DATA.100001', '17206429873');
INSERT INTO `lessonstudent` VALUES ('DATA.100008', '17206429873');
INSERT INTO `lessonstudent` VALUES ('BBBS.100001', '17233036523');
INSERT INTO `lessonstudent` VALUES ('BBBS.100001', '17279240585');
INSERT INTO `lessonstudent` VALUES ('BBBS.100001', '17439589453');
INSERT INTO `lessonstudent` VALUES ('BBBS.100001', '17688932082');
INSERT INTO `lessonstudent` VALUES ('BBBS.100001', '17977749826');
INSERT INTO `lessonstudent` VALUES ('BBBS.100002', '18011440603');
INSERT INTO `lessonstudent` VALUES ('BBBS.100003', '18011440603');
INSERT INTO `lessonstudent` VALUES ('DATA.100001', '18011440603');
INSERT INTO `lessonstudent` VALUES ('DATA.100008', '18011440603');
INSERT INTO `lessonstudent` VALUES ('BBBS.100002', '18026738672');
INSERT INTO `lessonstudent` VALUES ('DATA.100001', '18026738672');
INSERT INTO `lessonstudent` VALUES ('BBBS.100001', '18034620973');
INSERT INTO `lessonstudent` VALUES ('BBBS.100002', '18034620973');
INSERT INTO `lessonstudent` VALUES ('DATA.100001', '18034620973');
INSERT INTO `lessonstudent` VALUES ('BBBS.100001', '18091786225');
INSERT INTO `lessonstudent` VALUES ('DATA.100001', '18091786225');
INSERT INTO `lessonstudent` VALUES ('DATA.100001', '18107333919');
INSERT INTO `lessonstudent` VALUES ('BBBS.100003', '18300290007');
INSERT INTO `lessonstudent` VALUES ('DATA.100001', '18300290007');
INSERT INTO `lessonstudent` VALUES ('DATA.100008', '18300290007');
INSERT INTO `lessonstudent` VALUES ('BBBS.100003', '18307110276');
INSERT INTO `lessonstudent` VALUES ('DATA.100001', '18307110276');
INSERT INTO `lessonstudent` VALUES ('DATA.100008', '18307110276');
INSERT INTO `lessonstudent` VALUES ('BBBS.100001', '18641907766');
INSERT INTO `lessonstudent` VALUES ('BBBS.100002', '18641907766');
INSERT INTO `lessonstudent` VALUES ('BBBS.100003', '18641907766');
INSERT INTO `lessonstudent` VALUES ('BBBS.100001', '18745712355');
INSERT INTO `lessonstudent` VALUES ('DATA.100001', '18928477036');
INSERT INTO `lessonstudent` VALUES ('DATA.100008', '18928477036');
INSERT INTO `lessonstudent` VALUES ('BBBS.100001', '18949769032');
INSERT INTO `lessonstudent` VALUES ('BBBS.100001', '19039727092');
INSERT INTO `lessonstudent` VALUES ('BBBS.100002', '19039727092');
INSERT INTO `lessonstudent` VALUES ('BBBS.100003', '19039727092');
INSERT INTO `lessonstudent` VALUES ('DATA.100001', '19039727092');
INSERT INTO `lessonstudent` VALUES ('BBBS.100002', '19100454727');
INSERT INTO `lessonstudent` VALUES ('BBBS.100003', '19100454727');
INSERT INTO `lessonstudent` VALUES ('DATA.100001', '19100454727');
INSERT INTO `lessonstudent` VALUES ('DATA.100008', '19100454727');
INSERT INTO `lessonstudent` VALUES ('BBBS.100002', '19147811984');
INSERT INTO `lessonstudent` VALUES ('BBBS.100003', '19147811984');
INSERT INTO `lessonstudent` VALUES ('DATA.100001', '19147811984');
INSERT INTO `lessonstudent` VALUES ('DATA.100001', '19260808212');
INSERT INTO `lessonstudent` VALUES ('DATA.100008', '19260808212');
INSERT INTO `lessonstudent` VALUES ('BBBS.100002', '19307130203');
INSERT INTO `lessonstudent` VALUES ('BBBS.100003', '19307130203');
INSERT INTO `lessonstudent` VALUES ('DATA.100001', '19307130203');
INSERT INTO `lessonstudent` VALUES ('DATA.100008', '19307130203');
INSERT INTO `lessonstudent` VALUES ('DATA.100001', '19490589977');
INSERT INTO `lessonstudent` VALUES ('BBBS.100001', '19656946957');
INSERT INTO `lessonstudent` VALUES ('BBBS.100001', '19687866438');
INSERT INTO `lessonstudent` VALUES ('DATA.100001', '19818219604');
INSERT INTO `lessonstudent` VALUES ('BBBS.100001', '19854931373');
INSERT INTO `lessonstudent` VALUES ('DATA.100001', '19854931373');
INSERT INTO `lessonstudent` VALUES ('BBBS.100001', '19997902569');
INSERT INTO `lessonstudent` VALUES ('BBBS.100002', '20000556491');
INSERT INTO `lessonstudent` VALUES ('BBBS.100003', '20000556491');
INSERT INTO `lessonstudent` VALUES ('DATA.100001', '20000556491');
INSERT INTO `lessonstudent` VALUES ('DATA.100008', '20000556491');
INSERT INTO `lessonstudent` VALUES ('BBBS.100002', '20060097449');
INSERT INTO `lessonstudent` VALUES ('BBBS.100003', '20060097449');
INSERT INTO `lessonstudent` VALUES ('DATA.100001', '20060097449');
INSERT INTO `lessonstudent` VALUES ('DATA.100008', '20060097449');
INSERT INTO `lessonstudent` VALUES ('BBBS.100001', '20098081168');
INSERT INTO `lessonstudent` VALUES ('BBBS.100002', '20098081168');
INSERT INTO `lessonstudent` VALUES ('BBBS.100003', '20098081168');
INSERT INTO `lessonstudent` VALUES ('DATA.100001', '20098081168');
INSERT INTO `lessonstudent` VALUES ('BBBS.100002', '20102985227');
INSERT INTO `lessonstudent` VALUES ('DATA.100001', '20102985227');
INSERT INTO `lessonstudent` VALUES ('DATA.100001', '20114218819');
INSERT INTO `lessonstudent` VALUES ('BBBS.100001', '20193122526');
INSERT INTO `lessonstudent` VALUES ('DATA.100008', '20279114441');
INSERT INTO `lessonstudent` VALUES ('BBBS.100001', '20527549014');
INSERT INTO `lessonstudent` VALUES ('BBBS.100001', '20924733513');
INSERT INTO `lessonstudent` VALUES ('BBBS.100001', '20989521282');
COMMIT;

-- ----------------------------
-- Table structure for lessonteacher
-- ----------------------------
DROP TABLE IF EXISTS `lessonteacher`;
CREATE TABLE `lessonteacher` (
  `Code` varchar(20) NOT NULL COMMENT '课程代码',
  `Id` varchar(11) NOT NULL COMMENT '老师工号',
  PRIMARY KEY (`Code`,`Id`) USING BTREE,
  KEY `lt_fk_ti` (`Id`) USING BTREE,
  CONSTRAINT `lt_fk_li` FOREIGN KEY (`Code`) REFERENCES `lessoninfo` (`Code`),
  CONSTRAINT `lt_fk_ti` FOREIGN KEY (`Id`) REFERENCES `teacherinfo` (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of lessonteacher
-- ----------------------------
BEGIN;
INSERT INTO `lessonteacher` VALUES ('DATA.100001', '000001');
INSERT INTO `lessonteacher` VALUES ('DATA.100008', '000001');
INSERT INTO `lessonteacher` VALUES ('DATA.100002', '000002');
INSERT INTO `lessonteacher` VALUES ('DATA.100001', '000003');
INSERT INTO `lessonteacher` VALUES ('DATA.100003', '000003');
INSERT INTO `lessonteacher` VALUES ('DATA.100004', '000004');
INSERT INTO `lessonteacher` VALUES ('DATA.100005', '000005');
INSERT INTO `lessonteacher` VALUES ('DATA.100006', '000006');
INSERT INTO `lessonteacher` VALUES ('DATA.100007', '000007');
INSERT INTO `lessonteacher` VALUES ('BBBS.100001', '1');
INSERT INTO `lessonteacher` VALUES ('BBBS.100002', '1');
INSERT INTO `lessonteacher` VALUES ('BBBS.100003', '1');
INSERT INTO `lessonteacher` VALUES ('DATA.100001', '2');
INSERT INTO `lessonteacher` VALUES ('BBBS.100001', '3');
INSERT INTO `lessonteacher` VALUES ('BBBS.100002', '3');
INSERT INTO `lessonteacher` VALUES ('BBBS.100003', '3');
INSERT INTO `lessonteacher` VALUES ('DATA.100001', '3');
INSERT INTO `lessonteacher` VALUES ('BBBS.100001', '4');
INSERT INTO `lessonteacher` VALUES ('BBBS.100002', '4');
INSERT INTO `lessonteacher` VALUES ('BBBS.100003', '4');
INSERT INTO `lessonteacher` VALUES ('DATA.100001', '4');
COMMIT;

-- ----------------------------
-- Table structure for studentinfo
-- ----------------------------
DROP TABLE IF EXISTS `studentinfo`;
CREATE TABLE `studentinfo` (
  `Id` varchar(11) NOT NULL COMMENT '学号',
  `Name` varchar(20) NOT NULL COMMENT '姓名',
  `Dep` varchar(20) NOT NULL COMMENT '院系',
  `Major` varchar(20) DEFAULT NULL COMMENT '专业',
  `Sex` varchar(6) DEFAULT NULL COMMENT '性别',
  `Grade` int(11) DEFAULT NULL COMMENT '年级',
  `openID` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`Id`) USING BTREE,
  UNIQUE KEY `Id` (`Id`) USING BTREE,
  UNIQUE KEY `WeChatId` (`openID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of studentinfo
-- ----------------------------
BEGIN;
INSERT INTO `studentinfo` VALUES ('17008164334', '周淑兰', '计算机科学技术学院', '计算机', '女', 2017, NULL);
INSERT INTO `studentinfo` VALUES ('17081223323', '贾燕', '历史学系', '历史', '女', 2017, NULL);
INSERT INTO `studentinfo` VALUES ('17156899188', '郭帆', '微电子学院', '微电子', '女', 2017, NULL);
INSERT INTO `studentinfo` VALUES ('17165103782', '李英', '法学院', '法学', '女', 2017, NULL);
INSERT INTO `studentinfo` VALUES ('17206429873', '陈杨', '微电子学院', '微电子', '男', 2017, NULL);
INSERT INTO `studentinfo` VALUES ('17233036523', '李洁', '哲学学院', '哲学', '男', 2017, '053AVQ0w3WEezW2JaW0w3O7ToR0AVQ0n');
INSERT INTO `studentinfo` VALUES ('17255217348', '刘娟', '基础医学院', '基础医学', '女', 2017, NULL);
INSERT INTO `studentinfo` VALUES ('17271818979', '李凯', '数学科学学院', '数学', '男', 2017, NULL);
INSERT INTO `studentinfo` VALUES ('17279240585', '杜涛', '物理学系', '物理', '男', 2017, NULL);
INSERT INTO `studentinfo` VALUES ('17381684350', '赵凯', '基础医学院', '基础医学', '男', 2017, NULL);
INSERT INTO `studentinfo` VALUES ('17439589453', '杨亮', '法学院', '法学', '男', 2017, NULL);
INSERT INTO `studentinfo` VALUES ('17517729458', '梅建军', '马克思主义学院', '马克思', '男', 2017, NULL);
INSERT INTO `studentinfo` VALUES ('17529682945', '欧秀梅', '新闻学院', '新闻', '女', 2017, NULL);
INSERT INTO `studentinfo` VALUES ('17560471183', '侯文', '哲学学院', '哲学', '男', 2017, NULL);
INSERT INTO `studentinfo` VALUES ('17595754410', '吕海燕', '法学院', '法学', '女', 2017, NULL);
INSERT INTO `studentinfo` VALUES ('17600896335', '张倩', '化学系', '化学', '女', 2017, NULL);
INSERT INTO `studentinfo` VALUES ('17672421494', '张梅', '中国语言文学系', '中文', '女', 2017, NULL);
INSERT INTO `studentinfo` VALUES ('17688932082', '邓志强', '微电子学院', '微电子', '男', 2017, NULL);
INSERT INTO `studentinfo` VALUES ('17740025527', '冯楠', '生命科学学院', '生命科学', '女', 2017, NULL);
INSERT INTO `studentinfo` VALUES ('17781619138', '许婷婷', '大数据学院', '数据科学', '女', 2017, NULL);
INSERT INTO `studentinfo` VALUES ('17795413163', '袁凤兰', '生命科学学院', '生命科学', '女', 2017, NULL);
INSERT INTO `studentinfo` VALUES ('17811617662', '蔡兰英', '微电子学院', '微电子', '女', 2017, NULL);
INSERT INTO `studentinfo` VALUES ('17846419168', '潘萍', '哲学学院', '哲学', '女', 2017, NULL);
INSERT INTO `studentinfo` VALUES ('17906159491', '张想', '计算机科学技术学院', '计算机', '男', 2017, NULL);
INSERT INTO `studentinfo` VALUES ('17977749826', '杨春梅', '国际关系与公共事务学院', '国际关系', '女', 2017, '093T70Ga1AroeB09VbHa17oBez0T70Gp');
INSERT INTO `studentinfo` VALUES ('18011440603', '曾阳', '数学科学学院', '数学', '男', 2018, NULL);
INSERT INTO `studentinfo` VALUES ('18026738672', '吴桂芳', '管理学院', '管理', '女', 2018, NULL);
INSERT INTO `studentinfo` VALUES ('18034620973', '魏强', '化学系', '化学', '男', 2018, '083AmJ1w3CJ7AW2qlJ0w3eIKl93AmJ1z');
INSERT INTO `studentinfo` VALUES ('18091786225', '曹桂英', '经济学院', '经济', '女', 2018, NULL);
INSERT INTO `studentinfo` VALUES ('18107333919', '李艳', '化学系', '化学', '女', 2018, NULL);
INSERT INTO `studentinfo` VALUES ('18214672759', '柴燕', '大数据学院', '数据科学', '女', 2018, NULL);
INSERT INTO `studentinfo` VALUES ('18272773435', '张丽华', '微电子学院', '微电子', '女', 2018, NULL);
INSERT INTO `studentinfo` VALUES ('18289433314', '樊超', '马克思主义学院', '马克思', '男', 2018, NULL);
INSERT INTO `studentinfo` VALUES ('18300290007', '加兴华', '大数据学院', '数据科学', '男', 2018, 'o9H_D4sx0c_TL18TzXl4iHW3PFMg');
INSERT INTO `studentinfo` VALUES ('18307110245', '刘子涵', '大数据学院', '数据科学', '男', 2018, NULL);
INSERT INTO `studentinfo` VALUES ('18307110276', '陈浩贤', '大数据学院', '数据科学', '男', 2018, 'o9H_D4ten4j6x0SqnPAR04Cogcwo');
INSERT INTO `studentinfo` VALUES ('18417445373', '郑金凤', '马克思主义学院', '马克思', '女', 2018, NULL);
INSERT INTO `studentinfo` VALUES ('18511129100', '康坤', '国际关系与公共事务学院', '国际关系', '男', 2018, NULL);
INSERT INTO `studentinfo` VALUES ('18523881340', '胡红', '计算机科学技术学院', '计算机', '男', 2018, NULL);
INSERT INTO `studentinfo` VALUES ('18562850868', '路杰', '国际关系与公共事务学院', '国际关系', '男', 2018, NULL);
INSERT INTO `studentinfo` VALUES ('18589355027', '曹婷婷', '管理学院', '管理', '女', 2018, NULL);
INSERT INTO `studentinfo` VALUES ('18592691743', '戴建军', '法学院', '法学', '男', 2018, NULL);
INSERT INTO `studentinfo` VALUES ('18603917998', '方桂芝', '物理学系', '物理', '女', 2018, NULL);
INSERT INTO `studentinfo` VALUES ('18641907766', '王桂香', '生命科学学院', '生命科学', '女', 2018, '093vP5Ha1hLnfB0b9lIa1lHk522vP5HT');
INSERT INTO `studentinfo` VALUES ('18745712355', '张欢', '物理学系', '物理', '男', 2019, NULL);
INSERT INTO `studentinfo` VALUES ('18804420725', '靳兵', '马克思主义学院', '马克思', '男', 2018, NULL);
INSERT INTO `studentinfo` VALUES ('18821642405', '赖磊', '生命科学学院', '生命科学', '女', 2018, NULL);
INSERT INTO `studentinfo` VALUES ('18868923864', '李淑珍', '生命科学学院', '生命科学', '女', 2018, NULL);
INSERT INTO `studentinfo` VALUES ('18927303897', '邱秀兰', '法学院', '法学', '女', 2018, NULL);
INSERT INTO `studentinfo` VALUES ('18928477036', '聂刚', '计算机科学技术学院', '计算机', '男', 2018, NULL);
INSERT INTO `studentinfo` VALUES ('18949769032', '桑晨', '生命科学学院', '生命科学', '男', 2018, NULL);
INSERT INTO `studentinfo` VALUES ('18958895623', '白凯', '数学科学学院', '数学', '男', 2018, NULL);
INSERT INTO `studentinfo` VALUES ('18979020000', '刘瑞', '化学系', '化学', '女', 2018, NULL);
INSERT INTO `studentinfo` VALUES ('19039727092', '何健', '国际关系与公共事务学院', '国际关系', '男', 2019, NULL);
INSERT INTO `studentinfo` VALUES ('19100454727', '游佳', '大数据学院', '数据科学', '女', 2019, NULL);
INSERT INTO `studentinfo` VALUES ('19147811984', '杨荣', '管理学院', '管理', '男', 2019, NULL);
INSERT INTO `studentinfo` VALUES ('19152752758', '林秀珍', '马克思主义学院', '马克思', '女', 2019, NULL);
INSERT INTO `studentinfo` VALUES ('19196517400', '赵宇', '马克思主义学院', '马克思', '男', 2019, NULL);
INSERT INTO `studentinfo` VALUES ('19260808212', '李秀荣', '生命科学学院', '生命科学', '女', 2019, NULL);
INSERT INTO `studentinfo` VALUES ('19307130203', '于淼芃', '大数据学院', '数据科学', '男', 2019, 'o9H_D4uf9-paW1SmzogchLLwWOCA');
INSERT INTO `studentinfo` VALUES ('19490589977', '王华', '微电子学院', '微电子', '男', 2019, NULL);
INSERT INTO `studentinfo` VALUES ('19494935920', '萧琳', '马克思主义学院', '马克思', '男', 2019, NULL);
INSERT INTO `studentinfo` VALUES ('19512047960', '廖欢', '管理学院', '管理', '男', 2019, NULL);
INSERT INTO `studentinfo` VALUES ('19566003885', '贾利', '经济学院', '经济', '男', 2019, NULL);
INSERT INTO `studentinfo` VALUES ('19585457034', '苏桂荣', '历史学系', '历史', '男', 2019, NULL);
INSERT INTO `studentinfo` VALUES ('19629359270', '傅琴', '数学科学学院', '数学', '女', 2019, NULL);
INSERT INTO `studentinfo` VALUES ('19656946957', '吴建军', '国际关系与公共事务学院', '国际关系', '男', 2019, NULL);
INSERT INTO `studentinfo` VALUES ('19687866438', '宋丹', '历史学系', '历史', '女', 2019, '093Apenl2r8Kb74h8aol2MkIx40ApenT');
INSERT INTO `studentinfo` VALUES ('19750105293', '王丽娟', '马克思主义学院', '马克思', '女', 2019, NULL);
INSERT INTO `studentinfo` VALUES ('19769783074', '纪金凤', '新闻学院', '新闻', '女', 2019, NULL);
INSERT INTO `studentinfo` VALUES ('19784072937', '黄雪梅', '管理学院', '管理', '女', 2019, NULL);
INSERT INTO `studentinfo` VALUES ('19818219604', '丁瑜', '计算机科学技术学院', '计算机', '女', 2019, NULL);
INSERT INTO `studentinfo` VALUES ('19842082984', '黄丽', '生命科学学院', '生命科学', '女', 2019, NULL);
INSERT INTO `studentinfo` VALUES ('19852415159', '赵萍', '化学系', '化学', '女', 2019, NULL);
INSERT INTO `studentinfo` VALUES ('19854931373', '颜兵', '哲学学院', '哲学', '男', 2019, NULL);
INSERT INTO `studentinfo` VALUES ('19959537455', '邓红霞', '数学科学学院', '数学', '女', 2019, NULL);
INSERT INTO `studentinfo` VALUES ('19968549209', '陈亮', '物理学系', '物理', '男', 2019, NULL);
INSERT INTO `studentinfo` VALUES ('19982837474', '张红霞', '管理学院', '管理', '女', 2019, NULL);
INSERT INTO `studentinfo` VALUES ('19997902569', '吴明', '外国语言文学学院', '外国语', '男', 2019, NULL);
INSERT INTO `studentinfo` VALUES ('20000556491', '胡华', '基础医学院', '基础医学', '男', 2020, NULL);
INSERT INTO `studentinfo` VALUES ('20060097449', '邬金凤', '中国语言文学系', '中文', '女', 2020, NULL);
INSERT INTO `studentinfo` VALUES ('20098081168', '赵慧', '马克思主义学院', '马克思', '女', 2020, '023HB40w3HXsyW2xMe3w3JPB1B4HB40I');
INSERT INTO `studentinfo` VALUES ('20102985227', '刘丽娟', '管理学院', '管理', '女', 2020, NULL);
INSERT INTO `studentinfo` VALUES ('20114218819', '刘阳', '基础医学院', '基础医学', '男', 2020, NULL);
INSERT INTO `studentinfo` VALUES ('20149853561', '王桂兰', '国际关系与公共事务学院', '国际关系', '女', 2020, NULL);
INSERT INTO `studentinfo` VALUES ('20193122526', '曾涛', '经济学院', '经济', '男', 2020, NULL);
INSERT INTO `studentinfo` VALUES ('20277886956', '闵娟', '法学院', '法学', '女', 2020, NULL);
INSERT INTO `studentinfo` VALUES ('20279114441', '程阳', '微电子学院', '微电子', '男', 2020, NULL);
INSERT INTO `studentinfo` VALUES ('20330206240', '罗欢', '历史学系', '历史', '男', 2020, NULL);
INSERT INTO `studentinfo` VALUES ('20455736460', '万玲', '中国语言文学系', '中文', '女', 2020, NULL);
INSERT INTO `studentinfo` VALUES ('20487728256', '方健', '物理学系', '物理', '男', 2020, NULL);
INSERT INTO `studentinfo` VALUES ('20519017599', '夏秀英', '微电子学院', '微电子', '男', 2020, NULL);
INSERT INTO `studentinfo` VALUES ('20527549014', '庄兰英', '国际关系与公共事务学院', '国际关系', '女', 2020, NULL);
INSERT INTO `studentinfo` VALUES ('20591317704', '涂淑珍', '数学科学学院', '数学', '女', 2020, NULL);
INSERT INTO `studentinfo` VALUES ('20653647031', '陈敏', '管理学院', '管理', '女', 2020, NULL);
INSERT INTO `studentinfo` VALUES ('20779621822', '罗龙', '管理学院', '管理', '男', 2020, NULL);
INSERT INTO `studentinfo` VALUES ('20796722937', '蒋勇', '马克思主义学院', '马克思', '男', 2020, NULL);
INSERT INTO `studentinfo` VALUES ('20897883751', '张玉梅', '管理学院', '管理', '女', 2020, NULL);
INSERT INTO `studentinfo` VALUES ('20898968766', '张岩', '生命科学学院', '生命科学', '男', 2020, NULL);
INSERT INTO `studentinfo` VALUES ('20904417558', '陈玉珍', '基础医学院', '基础医学', '女', 2020, NULL);
INSERT INTO `studentinfo` VALUES ('20924733513', '郑博', '哲学学院', '哲学', '男', 2020, NULL);
INSERT INTO `studentinfo` VALUES ('20946816800', '鞠桂英', '管理学院', '管理', '女', 2020, NULL);
INSERT INTO `studentinfo` VALUES ('20953335540', '杨玉珍', '数学科学学院', '数学', '女', 2020, NULL);
INSERT INTO `studentinfo` VALUES ('20989521282', '陈帅', '哲学学院', '哲学', '男', 2020, NULL);
COMMIT;

-- ----------------------------
-- Table structure for teacherinfo
-- ----------------------------
DROP TABLE IF EXISTS `teacherinfo`;
CREATE TABLE `teacherinfo` (
  `Id` varchar(11) NOT NULL COMMENT '学号',
  `Name` varchar(20) NOT NULL COMMENT '姓名',
  `openID` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`Id`) USING BTREE,
  UNIQUE KEY `Id` (`Id`) USING BTREE,
  UNIQUE KEY `WeChatId` (`openID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of teacherinfo
-- ----------------------------
BEGIN;
INSERT INTO `teacherinfo` VALUES ('000001', 'AAA', NULL);
INSERT INTO `teacherinfo` VALUES ('000002', 'CCC', NULL);
INSERT INTO `teacherinfo` VALUES ('000003', 'DDD', NULL);
INSERT INTO `teacherinfo` VALUES ('000004', 'EEE', NULL);
INSERT INTO `teacherinfo` VALUES ('000005', 'FFF', NULL);
INSERT INTO `teacherinfo` VALUES ('000006', 'GGG', NULL);
INSERT INTO `teacherinfo` VALUES ('000007', 'HHH', NULL);
INSERT INTO `teacherinfo` VALUES ('1', 'Bbb', 'o9H_D4uf9-paW1SmzogchLLwWOCA');
INSERT INTO `teacherinfo` VALUES ('2', '赵信', 'o9H_D4jQGpWf-4_abXiHzR3LQJvs');
INSERT INTO `teacherinfo` VALUES ('3', 'chx', 'o9H_D4ten4j6x0SqnPAR04Cogcwo');
INSERT INTO `teacherinfo` VALUES ('4', 'jxh', 'o9H_D4sx0c_TL18TzXl4iHW3PFMg');
COMMIT;

-- ----------------------------
-- Triggers structure for table lessonstudent
-- ----------------------------
DROP TRIGGER IF EXISTS `tri_lestInsert`;
delimiter ;;
CREATE TRIGGER `tri_lestInsert` AFTER INSERT ON `lessonstudent` FOR EACH ROW BEGIN
	DECLARE c INT;
	set c = (SELECT num FROM lessoninfo WHERE code=new.code);
	UPDATE lessoninfo set num=c+1 where code=new.code;
end
;;
delimiter ;

-- ----------------------------
-- Triggers structure for table lessonstudent
-- ----------------------------
DROP TRIGGER IF EXISTS `tri_lestDelete`;
delimiter ;;
CREATE TRIGGER `tri_lestDelete` AFTER DELETE ON `lessonstudent` FOR EACH ROW BEGIN
	DECLARE c INT;
	set c = (SELECT num FROM lessoninfo WHERE code=old.code);
	UPDATE lessoninfo set num=c-1 where code=old.code;
end
;;
delimiter ;

SET FOREIGN_KEY_CHECKS = 1;