營銷（滿減送） · Niushop單商戶V5開發手冊

```[sql] -- ---------------------------- -- Table structure for ns_promotion_manjian -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_manjian`; CREATE TABLE `ns_promotion_manjian` ( `manjian_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵', `site_id` int(11) NOT NULL COMMENT '站點id', `manjian_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '名稱', `manjian_type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1全部商品參與 2指定商品 3指定商品不參與 ', `type` int(1) NOT NULL DEFAULT 0 COMMENT '條件類型 0:滿N元 1:滿N件', `goods_ids` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '商品id集', `status` int(11) NOT NULL DEFAULT 0 COMMENT '狀態（0未開始1進行中2已結束-1已關閉）', `start_time` int(11) NOT NULL DEFAULT 0 COMMENT '開始時間', `end_time` int(11) NOT NULL DEFAULT 0 COMMENT '結束時間', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間', `modify_time` int(11) NOT NULL DEFAULT 0 COMMENT '修改時間', `rule_json` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '{}' COMMENT '規則json', `remark` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '備注', PRIMARY KEY (`manjian_id`) USING BTREE, INDEX `IDX_ns_promotion_manjian_site_id`(`site_id`) USING BTREE, INDEX `IDX_ns_promotion_manjian_status`(`status`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 AVG_ROW_LENGTH = 5461 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '滿減活動' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_promotion_manjian_goods -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_manjian_goods`; CREATE TABLE `ns_promotion_manjian_goods` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `manjian_id` int(11) NOT NULL DEFAULT 0 COMMENT '滿減活動id', `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `goods_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品id', `manjian_type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1全部商品參與 2指定商品 3指定商品不參與 ', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '狀態（0未開始1進行中2已結束-1已關閉）', `rule_json` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '滿減規則json', `start_time` int(11) NOT NULL DEFAULT 0 COMMENT '開始時間', `end_time` int(11) NOT NULL DEFAULT 0 COMMENT '結束時間', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 AVG_ROW_LENGTH = 174 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '滿減商品表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_promotion_mansong_record -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_mansong_record`; CREATE TABLE `ns_promotion_mansong_record` ( `id` int(11) NOT NULL AUTO_INCREMENT, `manjian_id` int(11) NOT NULL DEFAULT 0 COMMENT '滿減送活動id', `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `manjian_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '滿減送活動名稱', `point` int(11) NOT NULL DEFAULT 0 COMMENT '所送積分數', `coupon` int(11) NOT NULL DEFAULT 0 COMMENT '所送優惠券', `order_id` int(11) NOT NULL DEFAULT 0 COMMENT '訂單id', `member_id` int(11) NOT NULL DEFAULT 0, `order_sku_ids` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '滿足條件的商品規格id', `status` int(11) NOT NULL DEFAULT 0 COMMENT '0未發放 1已發放', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 2340 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '滿送記錄表' ROW_FORMAT = Compact;