# 數據字典
```[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;
- 序言
- 系統簡介
- 系統介紹
- 前端腦圖
- 項目介紹
- 程序源碼安裝
- 運行環境
- 服務器及域名準備
- 服務器購買
- 服務器配置端口
- 域名購買
- 域名解析
- SSL證書申請
- 證書申請注意事項
- 寶塔申請SSL
- 阿里云申請SSL
- 騰訊云申請SSL
- https域名配置
- 新手推薦-寶塔環境安裝
- 【視頻安裝教程】
- 1.服務器配置
- 阿里云平臺
- 騰訊云平臺
- 2.登錄寶塔
- 3.環境配置
- 安裝軟件
- 數據庫配置
- PHP配置
- 4.源碼安裝
- 5.程序一鍵安裝
- 6.寶塔啟動命令
- 消息隊列
- 長連接
- 定時任務
- window+phpstudy8安裝
- 安裝前配置
- 安裝系統
- windows下的站點配置
- window啟動命令
- 消息隊列
- 長連接
- 定時任務
- Linux環境安裝
- Linux啟動命令
- 消息隊列
- Linux命令行開啟長連接
- 開啟定時任務
- 手動安裝
- 配置檢查
- 安裝常見問題
- mysql修改sql_mode
- 后臺空白
- 驗證碼不顯示
- 程序配置
- 應用配置
- 公眾號配置
- 公眾號配置
- 公眾號開發配置
- 公眾號菜單
- 設置公眾號菜單
- 關鍵字
- 跳轉網頁
- 跳轉小程序
- 小程序配置
- 1.微信平臺配置
- 2.CRMEB后臺配置
- 3.打包上傳
- 前端提交審核(4.3.1之前版本)
- 前端提交審核(4.3.1及以后版本)
- 4.確認發布
- PC端
- PC安裝
- PC設置
- PC端微信掃碼登錄配置
- 支付配置
- 微信支付
- 支付寶支付
- 客服配置
- 標準版客服配置
- 客服配置詳解
- 舊版本客服配置
- 公眾號客服
- 小程序客服
- 客服配置(4.3.1及以后版本)
- 反向代理
- Nginx反向代理
- Apache反向代理
- 一號通
- 一號通賬號
- 短信
- 商品采集
- 物流配置
- 電子面單
- 其他配置
- 公眾號模板消息
- 小程序訂閱消息
- 小程序直播配置
- 小票打印配置
- 付費采集
- 用戶賬號多端同步
- 圖標logo更換(4.3.1以上版本)
- 云存儲配置
- 存儲說明
- 阿里云OSS
- 騰訊云COS
- 七牛云存儲
- 消息管理
- 通知會員
- 微信模板消息
- 微信小程序提醒
- 通知平臺
- 系統通知
- 企業微信通知
- 功能說明
- 頁面跳轉鏈接
- 普通產品
- 發布商品
- 商品規格
- 商品評價
- 前臺頁面
- 設置商品口令
- 虛擬商品
- 商品分類
- 分類說明
- 分類管理
- 訂單管理
- 后臺訂單處理
- 前端訂單處理
- 訂單退款
- 訂單打印
- 客服訂單提醒
- 二維碼收銀訂單
- 訂單配送
- 訂單拆單發貨(4.3+)
- 訂單拆單退款(4.3+)
- 用戶管理
- 賬戶管理
- 賬號信息
- 賬戶資金
- 會員
- 用戶等級
- 付費會員
- 分銷規則
- 分銷配置
- 關于分銷
- 提現
- 傭金提現
- 提現規則
- 發起提現
- 后臺審核
- 分銷員管理
- 分銷規則說明
- 分銷等級
- 客服管理
- 客服添加
- 客服工作臺
- 營銷管理
- 優惠券
- 優惠券模板
- 發布優惠券
- 領取及使用
- 砍價
- 砍價規則
- 新建砍價活動
- 拼團
- 拼團規則
- 新建拼團活動
- 秒殺
- 秒殺規則
- 新建秒殺活動
- 積分
- 積分商城(4.3+)
- 積分商城介紹
- 創建積分商品
- 積分設置
- 積分來源
- 積分使用
- 小程序直播
- 開啟直播
- 直播使用說明
- 直播間管理
- 九宮格抽獎(4.3+)
- 抽獎規則
- 創建抽獎活動
- 全款預售(4.3+)
- 預售說明
- 添加預售商品
- 新聞資訊
- 新聞頁面
- 發布資訊
- 郵費說明
- 郵費組成
- 商城運費設置
- 運費模板
- 門店自提
- 開啟門店自提
- 門店及店員管理
- 訂單核銷說明
- 庫存說明
- 前端說明
- 首頁
- 分類頁
- 個人中心
- 頁面管理(4.3+)
- 頁面設計
- 數據配置
- 主題風格
- PC商城
- 常見問題
- 客服消息發送失敗
- 公眾號重復無限刷新登陸
- 配置了小程序訂閱消息不生效
- windows下點擊workerman.bat文件閃退
- 多項目部署Socket鏈接失敗
- 自動收貨功能不生效
- 后臺忘記密碼
- 支付成功訂單狀態沒改
- 小程序發布之后無法生成海報問題
- 安裝首頁數據庫鏈接失敗
- 技術文檔
- 打包教程
- 前臺打包教程
- 公眾號、H5打包
- 小程序打包
- 后臺打包教程
- PC端打包教程
- APP打包
- 1.基礎配置
- 2.開發調試
- 3.打包上線
- App打包
- 移動前端
- 目錄結構
- 移動端前端本地運行
- 頁面路徑
- 后臺前端說明
- 后臺前端目錄結構
- 后臺前端本地運行和打包
- 后臺前端頁面路徑
- 前端開發配置
- 前端配置說明
- 前端添加頁面
- 前端引用組件
- 前端構建和發布
- 開發規范
- 目錄結構
- 數據字典
- 標準版目錄結構
- 標準版數據字典
- 移動端路由
- 事件
- 系統配置
- 系統常用函數
- 后臺表單說明
- 驅動
- 后端路由
- 消息隊列
- URL重寫
- 長連接
- 定時任務
- 修改端口
- 商業授權
- 授權說明
- 申請授權