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

                ??碼云GVP開源項目 12k star Uniapp+ElementUI 功能強大 支持多語言、二開方便! 廣告
                ```[sql] -- ---------------------------- -- Table structure for ns_promotion_pintuan -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_pintuan`; CREATE TABLE `ns_promotion_pintuan` ( `pintuan_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '拼團id', `site_id` int(11) NOT NULL COMMENT '店鋪id', `site_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '店鋪名稱', `pintuan_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '活動名稱', `goods_id` int(11) NULL DEFAULT 0 COMMENT '商品id', `is_virtual_goods` tinyint(1) NULL DEFAULT 0 COMMENT '是否是虛擬商品(0否 1是)', `pintuan_num` int(11) NOT NULL DEFAULT 0 COMMENT '參團人數', `pintuan_time` int(11) NOT NULL DEFAULT 1 COMMENT '拼團有效期', `remark` text CHARACTER SET utf16 COLLATE utf16_general_ci NULL COMMENT '備注', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間', `modify_time` int(11) NOT NULL DEFAULT 0 COMMENT '修改時間', `is_recommend` 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 '結束時間', `buy_num` int(11) NOT NULL DEFAULT 0 COMMENT '拼團限制購買', `pintuan_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '顯示拼團價', `is_single_buy` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否單獨購買', `is_virtual_buy` tinyint(1) NULL DEFAULT 0 COMMENT '是否虛擬成團', `is_promotion` tinyint(1) NULL DEFAULT 0 COMMENT '是否團長優惠', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '狀態(0正常 1活動進行中 2活動已結束 3失效 4刪除)', `group_num` int(11) NOT NULL DEFAULT 0 COMMENT '開團組數', `order_num` int(11) NOT NULL DEFAULT 0 COMMENT '購買人數', PRIMARY KEY (`pintuan_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 4096 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '拼團活動表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_promotion_pintuan_goods -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_pintuan_goods`; CREATE TABLE `ns_promotion_pintuan_goods` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵', `pintuan_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 'skuid', `pintuan_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '拼團價', `promotion_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '團長優惠價', `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1489 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '拼團商品表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_promotion_pintuan_group -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_pintuan_group`; CREATE TABLE `ns_promotion_pintuan_group` ( `group_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '拼團分組id', `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '店鋪id', `goods_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品id', `is_virtual_goods` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否虛擬商品', `pintuan_id` int(11) NOT NULL DEFAULT 0 COMMENT '拼團活動id', `head_id` int(11) NOT NULL DEFAULT 0 COMMENT '團長id', `pintuan_num` int(11) NOT NULL DEFAULT 0 COMMENT '拼團數量', `pintuan_count` int(11) NOT NULL DEFAULT 1 COMMENT '當前數量', `create_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.拼團成功', `is_virtual_buy` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否虛擬成團', `is_single_buy` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否單獨購買', `is_promotion` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否團長優惠', `buy_num` int(11) NOT NULL DEFAULT 0 COMMENT '拼團限制購買', `head_member_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '組長會員頭像', `head_nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '組長會員昵稱', PRIMARY KEY (`group_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1260 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '拼團組' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_promotion_pintuan_order -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_pintuan_order`; CREATE TABLE `ns_promotion_pintuan_order` ( `id` int(11) NOT NULL AUTO_INCREMENT, `pintuan_id` int(11) NOT NULL DEFAULT 0 COMMENT '拼團id', `order_id` int(11) NOT NULL DEFAULT 0 COMMENT '訂單id', `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `order_no` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '訂單編號', `group_id` int(11) NOT NULL DEFAULT 0 COMMENT '拼團分組id', `pintuan_status` int(11) NOT NULL DEFAULT 0 COMMENT '拼團狀態(0未支付 1拼團失敗 2組團中 3拼團成功)', `order_type` int(11) NOT NULL DEFAULT 1 COMMENT '訂單類型', `head_id` int(11) NOT NULL DEFAULT 1 COMMENT '團長id', `member_id` int(11) NOT NULL DEFAULT 0 COMMENT '訂單會員id', `member_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '會員頭像圖', `nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '會員昵稱', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 744 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>

                              哎呀哎呀视频在线观看