基于微信小程序开发的智慧流调微信小程序（后端java）.zip

/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50726 Source Host : localhost:3306 Source Database : zhld Target Server Type : MYSQL Target Server Version : 50726 File Encoding : 65001 Date: 2023-03-27 19:23:27 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for article -- ---------------------------- DROP TABLE IF EXISTS `article`; CREATE TABLE `article` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键', `title` varchar(128) COLLATE utf8_bin DEFAULT NULL COMMENT '标题', `image` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '封面', `abs` longtext COLLATE utf8_bin COMMENT '摘要', `content` longtext COLLATE utf8_bin COMMENT '内容', `create_time` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '创建时间', `update_time` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='疫情通知'; -- ---------------------------- -- Records of article -- ---------------------------- INSERT INTO `article` VALUES ('1', '全员核算的重要性', '/static/uploads/20230314/20230314234442.png', 0xE585A8E59198E6A0B8E7AE97E79A84E9878DE8A681E680A7E585A8E59198E6A0B8E7AE97E79A84E9878DE8A681E680A7, 0x3C703EE585A8E59198E6A0B8E7AE97E79A84E9878DE8A681E680A7E585A8E59198E6A0B8E7AE97E79A84E9878DE8A681E680A7E585A8E59198E6A0B8E7AE97E79A84E9878DE8A681E680A7E585A8E59198E6A0B8E7AE97E79A84E9878DE8A681E680A7E585A8E59198E6A0B8E7AE97E79A84E9878DE8A681E680A73C2F703E, '2023-03-14 23:44:44', null); INSERT INTO `article` VALUES ('2', '疫情通知，大家必须哟啊及时u甘珠', '/static/uploads/20230315/20230315003009.png', 0xE796ABE68385E9809AE79FA5EFBC8CE5A4A7E5AEB6E5BF85E9A1BBE5939FE5958AE58F8AE697B675E79498E78FA0, 0x3C703EE796ABE68385E9809AE79FA5EFBC8CE5A4A7E5AEB6E5BF85E9A1BBE5939FE5958AE58F8AE697B675E79498E78FA0E796ABE68385E9809AE79FA5EFBC8CE5A4A7E5AEB6E5BF85E9A1BBE5939FE5958AE58F8AE697B675E79498E78FA0E796ABE68385E9809AE79FA5EFBC8CE5A4A7E5AEB6E5BF85E9A1BBE5939FE5958AE58F8AE697B675E79498E78FA0E796ABE68385E9809AE79FA5EFBC8CE5A4A7E5AEB6E5BF85E9A1BBE5939FE5958AE58F8AE697B675E79498E78FA0E796ABE68385E9809AE79FA5EFBC8CE5A4A7E5AEB6E5BF85E9A1BBE5939FE5958AE58F8AE697B675E79498E78FA03C2F703E, '2023-03-15 00:30:10', null); -- ---------------------------- -- Table structure for dict -- ---------------------------- DROP TABLE IF EXISTS `dict`; CREATE TABLE `dict` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键', `name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '名称', `code` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '编码', `txt` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '显示值', `val` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '字典值', `create_time` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建时间', `update_time` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='字典表'; -- ---------------------------- -- Records of dict -- ---------------------------- INSERT INTO `dict` VALUES ('1', '风险地区', 'risk_cate', '高风险', 'high', null, null); INSERT INTO `dict` VALUES ('2', '风险地区', 'risk_cate', '中风险', 'middle', null, null); -- ---------------------------- -- Table structure for record -- ---------------------------- DROP TABLE IF EXISTS `record`; CREATE TABLE `record` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键', `wxuser_id` int(11) DEFAULT NULL COMMENT '用户', `cate` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '类型', `user_id` int(11) DEFAULT '0' COMMENT '店铺id', `create_time` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '登记时间', `update_time` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='扫码记录'; -- ---------------------------- -- Records of record -- ---------------------------- INSERT INTO `record` VALUES ('1', '1', null, '2', '2023-03-15 00:12:14', null); INSERT INTO `record` VALUES ('2', '1', null, '2', '2023-03-15 00:12:29', null); INSERT INTO `record` VALUES ('3', '1', null, '2', '2023-03-15 00:12:54', null); INSERT INTO `record` VALUES ('4', '1', null, '2', '2023-03-15 00:13:21', null); INSERT INTO `record` VALUES ('5', '1', null, '2', '2023-03-15 00:14:06', null); INSERT INTO `record` VALUES ('6', '1', null, '3', '2023-03-15 00:30:32', null); INSERT INTO `record` VALUES ('7', '1', null, '2', '2023-03-15 00:30:39', null); -- ---------------------------- -- Table structure for user -- ---------------------------- DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键', `username` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '姓名', `usercode` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '账号', `password` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '密码', `userrole` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '角色', `userphone` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '手机号', `address` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '地址', `notes` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '备注', `createTime` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '创建时间', `updateTime` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='系统用户表'; -- ---------------------------- -- Records of user -- ---------------------------- INSERT INTO `user` VALUES ('1', '管理员', 'admin', '123456', 'admin', null, '北京朝阳大街', '', '2023-03-13 23:59:39', null); INSERT INTO `user` VALUES ('2', '北京全聚德', 'bjquanjude', '123456', 'shoper', '', '北京朝阳大街', null, null, null); INSERT INTO `user` VALUES ('3', '北京德云社', 'deyunshe', '123456', 'shoper', '', '北京三里屯100号1-10楼', '郭德纲', '2023-03-15 00:26:58', '2023-03-15 00:29:03'); -- ---------------------------- -- Table structure for wxuser -- ---------------------------- DROP TABLE IF EXISTS `wxuser`; CREATE TABLE `wxuser` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键', `name` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '姓名', `phone` varchar(11) COLLATE utf8_bin DEFAULT NULL COMMENT '手机号', `idcard` varchar(18) COLLATE utf8_bin DEFAULT NULL COMMENT '身份证', `avatar` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '头像', `village` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '小区', `build` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '楼号', `unit` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '单元', `room` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '户号', `status` int(11) DEFAULT NULL COMMENT '状态', `openid` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT 'openid', `create_time` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '注册时间', `update_time` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='业主用户'; -- ---------------------------- -- Records of wxuser -- ---------------------------- INSERT INTO `wxuser` VALUES ('1', '吴迪', '18812345656', '101010199909091234', 'static/uploads/20230314/20230314234129.png', '金恒家园', null, '2单元', '303', '0', 'oZM--5Mt22_aWq-_Ol60CmTRjnXM', '2023-03-14 23:42:08', null);