微信小程序相關 · Niushop單商戶V5開發手冊

```[sql] -- ---------------------------- -- Table structure for ns_weapp_experiencer -- ---------------------------- DROP TABLE IF EXISTS `ns_weapp_experiencer`; CREATE TABLE `ns_weapp_experiencer` ( `id` int(11) NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL COMMENT '站點id', `wechatid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '微信號', `userstr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '微信用戶唯一值', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加時間', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 8192 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '微信小程序體驗者' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_weapp_goods -- ---------------------------- DROP TABLE IF EXISTS `ns_weapp_goods`; CREATE TABLE `ns_weapp_goods` ( `id` int(11) NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL COMMENT '站點id', `goods_id` int(11) NOT NULL COMMENT '小程序商品庫商品id 非商城商品id', `name` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商品名稱', `cover_img` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商品圖片鏈接', `price` decimal(10,2) NOT NULL COMMENT '商品價格', `status` int(255) NOT NULL COMMENT '商品狀態，0：未審核。1：審核中，2：審核通過，3：審核駁回', `url` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商品小程序鏈接', `audit_id` int(11) NOT NULL COMMENT '審核單id', `sku_id` int(11) NOT NULL COMMENT '商品sku_id', `third_party_tag` int(1) NOT NULL COMMENT '商品來源 0在小程序平臺添加的商品 1/2通過api添加的商品', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 2340 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_weapp_live_room -- ---------------------------- DROP TABLE IF EXISTS `ns_weapp_live_room`; CREATE TABLE `ns_weapp_live_room` ( `id` int(11) NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL COMMENT '站點id', `roomid` int(11) NOT NULL COMMENT '直播間id', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '房間名稱', `cover_img` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '房間背景封面', `share_img` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '分享卡片圖片', `start_time` int(11) NOT NULL COMMENT '直播計劃開始時間', `end_time` int(11) NOT NULL COMMENT '直播計劃結束時間', `anchor_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主播昵稱', `goods` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '直播間商品', `live_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'live_status 101: 直播中, 102: 未開始, 103: 已結束, 104: 禁播, 105: 暫停中, 106: 異常, 107: 已過期', `anchor_img` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主播頭像', `banner` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '直播間橫幅', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1638 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '小程序直播直播間表' ROW_FORMAT = Compact;