數據字典 · CRMEB 單商戶 v4 幫助文檔（PHP）

# 數據字典 ```[sql] -- ---------------------------- -- Table structure for eb_article -- ---------------------------- DROP TABLE IF EXISTS `eb_article`; CREATE TABLE `eb_article` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '文章管理ID', `cid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '分類id', `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文章標題', `author` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文章作者', `image_input` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文章圖片', `synopsis` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文章簡介', `share_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文章分享標題', `share_synopsis` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文章分享簡介', `visit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '瀏覽次數', `sort` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序', `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '原文鏈接', `status` tinyint(1) UNSIGNED NOT NULL COMMENT '狀態', `add_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '添加時間', `hide` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否隱藏', `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '管理員id', `mer_id` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '商戶id', `product_id` int(10) NOT NULL DEFAULT 0 COMMENT '商品關聯id', `is_hot` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否熱門(小程序)', `is_banner` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否輪播圖(小程序)', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '文章管理表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_article_category -- ---------------------------- DROP TABLE IF EXISTS `eb_article_category`; CREATE TABLE `eb_article_category` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '文章分類id', `pid` int(11) NOT NULL DEFAULT 0 COMMENT '父級ID', `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文章分類標題', `intr` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文章分類簡介', `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文章分類圖片', `status` tinyint(1) UNSIGNED NOT NULL COMMENT '狀態', `sort` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序', `is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '1刪除0未刪除', `add_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '添加時間', `hidden` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否隱藏', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '文章分類表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_article_content -- ---------------------------- DROP TABLE IF EXISTS `eb_article_content`; CREATE TABLE `eb_article_content` ( `nid` int(10) UNSIGNED NOT NULL COMMENT '文章id', `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文章內容', UNIQUE INDEX `nid`(`nid`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '文章內容表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_cache -- ---------------------------- DROP TABLE IF EXISTS `eb_cache`; CREATE TABLE `eb_cache` ( `key` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `result` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '緩存數據', `expire_time` int(11) NOT NULL DEFAULT 0 COMMENT '失效時間0=永久', `add_time` int(10) NULL DEFAULT NULL COMMENT '緩存時間', PRIMARY KEY (`key`) USING BTREE, INDEX `key`(`key`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '微信緩存表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_diy -- ---------------------------- DROP TABLE IF EXISTS `eb_diy`; CREATE TABLE `eb_diy` ( `id` int(11) NOT NULL AUTO_INCREMENT, `version` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '版本號', `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '頁面名稱', `value` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '頁面數據', `add_time` int(11) NULL DEFAULT NULL COMMENT '添加時間', `update_time` int(11) NULL DEFAULT NULL COMMENT '更新時間', `status` tinyint(1) NULL DEFAULT 0 COMMENT '是否使用', `type` tinyint(1) NULL DEFAULT NULL COMMENT '頁面類型', `is_del` tinyint(1) NULL DEFAULT 0 COMMENT '是否刪除', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'DIY數據表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_express -- ---------------------------- DROP TABLE IF EXISTS `eb_express`; CREATE TABLE `eb_express` ( `id` mediumint(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '快遞公司id', `code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '快遞公司簡稱', `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '快遞公司全稱', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序', `is_show` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否顯示', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `code`(`code`) USING BTREE, INDEX `is_show`(`is_show`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 427 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '快遞公司表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_qrcode -- ---------------------------- DROP TABLE IF EXISTS `eb_qrcode`; CREATE TABLE `eb_qrcode` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '微信二維碼ID', `third_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '二維碼類型', `third_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用戶id', `ticket` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '二維碼參數', `expire_seconds` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '二維碼有效時間', `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '狀態', `add_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '添加時間', `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '微信訪問url', `qrcode_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '微信二維碼url', `scan` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '被掃的次數', `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '二維碼所屬平臺1=小程序，2=公眾號，3=H5', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `third_type`(`third_type`, `third_id`) USING BTREE, INDEX `ticket`(`ticket`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '微信二維碼管理表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_routine_access_token -- ---------------------------- DROP TABLE IF EXISTS `eb_routine_access_token`; CREATE TABLE `eb_routine_access_token` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '小程序access_token表ID', `access_token` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'openid', `stop_time` int(11) UNSIGNED NOT NULL COMMENT '添加時間', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '小程序access_token表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_routine_form_id -- ---------------------------- DROP TABLE IF EXISTS `eb_routine_form_id`; CREATE TABLE `eb_routine_form_id` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表單ID表ID', `uid` int(11) NULL DEFAULT 0 COMMENT '用戶uid', `form_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '表單ID', `stop_time` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '表單ID失效時間', `status` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '狀態1 未使用 2不能使用', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '表單id表記錄表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_routine_qrcode -- ---------------------------- DROP TABLE IF EXISTS `eb_routine_qrcode`; CREATE TABLE `eb_routine_qrcode` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '微信二維碼ID', `third_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '二維碼類型 spread(用戶推廣) product_spread(商品推廣)', `third_id` int(11) UNSIGNED NOT NULL COMMENT '用戶id', `status` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '狀態 0不可用 1可用', `add_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '添加時間', `page` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '小程序頁面路徑帶參數', `qrcode_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '小程序二維碼路徑', `url_time` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '二維碼添加時間', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '小程序二維碼管理表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_shipping_templates -- ---------------------------- DROP TABLE IF EXISTS `eb_shipping_templates`; CREATE TABLE `eb_shipping_templates` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '編號', `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模板名稱', `type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '計費方式', `appoint` tinyint(1) NOT NULL DEFAULT 0 COMMENT '指定包郵', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序', `add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加時間', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 COMMENT = '運費模板' CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_shipping_templates_free -- ---------------------------- DROP TABLE IF EXISTS `eb_shipping_templates_free`; CREATE TABLE `eb_shipping_templates_free` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '編號', `province_id` int(11) NOT NULL DEFAULT 0 COMMENT '省ID', `temp_id` int(11) NOT NULL DEFAULT 0 COMMENT '模板ID', `city_id` int(11) NOT NULL DEFAULT 0 COMMENT '城市ID', `number` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '包郵件數', `price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '包郵金額', `type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '計費方式', `uniqid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分組唯一值', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 COMMENT = '指定包郵表' CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_shipping_templates_region -- ---------------------------- DROP TABLE IF EXISTS `eb_shipping_templates_region`; CREATE TABLE `eb_shipping_templates_region` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '編號', `province_id` int(11) NOT NULL DEFAULT 0 COMMENT '省ID', `temp_id` int(11) NOT NULL DEFAULT 0 COMMENT '模板ID', `city_id` int(11) NOT NULL DEFAULT 0 COMMENT '城市ID', `first` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '首件', `first_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '首件運費', `continue` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '續件', `continue_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '續件運費', `type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '計費方式', `uniqid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分組唯一值', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 COMMENT = '指定運費表' CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_sms_record -- ---------------------------- DROP TABLE IF EXISTS `eb_sms_record`; CREATE TABLE `eb_sms_record` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '短信發送記錄編號', `uid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '短信平臺賬號', `phone` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '接受短信的手機號', `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '短信內容', `add_time` int(11) UNSIGNED NOT NULL COMMENT '發送短信時間', `add_ip` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '添加記錄ip', `template` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '短信模板ID', `resultcode` int(6) UNSIGNED NULL DEFAULT NULL COMMENT '狀態碼 100=成功,130=失敗,131=空號,132=停機,133=關機,134=無狀態', `record_id` int(11) UNSIGNED NOT NULL COMMENT '發送記錄id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '短信發送記錄表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_store_bargain -- ---------------------------- DROP TABLE IF EXISTS `eb_store_bargain`; CREATE TABLE `eb_store_bargain` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '砍價商品ID', `product_id` int(11) UNSIGNED NOT NULL COMMENT '關聯商品ID', `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '砍價活動名稱', `image` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '砍價活動圖片', `unit_name` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '單位名稱', `stock` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '庫存', `sales` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '銷量', `images` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '砍價商品輪播圖', `start_time` int(11) UNSIGNED NOT NULL COMMENT '砍價開啟時間', `stop_time` int(11) UNSIGNED NOT NULL COMMENT '砍價結束時間', `store_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '砍價商品名稱', `price` decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT '砍價金額', `min_price` decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT '砍價商品最低價', `num` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '每次購買的砍價商品數量', `bargain_max_price` decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT '用戶每次砍價的最大金額', `bargain_min_price` decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT '用戶每次砍價的最小金額', `bargain_num` int(11) UNSIGNED NOT NULL DEFAULT 1 COMMENT '用戶每次砍價的次數', `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '砍價狀態 0(到砍價時間不自動開啟) 1(到砍價時間自動開啟時間)', `give_integral` decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '反多少積分', `info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '砍價活動簡介', `cost` decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT '成本價', `sort` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序', `is_hot` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否推薦0不推薦1推薦', `is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否刪除 0未刪除 1刪除', `add_time` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '添加時間', `is_postage` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否包郵 0不包郵 1包郵', `postage` decimal(10, 2) UNSIGNED NULL DEFAULT NULL COMMENT '郵費', `rule` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '砍價規則', `look` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '砍價商品瀏覽量', `share` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '砍價商品分享量', `temp_id` int(11) NULL DEFAULT NULL COMMENT '運費模板ID', `weight` decimal(8, 2) NULL DEFAULT 0.00 COMMENT '重量', `volume` decimal(8, 2) NULL DEFAULT 0.00 COMMENT '體積', `quota` int(10) NOT NULL DEFAULT 0 COMMENT '限購總數', `quota_show` int(10) NOT NULL DEFAULT 0 COMMENT '限量總數顯示', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '砍價表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_store_bargain_user -- ---------------------------- DROP TABLE IF EXISTS `eb_store_bargain_user`; CREATE TABLE `eb_store_bargain_user` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用戶參與砍價表ID', `uid` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '用戶ID', `bargain_id` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '砍價商品id', `bargain_price_min` decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT '砍價的最低價', `bargain_price` decimal(8, 2) NULL DEFAULT NULL COMMENT '砍價金額', `price` decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT '砍掉的價格', `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '狀態 1參與中 2 活動結束參與失敗 3活動結束參與成功', `add_time` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '參與時間', `is_del` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否取消', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用戶參與砍價表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_store_bargain_user_help -- ---------------------------- DROP TABLE IF EXISTS `eb_store_bargain_user_help`; CREATE TABLE `eb_store_bargain_user_help` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '砍價用戶幫助表ID', `uid` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '幫助的用戶id', `bargain_id` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '砍價商品ID', `bargain_user_id` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '用戶參與砍價表id', `price` decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT '幫助砍價多少金額', `add_time` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '添加時間', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '砍價用戶幫助表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_store_cart -- ---------------------------- DROP TABLE IF EXISTS `eb_store_cart`; CREATE TABLE `eb_store_cart` ( `id` bigint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '購物車表ID', `uid` int(10) UNSIGNED NOT NULL COMMENT '用戶ID', `type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '類型', `product_id` int(10) UNSIGNED NOT NULL COMMENT '商品ID', `product_attr_unique` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品屬性', `cart_num` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品數量', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '購物車商品狀態 1=正常，0=失效，2無貨', `add_time` int(10) UNSIGNED NOT NULL COMMENT '添加時間', `is_pay` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0 = 未購買 1 = 已購買', `is_del` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否刪除', `is_new` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否為立即購買', `combination_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '拼團id', `seckill_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '秒殺商品ID', `bargain_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '砍價id', PRIMARY KEY (`id`) USING BTREE, INDEX `user_id`(`uid`) USING BTREE, INDEX `goods_id`(`product_id`) USING BTREE, INDEX `uid`(`uid`, `is_pay`) USING BTREE, INDEX `uid_2`(`uid`, `is_del`) USING BTREE, INDEX `uid_3`(`uid`, `is_new`) USING BTREE, INDEX `type`(`type`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '購物車表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_store_category -- ---------------------------- DROP TABLE IF EXISTS `eb_store_category`; CREATE TABLE `eb_store_category` ( `id` mediumint(11) NOT NULL AUTO_INCREMENT COMMENT '商品分類表ID', `pid` mediumint(11) NOT NULL COMMENT '父id', `cate_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '分類名稱', `sort` mediumint(11) NOT NULL COMMENT '排序', `pic` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '圖標', `is_show` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否推薦', `add_time` int(11) NOT NULL COMMENT '添加時間', PRIMARY KEY (`id`) USING BTREE, INDEX `pid`(`pid`) USING BTREE, INDEX `is_base`(`is_show`) USING BTREE, INDEX `sort`(`sort`) USING BTREE, INDEX `add_time`(`add_time`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品分類表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_store_combination -- ---------------------------- DROP TABLE IF EXISTS `eb_store_combination`; CREATE TABLE `eb_store_combination` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `product_id` int(10) UNSIGNED NOT NULL COMMENT '商品id', `mer_id` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '商戶id', `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '推薦圖', `images` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '輪播圖', `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '活動標題', `attr` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '活動屬性', `people` int(2) UNSIGNED NOT NULL COMMENT '參團人數', `info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '簡介', `price` decimal(10, 2) UNSIGNED NOT NULL COMMENT '價格', `sort` int(10) UNSIGNED NOT NULL COMMENT '排序', `sales` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '銷量', `stock` int(10) UNSIGNED NOT NULL COMMENT '庫存', `add_time` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '添加時間', `is_host` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '推薦', `is_show` tinyint(1) UNSIGNED NOT NULL COMMENT '商品狀態', `is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0, `combination` tinyint(1) UNSIGNED NOT NULL DEFAULT 1, `mer_use` tinyint(1) UNSIGNED NULL DEFAULT NULL COMMENT '商戶是否可用1可用0不可用', `is_postage` tinyint(1) UNSIGNED NOT NULL COMMENT '是否包郵1是0否', `postage` decimal(10, 2) UNSIGNED NOT NULL COMMENT '郵費', `start_time` int(11) UNSIGNED NOT NULL COMMENT '拼團開始時間', `stop_time` int(11) UNSIGNED NOT NULL COMMENT '拼團結束時間', `effective_time` int(11) NOT NULL DEFAULT 0 COMMENT '拼團訂單有效時間', `cost` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '拼圖商品成本', `browse` int(11) NULL DEFAULT 0 COMMENT '瀏覽量', `unit_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '單位名', `temp_id` int(11) NULL DEFAULT NULL COMMENT '運費模板ID', `weight` decimal(8, 2) NULL DEFAULT 0.00 COMMENT '重量', `volume` decimal(8, 2) NULL DEFAULT 0.00 COMMENT '體積', `num` int(11) NULL DEFAULT NULL COMMENT '單次購買數量', `quota` int(10) NOT NULL DEFAULT 0 COMMENT '限購總數', `quota_show` int(10) NOT NULL DEFAULT 0 COMMENT '限量總數顯示', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '拼團商品表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_store_coupon -- ---------------------------- DROP TABLE IF EXISTS `eb_store_coupon`; CREATE TABLE `eb_store_coupon` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '優惠券表ID', `title` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '優惠券名稱', `integral` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '兌換消耗積分值', `coupon_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '兌換的優惠券面值', `use_min_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '最低消費多少金額可用優惠券', `coupon_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '優惠券有效期限（單位：天）', `sort` int(11) UNSIGNED NOT NULL DEFAULT 1 COMMENT '排序', `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '狀態（0：關閉，1：開啟）', `add_time` int(11) UNSIGNED NOT NULL COMMENT '兌換項目添加時間', `is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否刪除', `product_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '所屬商品id', `category_id` int(11) NOT NULL DEFAULT 0 COMMENT '分類id', `type` tinyint(2) NOT NULL DEFAULT 0 COMMENT '優惠券類型 0-通用 1-品類券 2-商品券', PRIMARY KEY (`id`) USING BTREE, INDEX `state`(`status`) USING BTREE, INDEX `add_time`(`add_time`) USING BTREE, INDEX `coupon_time`(`coupon_time`) USING BTREE, INDEX `is_del`(`is_del`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '優惠券表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_store_coupon_issue -- ---------------------------- DROP TABLE IF EXISTS `eb_store_coupon_issue`; CREATE TABLE `eb_store_coupon_issue` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `cid` int(10) NULL DEFAULT NULL COMMENT '優惠券ID', `coupon_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '優惠券名稱', `start_time` int(10) NULL DEFAULT NULL COMMENT '優惠券領取開啟時間', `end_time` int(10) NULL DEFAULT NULL COMMENT '優惠券領取結束時間', `total_count` int(10) NULL DEFAULT NULL COMMENT '優惠券領取數量', `remain_count` int(10) NULL DEFAULT NULL COMMENT '優惠券剩余領取數量', `is_permanent` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否無限張數', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1 正常 0 未開啟 -1 已無效', `is_give_subscribe` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否首次關注贈送 0-否(默認) 1-是', `is_full_give` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否滿贈0-否(默認) 1-是', `full_reduction` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '消費滿多少贈送優惠券', `is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0, `add_time` int(10) NULL DEFAULT NULL COMMENT '優惠券添加時間', `title` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '優惠券名稱', `integral` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '兌換消耗積分值', `coupon_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '兌換的優惠券面值', `use_min_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '最低消費多少金額可用優惠券', `coupon_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '優惠券有效期限（單位：天）', `product_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '所屬商品id', `category_id` int(11) NOT NULL DEFAULT 0 COMMENT '分類id', `type` tinyint(2) NOT NULL DEFAULT 0 COMMENT '優惠券類型 0-通用 1-品類券 2-商品券', PRIMARY KEY (`id`) USING BTREE, INDEX `cid`(`cid`) USING BTREE, INDEX `start_time`(`start_time`, `end_time`) USING BTREE, INDEX `remain_count`(`remain_count`) USING BTREE, INDEX `status`(`status`) USING BTREE, INDEX `coupon_time`(`coupon_time`) USING BTREE, INDEX `is_del`(`is_del`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '優惠券前臺領取表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_store_coupon_issue_bak -- ---------------------------- DROP TABLE IF EXISTS `eb_store_coupon_issue_bak`; CREATE TABLE `eb_store_coupon_issue_bak` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `cid` int(10) NULL DEFAULT NULL COMMENT '優惠券ID', `coupon_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '優惠券名稱', `start_time` int(10) NULL DEFAULT NULL COMMENT '優惠券領取開啟時間', `end_time` int(10) NULL DEFAULT NULL COMMENT '優惠券領取結束時間', `total_count` int(10) NULL DEFAULT NULL COMMENT '優惠券領取數量', `remain_count` int(10) NULL DEFAULT NULL COMMENT '優惠券剩余領取數量', `is_permanent` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否無限張數', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1 正常 0 未開啟 -1 已無效', `is_give_subscribe` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否首次關注贈送 0-否(默認) 1-是', `is_full_give` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否滿贈0-否(默認) 1-是', `full_reduction` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '消費滿多少贈送優惠券', `is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0, `add_time` int(10) NULL DEFAULT NULL COMMENT '優惠券添加時間', PRIMARY KEY (`id`) USING BTREE, INDEX `cid`(`cid`) USING BTREE, INDEX `start_time`(`start_time`, `end_time`) USING BTREE, INDEX `remain_count`(`remain_count`) USING BTREE, INDEX `status`(`status`) USING BTREE, INDEX `is_del`(`is_del`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '優惠券前臺領取表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_store_coupon_issue_user -- ---------------------------- DROP TABLE IF EXISTS `eb_store_coupon_issue_user`; CREATE TABLE `eb_store_coupon_issue_user` ( `uid` int(10) NULL DEFAULT NULL COMMENT '領取優惠券用戶ID', `issue_coupon_id` int(10) NULL DEFAULT NULL COMMENT '優惠券前臺領取ID', `add_time` int(10) NULL DEFAULT NULL COMMENT '領取時間', UNIQUE INDEX `uid`(`uid`, `issue_coupon_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '優惠券前臺用戶領取記錄表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_store_coupon_product -- ---------------------------- DROP TABLE IF EXISTS `eb_store_coupon_product`; CREATE TABLE `eb_store_coupon_product` ( `coupon_id` int(11) NOT NULL DEFAULT 0 COMMENT '優惠卷模板id', `product_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品id', INDEX `coupon_id`(`coupon_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '優惠卷模板關聯列表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_coupon_user -- ---------------------------- DROP TABLE IF EXISTS `eb_store_coupon_user`; CREATE TABLE `eb_store_coupon_user` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '優惠券發放記錄id', `cid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '兌換的項目id', `uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '優惠券所屬用戶', `coupon_title` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '優惠券名稱', `coupon_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '優惠券的面值', `use_min_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '最低消費多少金額可用優惠券', `add_time` int(11) UNSIGNED NOT NULL COMMENT '優惠券創建時間', `end_time` int(11) UNSIGNED NOT NULL COMMENT '優惠券結束時間', `use_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '使用時間', `type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'send' COMMENT '獲取方式', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '狀態（0：未使用，1：已使用, 2:已過期）', `is_fail` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否有效', PRIMARY KEY (`id`) USING BTREE, INDEX `cid`(`cid`) USING BTREE, INDEX `uid`(`uid`) USING BTREE, INDEX `add_time`(`add_time`) USING BTREE, INDEX `end_time`(`end_time`) USING BTREE, INDEX `status`(`status`) USING BTREE, INDEX `is_fail`(`is_fail`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '優惠券發放記錄表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_store_order -- ---------------------------- DROP TABLE IF EXISTS `eb_store_order`; CREATE TABLE `eb_store_order` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '訂單ID', `order_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '訂單號', `uid` int(11) UNSIGNED NOT NULL COMMENT '用戶id', `real_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用戶姓名', `user_phone` varchar(18) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用戶電話', `user_address` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '詳細地址', `cart_id` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '[]' COMMENT '購物車id', `freight_price` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '運費金額', `total_num` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '訂單商品總數', `total_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '訂單總價', `total_postage` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '郵費', `pay_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '實際支付金額', `pay_postage` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '支付郵費', `deduction_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '抵扣金額', `coupon_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '優惠券id', `coupon_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '優惠券金額', `paid` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '支付狀態', `pay_time` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '支付時間', `pay_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '支付方式', `add_time` int(11) UNSIGNED NOT NULL COMMENT '創建時間', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '訂單狀態（-1 : 申請退款 -2 : 退貨成功 0：待發貨；1：待收貨；2：已收貨；3：待評價；-1：已退款）', `refund_status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '0 未退款 1 申請中 2 已退款', `refund_reason_wap_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '退款圖片', `refund_reason_wap_explain` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '退款用戶說明', `refund_reason_time` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '退款時間', `refund_reason_wap` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '前臺退款原因', `refund_reason` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '不退款的理由', `refund_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '退款金額', `delivery_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '快遞名稱/送貨人姓名', `delivery_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '發貨類型', `delivery_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '快遞單號/手機號', `gain_integral` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '消費賺取積分', `use_integral` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '使用積分', `back_integral` decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT '給用戶退了多少積分', `mark` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '備注', `is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否刪除', `unique` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '唯一id(md5加密)類似id', `remark` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理員備注', `mer_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商戶ID', `is_mer_check` tinyint(3) UNSIGNED NOT NULL DEFAULT 0, `combination_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '拼團商品id0一般商品', `pink_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '拼團id 0沒有拼團', `cost` decimal(8, 2) UNSIGNED NOT NULL COMMENT '成本價', `seckill_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '秒殺商品ID', `bargain_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '砍價id', `verify_code` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '核銷碼', `store_id` int(11) NOT NULL DEFAULT 0 COMMENT '門店id', `shipping_type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '配送方式 1=快遞，2=門店自提', `clerk_id` int(11) NOT NULL DEFAULT 0 COMMENT '店員id', `is_channel` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '支付渠道(0微信公眾號1微信小程序)', `is_remind` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '消息提醒', `is_system_del` tinyint(1) NULL DEFAULT 0 COMMENT '后臺是否刪除', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `order_id_2`(`order_id`, `uid`) USING BTREE, UNIQUE INDEX `unique`(`unique`) USING BTREE, INDEX `uid`(`uid`) USING BTREE, INDEX `add_time`(`add_time`) USING BTREE, INDEX `pay_price`(`pay_price`) USING BTREE, INDEX `paid`(`paid`) USING BTREE, INDEX `pay_time`(`pay_time`) USING BTREE, INDEX `pay_type`(`pay_type`) USING BTREE, INDEX `status`(`status`) USING BTREE, INDEX `is_del`(`is_del`) USING BTREE, INDEX `coupon_id`(`coupon_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '訂單表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_store_order_cart_info -- ---------------------------- DROP TABLE IF EXISTS `eb_store_order_cart_info`; CREATE TABLE `eb_store_order_cart_info` ( `oid` int(11) UNSIGNED NOT NULL COMMENT '訂單id', `cart_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '購物車id', `product_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品ID', `cart_info` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '購買東西的詳細信息', `unique` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '唯一id', UNIQUE INDEX `oid`(`oid`, `unique`) USING BTREE, INDEX `cart_id`(`cart_id`) USING BTREE, INDEX `product_id`(`product_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '訂單購物詳情表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_store_order_status -- ---------------------------- DROP TABLE IF EXISTS `eb_store_order_status`; CREATE TABLE `eb_store_order_status` ( `oid` int(10) UNSIGNED NOT NULL COMMENT '訂單id', `change_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '操作類型', `change_message` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '操作備注', `change_time` int(10) UNSIGNED NOT NULL COMMENT '操作時間', INDEX `oid`(`oid`) USING BTREE, INDEX `change_type`(`change_type`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '訂單操作記錄表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_store_pink -- ---------------------------- DROP TABLE IF EXISTS `eb_store_pink`; CREATE TABLE `eb_store_pink` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uid` int(10) UNSIGNED NOT NULL COMMENT '用戶id', `order_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '訂單id 生成', `order_id_key` int(10) UNSIGNED NOT NULL COMMENT '訂單id 數據庫', `total_num` int(10) UNSIGNED NOT NULL COMMENT '購買商品個數', `total_price` decimal(10, 2) UNSIGNED NOT NULL COMMENT '購買總金額', `cid` int(10) UNSIGNED NOT NULL COMMENT '拼團商品id', `pid` int(10) UNSIGNED NOT NULL COMMENT '商品id', `people` int(10) UNSIGNED NOT NULL COMMENT '拼圖總人數', `price` decimal(10, 2) UNSIGNED NOT NULL COMMENT '拼團商品單價', `add_time` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '開始時間', `stop_time` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `k_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '團長id 0為團長', `is_tpl` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否發送模板消息0未發送1已發送', `is_refund` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否退款 0未退款 1已退款', `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '狀態1進行中2已完成3未完成', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '拼團表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_store_product -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product`; CREATE TABLE `eb_store_product` ( `id` mediumint(11) NOT NULL AUTO_INCREMENT COMMENT '商品id', `mer_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商戶Id(0為總后臺管理員創建,不為0的時候是商戶后臺創建)', `image` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品圖片', `slider_image` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '輪播圖', `store_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品名稱', `store_info` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品簡介', `keyword` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '關鍵字', `bar_code` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品條碼（一維碼）', `cate_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '分類id', `price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '商品價格', `vip_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '會員價格', `ot_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '市場價', `postage` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '郵費', `unit_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '單位名', `sort` smallint(11) NOT NULL DEFAULT 0 COMMENT '排序', `sales` mediumint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '銷量', `stock` mediumint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '庫存', `is_show` tinyint(1) NOT NULL DEFAULT 1 COMMENT '狀態（0：未上架，1：上架）', `is_hot` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否熱賣', `is_benefit` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否優惠', `is_best` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否精品', `is_new` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否新品', `add_time` int(11) UNSIGNED NOT NULL COMMENT '添加時間', `is_postage` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否包郵', `is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否刪除', `mer_use` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商戶是否代理 0不可代理1可代理', `give_integral` decimal(8, 2) UNSIGNED NOT NULL COMMENT '獲得積分', `cost` decimal(8, 2) UNSIGNED NOT NULL COMMENT '成本價', `is_seckill` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '秒殺狀態 0 未開啟 1已開啟', `is_bargain` tinyint(1) UNSIGNED NULL DEFAULT NULL COMMENT '砍價狀態 0未開啟 1開啟', `is_good` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否優品推薦', `is_sub` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否單獨分傭', `ficti` mediumint(11) NULL DEFAULT 100 COMMENT '虛擬銷量', `browse` int(11) NULL DEFAULT 0 COMMENT '瀏覽量', `code_path` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品二維碼地址(用戶小程序海報)', `soure_link` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '淘寶京東1688類型', `video_link` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '主圖視頻鏈接', `temp_id` int(11) NOT NULL DEFAULT 1 COMMENT '運費模板ID', `spec_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '規格 0單 1多', `activity` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '活動顯示排序1=秒殺，2=砍價，3=拼團', `spu` char(13) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', `label_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '標簽ID', PRIMARY KEY (`id`) USING BTREE, INDEX `cate_id`(`cate_id`) USING BTREE, INDEX `is_hot`(`is_hot`) USING BTREE, INDEX `is_benefit`(`is_benefit`) USING BTREE, INDEX `is_best`(`is_best`) USING BTREE, INDEX `is_new`(`is_new`) USING BTREE, INDEX `toggle_on_sale, is_del`(`is_del`) USING BTREE, INDEX `price`(`price`) USING BTREE, INDEX `sort`(`sort`) USING BTREE, INDEX `sales`(`sales`) USING BTREE, INDEX `add_time`(`add_time`) USING BTREE, INDEX `is_postage`(`is_postage`) USING BTREE, INDEX `is_show`(`is_show`, `is_del`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_store_product_attr -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_attr`; CREATE TABLE `eb_store_product_attr` ( `product_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品ID', `attr_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '屬性名', `attr_values` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '屬性值', `type` tinyint(1) NULL DEFAULT 0 COMMENT '活動類型 0=商品，1=秒殺，2=砍價，3=拼團', INDEX `store_id`(`product_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品屬性表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_store_product_attr_result -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_attr_result`; CREATE TABLE `eb_store_product_attr_result` ( `product_id` int(10) UNSIGNED NOT NULL COMMENT '商品ID', `result` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品屬性參數', `change_time` int(10) UNSIGNED NOT NULL COMMENT '上次修改時間', `type` tinyint(1) NULL DEFAULT 0 COMMENT '活動類型 0=商品，1=秒殺，2=砍價，3=拼團', INDEX `product_id`(`product_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品屬性詳情表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_store_product_attr_value -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_attr_value`; CREATE TABLE `eb_store_product_attr_value` ( `product_id` int(10) UNSIGNED NOT NULL COMMENT '商品ID', `suk` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品屬性索引值 (attr_value|attr_value[|....])', `stock` int(10) UNSIGNED NOT NULL COMMENT '屬性對應的庫存', `sales` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '銷量', `price` decimal(8, 2) UNSIGNED NOT NULL COMMENT '屬性金額', `image` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '圖片', `unique` char(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '唯一值', `cost` decimal(8, 2) UNSIGNED NOT NULL COMMENT '成本價', `bar_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品條碼', `ot_price` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '原價', `weight` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '重量', `volume` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '體積', `brokerage` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '一級返傭', `brokerage_two` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '二級返傭', `type` tinyint(1) NULL DEFAULT 0 COMMENT '活動類型 0=商品，1=秒殺，2=砍價，3=拼團', `quota` int(11) NULL DEFAULT NULL COMMENT '活動限購數量', `quota_show` int(11) NULL DEFAULT NULL COMMENT '活動限購數量顯示', INDEX `unique`(`unique`, `suk`) USING BTREE, INDEX `store_id`(`product_id`, `suk`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品屬性值表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_store_product_cate -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_cate`; CREATE TABLE `eb_store_product_cate` ( `id` int(11) NOT NULL AUTO_INCREMENT, `product_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品id', `cate_id` int(11) NOT NULL DEFAULT 0 COMMENT '分類id', `add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加時間', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品分類輔助表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_store_product_coupon -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_coupon`; CREATE TABLE `eb_store_product_coupon` ( `id` int(10) NOT NULL AUTO_INCREMENT, `product_id` int(10) NOT NULL DEFAULT 0 COMMENT '商品id', `issue_coupon_id` int(10) NOT NULL DEFAULT 0 COMMENT '優惠劵id', `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '優惠券名稱', `add_time` int(10) NOT NULL DEFAULT 0 COMMENT '添加時間', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品關聯優惠券' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_product_description -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_description`; CREATE TABLE `eb_store_product_description` ( `product_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品ID', `description` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品詳情', `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '商品類型', INDEX `product_id`(`product_id`, `type`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品詳情表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_store_product_relation -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_relation`; CREATE TABLE `eb_store_product_relation` ( `uid` int(10) UNSIGNED NOT NULL COMMENT '用戶ID', `product_id` int(10) UNSIGNED NOT NULL COMMENT '商品ID', `type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '類型(收藏(collect）、點贊(like))', `category` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '某種類型的商品(普通商品、秒殺商品)', `add_time` int(10) UNSIGNED NOT NULL COMMENT '添加時間', UNIQUE INDEX `uid`(`uid`, `product_id`, `type`, `category`) USING BTREE, INDEX `type`(`type`) USING BTREE, INDEX `category`(`category`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品點贊和收藏表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_store_product_reply -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_reply`; CREATE TABLE `eb_store_product_reply` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '評論ID', `uid` int(11) NOT NULL COMMENT '用戶ID', `oid` int(11) NOT NULL COMMENT '訂單ID', `unique` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '唯一id', `product_id` int(11) NOT NULL COMMENT '商品id', `reply_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'product' COMMENT '某種商品類型(普通商品、秒殺商品）', `product_score` tinyint(1) NOT NULL COMMENT '商品分數', `service_score` tinyint(1) NOT NULL COMMENT '服務分數', `comment` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '評論內容', `pics` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '評論圖片', `add_time` int(11) NOT NULL COMMENT '評論時間', `merchant_reply_content` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理員回復內容', `merchant_reply_time` int(11) NULL DEFAULT NULL COMMENT '管理員回復時間', `is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '0未刪除1已刪除', `is_reply` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0未回復1已回復', `nickname` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用戶名稱', `avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用戶頭像', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `order_id_2`(`oid`, `unique`) USING BTREE, INDEX `add_time`(`add_time`) USING BTREE, INDEX `parent_id`(`reply_type`) USING BTREE, INDEX `is_del`(`is_del`) USING BTREE, INDEX `product_score`(`product_score`) USING BTREE, INDEX `service_score`(`service_score`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '評論表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_store_product_rule -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_rule`; CREATE TABLE `eb_store_product_rule` ( `id` int(10) NOT NULL AUTO_INCREMENT, `rule_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '規格名稱', `rule_value` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '規格值', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品規則值(規格)表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_store_seckill -- ---------------------------- DROP TABLE IF EXISTS `eb_store_seckill`; CREATE TABLE `eb_store_seckill` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '商品秒殺商品表id', `product_id` int(10) UNSIGNED NOT NULL COMMENT '商品id', `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '推薦圖', `images` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '輪播圖', `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '活動標題', `info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '簡介', `price` decimal(10, 2) UNSIGNED NOT NULL COMMENT '價格', `cost` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '成本', `ot_price` decimal(10, 2) UNSIGNED NOT NULL COMMENT '原價', `give_integral` decimal(10, 2) UNSIGNED NOT NULL COMMENT '返多少積分', `sort` int(10) UNSIGNED NOT NULL COMMENT '排序', `stock` int(10) UNSIGNED NOT NULL COMMENT '庫存', `sales` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '銷量', `unit_name` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '單位名', `postage` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '郵費', `description` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '內容', `start_time` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '開始時間', `stop_time` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '結束時間', `add_time` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '添加時間', `status` tinyint(1) UNSIGNED NOT NULL COMMENT '商品狀態', `is_postage` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否包郵', `is_hot` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '熱門推薦', `is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '刪除 0未刪除1已刪除', `num` int(11) UNSIGNED NOT NULL COMMENT '最多秒殺幾個', `is_show` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '顯示', `time_id` int(11) NULL DEFAULT NULL COMMENT '時間段ID', `temp_id` int(11) NULL DEFAULT NULL COMMENT '運費模板ID', `weight` decimal(8, 2) NULL DEFAULT 0.00 COMMENT '商品重量', `volume` decimal(8, 2) NULL DEFAULT 0.00 COMMENT '商品體積', `quota` int(10) NOT NULL DEFAULT 0 COMMENT '限購總數', `quota_show` int(10) NOT NULL DEFAULT 0 COMMENT '限購總數顯示', PRIMARY KEY (`id`) USING BTREE, INDEX `product_id`(`product_id`) USING BTREE, INDEX `start_time`(`start_time`, `stop_time`) USING BTREE, INDEX `is_del`(`is_del`) USING BTREE, INDEX `is_hot`(`is_hot`) USING BTREE, INDEX `is_show`(`status`) USING BTREE, INDEX `add_time`(`add_time`) USING BTREE, INDEX `sort`(`sort`) USING BTREE, INDEX `is_postage`(`is_postage`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品秒殺商品表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_store_seckill_time -- ---------------------------- DROP TABLE IF EXISTS `eb_store_seckill_time`; CREATE TABLE `eb_store_seckill_time` ( `seckill_id` int(10) NOT NULL DEFAULT 0 COMMENT '秒殺活動ID', `time_id` int(10) NOT NULL DEFAULT 0 COMMENT '秒殺時間段ID' ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '秒殺時段表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_store_service -- ---------------------------- DROP TABLE IF EXISTS `eb_store_service`; CREATE TABLE `eb_store_service` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '客服id', `mer_id` int(11) NOT NULL DEFAULT 0 COMMENT '商戶id', `uid` int(11) NOT NULL COMMENT '客服uid', `avatar` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '客服頭像', `nickname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '代理名稱', `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '客服手機號', `add_time` int(11) NOT NULL COMMENT '添加時間', `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '0隱藏1顯示', `notify` int(2) NULL DEFAULT 0 COMMENT '訂單通知1開啟0關閉', `customer` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否展示統計管理', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客服表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_store_service_log -- ---------------------------- DROP TABLE IF EXISTS `eb_store_service_log`; CREATE TABLE `eb_store_service_log` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '客服用戶對話記錄表ID', `mer_id` int(11) NOT NULL DEFAULT 0 COMMENT '商戶id', `msn` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '消息內容', `uid` int(11) NOT NULL COMMENT '發送人uid', `to_uid` int(11) NOT NULL COMMENT '接收人uid', `add_time` int(11) NOT NULL COMMENT '發送時間', `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已讀（0：否；1：是；）', `remind` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否提醒過', `msn_type` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '消息類型 1=文字 2=表情 3=圖片 4=語音', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客服用戶對話記錄表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_store_visit -- ---------------------------- DROP TABLE IF EXISTS `eb_store_visit`; CREATE TABLE `eb_store_visit` ( `id` int(10) NOT NULL AUTO_INCREMENT, `product_id` int(11) NULL DEFAULT NULL COMMENT '商品ID', `product_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品類型', `cate_id` int(11) NULL DEFAULT NULL COMMENT '商品分類ID', `type` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品類型', `uid` int(11) NULL DEFAULT NULL COMMENT '用戶ID', `count` int(11) NULL DEFAULT NULL COMMENT '訪問次數', `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '備注描述', `add_time` int(11) NULL DEFAULT NULL COMMENT '添加時間', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品瀏覽分析表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_system_admin -- ---------------------------- DROP TABLE IF EXISTS `eb_system_admin`; CREATE TABLE `eb_system_admin` ( `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '后臺管理員表ID', `account` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '后臺管理員賬號', `head_pic` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', `pwd` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '后臺管理員密碼', `real_name` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '后臺管理員姓名', `roles` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '后臺管理員權限(menus_id)', `last_ip` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '后臺管理員最后一次登錄ip', `last_time` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '后臺管理員最后一次登錄時間', `add_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '后臺管理員添加時間', `login_count` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '登錄次數', `level` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '后臺管理員級別', `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '后臺管理員狀態 1有效0無效', `is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE, INDEX `account`(`account`) USING BTREE, INDEX `status`(`status`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '后臺管理員表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_system_attachment -- ---------------------------- DROP TABLE IF EXISTS `eb_system_attachment`; CREATE TABLE `eb_system_attachment` ( `att_id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '附件名稱', `att_dir` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '附件路徑', `satt_dir` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '壓縮圖片路徑', `att_size` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '附件大小', `att_type` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '附件類型', `pid` int(10) NOT NULL DEFAULT 0 COMMENT '分類ID0編輯器,1商品圖片,2拼團圖片,3砍價圖片,4秒殺圖片,5文章圖片,6組合數據圖', `time` int(11) NOT NULL DEFAULT 0 COMMENT '上傳時間', `image_type` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '圖片上傳類型 1本地 2七牛云 3OSS 4COS ', `module_type` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '圖片上傳模塊類型 1 后臺上傳 2 用戶生成', PRIMARY KEY (`att_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '附件管理表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_system_attachment_category -- ---------------------------- DROP TABLE IF EXISTS `eb_system_attachment_category`; CREATE TABLE `eb_system_attachment_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `pid` int(11) NULL DEFAULT 0 COMMENT '父級ID', `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分類名稱', `enname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分類目錄', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `id`(`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '附件分類表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_system_city -- ---------------------------- DROP TABLE IF EXISTS `eb_system_city`; CREATE TABLE `eb_system_city` ( `id` int(11) NOT NULL AUTO_INCREMENT, `city_id` int(11) NOT NULL DEFAULT 0 COMMENT '城市id', `level` int(11) NOT NULL DEFAULT 0 COMMENT '省市級別', `parent_id` int(11) NOT NULL DEFAULT 0 COMMENT '父級id', `area_code` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '區號', `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '名稱', `merger_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '合并名稱', `lng` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '經度', `lat` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '緯度', `is_show` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否展示', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3975 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '城市表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_system_config -- ---------------------------- DROP TABLE IF EXISTS `eb_system_config`; CREATE TABLE `eb_system_config` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '配置id', `menu_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字段名稱', `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '類型(文本框,單選按鈕...)', `input_type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'input' COMMENT '表單類型', `config_tab_id` int(10) UNSIGNED NOT NULL COMMENT '配置分類id', `parameter` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '規則單選框和多選框', `upload_type` tinyint(1) UNSIGNED NULL DEFAULT NULL COMMENT '上傳文件格式1單圖2多圖3文件', `required` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '規則', `width` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '多行文本框的寬度', `high` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '多行文框的高度', `value` varchar(5000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '默認值', `info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '配置名稱', `desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '配置簡介', `sort` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序', `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否隱藏', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 193 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '配置表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_system_config_tab -- ---------------------------- DROP TABLE IF EXISTS `eb_system_config_tab`; CREATE TABLE `eb_system_config_tab` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '配置分類id', `pid` int(11) NOT NULL DEFAULT 0 COMMENT '上級分類id', `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '配置分類名稱', `eng_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '配置分類英文名稱', `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '配置分類狀態', `info` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '配置分類是否顯示', `icon` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '圖標', `type` int(2) NULL DEFAULT 0 COMMENT '配置類型', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 38 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '配置分類表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_system_file -- ---------------------------- DROP TABLE IF EXISTS `eb_system_file`; CREATE TABLE `eb_system_file` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '文件對比ID', `cthash` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '文件內容', `filename` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '文價名稱', `atime` char(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '上次訪問時間', `mtime` char(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '上次修改時間', `ctime` char(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '上次改變時間', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 537 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '文件對比表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_system_group -- ---------------------------- DROP TABLE IF EXISTS `eb_system_group`; CREATE TABLE `eb_system_group` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '組合數據ID', `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '數據組名稱', `info` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '數據提示', `config_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '數據字段', `fields` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '數據組字段以及類型（json數據）', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `config_name`(`config_name`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 73 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '組合數據表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_system_group_data -- ---------------------------- DROP TABLE IF EXISTS `eb_system_group_data`; CREATE TABLE `eb_system_group_data` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '組合數據詳情ID', `gid` int(11) NOT NULL DEFAULT 0 COMMENT '對應的數據組id', `value` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '數據組對應的數據值（json數據）', `add_time` int(10) NOT NULL DEFAULT 0 COMMENT '添加數據時間', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '數據排序', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '狀態（1：開啟；2：關閉；）', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 209 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '組合數據詳情表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_system_log -- ---------------------------- DROP TABLE IF EXISTS `eb_system_log`; CREATE TABLE `eb_system_log` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '管理員操作記錄ID', `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '管理員id', `admin_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '管理員姓名', `path` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '鏈接', `page` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '行為', `method` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '訪問類型', `ip` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '登錄IP', `type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '類型', `add_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '操作時間', `merchant_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商戶id', PRIMARY KEY (`id`) USING BTREE, INDEX `admin_id`(`admin_id`) USING BTREE, INDEX `add_time`(`add_time`) USING BTREE, INDEX `type`(`type`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1129 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '管理員操作記錄表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_system_menus -- ---------------------------- DROP TABLE IF EXISTS `eb_system_menus`; CREATE TABLE `eb_system_menus` ( `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '菜單ID', `pid` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT '父級id', `icon` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '圖標', `menu_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '按鈕名', `module` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '模塊名', `controller` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '控制器', `action` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '方法名', `api_url` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'api接口地址', `methods` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '提交方式POST GET PUT DELETE', `params` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '[]' COMMENT '參數', `sort` tinyint(3) NOT NULL DEFAULT 1 COMMENT '排序', `is_show` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否為隱藏菜單0=隱藏菜單,1=顯示菜單', `is_show_path` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否為隱藏菜單供前臺使用', `access` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '子管理員是否可用', `menu_path` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '路由名稱前端使用', `auth_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否為菜單 1菜單 2功能', `header` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '頂部菜單標示', `is_header` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否頂部菜單1是0否', `unique_auth` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '前臺唯一標識', `is_del` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否刪除', PRIMARY KEY (`id`) USING BTREE, INDEX `pid`(`pid`) USING BTREE, INDEX `is_show`(`is_show`) USING BTREE, INDEX `access`(`access`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 659 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '菜單表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_system_notice -- ---------------------------- DROP TABLE IF EXISTS `eb_system_notice`; CREATE TABLE `eb_system_notice` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '通知模板id', `title` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '通知標題', `type` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '通知類型', `icon` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '圖標', `url` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '鏈接', `table_title` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '通知數據', `template` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '通知模板', `push_admin` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '通知管理員id', `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '狀態', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `type`(`type`) USING BTREE, INDEX `status`(`status`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '通知模板表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_system_notice_admin -- ---------------------------- DROP TABLE IF EXISTS `eb_system_notice_admin`; CREATE TABLE `eb_system_notice_admin` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '通知記錄ID', `notice_type` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '通知類型', `admin_id` smallint(5) UNSIGNED NOT NULL COMMENT '通知的管理員', `link_id` int(10) UNSIGNED NOT NULL COMMENT '關聯ID', `table_data` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '通知的數據', `is_click` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '點擊次數', `is_visit` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '訪問次數', `visit_time` int(11) NOT NULL COMMENT '訪問時間', `add_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '通知時間', PRIMARY KEY (`id`) USING BTREE, INDEX `admin_id`(`admin_id`, `notice_type`) USING BTREE, INDEX `add_time`(`add_time`) USING BTREE, INDEX `is_visit`(`is_visit`) USING BTREE, INDEX `is_click`(`is_click`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '通知記錄表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_system_role -- ---------------------------- DROP TABLE IF EXISTS `eb_system_role`; CREATE TABLE `eb_system_role` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '身份管理id', `role_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '身份管理名稱', `rules` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '身份管理權限(menus_id)', `level` tinyint(3) UNSIGNED NOT NULL DEFAULT 0, `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '狀態', PRIMARY KEY (`id`) USING BTREE, INDEX `status`(`status`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '身份管理表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_system_store -- ---------------------------- DROP TABLE IF EXISTS `eb_system_store`; CREATE TABLE `eb_system_store` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '門店名稱', `introduction` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '簡介', `phone` char(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '手機號碼', `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '省市區', `detailed_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '詳細地址', `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '門店logo', `latitude` char(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '緯度', `longitude` char(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '經度', `valid_time` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '核銷有效日期', `day_time` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '每日營業開關時間', `add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加時間', `is_show` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否顯示', `is_del` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否刪除', PRIMARY KEY (`id`) USING BTREE, INDEX `phone`(`phone`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '門店自提' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_system_store_staff -- ---------------------------- DROP TABLE IF EXISTS `eb_system_store_staff`; CREATE TABLE `eb_system_store_staff` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `uid` int(10) UNSIGNED NOT NULL COMMENT '微信用戶id', `avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '店員頭像', `store_id` int(11) NOT NULL COMMENT '門店id', `staff_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '店員名稱', `phone` char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手機號碼', `verify_status` tinyint(2) NOT NULL DEFAULT 0 COMMENT '核銷開關', `status` tinyint(2) NULL DEFAULT 1 COMMENT '狀態', `add_time` int(10) NULL DEFAULT NULL COMMENT '添加時間', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '門店店員表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_system_user_level -- ---------------------------- DROP TABLE IF EXISTS `eb_system_user_level`; CREATE TABLE `eb_system_user_level` ( `id` int(11) NOT NULL AUTO_INCREMENT, `mer_id` int(11) NOT NULL DEFAULT 0 COMMENT '商戶id', `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '會員名稱', `money` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '購買金額', `valid_date` int(11) NOT NULL DEFAULT 0 COMMENT '有效時間', `is_forever` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否為永久會員', `is_pay` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否購買,1=購買,0=不購買', `is_show` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否顯示 1=顯示,0=隱藏', `grade` int(11) NOT NULL DEFAULT 0 COMMENT '會員等級', `discount` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '享受折扣', `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '會員卡背景', `icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '會員圖標', `explain` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '說明', `add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加時間', `is_del` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否刪除.1=刪除,0=未刪除', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '設置用戶等級表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_system_user_task -- ---------------------------- DROP TABLE IF EXISTS `eb_system_user_task`; CREATE TABLE `eb_system_user_task` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '任務名稱', `real_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '配置原名', `task_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '任務類型', `number` int(11) NOT NULL DEFAULT 0 COMMENT '限定數', `level_id` int(11) NOT NULL DEFAULT 0 COMMENT '等級id', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序', `is_show` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否顯示', `is_must` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否務必達成任務,1務必達成,0=滿足其一', `illustrate` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '任務說明', `add_time` int(11) NOT NULL DEFAULT 0 COMMENT '新增時間', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 30 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '等級任務設置' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_template_message -- ---------------------------- DROP TABLE IF EXISTS `eb_template_message`; CREATE TABLE `eb_template_message` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '模板id', `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0=訂閱消息,1=微信模板消息', `tempkey` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模板編號', `name` char(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模板名', `content` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '回復內容', `tempid` char(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板ID', `add_time` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '添加時間', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '狀態', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 29 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '微信模板' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_user -- ---------------------------- DROP TABLE IF EXISTS `eb_user`; CREATE TABLE `eb_user` ( `uid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用戶id', `account` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用戶賬號', `pwd` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用戶密碼', `real_name` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '真實姓名', `birthday` int(11) NOT NULL DEFAULT 0 COMMENT '生日', `card_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '身份證號碼', `mark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用戶備注', `partner_id` int(11) NOT NULL DEFAULT 0 COMMENT '合伙人id', `group_id` int(11) NOT NULL DEFAULT 0 COMMENT '用戶分組id', `nickname` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用戶昵稱', `avatar` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用戶頭像', `phone` char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手機號碼', `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間', `add_ip` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '添加ip', `last_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最后一次登錄時間', `last_ip` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '最后一次登錄ip', `now_money` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '用戶余額', `brokerage_price` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '傭金金額', `integral` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '用戶剩余積分', `sign_num` int(11) NOT NULL DEFAULT 0 COMMENT '連續簽到天數', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1為正常，0為禁止', `level` tinyint(2) UNSIGNED NOT NULL DEFAULT 0 COMMENT '等級', `spread_uid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '推廣元id', `spread_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '推廣員關聯時間', `user_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用戶類型', `is_promoter` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否為推廣員', `pay_count` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '用戶購買次數', `spread_count` int(11) NULL DEFAULT 0 COMMENT '下級人數', `clean_time` int(11) NULL DEFAULT 0 COMMENT '清理會員時間', `addres` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '詳細地址', `adminid` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '管理員編號 ', `login_type` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用戶登陸類型，h5,wechat,routine', PRIMARY KEY (`uid`) USING BTREE, INDEX `account`(`account`) USING BTREE, INDEX `spreaduid`(`spread_uid`) USING BTREE, INDEX `level`(`level`) USING BTREE, INDEX `status`(`status`) USING BTREE, INDEX `is_promoter`(`is_promoter`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用戶表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_user_address -- ---------------------------- DROP TABLE IF EXISTS `eb_user_address`; CREATE TABLE `eb_user_address` ( `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用戶地址id', `uid` int(10) UNSIGNED NOT NULL COMMENT '用戶id', `real_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '收貨人姓名', `phone` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '收貨人電話', `province` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '收貨人所在省', `city` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '收貨人所在市', `city_id` int(11) NOT NULL DEFAULT 0 COMMENT '城市id', `district` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '收貨人所在區', `detail` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '收貨人詳細地址', `post_code` int(10) UNSIGNED NOT NULL COMMENT '郵編', `longitude` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '經度', `latitude` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '緯度', `is_default` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否默認', `is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否刪除', `add_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間', PRIMARY KEY (`id`) USING BTREE, INDEX `uid`(`uid`) USING BTREE, INDEX `is_default`(`is_default`) USING BTREE, INDEX `is_del`(`is_del`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用戶地址表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_user_bill -- ---------------------------- DROP TABLE IF EXISTS `eb_user_bill`; CREATE TABLE `eb_user_bill` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用戶賬單id', `uid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用戶uid', `link_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '關聯id', `pm` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '0 = 支出 1 = 獲得', `title` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '賬單標題', `category` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '明細種類', `type` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '明細類型', `number` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '明細數字', `balance` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '剩余', `mark` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '備注', `add_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '0 = 帶確定 1 = 有效 -1 = 無效', `take` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0 = 未收貨 1 = 已收貨', PRIMARY KEY (`id`) USING BTREE, INDEX `openid`(`uid`) USING BTREE, INDEX `status`(`status`) USING BTREE, INDEX `add_time`(`add_time`) USING BTREE, INDEX `pm`(`pm`) USING BTREE, INDEX `type`(`category`, `type`, `link_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用戶賬單表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_user_enter -- ---------------------------- DROP TABLE IF EXISTS `eb_user_enter`; CREATE TABLE `eb_user_enter` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '商戶申請ID', `uid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用戶ID', `province` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商戶所在省', `city` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商戶所在市', `district` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商戶所在區', `address` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商戶詳細地址', `merchant_name` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商戶名稱', `link_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', `link_tel` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商戶電話', `charter` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商戶證書', `add_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時間', `apply_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '審核時間', `success_time` int(11) NOT NULL COMMENT '通過時間', `fail_message` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '未通過原因', `fail_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '未通過時間', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '-1 審核未通過 0未審核 1審核通過', `is_lock` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '0 = 開啟 1= 關閉', `is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否刪除', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uid`(`uid`) USING BTREE, INDEX `province`(`province`, `city`, `district`) USING BTREE, INDEX `is_lock`(`is_lock`) USING BTREE, INDEX `is_del`(`is_del`) USING BTREE, INDEX `status`(`status`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商戶申請表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_user_extract -- ---------------------------- DROP TABLE IF EXISTS `eb_user_extract`; CREATE TABLE `eb_user_extract` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uid` int(10) UNSIGNED NULL DEFAULT NULL, `real_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名稱', `extract_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'bank' COMMENT 'bank = 銀行卡 alipay = 支付寶wx=微信', `bank_code` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '銀行卡', `bank_address` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '開戶地址', `alipay_code` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '支付寶賬號', `extract_price` decimal(8, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '提現金額', `mark` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `balance` decimal(8, 2) UNSIGNED NULL DEFAULT 0.00, `fail_msg` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '無效原因', `fail_time` int(10) UNSIGNED NULL DEFAULT NULL, `add_time` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '添加時間', `status` tinyint(2) NULL DEFAULT 0 COMMENT '-1 未通過 0 審核中 1 已提現', `wechat` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微信號', PRIMARY KEY (`id`) USING BTREE, INDEX `extract_type`(`extract_type`) USING BTREE, INDEX `status`(`status`) USING BTREE, INDEX `add_time`(`add_time`) USING BTREE, INDEX `openid`(`uid`) USING BTREE, INDEX `fail_time`(`fail_time`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用戶提現表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_user_group -- ---------------------------- DROP TABLE IF EXISTS `eb_user_group`; CREATE TABLE `eb_user_group` ( `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, `group_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用戶分組名稱', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用戶分組表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_user_label -- ---------------------------- DROP TABLE IF EXISTS `eb_user_label`; CREATE TABLE `eb_user_label` ( `id` int(11) NOT NULL AUTO_INCREMENT, `label_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '標簽名稱', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用戶標簽表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_user_label_relation -- ---------------------------- DROP TABLE IF EXISTS `eb_user_label_relation`; CREATE TABLE `eb_user_label_relation` ( `uid` int(11) NOT NULL DEFAULT 0 COMMENT '用戶ID', `label_id` int(11) NOT NULL DEFAULT 0 COMMENT '標簽ID' ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用戶標簽關聯表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_user_level -- ---------------------------- DROP TABLE IF EXISTS `eb_user_level`; CREATE TABLE `eb_user_level` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL DEFAULT 0 COMMENT '用戶uid', `level_id` int(11) NOT NULL DEFAULT 0 COMMENT '等級vip', `grade` int(11) NOT NULL DEFAULT 0 COMMENT '會員等級', `valid_time` int(11) NOT NULL DEFAULT 0 COMMENT '過期時間', `is_forever` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否永久', `mer_id` int(11) NOT NULL DEFAULT 0 COMMENT '商戶id', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0:禁止,1:正常', `mark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '備注', `remind` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已通知', `is_del` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否刪除,0=未刪除,1=刪除', `add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加時間', `discount` int(11) NOT NULL DEFAULT 0 COMMENT '享受折扣', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `id`(`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用戶等級記錄表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_user_notice -- ---------------------------- DROP TABLE IF EXISTS `eb_user_notice`; CREATE TABLE `eb_user_notice` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '接收消息的用戶id（類型：json數據）', `type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '消息通知類型（1：系統消息；2：用戶通知）', `user` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '發送人', `title` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '通知消息的標題信息', `content` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '通知消息的內容', `add_time` int(11) NOT NULL DEFAULT 0 COMMENT '通知消息發送的時間', `is_send` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否發送（0：未發送；1：已發送）', `send_time` int(11) NOT NULL COMMENT '發送時間', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用戶通知表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_user_notice_see -- ---------------------------- DROP TABLE IF EXISTS `eb_user_notice_see`; CREATE TABLE `eb_user_notice_see` ( `id` int(11) NOT NULL AUTO_INCREMENT, `nid` int(11) NOT NULL DEFAULT 0 COMMENT '查看的通知id', `uid` int(11) NOT NULL DEFAULT 0 COMMENT '查看通知的用戶id', `add_time` int(11) NOT NULL DEFAULT 0 COMMENT '查看通知的時間', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用戶通知發送記錄表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_user_recharge -- ---------------------------- DROP TABLE IF EXISTS `eb_user_recharge`; CREATE TABLE `eb_user_recharge` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uid` int(10) NULL DEFAULT NULL COMMENT '充值用戶UID', `order_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '訂單號', `price` decimal(8, 2) NULL DEFAULT NULL COMMENT '充值金額', `give_price` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '購買贈送金額', `recharge_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '充值類型', `paid` tinyint(1) NULL DEFAULT NULL COMMENT '是否充值', `pay_time` int(10) NULL DEFAULT NULL COMMENT '充值支付時間', `add_time` int(12) NULL DEFAULT NULL COMMENT '充值時間', `refund_price` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '退款金額', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `order_id`(`order_id`) USING BTREE, INDEX `uid`(`uid`) USING BTREE, INDEX `recharge_type`(`recharge_type`) USING BTREE, INDEX `paid`(`paid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用戶充值表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_user_sign -- ---------------------------- DROP TABLE IF EXISTS `eb_user_sign`; CREATE TABLE `eb_user_sign` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL DEFAULT 0 COMMENT '用戶uid', `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '簽到說明', `number` int(11) NOT NULL DEFAULT 0 COMMENT '獲得積分', `balance` int(11) NOT NULL DEFAULT 0 COMMENT '剩余積分', `add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加時間', PRIMARY KEY (`id`) USING BTREE, INDEX `uid`(`uid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '簽到記錄表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_user_task_finish -- ---------------------------- DROP TABLE IF EXISTS `eb_user_task_finish`; CREATE TABLE `eb_user_task_finish` ( `id` int(11) NOT NULL AUTO_INCREMENT, `task_id` int(11) NOT NULL DEFAULT 0 COMMENT '任務id', `uid` int(11) NOT NULL DEFAULT 0 COMMENT '用戶id', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否有效', `add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加時間', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `id`(`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用戶任務完成記錄表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_user_visit -- ---------------------------- DROP TABLE IF EXISTS `eb_user_visit`; CREATE TABLE `eb_user_visit` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL COMMENT '用戶uid', `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '訪問路徑', `ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用戶ip', `stay_time` int(11) NOT NULL DEFAULT 0 COMMENT '頁面停留時間(秒)', `add_time` int(11) NOT NULL DEFAULT 0 COMMENT '訪問時間', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 112 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用戶訪問表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_wechat_key -- ---------------------------- DROP TABLE IF EXISTS `eb_wechat_key`; CREATE TABLE `eb_wechat_key` ( `id` mediumint(8) NOT NULL AUTO_INCREMENT, `reply_id` mediumint(8) NOT NULL COMMENT '回復內容id', `keys` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '關鍵詞', PRIMARY KEY (`id`) USING BTREE ) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '微信回復關鍵詞輔助表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_wechat_media -- ---------------------------- DROP TABLE IF EXISTS `eb_wechat_media`; CREATE TABLE `eb_wechat_media` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '微信視頻音頻id', `type` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '回復類型', `path` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '文件路徑', `media_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '微信服務器返回的id', `url` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '地址', `temporary` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否永久或者臨時 0永久1臨時', `add_time` int(10) UNSIGNED NOT NULL COMMENT '添加時間', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `type`(`type`, `media_id`) USING BTREE, INDEX `type_2`(`type`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '微信回復表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_wechat_message -- ---------------------------- DROP TABLE IF EXISTS `eb_wechat_message`; CREATE TABLE `eb_wechat_message` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用戶行為記錄id', `openid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用戶openid', `type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '操作類型', `result` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '操作詳細記錄', `add_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '操作時間', PRIMARY KEY (`id`) USING BTREE, INDEX `openid`(`openid`) USING BTREE, INDEX `type`(`type`) USING BTREE, INDEX `add_time`(`add_time`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用戶行為記錄表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_wechat_news_category -- ---------------------------- DROP TABLE IF EXISTS `eb_wechat_news_category`; CREATE TABLE `eb_wechat_news_category` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '圖文消息管理ID', `cate_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '圖文名稱', `sort` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序', `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '狀態', `new_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '文章id', `add_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '添加時間', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '圖文消息管理表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_wechat_reply -- ---------------------------- DROP TABLE IF EXISTS `eb_wechat_reply`; CREATE TABLE `eb_wechat_reply` ( `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '微信關鍵字回復id', `type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '回復類型', `data` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '回復數據', `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '0=不可用 1 =可用', `hide` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否隱藏', PRIMARY KEY (`id`) USING BTREE, INDEX `type`(`type`) USING BTREE, INDEX `status`(`status`) USING BTREE, INDEX `hide`(`hide`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '微信關鍵字回復表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for eb_wechat_user -- ---------------------------- DROP TABLE IF EXISTS `eb_wechat_user`; CREATE TABLE `eb_wechat_user` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主鍵ID', `uid` int(10) NOT NULL COMMENT '微信用戶id', `unionid` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '只有在用戶將公眾號綁定到微信開放平臺帳號后，才會出現該字段', `openid` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用戶的標識，對當前公眾號唯一', `routine_openid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '小程序唯一身份ID', `nickname` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用戶的昵稱', `headimgurl` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用戶頭像', `sex` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用戶的性別，值為1時是男性，值為2時是女性，值為0時是未知', `city` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用戶所在城市', `language` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用戶的語言，簡體中文為zh_CN', `province` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用戶所在省份', `country` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用戶所在國家', `remark` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公眾號運營者對粉絲的備注，公眾號運營者可在微信公眾平臺用戶管理界面對粉絲添加備注', `groupid` smallint(5) UNSIGNED NULL DEFAULT 0 COMMENT '用戶所在的分組ID（兼容舊的用戶分組接口）', `tagid_list` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用戶被打上的標簽ID列表', `subscribe` tinyint(3) UNSIGNED NULL DEFAULT 1 COMMENT '用戶是否訂閱該公眾號標識', `subscribe_time` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '關注公眾號時間', `add_time` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '添加時間', `stair` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '一級推薦人', `second` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '二級推薦人', `order_stair` int(11) NULL DEFAULT NULL COMMENT '一級推薦人訂單', `order_second` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '二級推薦人訂單', `now_money` decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT '傭金', `session_key` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '小程序用戶會話密匙', `user_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'wechat' COMMENT '用戶類型', PRIMARY KEY (`id`) USING BTREE, INDEX `groupid`(`groupid`) USING BTREE, INDEX `subscribe_time`(`subscribe_time`) USING BTREE, INDEX `add_time`(`add_time`) USING BTREE, INDEX `subscribe`(`subscribe`) USING BTREE, INDEX `unionid`(`unionid`) USING BTREE, INDEX `openid`(`openid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '微信用戶表' ROW_FORMAT = Compact;