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

```[sql] -- ---------------------------- -- Table structure for ns_promotion_groupbuy -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_groupbuy`; CREATE TABLE `ns_promotion_groupbuy` ( `groupbuy_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '店鋪ID', `site_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '店鋪名稱', `goods_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品ID', `goods_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品名稱', `goods_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品圖片', `is_virtual_goods` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否是虛擬商品（0否 1是）', `goods_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '商品原價', `groupbuy_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '團購價', `buy_num` 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 '修改時間', `start_time` int(11) NOT NULL DEFAULT 0 COMMENT '開始時間', `end_time` int(11) NOT NULL DEFAULT 0 COMMENT '結束時間', `sell_num` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '已出售數量', `status` tinyint(3) NOT NULL DEFAULT 1 COMMENT '狀態（1未開始 2進行中 3已結束）', `sku_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品sku', PRIMARY KEY (`groupbuy_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1365 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '團購' ROW_FORMAT = Compact;