營銷（限時折扣） · Niushop單商戶V5開發手冊

```[sql] -- ---------------------------- -- Table structure for ns_promotion_discount -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_discount`; CREATE TABLE `ns_promotion_discount` ( `discount_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵', `site_id` int(11) NOT NULL DEFAULT 1 COMMENT '站點id', `site_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '站點名稱', `discount_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '活動名稱', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '活動狀態 0未開始 1進行中 2已結束 -1已關閉（手動）', `remark` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '備注', `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 '修改時間', PRIMARY KEY (`discount_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_discount_goods -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_discount_goods`; CREATE TABLE `ns_promotion_discount_goods` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵', `discount_id` int(11) NOT NULL DEFAULT 0 COMMENT '對應活動Id', `start_time` int(11) NOT NULL DEFAULT 0 COMMENT '活動開始時間', `end_time` int(11) NOT NULL DEFAULT 0 COMMENT '活動結束時間', `goods_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品id', `sku_id` int(11) NOT NULL DEFAULT 0 COMMENT 'skuId', `price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '商品價格', `discount_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '折扣價', `sku_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品名稱', `sku_image` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '商品圖片', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 780 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '限時折扣商品列表' ROW_FORMAT = Compact;