營銷（砍價） · Niushop單商戶V5開發手冊

```[sql] -- ---------------------------- -- Table structure for ns_promotion_bargain -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_bargain`; CREATE TABLE `ns_promotion_bargain` ( `bargain_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '砍價id', `site_id` int(11) NOT NULL COMMENT '店鋪id', `bargain_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '砍價活動名稱', `is_fenxiao` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否參與分銷（0不參與 1參與）', `buy_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '購買方式（0任意金額可購買 1砍到指定價格）', `bargain_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '砍價金額類型（0固定金額 1隨機金額）', `bargain_num` int(11) NOT NULL DEFAULT 0 COMMENT '幫砍價人數', `bargain_time` int(11) NOT NULL DEFAULT 1 COMMENT '砍價有效期（小時）', `remark` text CHARACTER SET utf16 COLLATE utf16_general_ci NOT NULL COMMENT '活動規則說明', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間', `modify_time` 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 '活動結束時間', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '狀態（0未開始 1活動進行中 2活動已結束 3失效 4刪除）', `status_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '狀態名稱', `is_own` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否自己砍價（0不支持 1支持）', PRIMARY KEY (`bargain_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 AVG_ROW_LENGTH = 1820 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '砍價活動表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_promotion_bargain_goods -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_bargain_goods`; CREATE TABLE `ns_promotion_bargain_goods` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id', `site_id` int(11) NOT NULL COMMENT '店鋪id', `bargain_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 'sku商品id', `first_bargain_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '首刀金額', `bargain_stock` int(11) NOT NULL DEFAULT 0 COMMENT '砍價庫存', `floor_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '底價', `bargain_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '砍價活動名稱', `is_fenxiao` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否參與分銷（0不參與 1參與）', `buy_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '購買方式（0任意金額可購買 1砍到指定價格）', `bargain_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '砍價金額類型（0固定金額 1隨機金額）', `bargain_num` int(11) NOT NULL DEFAULT 0 COMMENT '幫砍價人數', `bargain_time` int(11) NOT NULL DEFAULT 1 COMMENT '砍價有效期', `remark` text CHARACTER SET utf16 COLLATE utf16_general_ci NOT NULL COMMENT '活動規則說明', `start_time` int(11) NOT NULL DEFAULT 0 COMMENT '活動開始時間', `end_time` int(11) NOT NULL DEFAULT 0 COMMENT '活動結束時間', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '狀態（0未開始 1活動進行中 2活動已結束 3已關閉）', `status_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '狀態名稱', `is_own` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否自己砍價（0不支持 1支持）', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10 AVG_ROW_LENGTH = 819 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '砍價活動表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_promotion_bargain_launch -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_bargain_launch`; CREATE TABLE `ns_promotion_bargain_launch` ( `launch_id` int(11) NOT NULL AUTO_INCREMENT, `bargain_id` int(11) NOT NULL DEFAULT 0 COMMENT '砍價活動id', `sku_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品sku_id', `goods_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品id', `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `sku_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品名稱', `sku_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品圖', `price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '商品原價', `floor_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '底價', `buy_type` int(1) NOT NULL DEFAULT 0 COMMENT '購買方式（0任意金額可購買 1砍到指定價格）', `bargain_type` int(1) NOT NULL DEFAULT 0 COMMENT '砍價金額類型（0固定金額 1隨機金額）', `need_num` int(11) NOT NULL DEFAULT 0 COMMENT '幫砍人數需達到數', `curr_num` 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 '結束時間', `status` int(1) NOT NULL DEFAULT 0 COMMENT '0砍價中 1已成功 2未成功', `member_id` int(11) NOT NULL DEFAULT 0 COMMENT '砍價發起用戶', `nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '昵稱', `headimg` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '頭像', `is_fenxiao` int(1) NOT NULL DEFAULT 0 COMMENT '是否參與分銷（0不參與 1參與）', `order_id` int(11) NOT NULL DEFAULT 0 COMMENT '訂單id', `first_bargain_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '首刀金額', `curr_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '當前金額', `is_own` int(11) NOT NULL DEFAULT 0 COMMENT '是否自己砍價（0不支持 1支持）', PRIMARY KEY (`launch_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 AVG_ROW_LENGTH = 963 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '砍價發起表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_promotion_bargain_record -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_bargain_record`; CREATE TABLE `ns_promotion_bargain_record` ( `id` int(11) NOT NULL AUTO_INCREMENT, `launch_id` int(11) NOT NULL DEFAULT 0 COMMENT '砍價發起id', `member_id` int(11) NOT NULL DEFAULT 0 COMMENT '幫砍會員id', `nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '昵稱', `headimg` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '頭像', `money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '幫砍金額', `bargain_time` int(11) NOT NULL DEFAULT 0 COMMENT '幫砍時間', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 AVG_ROW_LENGTH = 481 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;