master

分支 (1)

管理

管理

master

hsjctj
/
ims_yc_hsjctj_admin.sql

/*
 Navicat Premium Data Transfer

 Source Server         : admin_admin_cn
 Source Server Type    : MySQL
 Source Server Version : 50650
 Source Host           : 1.1.1.1:3306
 Source Schema         : admin_admin_cn

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

 Date: 11/10/2022 13:16:58
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for ims_yc_hsjctj_admin
-- ----------------------------
DROP TABLE IF EXISTS `ims_yc_hsjctj_admin`;
CREATE TABLE `ims_yc_hsjctj_admin`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '管理员id',
  `weid` int(11) NOT NULL COMMENT '公众号id',
  `group` int(11) NOT NULL COMMENT '权限id',
  `jid` int(11) NOT NULL DEFAULT 1 COMMENT '街道id',
  `kid` int(11) NULL DEFAULT NULL,
  `sid` int(11) NULL DEFAULT NULL COMMENT '社区id',
  `wid` int(11) NULL DEFAULT NULL COMMENT '网格id',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '姓名',
  `card` char(18) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `openid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'openid',
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '手机号',
  `photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '照片',
  `personalinfo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '个人简介',
  `jurisdiction` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管辖范围',
  `time` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `status` int(11) NOT NULL DEFAULT 1 COMMENT '状态',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `card`(`card`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 80 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '管理员表' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for ims_yc_hsjctj_banne
-- ----------------------------
DROP TABLE IF EXISTS `ims_yc_hsjctj_banne`;
CREATE TABLE `ims_yc_hsjctj_banne`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `weid` int(11) NOT NULL,
  `title` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `thumb` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `createtime` datetime NOT NULL,
  `orderid` int(11) NOT NULL DEFAULT 0,
  `link` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '幻灯片' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ims_yc_hsjctj_collect
-- ----------------------------
DROP TABLE IF EXISTS `ims_yc_hsjctj_collect`;
CREATE TABLE `ims_yc_hsjctj_collect`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `weid` int(11) NULL DEFAULT NULL,
  `sid` int(11) NULL DEFAULT NULL COMMENT '社区id',
  `wid` int(11) NULL DEFAULT NULL COMMENT '网格id',
  `pid` int(11) NULL DEFAULT NULL COMMENT '检测点id',
  `jid` int(11) NULL DEFAULT NULL COMMENT '街道id',
  `cid` int(11) NULL DEFAULT NULL COMMENT '检测id',
  `way` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '1硬件扫码2网格员扫码3主动扫码',
  `codeid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '健康码id',
  `rid` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建时间',
  `colors` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '健康码颜色(硬件扫码和网格员扫码才有这个)',
  `openid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'openid',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '采检记录' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for ims_yc_hsjctj_community
-- ----------------------------
DROP TABLE IF EXISTS `ims_yc_hsjctj_community`;
CREATE TABLE `ims_yc_hsjctj_community`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '社区id',
  `weid` int(11) NOT NULL COMMENT '公众号id',
  `jid` int(11) NOT NULL DEFAULT 1 COMMENT '街道id',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '社区名称',
  `time` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP,
  `status` int(11) NOT NULL DEFAULT 1 COMMENT '状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 29 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '社区表' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for ims_yc_hsjctj_grid
-- ----------------------------
DROP TABLE IF EXISTS `ims_yc_hsjctj_grid`;
CREATE TABLE `ims_yc_hsjctj_grid`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '网格id',
  `weid` int(11) NOT NULL COMMENT '公众号id',
  `jid` int(11) NOT NULL DEFAULT 1 COMMENT '街道id',
  `sid` int(11) NOT NULL COMMENT '社区id',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '网格名称',
  `time` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP,
  `status` int(11) NOT NULL DEFAULT 1 COMMENT '状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '网格表' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for ims_yc_hsjctj_group
-- ----------------------------
DROP TABLE IF EXISTS `ims_yc_hsjctj_group`;
CREATE TABLE `ims_yc_hsjctj_group`  (
  `id` int(11) NOT NULL COMMENT '权限id权限id权限id权限id',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '权限名称',
  `status` int(11) NOT NULL DEFAULT 1 COMMENT '状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '权限表' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for ims_yc_hsjctj_log
-- ----------------------------
DROP TABLE IF EXISTS `ims_yc_hsjctj_log`;
CREATE TABLE `ims_yc_hsjctj_log`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `weid` int(11) NULL DEFAULT NULL,
  `into` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for ims_yc_hsjctj_place
-- ----------------------------
DROP TABLE IF EXISTS `ims_yc_hsjctj_place`;
CREATE TABLE `ims_yc_hsjctj_place`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '网格id',
  `weid` int(11) NOT NULL COMMENT '公众号id',
  `jid` int(11) NOT NULL DEFAULT 1 COMMENT '街道id',
  `sid` int(11) NOT NULL COMMENT '社区id',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '网格名称',
  `time` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP,
  `status` int(11) NOT NULL DEFAULT 1 COMMENT '状态',
  `wid` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '采检点表' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for ims_yc_hsjctj_settings
-- ----------------------------
DROP TABLE IF EXISTS `ims_yc_hsjctj_settings`;
CREATE TABLE `ims_yc_hsjctj_settings`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '管理员id',
  `weid` int(11) NOT NULL COMMENT '公众号id',
  `common` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '全部设置',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 75 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '配置表参数配置' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ims_yc_hsjctj_testing
-- ----------------------------
DROP TABLE IF EXISTS `ims_yc_hsjctj_testing`;
CREATE TABLE `ims_yc_hsjctj_testing`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `weid` int(11) NULL DEFAULT NULL,
  `sid` int(11) NULL DEFAULT NULL,
  `wid` int(11) NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '检测点名称',
  `stime` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '检测时间',
  `rnum` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '应检人数',
  `jcy` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '检测员',
  `fzr` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '负责人',
  `jtime` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '结束时间',
  `remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `status` int(11) NULL DEFAULT 1,
  `time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建时间',
  `pid` int(11) NULL DEFAULT NULL COMMENT '检测点',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '检测表  ' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for ims_yc_hsjctj_user
-- ----------------------------
DROP TABLE IF EXISTS `ims_yc_hsjctj_user`;
CREATE TABLE `ims_yc_hsjctj_user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `weid` int(11) NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',
  `phone` varchar(255) 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 '家庭地址',
  `sid` int(11) NULL DEFAULT NULL COMMENT '社区id',
  `wid` int(11) NULL DEFAULT NULL COMMENT '网格id',
  `jid` int(11) NULL DEFAULT NULL COMMENT '街道id',
  `pid` int(11) NULL DEFAULT NULL COMMENT '检测点id',
  `codeid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '健康码id',
  `zhu` int(11) NULL DEFAULT NULL COMMENT '家庭id',
  `openid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微信身份id',
  `always` int(11) NULL DEFAULT NULL COMMENT '1户主2成员',
  `ma` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '1健康码2身份证',
  `ntime` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '注册时间',
  `utime` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新时间',
  `status` int(11) NULL DEFAULT NULL COMMENT '状态',
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '健康码图片',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `openid`(`openid`) USING BTREE,
  UNIQUE INDEX `codeid`(`codeid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 59 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '居民用户表' ROW_FORMAT = Compact;

SET FOREIGN_KEY_CHECKS = 1;