營銷（互動游戲） · Niushop單商戶V5開發手冊

```[sql] -- ---------------------------- -- Table structure for ns_promotion_games -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_games`; CREATE TABLE `ns_promotion_games` ( `game_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '游戲id', `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `game_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '游戲活動名稱', `game_type` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1' COMMENT '游戲類型（插件名稱）', `game_type_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '游戲類型名稱', `level_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '參與的會員等級0表示全部參與', `level_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '參與活動會員名稱', `points` 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(11) NOT NULL DEFAULT 0 COMMENT '活動狀態 0未開始 1已開始 2已結束 3已關閉', `remark` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '活動說明', `winning_rate` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '中獎率', `no_winning_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', `no_winning_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '未中獎說明', `is_show_winner` int(11) NOT NULL DEFAULT 0 COMMENT '中獎名單是否顯示 0不顯示 1顯示', `join_type` int(11) NOT NULL DEFAULT 0 COMMENT '參加類型 0活動全過程 1每天', `join_frequency` int(11) NOT NULL DEFAULT 1 COMMENT '根據類型計算參加次數', `join_num` int(11) NOT NULL DEFAULT 0 COMMENT '抽獎人數', `winning_num` int(11) NOT NULL DEFAULT 0 COMMENT '中獎人數', `create_time` int(11) NOT NULL DEFAULT 0, `update_time` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`game_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 AVG_ROW_LENGTH = 16384 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '營銷游戲（概率游戲）' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_promotion_games_award -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_games_award`; CREATE TABLE `ns_promotion_games_award` ( `award_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `game_id` int(11) NOT NULL DEFAULT 0 COMMENT '游戲id', `award_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '獎品名稱', `award_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '圖片', `award_type` tinyint(3) NOT NULL DEFAULT 0 COMMENT '獎品類型（1積分 2余額（不可提現） 3優惠券 4贈品）', `relate_id` int(11) NOT NULL DEFAULT 0 COMMENT '關聯id（根據獎品類型）', `relate_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '關聯商品名稱（優惠券或者贈品名稱）', `point` int(11) NOT NULL DEFAULT 0 COMMENT '積分數', `balance` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '余額', `award_num` int(11) NOT NULL DEFAULT 0 COMMENT '獎品數量', `award_winning_rate` int(11) NOT NULL DEFAULT 0 COMMENT '獎品中獎概率', `remaining_num` int(11) NOT NULL DEFAULT 0 COMMENT '剩余數量', `receive_num` int(11) NOT NULL DEFAULT 0 COMMENT '已領取數量', `no_winning_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '未中獎圖片', PRIMARY KEY (`award_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 9 AVG_ROW_LENGTH = 264 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '游戲獎品' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_promotion_games_draw_record -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_games_draw_record`; CREATE TABLE `ns_promotion_games_draw_record` ( `record_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `game_id` int(11) NOT NULL DEFAULT 0 COMMENT '游戲id', `game_type` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '游戲類型（插件名稱）', `member_id` int(11) NOT NULL DEFAULT 0 COMMENT '會員id', `member_nick_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '會員昵稱', `points` int(11) NOT NULL DEFAULT 0 COMMENT '參與消耗積分', `is_winning` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否中獎（0未中 1中獎）', `award_id` int(11) NOT NULL DEFAULT 0 COMMENT '獎品id', `award_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '獎品名稱', `award_type` tinyint(3) NOT NULL DEFAULT 0 COMMENT '獎品類型（1積分 2余額（不可提現） 3優惠券 4贈品）', `relate_id` int(11) NOT NULL DEFAULT 0 COMMENT '關聯id（根據獎品類型）', `relate_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '關聯商品名稱（優惠券或者贈品名稱）', `is_receive` tinyint(3) NOT NULL DEFAULT 0 COMMENT '是否領取（0未領取 1領取）獎品為優惠券贈品是使用', `point` int(11) NOT NULL DEFAULT 0 COMMENT '獎勵積分數', `balance` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '獎勵余額', `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '說明', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '參與時間', PRIMARY KEY (`record_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 14 AVG_ROW_LENGTH = 146 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '抽獎記錄' ROW_FORMAT = Compact;