微信公众号相关 · Niushop单商户V5开发手册

```[sql] -- ---------------------------- -- Table structure for ns_weapp_audit_record -- ---------------------------- DROP TABLE IF EXISTS `ns_weapp_audit_record`; CREATE TABLE `ns_weapp_audit_record` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '审核id', `site_id` int(11) NOT NULL COMMENT '站点id', `auditid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '审核编号', `version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '版本号', `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '审核状态 0审核中 1通过 -1失败 2延后 3已发布 4已撤回', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '审核提交时间', `audit_time` int(11) NOT NULL DEFAULT 0 COMMENT '审核通过时间', `release_time` int(11) NOT NULL DEFAULT 0 COMMENT '发布时间', `reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '未通过和延后的原因', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1489 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '小程序审核记录表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_wechat_fans -- ---------------------------- DROP TABLE IF EXISTS `ns_wechat_fans`; CREATE TABLE `ns_wechat_fans` ( `fans_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '粉丝ID', `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站点id', `nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '昵称', `nickname_decode` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '昵称编码', `headimgurl` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '头像', `sex` smallint(6) NOT NULL DEFAULT 1 COMMENT '性别', `language` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户语言', `country` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '国家', `province` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '省', `city` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '城市', `district` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '行政区/县', `openid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户的标识，对当前公众号唯一用户的唯一身份ID', `unionid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '粉丝unionid', `groupid` int(11) NOT NULL DEFAULT 0 COMMENT '粉丝所在组id', `is_subscribe` bigint(1) NOT NULL DEFAULT 1 COMMENT '是否订阅', `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '备注', `subscribe_time` int(11) NOT NULL DEFAULT 0 COMMENT '关注时间', `subscribe_scene` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '返回用户关注的渠道来源', `unsubscribe_time` int(11) NOT NULL DEFAULT 0 COMMENT '取消关注时间', `update_date` int(11) NOT NULL DEFAULT 0 COMMENT '粉丝信息最后更新时间', `tagid_list` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户被打上的标签ID列表', `subscribe_scene_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '返回用户关注的渠道来源名称', `qr_scene` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'qr_scene', `qr_scene_str` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'qr_scene_str', PRIMARY KEY (`fans_id`) USING BTREE, INDEX `IDX_ns_weixin_fans`(`unionid`, `openid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1092 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '微信粉丝列表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_wechat_fans_tag -- ---------------------------- DROP TABLE IF EXISTS `ns_wechat_fans_tag`; CREATE TABLE `ns_wechat_fans_tag` ( `id` int(11) NOT NULL AUTO_INCREMENT, `tags` varchar(3000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '微信拉取到的标签内容 json格式', `tag_id` int(11) NOT NULL DEFAULT 0 COMMENT '标签id', `tag_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '标签名称', PRIMARY KEY (`id`) USING BTREE, INDEX `IDX_ns_wechat_fans_tag`(`tag_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '微信粉丝标签表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_wechat_mass_recording -- ---------------------------- DROP TABLE IF EXISTS `ns_wechat_mass_recording`; CREATE TABLE `ns_wechat_mass_recording` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `status` int(50) NOT NULL DEFAULT 0 COMMENT '发送状态1-成功 0-失败', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间', `modify_time` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间', `member_label` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '发送群体（会员标签）', `media_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '素材id', `err` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '错误信息', `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '内容', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '微信消息记录' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_wechat_media -- ---------------------------- DROP TABLE IF EXISTS `ns_wechat_media`; CREATE TABLE `ns_wechat_media` ( `id` int(11) NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站点id', `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '类型', `value` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '值', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间', `update_time` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间', `media_id` varchar(70) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '微信端返回的素材id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 910 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '微信素材表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_wechat_qrcode -- ---------------------------- DROP TABLE IF EXISTS `ns_wechat_qrcode`; CREATE TABLE `ns_wechat_qrcode` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '实例ID', `background` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '背景图片', `nick_font_color` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '#000' COMMENT '昵称字体颜色', `nick_font_size` smallint(6) NOT NULL DEFAULT 12 COMMENT '昵称字体大小', `is_logo_show` smallint(6) NOT NULL DEFAULT 1 COMMENT 'logo是否显示', `header_left` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0px' COMMENT '头部左边距', `header_top` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0px' COMMENT '头部上边距', `name_left` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0px' COMMENT '昵称左边距', `name_top` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0px' COMMENT '昵称上边距', `logo_left` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0px' COMMENT 'logo左边距', `logo_top` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0px' COMMENT 'logo上边距', `code_left` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0px' COMMENT '二维码左边距', `code_top` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0px' COMMENT '二维码上边距', `is_default` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否默认', `is_remove` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除 0未删除 1删除', `update_time` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 8192 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '微信推广二维码模板管理' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_wechat_replay_rule -- ---------------------------- DROP TABLE IF EXISTS `ns_wechat_replay_rule`; CREATE TABLE `ns_wechat_replay_rule` ( `rule_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站点id', `rule_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '规则名称', `rule_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'KEYWORDS' COMMENT '规则类型KEYWORDS表示关键字,DEFAULT表示默认,AFTER表示关注后', `keywords_json` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '关键字json', `replay_json` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '回复内容json', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间', `modify_time` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间', PRIMARY KEY (`rule_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 175 AVG_ROW_LENGTH = 8192 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '微信回复规则' ROW_FORMAT = Compact; SET FOREIGN_KEY_CHECKS = 1;