營銷（拼團） · Niushop單商戶V5開發手冊

```[sql] -- ---------------------------- -- Table structure for ns_promotion_pintuan -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_pintuan`; CREATE TABLE `ns_promotion_pintuan` ( `pintuan_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '拼團id', `site_id` int(11) NOT NULL COMMENT '店鋪id', `site_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '店鋪名稱', `pintuan_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '活動名稱', `goods_id` int(11) NULL DEFAULT 0 COMMENT '商品id', `is_virtual_goods` tinyint(1) NULL DEFAULT 0 COMMENT '是否是虛擬商品（0否 1是）', `pintuan_num` int(11) NOT NULL DEFAULT 0 COMMENT '參團人數', `pintuan_time` int(11) NOT NULL DEFAULT 1 COMMENT '拼團有效期', `remark` text CHARACTER SET utf16 COLLATE utf16_general_ci NULL COMMENT '備注', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間', `modify_time` int(11) NOT NULL DEFAULT 0 COMMENT '修改時間', `is_recommend` int(11) NOT NULL DEFAULT 0 COMMENT '是否推薦', `start_time` int(11) NOT NULL DEFAULT 0 COMMENT '開始時間', `end_time` int(11) NOT NULL DEFAULT 0 COMMENT '結束時間', `buy_num` int(11) NOT NULL DEFAULT 0 COMMENT '拼團限制購買', `pintuan_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '顯示拼團價', `is_single_buy` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否單獨購買', `is_virtual_buy` tinyint(1) NULL DEFAULT 0 COMMENT '是否虛擬成團', `is_promotion` tinyint(1) NULL DEFAULT 0 COMMENT '是否團長優惠', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '狀態（0正常 1活動進行中 2活動已結束 3失效 4刪除）', `group_num` int(11) NOT NULL DEFAULT 0 COMMENT '開團組數', `order_num` int(11) NOT NULL DEFAULT 0 COMMENT '購買人數', PRIMARY KEY (`pintuan_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 4096 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '拼團活動表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_promotion_pintuan_goods -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_pintuan_goods`; CREATE TABLE `ns_promotion_pintuan_goods` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵', `pintuan_id` int(11) NOT NULL DEFAULT 0 COMMENT '拼團id', `goods_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品id', `sku_id` int(11) NOT NULL DEFAULT 0 COMMENT 'skuid', `pintuan_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '拼團價', `promotion_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '團長優惠價', `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1489 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '拼團商品表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_promotion_pintuan_group -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_pintuan_group`; CREATE TABLE `ns_promotion_pintuan_group` ( `group_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '拼團分組id', `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '店鋪id', `goods_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品id', `is_virtual_goods` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否虛擬商品', `pintuan_id` int(11) NOT NULL DEFAULT 0 COMMENT '拼團活動id', `head_id` int(11) NOT NULL DEFAULT 0 COMMENT '團長id', `pintuan_num` int(11) NOT NULL DEFAULT 0 COMMENT '拼團數量', `pintuan_count` int(11) NOT NULL DEFAULT 1 COMMENT '當前數量', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間', `end_time` int(11) NOT NULL DEFAULT 0 COMMENT '拼團結束時間', `status` int(11) NOT NULL DEFAULT 0 COMMENT '當前狀態 0未支付 1拼團失敗 2.組團中3.拼團成功', `is_virtual_buy` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否虛擬成團', `is_single_buy` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否單獨購買', `is_promotion` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否團長優惠', `buy_num` int(11) NOT NULL DEFAULT 0 COMMENT '拼團限制購買', `head_member_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '組長會員頭像', `head_nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '組長會員昵稱', PRIMARY KEY (`group_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1260 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '拼團組' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_promotion_pintuan_order -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_pintuan_order`; CREATE TABLE `ns_promotion_pintuan_order` ( `id` int(11) NOT NULL AUTO_INCREMENT, `pintuan_id` int(11) NOT NULL DEFAULT 0 COMMENT '拼團id', `order_id` int(11) NOT NULL DEFAULT 0 COMMENT '訂單id', `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `order_no` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '訂單編號', `group_id` int(11) NOT NULL DEFAULT 0 COMMENT '拼團分組id', `pintuan_status` int(11) NOT NULL DEFAULT 0 COMMENT '拼團狀態(0未支付 1拼團失敗 2組團中 3拼團成功)', `order_type` int(11) NOT NULL DEFAULT 1 COMMENT '訂單類型', `head_id` int(11) NOT NULL DEFAULT 1 COMMENT '團長id', `member_id` int(11) NOT NULL DEFAULT 0 COMMENT '訂單會員id', `member_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '會員頭像圖', `nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '會員昵稱', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 744 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '拼團訂單' ROW_FORMAT = Compact;