王彦博自己的本科毕业论文

/* Navicat MySQL Data Transfer Source Server : WYB Source Server Type : MySQL Source Server Version : 80011 Source Host : localhost:3306 Source Schema : wyb Target Server Type : MySQL Target Server Version : 80011 File Encoding : 65001 Date: 09/05/2023 11:52:46 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for tb_admin -- ---------------------------- DROP TABLE IF EXISTS `tb_admin`; CREATE TABLE `tb_admin` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id', `admin_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '管理员编号', `username` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名', `password` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码', `realname` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '真实姓名', `user_type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '用户类型', `jobtitle` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '职称', `license` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '证件照地址', `teach` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '教授科目', `telephone` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系电话', `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电子邮件', `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址', `age` int(3) NULL DEFAULT NULL COMMENT '年龄', `avatar` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头像', `description` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '签名', `remark` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', `type` tinyint(1) NULL DEFAULT NULL COMMENT '管理员类型', `piority` int(2) NULL DEFAULT NULL COMMENT '优先级', `power` tinyint(1) NULL DEFAULT NULL COMMENT '1为管理员，0为超级管理员', `status` tinyint(1) NULL DEFAULT 0 COMMENT '账号状态', `deleted` tinyint(1) NULL DEFAULT 0, `create_time` datetime NULL DEFAULT NULL, `update_time` datetime NULL DEFAULT NULL, `token` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录令牌', `roles` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of tb_admin -- ---------------------------- INSERT INTO `tb_admin` VALUES (1, '10011', 'admin', '123456', '周云', 1, '办公室处主任', NULL, NULL, '13766551213', 'admin@guet.com', NULL, NULL, NULL, '认真对待工作', '务实', NULL, NULL, NULL, 0, 0, '2020-02-01 15:31:17', '2021-03-30 02:25:22', 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJhdWQiOiIxIiwiZXhwIjoxNjE3MjUyNzQ0LCJpYXQiOjE2MTcyNTA5NDR9.l0K4DC3ObN2HSXWePVvrNgc9O_SoJwCtoNrTRRBUaHE', 'normal'); INSERT INTO `tb_admin` VALUES (2, '10012', '123', '123456', '张三丰', 1, '办公室副主任', NULL, NULL, NULL, 'admin@guet.com', NULL, NULL, NULL, '光线强的地方，影子也比较黑暗。', '零下1摄氏度', NULL, NULL, NULL, 0, 0, '2020-03-04 21:24:57', NULL, NULL, NULL); INSERT INTO `tb_admin` VALUES (3, '10013', 'admin1', '123456', '王五', 1, '办公室副主任', NULL, NULL, NULL, 'admin@guet.com', NULL, NULL, NULL, '加油每一天', NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL); -- ---------------------------- -- Table structure for tb_flink -- ---------------------------- DROP TABLE IF EXISTS `tb_flink`; CREATE TABLE `tb_flink` ( `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `value` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `create_time` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tb_flink -- ---------------------------- INSERT INTO `tb_flink` VALUES ('用户数', '22', '2022-03-03 14:00:56'); INSERT INTO `tb_flink` VALUES ('打卡记录', '24', '2022-03-03 14:00:56'); INSERT INTO `tb_flink` VALUES ('用户', '27', '2022-03-03 14:00:56'); INSERT INTO `tb_flink` VALUES ('请假记录', '12', '2022-03-03 14:01:52'); INSERT INTO `tb_flink` VALUES ('用户', '27', '2022-03-03 14:01:52'); INSERT INTO `tb_flink` VALUES ('用户数', '22', '2022-03-03 14:01:52'); INSERT INTO `tb_flink` VALUES ('打卡记录', '24', '2022-03-03 14:01:52'); -- ---------------------------- -- Table structure for tb_group -- ---------------------------- DROP TABLE IF EXISTS `tb_group`; CREATE TABLE `tb_group` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id', `group_id` int(11) NULL DEFAULT NULL COMMENT 'Group ID', `user_id` int(11) NULL DEFAULT NULL COMMENT 'User ID', `remark` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '介绍', `street` varchar(518) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `amount` double NULL DEFAULT NULL COMMENT '资金', `deleted` tinyint(1) NULL DEFAULT 0, `create_time` datetime NULL DEFAULT NULL, `update_time` datetime NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '部门表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tb_group -- ---------------------------- INSERT INTO `tb_group` VALUES (1, NULL, NULL, '滩尖子社区', '南京路街道', 18964, 0, '2023-04-20 16:30:28', '2023-04-20 16:30:28'); INSERT INTO `tb_group` VALUES (2, NULL, NULL, '朝天门社区', '大竹林街道', 15825, 0, '2023-04-20 16:31:04', '2023-04-20 16:31:04'); INSERT INTO `tb_group` VALUES (3, NULL, NULL, '红河社区', '江北区观音桥街道', 3000, 0, '2023-04-20 16:31:04', '2023-04-20 16:31:04'); INSERT INTO `tb_group` VALUES (4, NULL, NULL, '大雁滩社区', '江北区观音桥街道', 3000, 0, '2023-04-15 16:31:04', '2023-04-15 16:31:04'); INSERT INTO `tb_group` VALUES (5, NULL, NULL, '兴龙湖社区', '江北区观音桥街道', 2801, 0, '2023-04-14 16:31:04', '2023-04-14 16:31:04'); INSERT INTO `tb_group` VALUES (6, NULL, NULL, '徐家汇社区', '江北区观音桥街道', 5500, 0, '2023-04-13 16:31:04', '2023-04-13 16:31:04'); INSERT INTO `tb_group` VALUES (7, NULL, NULL, '陆家嘴社区', '江北区观音桥街道', 5500, 0, '2023-04-11 16:31:04', '2023-04-11 16:31:04'); -- ---------------------------- -- Table structure for tb_health -- ---------------------------- DROP TABLE IF EXISTS `tb_health`; CREATE TABLE `tb_health` ( `id` int(111) NOT NULL AUTO_INCREMENT COMMENT 'id', `user_id` int(111) NULL DEFAULT NULL COMMENT '学号', `type` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '填报时间段', `visit` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '行程轨迹', `temperature` double NULL DEFAULT NULL COMMENT '体温', `cough` int(11) NULL DEFAULT NULL COMMENT '咳嗽', `fever` int(11) NULL DEFAULT NULL COMMENT '发烧', `status` tinyint(1) NULL DEFAULT 0 COMMENT '状态', `deleted` tinyint(1) NULL DEFAULT 0, `create_time` datetime NULL DEFAULT NULL, `update_time` datetime NULL DEFAULT NULL, `country` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '国家', `province` varchar(100) CHARACTER SET utf8 COLLATE utf8_gen