微信公眾號相關 · 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;