<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>

                ThinkChat2.0新版上線,更智能更精彩,支持會話、畫圖、視頻、閱讀、搜索等,送10W Token,即刻開啟你的AI之旅 廣告
                ```[sql] -- ---------------------------- -- Table structure for ns_promotion_bargain -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_bargain`; CREATE TABLE `ns_promotion_bargain` ( `bargain_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '砍價id', `site_id` int(11) NOT NULL COMMENT '店鋪id', `bargain_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '砍價活動名稱', `is_fenxiao` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否參與分銷(0不參與 1參與)', `buy_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '購買方式(0任意金額可購買 1砍到指定價格)', `bargain_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '砍價金額類型(0固定金額 1隨機金額)', `bargain_num` int(11) NOT NULL DEFAULT 0 COMMENT '幫砍價人數', `bargain_time` int(11) NOT NULL DEFAULT 1 COMMENT '砍價有效期(小時)', `remark` text CHARACTER SET utf16 COLLATE utf16_general_ci NOT NULL 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 '活動結束時間', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '狀態(0未開始 1活動進行中 2活動已結束 3失效 4刪除)', `status_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '狀態名稱', `is_own` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否自己砍價(0不支持 1支持)', PRIMARY KEY (`bargain_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 AVG_ROW_LENGTH = 1820 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '砍價活動表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_promotion_bargain_goods -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_bargain_goods`; CREATE TABLE `ns_promotion_bargain_goods` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id', `site_id` int(11) NOT NULL COMMENT '店鋪id', `bargain_id` int(11) NOT NULL DEFAULT 0 COMMENT '砍價id', `goods_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品id', `sku_id` int(11) NOT NULL DEFAULT 0 COMMENT 'sku商品id', `first_bargain_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '首刀金額', `bargain_stock` int(11) NOT NULL DEFAULT 0 COMMENT '砍價庫存', `floor_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '底價', `bargain_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '砍價活動名稱', `is_fenxiao` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否參與分銷(0不參與 1參與)', `buy_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '購買方式(0任意金額可購買 1砍到指定價格)', `bargain_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '砍價金額類型(0固定金額 1隨機金額)', `bargain_num` int(11) NOT NULL DEFAULT 0 COMMENT '幫砍價人數', `bargain_time` int(11) NOT NULL DEFAULT 1 COMMENT '砍價有效期', `remark` text CHARACTER SET utf16 COLLATE utf16_general_ci NOT NULL COMMENT '活動規則說明', `start_time` int(11) NOT NULL DEFAULT 0 COMMENT '活動開始時間', `end_time` int(11) NOT NULL DEFAULT 0 COMMENT '活動結束時間', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '狀態(0未開始 1活動進行中 2活動已結束 3已關閉)', `status_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '狀態名稱', `is_own` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否自己砍價(0不支持 1支持)', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10 AVG_ROW_LENGTH = 819 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '砍價活動表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_promotion_bargain_launch -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_bargain_launch`; CREATE TABLE `ns_promotion_bargain_launch` ( `launch_id` int(11) NOT NULL AUTO_INCREMENT, `bargain_id` int(11) NOT NULL DEFAULT 0 COMMENT '砍價活動id', `sku_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品sku_id', `goods_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品id', `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `sku_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品名稱', `sku_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品圖', `price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '商品原價', `floor_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '底價', `buy_type` int(1) NOT NULL DEFAULT 0 COMMENT '購買方式(0任意金額可購買 1砍到指定價格)', `bargain_type` int(1) NOT NULL DEFAULT 0 COMMENT '砍價金額類型(0固定金額 1隨機金額)', `need_num` int(11) NOT NULL DEFAULT 0 COMMENT '幫砍人數需達到數', `curr_num` 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(1) NOT NULL DEFAULT 0 COMMENT '0砍價中 1已成功 2未成功', `member_id` int(11) NOT NULL DEFAULT 0 COMMENT '砍價發起用戶', `nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '昵稱', `headimg` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '頭像', `is_fenxiao` int(1) NOT NULL DEFAULT 0 COMMENT '是否參與分銷(0不參與 1參與)', `order_id` int(11) NOT NULL DEFAULT 0 COMMENT '訂單id', `first_bargain_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '首刀金額', `curr_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '當前金額', `is_own` int(11) NOT NULL DEFAULT 0 COMMENT '是否自己砍價(0不支持 1支持)', PRIMARY KEY (`launch_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 AVG_ROW_LENGTH = 963 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '砍價發起表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_promotion_bargain_record -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_bargain_record`; CREATE TABLE `ns_promotion_bargain_record` ( `id` int(11) NOT NULL AUTO_INCREMENT, `launch_id` int(11) NOT NULL DEFAULT 0 COMMENT '砍價發起id', `member_id` int(11) NOT NULL DEFAULT 0 COMMENT '幫砍會員id', `nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '昵稱', `headimg` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '頭像', `money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '幫砍金額', `bargain_time` int(11) NOT NULL DEFAULT 0 COMMENT '幫砍時間', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 AVG_ROW_LENGTH = 481 CHARACTER SET = utf8 COLLATE = utf8_general_ci 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>

                              哎呀哎呀视频在线观看