<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                企業??AI智能體構建引擎,智能編排和調試,一鍵部署,支持知識庫和私有化部署方案 廣告
                ```[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;
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看