營銷（專題） · Niushop單商戶V5開發手冊

```[sql] - ---------------------------- -- Table structure for ns_promotion_topic -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_topic`; CREATE TABLE `ns_promotion_topic` ( `topic_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵', `site_id` int(10) NOT NULL DEFAULT 0 COMMENT '站點id', `topic_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '專題名稱', `topic_adv` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '專題廣告', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '活動狀態 1未開始 2進行中 3已結束', `remark` varchar(255) 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 '修改時間', `bg_color` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '#ffffff' COMMENT '背景色', PRIMARY KEY (`topic_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 16384 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '專題活動' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_promotion_topic_goods -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_topic_goods`; CREATE TABLE `ns_promotion_topic_goods` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵', `topic_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 '活動結束時間', `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `sku_id` int(11) NOT NULL DEFAULT 0 COMMENT 'skuId', `topic_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '折扣價', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 2048 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '限時折扣商品列表' ROW_FORMAT = Compact;