數據字典 · CRMEB 多商戶系統幫助文檔

```[sql] -- ---------------------------- -- Table structure for eb_article -- ---------------------------- DROP TABLE IF EXISTS `eb_article`; CREATE TABLE `eb_article` ( `article_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '文章管理ID', `cid` int(11) unsigned DEFAULT '0' COMMENT '分類id', `title` varchar(64) NOT NULL COMMENT '文章標題', `author` varchar(32) DEFAULT NULL COMMENT '文章作者', `image_input` varchar(128) NOT NULL COMMENT '文章圖片', `synopsis` varchar(128) DEFAULT NULL COMMENT '文章簡介', `visit` varchar(255) DEFAULT NULL COMMENT '瀏覽次數', `sort` int(10) unsigned DEFAULT '0' COMMENT '排序', `url` varchar(128) DEFAULT NULL COMMENT '原文鏈接', `admin_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '管理員id', `mer_id` int(10) unsigned DEFAULT '0' COMMENT '商戶id', `is_hot` tinyint(1) unsigned DEFAULT '0' COMMENT '是否熱門(小程序)', `is_banner` tinyint(1) unsigned DEFAULT '0' COMMENT '是否輪播圖(小程序)', `status` tinyint(1) unsigned DEFAULT NULL COMMENT '狀態', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加時間', `wechat_news_id` int(11) DEFAULT '0' COMMENT '微信圖文id', PRIMARY KEY (`article_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=257 DEFAULT CHARSET=utf8 COMMENT='文章管理表'; -- ---------------------------- -- Table structure for eb_article_category -- ---------------------------- DROP TABLE IF EXISTS `eb_article_category`; CREATE TABLE `eb_article_category` ( `article_category_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '文章分類id', `pid` int(11) NOT NULL DEFAULT '0' COMMENT '父級ID', `mer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商戶 id', `title` varchar(32) NOT NULL COMMENT '文章分類標題', `info` varchar(255) DEFAULT NULL COMMENT '文章分類簡介', `image` varchar(128) NOT NULL COMMENT '文章分類圖片', `status` tinyint(1) unsigned NOT NULL COMMENT '狀態', `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加時間', PRIMARY KEY (`article_category_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8 COMMENT='文章分類表'; -- ---------------------------- -- Table structure for eb_article_content -- ---------------------------- DROP TABLE IF EXISTS `eb_article_content`; CREATE TABLE `eb_article_content` ( `article_content_id` int(10) unsigned NOT NULL COMMENT '文章id', `content` text NOT NULL COMMENT '文章內容', UNIQUE KEY `article_content_id` (`article_content_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文章內容表'; -- ---------------------------- -- Table structure for eb_broadcast_assistant -- ---------------------------- DROP TABLE IF EXISTS `eb_broadcast_assistant`; CREATE TABLE `eb_broadcast_assistant` ( `assistant_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(50) DEFAULT NULL COMMENT '微信號', `nickname` varchar(100) DEFAULT NULL COMMENT '微信昵稱', `mer_id` int(11) DEFAULT NULL COMMENT '商戶ID', `mark` varchar(255) DEFAULT NULL COMMENT '備注', `is_del` tinyint(1) DEFAULT '0', UNIQUE KEY `id` (`assistant_id`) ) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8 COMMENT='直播助手信息'; -- ---------------------------- -- Table structure for eb_broadcast_goods -- ---------------------------- DROP TABLE IF EXISTS `eb_broadcast_goods`; CREATE TABLE `eb_broadcast_goods` ( `broadcast_goods_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `mer_id` int(10) unsigned NOT NULL COMMENT '商戶 id', `goods_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '微信商品ID', `audit_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '審核單 id', `cover_img` varchar(255) NOT NULL COMMENT '圖片', `name` varchar(64) NOT NULL COMMENT '商品名稱', `price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '價格', `product_type` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '商品類型', `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商品 id', `error_msg` varchar(255) DEFAULT NULL COMMENT '未通過原因', `audit_status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0：未審核，1：審核中，2:審核通過，3審核失敗', `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '審核狀態0=未審核1=微信審核2=審核通過-1=審核未通過', `is_show` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否顯示', `is_mer_show` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '商戶是否顯示', `mark` varchar(512) DEFAULT NULL COMMENT '備注', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `sort` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0', `is_mer_del` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '商戶是否刪除', PRIMARY KEY (`broadcast_goods_id`) USING BTREE, KEY `mer_id` (`mer_id`) USING BTREE, KEY `goods_id` (`goods_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=525 DEFAULT CHARSET=utf8 COMMENT='直播商品表'; -- ---------------------------- -- Table structure for eb_broadcast_room -- ---------------------------- DROP TABLE IF EXISTS `eb_broadcast_room`; CREATE TABLE `eb_broadcast_room` ( `broadcast_room_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `mer_id` int(10) unsigned NOT NULL COMMENT '商戶 id', `room_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '直播間 id', `name` varchar(32) NOT NULL COMMENT '直播間名字', `cover_img` varchar(255) NOT NULL COMMENT '背景圖', `share_img` varchar(255) NOT NULL COMMENT '分享圖', `start_time` timestamp NULL DEFAULT NULL COMMENT '直播計劃開始時間', `end_time` timestamp NULL DEFAULT NULL COMMENT '直播計劃結束時間', `anchor_name` varchar(32) NOT NULL COMMENT '主播昵稱', `anchor_wechat` varchar(32) NOT NULL COMMENT '主播微信號', `phone` varchar(32) NOT NULL COMMENT '主播手機號', `type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '直播間類型【1: 推流，0：手機直播】', `screen_type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '橫屏、豎屏【1：橫屏，0：豎屏】', `close_like` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否關閉點贊', `close_goods` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否關閉貨架', `close_comment` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否關閉評論', `close_share` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否關閉分享', `close_kf` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否關閉客服', `error_msg` varchar(255) DEFAULT NULL COMMENT '未通過原因', `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '審核狀態0=未審核1=微信審核2=審核通過-1=審核未通過', `live_status` smallint(5) unsigned NOT NULL DEFAULT '102' COMMENT '直播狀態101：直播中，102：未開始，103已結束，104禁播，105：暫停，106：異常，107：已過期', `mark` varchar(512) DEFAULT NULL COMMENT '備注', `replay_status` tinyint(1) unsigned DEFAULT '0' COMMENT '回放狀態', `is_mer_show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '商戶是否顯示', `is_show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否顯示', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加時間', `star` smallint(1) unsigned NOT NULL DEFAULT '1' COMMENT '推薦星級', `sort` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否刪除', `is_mer_del` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '商戶是否刪除', `feeds_img` varchar(255) DEFAULT NULL COMMENT '封面圖', `push_url` varchar(255) DEFAULT NULL COMMENT '推流地址', `assistant_id` varchar(255) DEFAULT NULL COMMENT '小助手ID', `is_feeds_public` tinyint(1) unsigned DEFAULT '0' COMMENT '是否開啟官方收錄，1 開啟，0 關閉', PRIMARY KEY (`broadcast_room_id`) USING BTREE, KEY `mer_id` (`mer_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=392 DEFAULT CHARSET=utf8 COMMENT='直播間表'; -- ---------------------------- -- Table structure for eb_broadcast_room_goods -- ---------------------------- DROP TABLE IF EXISTS `eb_broadcast_room_goods`; CREATE TABLE `eb_broadcast_room_goods` ( `broadcast_room_id` int(10) unsigned NOT NULL, `broadcast_goods_id` int(10) unsigned NOT NULL, `on_sale` tinyint(2) DEFAULT '1' COMMENT '商品上下架', KEY `broadcast_room_id` (`broadcast_room_id`,`broadcast_goods_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='直播間導入商品表'; -- ---------------------------- -- Table structure for eb_cache -- ---------------------------- DROP TABLE IF EXISTS `eb_cache`; CREATE TABLE `eb_cache` ( `key` varchar(32) NOT NULL, `expire_time` int(11) NOT NULL DEFAULT '0' COMMENT '0=永久', `result` longtext NOT NULL COMMENT '緩存數據', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '緩存時間', PRIMARY KEY (`key`) USING BTREE, KEY `key` (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='微信緩存表'; -- ---------------------------- -- Table structure for eb_city_area -- ---------------------------- DROP TABLE IF EXISTS `eb_city_area`; CREATE TABLE `eb_city_area` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `path` varchar(128) NOT NULL DEFAULT '/' COMMENT '省市級別', `parent_id` int(11) NOT NULL DEFAULT '0' COMMENT '父級id', `type` varchar(32) NOT NULL COMMENT '類型', `level` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '級別', `snum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '子級個數', `name` varchar(100) NOT NULL DEFAULT '' COMMENT '名稱', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, KEY `parent_id` (`parent_id`) USING BTREE, KEY `path` (`path`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=59046 DEFAULT CHARSET=utf8 COMMENT='省市區縣數據'; -- ---------------------------- -- Table structure for eb_community -- ---------------------------- DROP TABLE IF EXISTS `eb_community`; CREATE TABLE `eb_community` ( `community_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT NULL COMMENT '標題', `image` varchar(1000) DEFAULT NULL COMMENT '圖片', `category_id` int(11) unsigned DEFAULT '0', `topic_id` int(11) unsigned DEFAULT '0' COMMENT '話題', `uid` int(11) unsigned DEFAULT '0' COMMENT '用戶', `count_start` int(11) unsigned DEFAULT '0' COMMENT '點贊數', `count_reply` int(11) unsigned DEFAULT '0' COMMENT '評論數', `count_share` int(11) unsigned DEFAULT '0' COMMENT '分享數', `status` tinyint(2) DEFAULT '0' COMMENT '審核狀態', `is_show` tinyint(2) DEFAULT '0' COMMENT '顯示狀態', `start` tinyint(1) DEFAULT '1' COMMENT '星級排序', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `is_del` tinyint(1) DEFAULT '0', `content` varchar(1000) DEFAULT NULL, `refusal` varchar(255) DEFAULT NULL COMMENT '拒絕理由', `is_hot` tinyint(2) DEFAULT '0' COMMENT '是否推薦', `order_id` int(11) unsigned DEFAULT '0' COMMENT '關聯訂單ID', PRIMARY KEY (`community_id`) ) ENGINE=InnoDB AUTO_INCREMENT=144 DEFAULT CHARSET=utf8 COMMENT='社區圖文表信息'; -- ---------------------------- -- Table structure for eb_community_category -- ---------------------------- DROP TABLE IF EXISTS `eb_community_category`; CREATE TABLE `eb_community_category` ( `category_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `cate_name` varchar(50) DEFAULT NULL COMMENT '分類名', `pid` int(11) DEFAULT NULL COMMENT '父級ID', `path` varchar(255) DEFAULT '/' COMMENT '路徑 ', `is_show` tinyint(2) DEFAULT '1' COMMENT '狀態', `level` int(11) DEFAULT '0' COMMENT '等級', `sort` int(11) DEFAULT NULL, PRIMARY KEY (`category_id`) ) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=utf8 COMMENT='社區分類'; -- ---------------------------- -- Table structure for eb_community_reply -- ---------------------------- DROP TABLE IF EXISTS `eb_community_reply`; CREATE TABLE `eb_community_reply` ( `reply_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `content` varchar(255) DEFAULT NULL COMMENT '評論內容', `pid` int(11) unsigned DEFAULT '0' COMMENT '回復id', `uid` int(11) unsigned DEFAULT '0' COMMENT '發言人', `re_uid` int(11) unsigned DEFAULT '0' COMMENT '回復人', `count_start` int(11) unsigned DEFAULT '0' COMMENT '點贊數', `count_reply` int(11) unsigned DEFAULT '0' COMMENT '評論數', `status` tinyint(2) DEFAULT '1' COMMENT '狀態 ', `community_id` int(11) unsigned DEFAULT '0' COMMENT '文章id', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `is_del` tinyint(2) DEFAULT '0', `refusal` varchar(255) DEFAULT NULL COMMENT '拒絕原因', PRIMARY KEY (`reply_id`), UNIQUE KEY `id` (`reply_id`) ) ENGINE=InnoDB AUTO_INCREMENT=269 DEFAULT CHARSET=utf8 COMMENT='社區評論'; -- ---------------------------- -- Table structure for eb_community_topic -- ---------------------------- DROP TABLE IF EXISTS `eb_community_topic`; CREATE TABLE `eb_community_topic` ( `topic_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `topic_name` varchar(100) DEFAULT NULL COMMENT '話題', `status` tinyint(2) DEFAULT '1' COMMENT '狀態', `is_hot` tinyint(11) DEFAULT '0' COMMENT '推薦', `category_id` int(11) unsigned DEFAULT '0' COMMENT '分類id', `is_del` tinyint(2) DEFAULT '0', `pic` varchar(128) DEFAULT NULL COMMENT '圖標', `count_use` int(11) unsigned DEFAULT '0' COMMENT '使用次數', `count_view` int(11) unsigned DEFAULT '0' COMMENT '瀏覽量', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `sort` int(11) unsigned DEFAULT '0', PRIMARY KEY (`topic_id`), UNIQUE KEY `id` (`topic_id`) ) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8 COMMENT='社區話題'; -- ---------------------------- -- Table structure for eb_excel -- ---------------------------- DROP TABLE IF EXISTS `eb_excel`; CREATE TABLE `eb_excel` ( `excel_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `name` varchar(255) DEFAULT NULL COMMENT '文件名', `status` int(255) DEFAULT '0' COMMENT '0.默認，1.完成，2.失敗', `type` varchar(255) DEFAULT NULL COMMENT '類型', `path` varchar(255) DEFAULT NULL COMMENT '文件路徑', `mer_id` int(11) DEFAULT '0' COMMENT '商戶id', `admin_id` int(11) DEFAULT NULL COMMENT '操作者id', `is_del` int(11) DEFAULT '0' COMMENT '是否刪除', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `message` varchar(255) DEFAULT NULL, PRIMARY KEY (`excel_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=406 DEFAULT CHARSET=utf8 COMMENT='導出文件記錄表'; -- ---------------------------- -- 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) NOT NULL COMMENT '快遞公司簡稱', `name` varchar(50) NOT NULL COMMENT '快遞公司全稱', `mark` varchar(255) DEFAULT '' COMMENT '備注', `partner_id` int(11) DEFAULT '0' COMMENT '月結賬號', `partner_key` int(11) DEFAULT '0' COMMENT '月結密碼', `net` int(11) DEFAULT '0' COMMENT '取件網點', `sort` int(11) NOT NULL COMMENT '排序', `is_show` int(11) DEFAULT '1' COMMENT '是否顯示', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `code` (`code`) USING BTREE, KEY `is_show` (`is_show`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=1641 DEFAULT CHARSET=utf8 COMMENT='快遞公司表'; -- ---------------------------- -- Table structure for eb_express_partner -- ---------------------------- DROP TABLE IF EXISTS `eb_express_partner`; CREATE TABLE `eb_express_partner` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `express_id` int(11) NOT NULL COMMENT '快遞公司id', `account` varchar(20) DEFAULT NULL COMMENT '月結賬號', `key` varchar(50) DEFAULT NULL COMMENT '月結密碼', `net_name` varchar(50) DEFAULT NULL COMMENT '取件網點', `mer_id` int(11) DEFAULT NULL, `status` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='快遞公司賬號信息'; -- ---------------------------- -- Table structure for eb_feedback -- ---------------------------- DROP TABLE IF EXISTS `eb_feedback`; CREATE TABLE `eb_feedback` ( `feedback_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uid` int(10) unsigned NOT NULL DEFAULT '0', `type` varchar(255) NOT NULL, `content` varchar(512) NOT NULL, `images` text COMMENT '反饋圖片', `realname` varchar(24) NOT NULL COMMENT '姓名', `contact` varchar(32) NOT NULL COMMENT '聯系方式', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `status` tinyint(1) DEFAULT '0' COMMENT '狀態', `reply` varchar(255) DEFAULT NULL COMMENT '回復，最終給用戶的回復內容', `remake` varchar(255) DEFAULT NULL COMMENT '備注，后臺人員自己查看用', `is_del` tinyint(1) NOT NULL DEFAULT '0', `update_time` timestamp NULL DEFAULT NULL COMMENT '回復時間', PRIMARY KEY (`feedback_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COMMENT='用戶反饋表'; -- ---------------------------- -- Table structure for eb_feedback_category -- ---------------------------- DROP TABLE IF EXISTS `eb_feedback_category`; CREATE TABLE `eb_feedback_category` ( `feedback_category_id` mediumint(11) NOT NULL AUTO_INCREMENT COMMENT '商品分類表ID', `pid` mediumint(11) NOT NULL COMMENT '父id', `cate_name` varchar(100) NOT NULL COMMENT '分類名稱', `path` varchar(255) NOT NULL DEFAULT '' COMMENT '路徑', `sort` mediumint(11) NOT NULL COMMENT '排序', `pic` varchar(128) NOT NULL DEFAULT '' COMMENT '圖標', `is_show` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否顯示', `level` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '等級', `mer_id` int(11) unsigned DEFAULT '0' COMMENT '商戶id', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '添加時間', PRIMARY KEY (`feedback_category_id`) USING BTREE, KEY `pid` (`pid`) USING BTREE, KEY `sort` (`sort`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=191 DEFAULT CHARSET=utf8 COMMENT='用戶反饋分類表'; -- ---------------------------- -- Table structure for eb_financial -- ---------------------------- DROP TABLE IF EXISTS `eb_financial`; CREATE TABLE `eb_financial` ( `financial_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `financial_sn` varchar(32) NOT NULL COMMENT '單號', `mer_money` decimal(12,2) unsigned NOT NULL COMMENT '余額', `extract_money` decimal(12,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '提現金額', `financial_type` int(11) unsigned DEFAULT '0' COMMENT '收款類型', `financial_account` varchar(500) NOT NULL COMMENT '商戶賬戶信息', `financial_status` int(11) unsigned DEFAULT '0' COMMENT '轉賬狀態', `status` int(10) NOT NULL COMMENT '審核0待審核，1通過，-1 未通過', `refusal` varchar(32) NOT NULL COMMENT '拒絕理由', `mer_id` int(11) unsigned NOT NULL COMMENT '商戶 id', `image` varchar(1000) DEFAULT NULL COMMENT '憑證', `admin_id` int(11) DEFAULT NULL, `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創建時間', `status_time` timestamp NULL DEFAULT NULL COMMENT '審核時間', `update_time` timestamp NULL DEFAULT NULL COMMENT '修改拼憑證時間', `is_del` int(11) unsigned DEFAULT '0', `mark` varchar(255) DEFAULT NULL COMMENT '商戶備注', `admin_mark` varchar(255) DEFAULT NULL COMMENT '平臺備注', `mer_admin_id` int(11) DEFAULT NULL COMMENT '商戶管理員', PRIMARY KEY (`financial_id`) USING BTREE, KEY `mer_id` (`mer_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=464 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='商戶財務申請提現'; -- ---------------------------- -- Table structure for eb_financial_record -- ---------------------------- DROP TABLE IF EXISTS `eb_financial_record`; CREATE TABLE `eb_financial_record` ( `financial_record_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `financial_record_sn` varchar(32) NOT NULL COMMENT '流水號', `order_id` int(10) unsigned NOT NULL COMMENT '訂單號', `order_sn` varchar(32) NOT NULL COMMENT '訂單編號', `user_info` varchar(32) NOT NULL COMMENT '用戶名', `user_id` int(10) unsigned NOT NULL COMMENT '用戶 id', `financial_type` varchar(32) NOT NULL COMMENT '流水類型', `financial_pm` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0 = 支出 1 = 獲得', `number` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '金額', `type` tinyint(1) NOT NULL DEFAULT '-1' COMMENT '0:商戶 1:公共 2:平臺', `mer_id` int(10) unsigned NOT NULL COMMENT '商戶 id', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創建時間', PRIMARY KEY (`financial_record_id`) USING BTREE, KEY `mer_id` (`mer_id`) USING BTREE, KEY `financial_type` (`financial_type`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=7745 DEFAULT CHARSET=utf8 COMMENT='商戶財務流水'; -- ---------------------------- -- Table structure for eb_guarantee -- ---------------------------- DROP TABLE IF EXISTS `eb_guarantee`; CREATE TABLE `eb_guarantee` ( `guarantee_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主鍵', `guarantee_name` varchar(255) DEFAULT NULL COMMENT '保障服務名稱', `guarantee_info` varchar(500) DEFAULT NULL COMMENT '保障服務簡介', `status` int(11) DEFAULT '1' COMMENT '0.關閉，1開啟', `image` varchar(255) DEFAULT NULL COMMENT '圖標', `sort` int(11) DEFAULT NULL COMMENT '排序', `mer_count` int(11) DEFAULT '0' COMMENT '使用的商戶數', `product_cout` int(11) DEFAULT '0' COMMENT '使用的商品數', `is_del` int(11) DEFAULT '0', `create_time` timestamp NULL DEFAULT NULL, `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`guarantee_id`) ) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8 COMMENT='保障服務選項'; -- ---------------------------- -- Table structure for eb_guarantee_template -- ---------------------------- DROP TABLE IF EXISTS `eb_guarantee_template`; CREATE TABLE `eb_guarantee_template` ( `guarantee_template_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `template_name` varchar(255) DEFAULT NULL, `mer_id` int(11) DEFAULT NULL, `status` int(11) unsigned DEFAULT '1', `sort` int(11) DEFAULT NULL, `create_time` timestamp NULL DEFAULT NULL, `is_del` int(11) unsigned DEFAULT '0', PRIMARY KEY (`guarantee_template_id`) ) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8 COMMENT='保障服務模板'; -- ---------------------------- -- Table structure for eb_guarantee_value -- ---------------------------- DROP TABLE IF EXISTS `eb_guarantee_value`; CREATE TABLE `eb_guarantee_value` ( `guarantee_value_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `guarantee_id` int(11) unsigned DEFAULT NULL, `guarantee_template_id` int(11) unsigned DEFAULT NULL, `mer_id` int(11) DEFAULT NULL, `status` int(11) DEFAULT '1', PRIMARY KEY (`guarantee_value_id`) ) ENGINE=InnoDB AUTO_INCREMENT=239 DEFAULT CHARSET=utf8 COMMENT='保障服務模板條款'; -- ---------------------------- -- Table structure for eb_label_rule -- ---------------------------- DROP TABLE IF EXISTS `eb_label_rule`; CREATE TABLE `eb_label_rule` ( `label_rule_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `mer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商戶 id', `label_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '標簽 id', `type` tinyint(1) unsigned DEFAULT '0' COMMENT '0=訂單數 1=訂單金額', `min` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '最小值', `max` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT ' 最大值', `user_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用戶數', `update_time` timestamp NULL DEFAULT NULL COMMENT '更新時間', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`label_rule_id`), KEY `mer_id` (`mer_id`) ) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8 COMMENT='自定標簽規則'; -- ---------------------------- -- Table structure for eb_member_interests -- ---------------------------- DROP TABLE IF EXISTS `eb_member_interests`; CREATE TABLE `eb_member_interests` ( `interests_id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(20) DEFAULT NULL COMMENT '名稱', `info` varchar(200) DEFAULT NULL COMMENT '介紹', `brokerage_level` tinyint(3) unsigned DEFAULT NULL COMMENT '關聯等級', `pic` varchar(128) DEFAULT NULL COMMENT '圖標', `type` tinyint(2) DEFAULT '0' COMMENT '類型1.免費會員', PRIMARY KEY (`interests_id`) ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for eb_merchant -- ---------------------------- DROP TABLE IF EXISTS `eb_merchant`; CREATE TABLE `eb_merchant` ( `mer_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '商戶id', `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商戶分類 id', `type_id` int(10) unsigned DEFAULT '0' COMMENT '店鋪類型 id', `mer_name` varchar(32) NOT NULL COMMENT '商戶名稱', `real_name` varchar(32) NOT NULL COMMENT '商戶姓名', `mer_phone` varchar(13) NOT NULL COMMENT '商戶手機號', `mer_address` varchar(64) NOT NULL COMMENT '商戶地址', `mer_keyword` varchar(64) NOT NULL COMMENT '商戶關鍵字', `mer_avatar` varchar(128) DEFAULT NULL COMMENT '商戶頭像', `mer_banner` varchar(128) DEFAULT NULL COMMENT '商戶banner圖片', `mini_banner` varchar(128) DEFAULT NULL COMMENT '商戶店店鋪街圖片', `sales` int(11) unsigned DEFAULT '0' COMMENT '銷量', `product_score` decimal(11,1) DEFAULT '5.0' COMMENT '商品描述評分', `service_score` decimal(11,1) DEFAULT '5.0' COMMENT '服務評分', `postage_score` decimal(11,1) DEFAULT '5.0' COMMENT '物流評分', `mark` varchar(256) NOT NULL COMMENT '商戶備注', `reg_admin_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '總后臺管理員ID', `sort` int(10) unsigned NOT NULL DEFAULT '0', `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '商戶是否禁用0鎖定,1正常', `commission_rate` decimal(11,4) DEFAULT NULL COMMENT '提成比例', `long` varchar(16) DEFAULT NULL COMMENT '經度', `lat` varchar(16) DEFAULT NULL COMMENT '緯度', `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0未刪除1刪除', `is_audit` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '添加的產品是否審核0不審核1審核', `is_bro_room` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否審核直播間0不審核1審核', `is_bro_goods` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否審核直播商品0不審核1審核', `is_best` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否推薦', `is_trader` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否自營', `mer_state` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '商戶是否1開啟0關閉', `mer_info` varchar(256) NOT NULL DEFAULT '' COMMENT '店鋪簡介', `service_phone` varchar(13) NOT NULL DEFAULT '' COMMENT '店鋪電話', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `care_count` int(11) unsigned DEFAULT '0' COMMENT '關注總數', `copy_product_num` int(11) unsigned DEFAULT '0' COMMENT '剩余復制商品次數', `export_dump_num` int(11) unsigned DEFAULT '0' COMMENT '電子面單剩余次數', `mer_money` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '商戶余額', `financial_bank` varchar(255) DEFAULT NULL COMMENT '銀行卡轉賬信息', `financial_wechat` varchar(255) DEFAULT NULL COMMENT '微信轉賬信息', `financial_alipay` varchar(255) DEFAULT NULL COMMENT '支付寶轉賬信息', `financial_type` tinyint(2) unsigned DEFAULT '1' COMMENT '默認使用類型', `sub_mchid` varchar(16) NOT NULL DEFAULT '' COMMENT '微信支付分配的分賬號', `delivery_way` varchar(50) DEFAULT '' COMMENT '配送方式', PRIMARY KEY (`mer_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=152 DEFAULT CHARSET=utf8 COMMENT='商戶表'; -- ---------------------------- -- Table structure for eb_merchant_admin -- ---------------------------- DROP TABLE IF EXISTS `eb_merchant_admin`; CREATE TABLE `eb_merchant_admin` ( `merchant_admin_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '商戶管理員表ID', `mer_id` int(10) unsigned NOT NULL COMMENT '商戶ID(屬于哪一個商戶)', `account` varchar(32) NOT NULL COMMENT '商戶管理員賬號', `pwd` char(64) NOT NULL COMMENT '商戶管理員密碼', `real_name` varchar(16) NOT NULL COMMENT '商戶管理員姓名', `phone` varchar(13) DEFAULT NULL COMMENT '商戶管理員手機號', `last_ip` varchar(16) DEFAULT NULL COMMENT '商戶管理員最后一次登錄IP地址', `last_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '商戶管理員最后一次登錄時間', `roles` varchar(128) DEFAULT '', `login_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商戶管理員登錄次數', `level` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '商戶管理員等級(管理員添加的為0, 商戶添加的為1)', `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否刪除', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否有效 1有效 0無效 ', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '商戶管理員添加時間', PRIMARY KEY (`merchant_admin_id`) USING BTREE, KEY `account` (`account`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=181 DEFAULT CHARSET=utf8 COMMENT='商戶管理員表'; -- ---------------------------- -- Table structure for eb_merchant_applyments -- ---------------------------- DROP TABLE IF EXISTS `eb_merchant_applyments`; CREATE TABLE `eb_merchant_applyments` ( `mer_applyments_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `out_request_no` varchar(128) DEFAULT NULL COMMENT '業務申請編號', `applyment_id` varchar(100) DEFAULT NULL COMMENT '微信支付分配的申請單號', `mer_id` int(11) DEFAULT '0' COMMENT '商戶ID', `sub_mchid` varchar(100) DEFAULT NULL COMMENT '二級商戶號', `mer_name` varchar(50) DEFAULT NULL COMMENT '商戶名', `info` text COMMENT '申請資料', `status` int(11) DEFAULT '0' COMMENT '申請狀態: 0.平臺未提交，-1.平臺駁回，10.平臺提交審核中，11.需用戶操作，20.已完成，30.已凍結，40.駁回', `message` varchar(1000) DEFAULT NULL COMMENT '返回信息', `mark` varchar(255) DEFAULT NULL COMMENT '備注', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `is_del` int(11) DEFAULT '0' COMMENT '刪除', PRIMARY KEY (`mer_applyments_id`) ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for eb_merchant_category -- ---------------------------- DROP TABLE IF EXISTS `eb_merchant_category`; CREATE TABLE `eb_merchant_category` ( `merchant_category_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '商戶分類 id', `commission_rate` decimal(6,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT '手續費', `category_name` varchar(32) NOT NULL COMMENT '商戶分類名稱', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加時間', PRIMARY KEY (`merchant_category_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8 COMMENT='商戶分類表'; -- ---------------------------- -- Table structure for eb_merchant_intention -- ---------------------------- DROP TABLE IF EXISTS `eb_merchant_intention`; CREATE TABLE `eb_merchant_intention` ( `mer_intention_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID', `uid` int(11) unsigned DEFAULT '0' COMMENT '用戶ID', `phone` varchar(11) DEFAULT NULL COMMENT '手機號', `mer_name` varchar(30) DEFAULT NULL COMMENT '商戶名稱', `name` varchar(30) DEFAULT NULL COMMENT '客戶姓名', `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '提交時間', `status` tinyint(2) DEFAULT '0' COMMENT '處理狀態 1通過，2未通過', `fail_msg` varchar(255) DEFAULT NULL COMMENT '未通過原因', `is_del` tinyint(2) DEFAULT '0' COMMENT '刪除狀態 1刪除，0未刪除', `mark` varchar(255) DEFAULT NULL COMMENT '備注', `mer_id` int(11) unsigned DEFAULT '0' COMMENT '關聯商戶', `images` varchar(2000) DEFAULT NULL COMMENT '多圖', `merchant_category_id` int(11) unsigned DEFAULT '0' COMMENT '商戶分類', `mer_type_id` int(10) unsigned DEFAULT '0' COMMENT '店鋪類型', PRIMARY KEY (`mer_intention_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=140 DEFAULT CHARSET=utf8 COMMENT='商戶申請表'; -- ---------------------------- -- Table structure for eb_merchant_reconciliation -- ---------------------------- DROP TABLE IF EXISTS `eb_merchant_reconciliation`; CREATE TABLE `eb_merchant_reconciliation` ( `reconciliation_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '對賬id', `mer_id` int(10) unsigned NOT NULL COMMENT '商戶id', `admin_id` int(10) unsigned NOT NULL COMMENT '后臺管理員id', `mer_admin_id` int(10) unsigned NOT NULL COMMENT '商戶管理員id', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '對賬時間', `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '對賬狀態0等待對賬1取消對賬2確定對賬', `price` decimal(10,2) NOT NULL COMMENT '對賬總金額', `order_price` decimal(10,2) unsigned DEFAULT NULL COMMENT '訂單金額', `order_extension` decimal(10,2) NOT NULL COMMENT '訂單傭金', `order_rate` decimal(10,2) DEFAULT NULL COMMENT '訂單手續費', `refund_price` decimal(10,2) NOT NULL COMMENT '退款單金額', `refund_extension` decimal(10,2) NOT NULL COMMENT '退款單傭金', `refund_rate` decimal(10,2) DEFAULT NULL, `bank` varchar(128) DEFAULT NULL COMMENT '銀行卡開戶行', `bank_number` varchar(20) DEFAULT NULL COMMENT '銀行卡卡號', `bank_name` varchar(64) DEFAULT NULL COMMENT '銀行卡持卡人姓名', `bank_address` varchar(256) DEFAULT NULL COMMENT '銀行卡開戶行地址', `mark` varchar(255) DEFAULT NULL COMMENT '備注', `admin_mark` varchar(255) DEFAULT NULL COMMENT '管理員備注', `is_accounts` tinyint(1) unsigned NOT NULL COMMENT '轉賬狀態0未轉賬1已轉賬', `order_ids` varchar(255) DEFAULT NULL COMMENT '已對賬的訂單id', `accounts_time` timestamp NULL DEFAULT NULL, PRIMARY KEY (`reconciliation_id`) USING BTREE, KEY `mer_id` (`mer_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8 COMMENT='商戶對賬記錄表'; -- ---------------------------- -- Table structure for eb_merchant_reconciliation_order -- ---------------------------- DROP TABLE IF EXISTS `eb_merchant_reconciliation_order`; CREATE TABLE `eb_merchant_reconciliation_order` ( `reconciliation_id` int(11) DEFAULT NULL COMMENT '對賬單id', `order_id` int(11) DEFAULT NULL COMMENT '訂單id', `type` tinyint(1) DEFAULT NULL COMMENT '0.訂單， 1 . 退款訂單' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='對賬單中間表'; -- ---------------------------- -- Table structure for eb_merchant_type -- ---------------------------- DROP TABLE IF EXISTS `eb_merchant_type`; CREATE TABLE `eb_merchant_type` ( `mer_type_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '商戶類型 id', `type_name` varchar(16) NOT NULL COMMENT '類型名稱', `type_info` varchar(512) DEFAULT NULL COMMENT '類型要求', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加時間', PRIMARY KEY (`mer_type_id`) ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COMMENT='商戶類型表'; -- ---------------------------- -- Table structure for eb_presell_order -- ---------------------------- DROP TABLE IF EXISTS `eb_presell_order`; CREATE TABLE `eb_presell_order` ( `presell_order_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '預售尾款訂單id', `presell_order_sn` varchar(32) NOT NULL COMMENT '預售訂單號', `uid` int(10) unsigned NOT NULL COMMENT '用戶 id', `mer_id` int(10) unsigned NOT NULL COMMENT '商戶 id', `order_id` int(10) unsigned NOT NULL COMMENT '訂單id', `transaction_id` varchar(60) DEFAULT NULL COMMENT '微信支付訂單號(分賬時有效)', `final_start_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '支付開始時間', `final_end_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '尾款支付結時間', `paid` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '0:未支付 1:已支付', `status` tinyint(1) unsigned DEFAULT '1' COMMENT '0:無效 1:有效', `pay_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '支付方式 0余額 1微信 2小程序 3,4支付寶', `pay_price` decimal(8,2) unsigned NOT NULL COMMENT '尾款', `refun_price` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '退款金額', `pay_time` timestamp NULL DEFAULT NULL COMMENT '支付時間', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創建時間', `is_combine` tinyint(1) unsigned DEFAULT '0' COMMENT '是否為合并支付', PRIMARY KEY (`presell_order_id`), UNIQUE KEY `order_id` (`order_id`), KEY `uid` (`uid`), KEY `mer_id` (`mer_id`) ) ENGINE=InnoDB AUTO_INCREMENT=236 DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for eb_relevance -- ---------------------------- DROP TABLE IF EXISTS `eb_relevance`; CREATE TABLE `eb_relevance` ( `relevance_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `left_id` int(11) unsigned NOT NULL, `right_id` int(11) unsigned NOT NULL, `type` varchar(32) NOT NULL DEFAULT '', PRIMARY KEY (`relevance_id`) USING BTREE, KEY `type` (`type`,`left_id`,`right_id`) ) ENGINE=InnoDB AUTO_INCREMENT=929 DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for eb_routine_qrcode -- ---------------------------- DROP TABLE IF EXISTS `eb_routine_qrcode`; CREATE TABLE `eb_routine_qrcode` ( `routine_qrcode_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '微信二維碼ID', `third_type` varchar(32) NOT NULL COMMENT '二維碼類型 spread(用戶推廣) product_spread(商品推廣)', `third_id` int(11) unsigned NOT NULL COMMENT '用戶id', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '狀態 0不可用 1可用', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加時間', `page` varchar(255) DEFAULT NULL COMMENT '小程序頁面路徑帶參數', `qrcode_url` varchar(255) DEFAULT NULL COMMENT '小程序二維碼路徑', `url_time` timestamp NULL DEFAULT NULL COMMENT '二維碼添加時間', PRIMARY KEY (`routine_qrcode_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COMMENT='小程序二維碼管理表'; -- ---------------------------- -- Table structure for eb_serve_meal -- ---------------------------- DROP TABLE IF EXISTS `eb_serve_meal`; CREATE TABLE `eb_serve_meal` ( `meal_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(30) DEFAULT NULL COMMENT '套餐名稱', `type` int(11) DEFAULT '0' COMMENT '套餐類型,1復制商品，2電子面單', `price` decimal(8,2) DEFAULT '0.00' COMMENT '價格', `num` int(11) DEFAULT '1' COMMENT '數量', `sort` int(11) DEFAULT NULL COMMENT '排序', `status` int(11) DEFAULT '1' COMMENT '狀態', `is_del` int(11) DEFAULT '0', `create_time` timestamp NULL DEFAULT NULL, PRIMARY KEY (`meal_id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for eb_serve_order -- ---------------------------- DROP TABLE IF EXISTS `eb_serve_order`; CREATE TABLE `eb_serve_order` ( `order_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `meal_id` int(11) DEFAULT NULL COMMENT '套餐ID', `pay_type` int(11) DEFAULT NULL COMMENT '支付方式：1微信，2支付寶', `order_sn` varchar(50) DEFAULT NULL COMMENT '訂單ID', `pay_price` decimal(8,2) DEFAULT NULL COMMENT '價格', `order_info` varchar(255) DEFAULT NULL COMMENT '套餐信息', `type` int(11) DEFAULT NULL COMMENT '套餐類型', `status` int(11) DEFAULT '0' COMMENT '狀態：默認0，支付成功 10，支付失敗 -1', `mer_id` int(11) DEFAULT NULL, `create_time` timestamp NULL DEFAULT NULL, `is_del` int(11) DEFAULT '0', PRIMARY KEY (`order_id`) ) ENGINE=InnoDB AUTO_INCREMENT=154 DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for eb_shipping_template -- ---------------------------- DROP TABLE IF EXISTS `eb_shipping_template`; CREATE TABLE `eb_shipping_template` ( `shipping_template_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '編號', `name` varchar(255) NOT NULL COMMENT '模板名稱', `type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '計費方式 0=數量 1=重量 2=體積', `appoint` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '開啟指定包郵', `undelivery` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '開啟指定區域不配送', `mer_id` int(10) unsigned NOT NULL COMMENT '商戶 id', `is_default` tinyint(1) unsigned DEFAULT '0' COMMENT '默認模板', `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加時間', `info` varchar(1000) DEFAULT NULL COMMENT '運費說明', PRIMARY KEY (`shipping_template_id`) USING BTREE, KEY `mer_id` (`mer_id`,`sort`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=303 DEFAULT CHARSET=utf8 COMMENT='運費表'; -- ---------------------------- -- Table structure for eb_shipping_template_free -- ---------------------------- DROP TABLE IF EXISTS `eb_shipping_template_free`; CREATE TABLE `eb_shipping_template_free` ( `shipping_template_free_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '編號', `temp_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '模板ID', `city_id` text NOT NULL COMMENT '城市ID /id/id/id/id/', `number` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '包郵件數', `price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '包郵金額', PRIMARY KEY (`shipping_template_free_id`) USING BTREE, KEY `temp_id` (`temp_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=259 DEFAULT CHARSET=utf8 COMMENT='指定包郵信息表'; -- ---------------------------- -- Table structure for eb_shipping_template_region -- ---------------------------- DROP TABLE IF EXISTS `eb_shipping_template_region`; CREATE TABLE `eb_shipping_template_region` ( `shipping_template_region_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '編號', `temp_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '模板ID', `city_id` text NOT NULL COMMENT '城市ID /id/id/id/', `first` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '首件', `first_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '首件運費', `continue` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '續件', `continue_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '續件運費', PRIMARY KEY (`shipping_template_region_id`) USING BTREE, KEY `temp_id` (`temp_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=942 DEFAULT CHARSET=utf8 COMMENT='配送區域表'; -- ---------------------------- -- Table structure for eb_shipping_template_undelivery -- ---------------------------- DROP TABLE IF EXISTS `eb_shipping_template_undelivery`; CREATE TABLE `eb_shipping_template_undelivery` ( `shipping_template_undelivery_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '編號', `temp_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '模板ID', `city_id` text NOT NULL COMMENT '城市ID /id/id/id/', PRIMARY KEY (`shipping_template_undelivery_id`) USING BTREE, KEY `temp_id` (`temp_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=213 DEFAULT CHARSET=utf8 COMMENT='指定不配送區域表'; -- ---------------------------- -- Table structure for eb_sms_record -- ---------------------------- DROP TABLE IF EXISTS `eb_sms_record`; CREATE TABLE `eb_sms_record` ( `sms_record_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '短信發送記錄編號', `uid` varchar(255) NOT NULL COMMENT '短信平臺賬號', `phone` char(11) NOT NULL COMMENT '接受短信的手機號', `content` text NOT NULL COMMENT '短信內容', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '發送短信時間', `ip` varchar(16) NOT NULL DEFAULT '' COMMENT '添加記錄ip', `template` varchar(255) NOT NULL COMMENT '短信模板ID', `resultcode` int(6) unsigned DEFAULT NULL COMMENT '狀態碼 100=成功,130=失敗,131=空號,132=停機,133=關機,134=無狀態', `record_id` int(11) unsigned NOT NULL COMMENT '發送記錄id', PRIMARY KEY (`sms_record_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=2272 DEFAULT CHARSET=utf8 COMMENT='短信發送記錄表'; -- ---------------------------- -- Table structure for eb_store_attr_template -- ---------------------------- DROP TABLE IF EXISTS `eb_store_attr_template`; CREATE TABLE `eb_store_attr_template` ( `attr_template_id` int(10) NOT NULL AUTO_INCREMENT, `template_name` varchar(32) NOT NULL COMMENT '規格名稱', `template_value` text NOT NULL COMMENT '規格值', `mer_id` int(11) NOT NULL COMMENT '商戶 id', PRIMARY KEY (`attr_template_id`) USING BTREE, KEY `mer_id` (`mer_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=167 DEFAULT CHARSET=utf8 COMMENT='商品規則值(規格)表'; -- ---------------------------- -- Table structure for eb_store_brand -- ---------------------------- DROP TABLE IF EXISTS `eb_store_brand`; CREATE TABLE `eb_store_brand` ( `brand_id` mediumint(11) NOT NULL AUTO_INCREMENT COMMENT '商品品牌表ID', `brand_category_id` mediumint(11) NOT NULL COMMENT '父id', `brand_name` varchar(100) NOT NULL COMMENT '品牌名稱', `sort` mediumint(11) NOT NULL COMMENT '排序', `pic` varchar(128) NOT NULL DEFAULT '' COMMENT '圖標', `is_show` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否顯示', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加時間', PRIMARY KEY (`brand_id`) USING BTREE, KEY `pid` (`brand_category_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=179 DEFAULT CHARSET=utf8 COMMENT='商品品牌表'; -- ---------------------------- -- Table structure for eb_store_brand_category -- ---------------------------- DROP TABLE IF EXISTS `eb_store_brand_category`; CREATE TABLE `eb_store_brand_category` ( `store_brand_category_id` mediumint(11) NOT NULL AUTO_INCREMENT COMMENT '品牌分類表ID', `pid` mediumint(11) NOT NULL COMMENT '父id', `cate_name` varchar(100) NOT NULL COMMENT '分類名稱', `path` varchar(255) NOT NULL DEFAULT '' COMMENT '路徑', `sort` mediumint(11) NOT NULL COMMENT '排序', `is_show` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否顯示', `level` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '等級', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加時間', PRIMARY KEY (`store_brand_category_id`) USING BTREE, KEY `pid` (`pid`) USING BTREE, KEY `sort` (`sort`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=202 DEFAULT CHARSET=utf8 COMMENT='品牌分類表'; -- ---------------------------- -- Table structure for eb_store_cart -- ---------------------------- DROP TABLE IF EXISTS `eb_store_cart`; CREATE TABLE `eb_store_cart` ( `cart_id` bigint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '購物車表ID', `uid` int(10) unsigned NOT NULL COMMENT '用戶ID', `mer_id` int(10) unsigned NOT NULL COMMENT '商戶 id', `product_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '類型 0=普通產品，2.預售商品', `product_id` int(10) unsigned NOT NULL COMMENT '商品ID', `product_attr_unique` varchar(16) NOT NULL DEFAULT '' COMMENT '商品屬性', `cart_num` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '商品數量', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加時間', `source` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '來源 1.直播間,2.預售商品,3.助力商品', `source_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '來源關聯 id', `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 '是否為立即購買', `is_fail` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否失效', `spread_id` int(11) unsigned DEFAULT '0' COMMENT '推廣人', PRIMARY KEY (`cart_id`) USING BTREE, KEY `user_id` (`uid`) USING BTREE, KEY `product_id` (`product_id`) USING BTREE, KEY `mer_id` (`mer_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=8633 DEFAULT CHARSET=utf8 COMMENT='購物車表'; -- ---------------------------- -- Table structure for eb_store_category -- ---------------------------- DROP TABLE IF EXISTS `eb_store_category`; CREATE TABLE `eb_store_category` ( `store_category_id` mediumint(11) NOT NULL AUTO_INCREMENT COMMENT '商品分類表ID', `pid` mediumint(11) NOT NULL COMMENT '父id', `cate_name` varchar(100) NOT NULL COMMENT '分類名稱', `path` varchar(255) NOT NULL DEFAULT '' COMMENT '路徑', `sort` mediumint(11) NOT NULL COMMENT '排序', `pic` varchar(128) NOT NULL DEFAULT '' COMMENT '圖標', `is_show` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否顯示', `level` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '等級', `mer_id` int(11) unsigned DEFAULT '0' COMMENT '商戶id', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '添加時間', PRIMARY KEY (`store_category_id`) USING BTREE, KEY `pid` (`pid`) USING BTREE, KEY `sort` (`sort`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=697 DEFAULT CHARSET=utf8 COMMENT='商品分類表'; -- ---------------------------- -- Table structure for eb_store_coupon -- ---------------------------- DROP TABLE IF EXISTS `eb_store_coupon`; CREATE TABLE `eb_store_coupon` ( `coupon_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '優惠券表ID', `mer_id` int(10) unsigned NOT NULL COMMENT '商戶 id', `is_timeout` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否限時', `start_time` timestamp NULL DEFAULT NULL COMMENT '優惠券領取開啟時間', `end_time` timestamp NULL DEFAULT NULL COMMENT '優惠券領取結束時間', `is_limited` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否限量', `total_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '優惠券領取數量', `remain_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '優惠券剩余領取數量', `send_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0=領取 1=消費滿贈 2=新人 3=買增', `full_reduction` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '消費滿多少贈送優惠券', `title` varchar(64) 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 '最低消費多少金額可用優惠券', `coupon_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '優惠券類型 0=有效天數 1=固定時間段', `coupon_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '優惠券有效期限（單位：天）', `use_start_time` timestamp NULL DEFAULT NULL COMMENT '開始時間', `use_end_time` timestamp NULL DEFAULT NULL COMMENT '到期時間', `sort` int(11) unsigned NOT NULL DEFAULT '1' COMMENT '排序', `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '狀態（0：關閉，1：開啟 -1: 失效）', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加時間', `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否刪除', `type` tinyint(2) NOT NULL DEFAULT '0' COMMENT '優惠券類型 0-店鋪 1-商品券', PRIMARY KEY (`coupon_id`) USING BTREE, KEY `mer_id` (`mer_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=430 DEFAULT CHARSET=utf8 COMMENT='優惠券表'; -- ---------------------------- -- 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) NOT NULL DEFAULT '0' COMMENT '領取優惠券用戶ID', `coupon_id` int(10) NOT NULL DEFAULT '0' COMMENT '優惠券ID', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '領取時間', KEY `uid` (`uid`,`coupon_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='優惠券前臺用戶領取記錄表'; -- ---------------------------- -- Table structure for eb_store_coupon_product -- ---------------------------- DROP TABLE IF EXISTS `eb_store_coupon_product`; CREATE TABLE `eb_store_coupon_product` ( `product_id` int(11) NOT NULL DEFAULT '0' COMMENT '產品id', `coupon_id` int(11) NOT NULL DEFAULT '0' COMMENT '優惠卷id', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加時間' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='優惠卷關聯商品輔助表'; -- ---------------------------- -- Table structure for eb_store_coupon_send -- ---------------------------- DROP TABLE IF EXISTS `eb_store_coupon_send`; CREATE TABLE `eb_store_coupon_send` ( `coupon_send_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `mer_id` int(10) unsigned NOT NULL COMMENT '商戶 id', `coupon_id` int(10) unsigned NOT NULL COMMENT '優惠券 id', `coupon_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '發送數量', `mark` varchar(512) NOT NULL COMMENT '發送群體', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創建時間', `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0:發送中 1:全部發送', PRIMARY KEY (`coupon_send_id`), KEY `mer_id` (`mer_id`), KEY `coupon_id` (`coupon_id`) ) ENGINE=InnoDB AUTO_INCREMENT=91 DEFAULT CHARSET=utf8 COMMENT='優惠券發送記錄'; -- ---------------------------- -- Table structure for eb_store_coupon_user -- ---------------------------- DROP TABLE IF EXISTS `eb_store_coupon_user`; CREATE TABLE `eb_store_coupon_user` ( `coupon_user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '優惠券發放記錄id', `coupon_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '兌換的項目id', `mer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商戶 id', `uid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '優惠券所屬用戶', `coupon_title` varchar(32) 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 '最低消費多少金額可用優惠券', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '優惠券創建時間', `start_time` timestamp NULL DEFAULT NULL COMMENT '優惠券開啟時間', `end_time` timestamp NULL DEFAULT NULL COMMENT '優惠券結束時間', `use_time` timestamp NULL DEFAULT NULL COMMENT '使用時間', `type` varchar(16) NOT NULL DEFAULT 'send' COMMENT '獲取方式(receive:自己領取 send:后臺發送 give:滿贈 new:新人 buy:買贈送)', `send_id` int(10) unsigned DEFAULT '0' COMMENT '批量發送 id', `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '狀態（0：未使用，1：已使用, 2:已過期）', `is_fail` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否有效', PRIMARY KEY (`coupon_user_id`) USING BTREE, KEY `coupon_id` (`coupon_id`) USING BTREE, KEY `uid` (`uid`) USING BTREE, KEY `type` (`type`,`send_id`) ) ENGINE=InnoDB AUTO_INCREMENT=10407 DEFAULT CHARSET=utf8 COMMENT='優惠券發放記錄表'; -- ---------------------------- -- Table structure for eb_store_group_order -- ---------------------------- DROP TABLE IF EXISTS `eb_store_group_order`; CREATE TABLE `eb_store_group_order` ( `group_order_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `group_order_sn` varchar(32) NOT NULL COMMENT '訂單號', `uid` int(10) unsigned NOT NULL COMMENT '用戶 ID', `total_postage` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '郵費', `total_price` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '訂單總額', `total_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商品數', `integral` int(8) unsigned DEFAULT '0' COMMENT '使用積分數量', `integral_price` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '積分抵扣金額', `give_integral` int(8) unsigned DEFAULT '0' COMMENT '贈送積分', `coupon_price` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '優惠金額', `real_name` varchar(32) NOT NULL COMMENT '聯系人', `user_phone` varchar(18) NOT NULL COMMENT '聯系電話', `user_address` varchar(128) NOT NULL COMMENT '收貨地址', `pay_price` decimal(8,2) unsigned NOT NULL COMMENT '支付金額', `pay_postage` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '支付郵費', `cost` decimal(8,2) unsigned NOT NULL COMMENT '成本價', `give_coupon_ids` varchar(500) DEFAULT '' COMMENT '贈送優惠券', `paid` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否支付', `pay_time` timestamp NULL DEFAULT NULL COMMENT '支付時間', `pay_type` tinyint(1) NOT NULL COMMENT '支付方式 0=余額 1=微信 2=小程序 3=h5', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創建時間', `is_remind` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否提醒', `is_del` tinyint(3) unsigned NOT NULL DEFAULT '0', `is_combine` tinyint(1) unsigned DEFAULT '0' COMMENT '是否為合并支付 ', PRIMARY KEY (`group_order_id`) USING BTREE, UNIQUE KEY `group_order_id` (`group_order_sn`) USING BTREE, KEY `uid` (`uid`) USING BTREE, KEY `paid` (`paid`) USING BTREE, KEY `create_time` (`create_time`,`paid`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=4076 DEFAULT CHARSET=utf8 COMMENT='用戶訂單表'; -- ---------------------------- -- Table structure for eb_store_import -- ---------------------------- DROP TABLE IF EXISTS `eb_store_import`; CREATE TABLE `eb_store_import` ( `import_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `import_type` varchar(20) DEFAULT NULL COMMENT 'delivery發貨單', `type` int(11) DEFAULT '1' COMMENT '類型：1發貨，2送貨，3虛擬，4電子面單', `count` int(11) DEFAULT NULL COMMENT '總數', `success` int(11) DEFAULT NULL COMMENT '成功數', `status` int(2) DEFAULT '0' COMMENT '0.處理中，1成功，10部分完成，-1失敗', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `mer_id` int(11) DEFAULT NULL, PRIMARY KEY (`import_id`) ) ENGINE=InnoDB AUTO_INCREMENT=151 DEFAULT CHARSET=utf8 COMMENT='導入批次記錄'; -- ---------------------------- -- Table structure for eb_store_import_delivery -- ---------------------------- DROP TABLE IF EXISTS `eb_store_import_delivery`; CREATE TABLE `eb_store_import_delivery` ( `import_delivery_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `import_id` int(10) unsigned NOT NULL, `order_sn` varchar(32) DEFAULT NULL COMMENT '訂單sn', `delivery_type` int(11) DEFAULT '1' COMMENT '類型：1發貨，2送貨，3虛擬，4電子面單', `delivery_name` varchar(64) DEFAULT NULL COMMENT '快遞公司', `delivery_id` varchar(64) DEFAULT NULL COMMENT '快遞單號', `status` tinyint(2) DEFAULT NULL COMMENT '狀態', `mark` varchar(255) DEFAULT NULL COMMENT '備注', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `mer_id` int(11) DEFAULT NULL, PRIMARY KEY (`import_delivery_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=632 DEFAULT CHARSET=utf8 COMMENT='導入發貨單詳細記錄'; -- ---------------------------- -- Table structure for eb_store_order -- ---------------------------- DROP TABLE IF EXISTS `eb_store_order`; CREATE TABLE `eb_store_order` ( `order_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '訂單ID', `group_order_id` int(11) DEFAULT NULL COMMENT '訂單組 id', `order_sn` varchar(32) NOT NULL COMMENT '訂單號', `uid` int(11) unsigned NOT NULL COMMENT '用戶id', `spread_uid` int(11) unsigned DEFAULT '0' COMMENT '推薦人id', `top_uid` int(11) unsigned DEFAULT '0' COMMENT '二級推薦人 id', `real_name` varchar(32) NOT NULL COMMENT '用戶姓名', `user_phone` varchar(18) NOT NULL COMMENT '用戶電話', `user_address` varchar(128) NOT NULL COMMENT '詳細地址', `cart_id` varchar(256) NOT NULL COMMENT '購物車id', `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 '支付郵費', `is_selfbuy` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否為自購', `extension_one` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '一級傭金', `extension_two` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '二級傭金', `commission_rate` decimal(6,4) unsigned NOT NULL DEFAULT '0.0000' COMMENT '平臺手續費', `integral` int(8) unsigned DEFAULT '0' COMMENT '使用積分數量', `integral_price` decimal(8,2) unsigned DEFAULT '0.00' COMMENT '積分抵扣金額', `give_integral` int(8) unsigned DEFAULT '0' COMMENT '贈送積分', `coupon_id` varchar(128) NOT NULL DEFAULT '' COMMENT '優惠券id', `coupon_price` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '優惠券金額', `order_type` tinyint(1) unsigned DEFAULT '0' COMMENT '0普通1自提', `paid` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '支付狀態', `pay_time` timestamp NULL DEFAULT NULL COMMENT '支付時間', `pay_type` tinyint(1) NOT NULL COMMENT '支付方式 0余額 1微信 2小程序 3 h5 4支付寶 5 支付寶掃碼 6 微信掃碼', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創建時間', `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '訂單狀態（0：待發貨；1：待收貨；2：待評價；3：已完成；-1：已退款）', `delivery_type` varchar(32) DEFAULT NULL COMMENT '發貨類型(1:發貨 2: 送貨 3: 虛擬)', `delivery_name` varchar(64) DEFAULT NULL COMMENT '快遞名稱/送貨人姓名', `delivery_id` varchar(64) DEFAULT NULL COMMENT '快遞單號/手機號', `mark` varchar(512) NOT NULL COMMENT '備注', `remark` varchar(512) DEFAULT NULL COMMENT '管理員備注', `admin_mark` varchar(512) DEFAULT NULL COMMENT '總后臺備注', `verify_code` char(16) DEFAULT NULL COMMENT '核銷碼', `verify_time` timestamp NULL DEFAULT NULL COMMENT '核銷時間/收貨時間', `verify_service_id` int(10) unsigned DEFAULT NULL COMMENT '核銷客服 id', `transaction_id` varchar(60) DEFAULT NULL COMMENT '微信支付訂單號(分賬時有效)', `activity_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1:秒殺 2:預售 3:助力', `mer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商戶ID', `reconciliation_id` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '對賬id', `cost` decimal(8,2) unsigned NOT NULL COMMENT '成本價', `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否刪除', `is_system_del` tinyint(1) DEFAULT '0' COMMENT '后臺是否刪除', PRIMARY KEY (`order_id`) USING BTREE, UNIQUE KEY `order_id_2` (`order_id`) USING BTREE, KEY `uid` (`uid`) USING BTREE, KEY `mer_id` (`mer_id`) USING BTREE, KEY `verify_code` (`verify_code`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=4165 DEFAULT CHARSET=utf8 COMMENT='訂單表'; -- ---------------------------- -- Table structure for eb_store_order_product -- ---------------------------- DROP TABLE IF EXISTS `eb_store_order_product`; CREATE TABLE `eb_store_order_product` ( `order_product_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '訂單產品 id', `order_id` int(11) unsigned NOT NULL COMMENT '訂單id', `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用戶 id', `cart_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '購物車id', `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商品ID', `extension_one` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '一級傭金', `extension_two` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '二級傭金', `integral` int(8) unsigned DEFAULT '0' COMMENT '使用積分', `product_sku` char(12) NOT NULL COMMENT '商品 sku', `is_refund` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否退款 0:未退款 1:退款中 2:部分退款 3=全退', `product_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '購買數量', `product_type` int(11) NOT NULL DEFAULT '0' COMMENT '0.普通商品 1.秒殺商品,2.預售商品', `activity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '活動關聯 id', `refund_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '可申請退貨數量', `is_reply` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否評價', `product_price` decimal(10,2) unsigned NOT NULL COMMENT '商品金額', `cart_info` text NOT NULL COMMENT '購買東西的詳細信息', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`order_product_id`) USING BTREE, KEY `product_id` (`product_id`) USING BTREE, KEY `oid` (`order_id`) USING BTREE, KEY `uid` (`uid`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=4214 DEFAULT CHARSET=utf8 COMMENT='訂單購物詳情表'; -- ---------------------------- -- Table structure for eb_store_order_profitsharing -- ---------------------------- DROP TABLE IF EXISTS `eb_store_order_profitsharing`; CREATE TABLE `eb_store_order_profitsharing` ( `profitsharing_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `profitsharing_sn` varchar(32) NOT NULL COMMENT '分賬 id', `order_id` int(10) unsigned NOT NULL COMMENT '訂單 id', `mer_id` int(10) unsigned NOT NULL COMMENT '商戶 id', `transaction_id` varchar(60) NOT NULL COMMENT '微信支付訂單號', `profitsharing_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '分賬金額', `profitsharing_refund` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '退款金額', `profitsharing_mer_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '分賬給商戶金額', `type` varchar(32) NOT NULL COMMENT '分類', `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0:未分賬 1:已分賬 -1已退款 -2失敗', `error_msg` varchar(255) DEFAULT NULL COMMENT '失敗原因', `profitsharing_time` timestamp NULL DEFAULT NULL COMMENT '分賬時間', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創建時間', PRIMARY KEY (`profitsharing_id`), KEY `order_id` (`order_id`), KEY `mer_id` (`mer_id`) ) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8 COMMENT='分賬表'; -- ---------------------------- -- Table structure for eb_store_order_receipt -- ---------------------------- DROP TABLE IF EXISTS `eb_store_order_receipt`; CREATE TABLE `eb_store_order_receipt` ( `order_receipt_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `order_id` varchar(255) NOT NULL DEFAULT '0' COMMENT '訂單ID', `uid` int(11) NOT NULL DEFAULT '0' COMMENT '用戶ID', `receipt_info` varchar(500) DEFAULT '' COMMENT '發票類型：1.普通發票，2.增值稅發票', `status` tinyint(2) DEFAULT '0' COMMENT '開票狀態：1.已出票,10.已寄出', `receipt_sn` varchar(255) DEFAULT '' COMMENT '發票單號', `receipt_no` varchar(255) DEFAULT NULL COMMENT '發票編號', `delivery_info` varchar(255) DEFAULT NULL COMMENT '收票聯系信息', `mark` varchar(255) DEFAULT NULL COMMENT '用戶備注', `receipt_price` decimal(10,2) DEFAULT NULL COMMENT '開票金額', `order_price` decimal(10,2) DEFAULT NULL COMMENT '訂單金額', `status_time` datetime NOT NULL COMMENT '狀態變更時間', `is_del` tinyint(1) DEFAULT '0', `create_time` timestamp NULL DEFAULT NULL, `mer_id` int(11) DEFAULT '0', `mer_mark` varchar(255) DEFAULT NULL COMMENT '備注', PRIMARY KEY (`order_receipt_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=188 DEFAULT CHARSET=utf8 COMMENT='訂單發票信息'; -- ---------------------------- -- Table structure for eb_store_order_status -- ---------------------------- DROP TABLE IF EXISTS `eb_store_order_status`; CREATE TABLE `eb_store_order_status` ( `order_id` int(10) unsigned NOT NULL COMMENT '訂單id', `change_type` varchar(32) NOT NULL COMMENT '操作類型', `change_message` varchar(256) NOT NULL COMMENT '操作備注', `change_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '操作時間', KEY `order_id` (`order_id`) USING BTREE, KEY `change_type` (`change_type`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='訂單操作記錄表'; -- ---------------------------- -- Table structure for eb_store_product -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product`; CREATE TABLE `eb_store_product` ( `product_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '商品id', `mer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商戶Id', `store_name` varchar(128) NOT NULL COMMENT '商品名稱', `store_info` varchar(256) NOT NULL COMMENT '商品簡介', `keyword` varchar(128) NOT NULL COMMENT '關鍵字', `bar_code` varchar(15) NOT NULL DEFAULT '' COMMENT '產品條碼（一維碼）', `brand_id` int(11) DEFAULT NULL COMMENT '品牌 id', `is_show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '商戶狀態（0：未上架，1：上架）', `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '管理員狀態（0：審核中，1：審核通過 -1: 未通過 -2: 下架）', `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否刪除', `mer_status` tinyint(1) DEFAULT '1' COMMENT '商鋪狀態是否 1.正常 0. 非正常', `cate_id` int(11) NOT NULL COMMENT '分類id', `unit_name` varchar(16) NOT NULL COMMENT '單位名', `sort` smallint(11) NOT NULL DEFAULT '0' COMMENT '排序', `rank` smallint(11) NOT NULL DEFAULT '0' COMMENT '總后臺排序', `sales` mediumint(11) unsigned NOT NULL DEFAULT '0' COMMENT '銷量', `price` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '最低價格', `cost` decimal(10,2) DEFAULT '0.00' COMMENT '成本價', `ot_price` decimal(10,2) DEFAULT '0.00' COMMENT '原價', `stock` int(11) unsigned DEFAULT '0' COMMENT '總庫存', `is_hot` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否熱賣', `is_benefit` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '促銷單品', `is_best` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否精品', `is_new` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否新品', `is_good` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否優品推薦', `product_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0.普通商品 1.秒殺商品,2.預售商品，3.助力商品', `ficti` mediumint(11) DEFAULT '0' COMMENT '虛擬銷量', `browse` int(11) DEFAULT '0' COMMENT '瀏覽量', `code_path` varchar(64) NOT NULL DEFAULT '' COMMENT '產品二維碼地址(用戶小程序海報)', `video_link` varchar(200) 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多', `extension_type` tinyint(1) DEFAULT '0' COMMENT '傭金比例 0.系統，1.自定義', `refusal` varchar(255) DEFAULT NULL COMMENT '審核拒絕理由', `rate` decimal(2,1) DEFAULT '3.0' COMMENT '評價分數', `reply_count` int(11) unsigned DEFAULT '0' COMMENT '評論數', `give_coupon_ids` varchar(500) DEFAULT NULL COMMENT '贈送優惠券', `is_gift_bag` tinyint(1) DEFAULT '0' COMMENT '是否為禮包', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加時間', `care_count` int(11) NOT NULL DEFAULT '0' COMMENT '收藏數', `is_used` int(1) DEFAULT '1' COMMENT '顯示/隱藏', `old_product_id` int(11) DEFAULT '0' COMMENT '原商品ID', `image` varchar(256) NOT NULL COMMENT '商品圖片', `slider_image` varchar(2000) NOT NULL COMMENT '輪播圖', `guarantee_template_id` int(11) DEFAULT '0' COMMENT '保障服務模板', `once_count` int(11) DEFAULT '0' COMMENT '訂單單次購買數量最大限制', `integral_rate` int(11) NOT NULL DEFAULT '-1' COMMENT '積分抵扣比例', `integral_total` int(10) unsigned DEFAULT '0' COMMENT '使用積分抵扣總數', `integral_price_total` decimal(8,2) unsigned DEFAULT '0.00' COMMENT '使用積分抵扣金額總數', `labels` varchar(255) DEFAULT '' COMMENT '標簽id', `delivery_way` varchar(100) DEFAULT NULL COMMENT '1.僅到店自提2快遞計價配送3全國包郵', `delivery_free` int(11) DEFAULT '0' COMMENT '全國包郵', PRIMARY KEY (`product_id`) USING BTREE, KEY `cate_id` (`cate_id`) USING BTREE, KEY `sort` (`sort`) USING BTREE, KEY `sales` (`sales`) USING BTREE, KEY `create_time` (`create_time`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=1416 DEFAULT CHARSET=utf8 COMMENT='商品表'; -- ---------------------------- -- Table structure for eb_store_product_assist -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_assist`; CREATE TABLE `eb_store_product_assist` ( `product_assist_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `start_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '開始時間', `end_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '結束時間', `status` int(11) unsigned NOT NULL DEFAULT '1' COMMENT '平臺控制狀態：1開啟，0.結束', `pay_count` int(11) unsigned DEFAULT '0' COMMENT '限購數量，0為不限制', `assist_count` int(11) unsigned DEFAULT '0' COMMENT '助力總需人數', `assist_user_count` int(11) unsigned DEFAULT '0' COMMENT '單人可助力次數', `product_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商品ID', `is_show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '商戶控制狀態 0.下架；1.上架', `store_name` varchar(128) NOT NULL COMMENT '商品活動標題', `mer_id` int(11) unsigned NOT NULL DEFAULT '0', `store_info` varchar(255) DEFAULT NULL COMMENT '商品簡介', `is_del` int(11) unsigned NOT NULL DEFAULT '0', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `product_status` int(11) DEFAULT '0' COMMENT '審核狀態；0.待審核，1審核通過，-1 審核失敗，-2 強制下架', `refusal` varchar(255) DEFAULT NULL, `action_status` int(11) DEFAULT '1' COMMENT '活動狀態1開啟，-1 結束', PRIMARY KEY (`product_assist_id`) USING BTREE, KEY `start_time` (`start_time`,`end_time`), KEY `product_id` (`product_id`), KEY `mer_id` (`mer_id`) ) ENGINE=InnoDB AUTO_INCREMENT=187 DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for eb_store_product_assist_set -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_assist_set`; CREATE TABLE `eb_store_product_assist_set` ( `product_assist_set_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `product_assist_id` int(11) unsigned NOT NULL, `product_id` int(11) unsigned NOT NULL, `uid` int(11) unsigned NOT NULL DEFAULT '0', `status` int(11) NOT NULL DEFAULT '1' COMMENT '狀態：-1 未完成，1 進行中， 10 已完成，20.已支付', `assist_count` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '需助力總人數', `assist_user_count` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '單人可助力次數', `yet_assist_count` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '已助力人數', `create_time` timestamp NOT NULL COMMENT '時間', `mer_id` int(11) unsigned DEFAULT '0', `share_num` int(11) unsigned DEFAULT '0', `view_num` int(11) unsigned DEFAULT '0', `is_del` int(11) unsigned DEFAULT '0', PRIMARY KEY (`product_assist_set_id`) USING BTREE, KEY `product_assist_id` (`product_assist_id`,`product_id`) USING BTREE, KEY `uid` (`uid`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=512 DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for eb_store_product_assist_sku -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_assist_sku`; CREATE TABLE `eb_store_product_assist_sku` ( `product_assist_id` int(11) unsigned NOT NULL DEFAULT '0', `product_id` int(11) unsigned NOT NULL, `unique` char(12) NOT NULL, `assist_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '助力售價', `stock` int(11) unsigned NOT NULL DEFAULT '0', `stock_count` int(11) unsigned DEFAULT '0' COMMENT '總限購', KEY `product_assist_id` (`product_assist_id`,`product_id`) USING BTREE, KEY `unique` (`unique`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for eb_store_product_assist_user -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_assist_user`; CREATE TABLE `eb_store_product_assist_user` ( `product_assist_user_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `product_assist_set_id` int(11) unsigned NOT NULL, `product_assist_id` int(11) unsigned NOT NULL, `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'id', `avatar_img` varchar(256) DEFAULT NULL COMMENT '頭像', `nickname` varchar(50) DEFAULT NULL COMMENT '昵稱', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`product_assist_user_id`), KEY `uid` (`uid`,`product_assist_set_id`) USING BTREE, KEY `product_assist_id` (`product_assist_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=165 DEFAULT CHARSET=utf8; -- ---------------------------- -- 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) NOT NULL COMMENT '屬性名', `attr_values` varchar(2000) NOT NULL COMMENT '屬性值', `type` tinyint(1) DEFAULT '0' COMMENT '活動類型 0=商品', KEY `product_id` (`product_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商品屬性表'; -- ---------------------------- -- 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', `detail` varchar(1000) NOT NULL DEFAULT '', `sku` varchar(128) NOT NULL COMMENT '商品屬性索引值 (attr_value|attr_value[|....])', `stock` int(10) unsigned NOT NULL COMMENT '屬性對應的庫存', `sales` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '銷量', `image` varchar(128) DEFAULT NULL COMMENT '圖片', `bar_code` varchar(50) NOT NULL DEFAULT '' COMMENT '產品條碼', `cost` decimal(8,2) unsigned NOT NULL COMMENT '成本價', `ot_price` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '原價', `price` decimal(8,2) unsigned NOT NULL COMMENT '價格', `volume` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '體積', `weight` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '重量', `type` tinyint(1) DEFAULT '0' COMMENT '活動類型 0=商品', `extension_one` decimal(8,2) DEFAULT '0.00' COMMENT '一級傭金', `extension_two` decimal(8,2) DEFAULT '0.00' COMMENT '二級傭金', `unique` char(12) NOT NULL DEFAULT '' COMMENT '唯一值', KEY `store_id` (`product_id`,`sku`) USING BTREE, KEY `unique` (`unique`,`sku`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商品屬性值表'; -- ---------------------------- -- Table structure for eb_store_product_cate -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_cate`; CREATE TABLE `eb_store_product_cate` ( `product_id` int(11) DEFAULT NULL, `mer_cate_id` int(11) DEFAULT NULL, `mer_id` int(11) DEFAULT NULL, KEY `mer_id` (`mer_id`) USING BTREE, KEY `mer_cate_id` (`mer_cate_id`,`product_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商品商戶分類關聯表'; -- ---------------------------- -- Table structure for eb_store_product_content -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_content`; CREATE TABLE `eb_store_product_content` ( `product_id` int(11) unsigned NOT NULL COMMENT '商品id', `content` longtext NOT NULL COMMENT '商品詳情', `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '商品類型 0=普通', KEY `product_id` (`product_id`,`type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商品詳情表'; -- ---------------------------- -- Table structure for eb_store_product_copy -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_copy`; CREATE TABLE `eb_store_product_copy` ( `store_product_copy_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `type` varchar(255) DEFAULT NULL COMMENT '''taobao'', ''tmall'', ''jd'', ''pinduoduo'', ''suning'', ''yangkeduo''\n', `mer_id` int(11) DEFAULT NULL COMMENT '商戶id', `num` int(11) DEFAULT NULL COMMENT '數量', `number` int(11) DEFAULT '1' COMMENT '剩余數量', `message` varchar(255) DEFAULT NULL, `info` varchar(500) DEFAULT '1' COMMENT '信息', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`store_product_copy_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=672 DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for eb_store_product_group -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_group`; CREATE TABLE `eb_store_product_group` ( `product_group_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主鍵ID', `product_id` int(11) unsigned DEFAULT '0' COMMENT '商品ID', `start_time` datetime DEFAULT NULL COMMENT '開始時間', `end_time` datetime DEFAULT NULL COMMENT '結束時間', `time` int(10) unsigned DEFAULT '0' COMMENT '開團時長', `buying_count_num` int(11) DEFAULT '0' COMMENT '拼團總人數', `buying_num` int(11) DEFAULT '0' COMMENT '最少真實購買人數', `pay_count` int(11) unsigned DEFAULT '0' COMMENT '活動購買總人數', `once_pay_count` int(11) unsigned DEFAULT '0' COMMENT '單次購買數量', `status` int(11) DEFAULT '0' COMMENT '平臺控制狀態', `mer_id` int(11) unsigned DEFAULT '0' COMMENT '商戶ID', `ficti_status` int(11) DEFAULT '0' COMMENT '虛擬成團狀態', `ficti_num` int(11) DEFAULT '0' COMMENT '最多虛擬人數', `is_show` int(11) DEFAULT '0' COMMENT '上下架', `is_del` int(11) unsigned DEFAULT '0', `success_num` int(11) unsigned DEFAULT '0' COMMENT '成功團數', `product_status` int(11) DEFAULT '0', `price` decimal(10,2) DEFAULT '0.00', `action_status` int(11) DEFAULT '0' COMMENT '活動狀態', `create_time` datetime DEFAULT NULL, `refusal` varchar(255) DEFAULT NULL, PRIMARY KEY (`product_group_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=163 DEFAULT CHARSET=utf8 COMMENT='拼團商品信息表'; -- ---------------------------- -- Table structure for eb_store_product_group_buying -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_group_buying`; CREATE TABLE `eb_store_product_group_buying` ( `group_buying_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `product_group_id` int(11) unsigned DEFAULT '0' COMMENT '活動商品ID', `status` int(11) DEFAULT '0' COMMENT '狀態：0。默認，進行中，10.已完成，-1 時間到未完成', `ficti_status` int(11) DEFAULT '0' COMMENT '虛擬成團狀態0.未開啟，1開啟', `ficti_num` int(11) unsigned DEFAULT '0' COMMENT '虛擬成團人數', `buying_count_num` int(11) unsigned DEFAULT '0' COMMENT '成團總人數', `buying_num` int(11) unsigned DEFAULT '0' COMMENT '真實人數', `yet_buying_num` int(11) unsigned DEFAULT '0' COMMENT '已參團人數', `is_del` int(11) DEFAULT '0', `mer_id` int(11) unsigned DEFAULT '0', `end_time` int(11) DEFAULT NULL COMMENT '結束時間', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`group_buying_id`) ) ENGINE=InnoDB AUTO_INCREMENT=260 DEFAULT CHARSET=utf8 COMMENT='拼團活動表'; -- ---------------------------- -- Table structure for eb_store_product_group_sku -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_group_sku`; CREATE TABLE `eb_store_product_group_sku` ( `product_group_id` int(11) unsigned NOT NULL DEFAULT '0', `product_id` int(11) unsigned NOT NULL, `unique` char(12) NOT NULL, `active_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '活動價', `stock` int(11) unsigned NOT NULL DEFAULT '0', `stock_count` int(11) unsigned DEFAULT '0', KEY `product_group_id` (`product_group_id`,`product_id`), KEY `unique` (`unique`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for eb_store_product_group_user -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_group_user`; CREATE TABLE `eb_store_product_group_user` ( `group_buying_id` int(11) unsigned DEFAULT '0' COMMENT '團ID', `product_group_id` int(11) unsigned DEFAULT '0' COMMENT '活動商品ID', `status` int(11) DEFAULT '0' COMMENT '狀態', `is_initiator` int(11) unsigned DEFAULT '0' COMMENT '是否為團長', `order_id` int(11) unsigned DEFAULT '0' COMMENT '訂單ID', `uid` int(11) unsigned DEFAULT '0' COMMENT '用戶ID ', `nickname` varchar(255) DEFAULT NULL COMMENT '昵稱', `avatar` varchar(255) DEFAULT NULL COMMENT '頭像', `is_del` int(11) unsigned DEFAULT '0', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='拼團成員表'; -- ---------------------------- -- Table structure for eb_store_product_label -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_label`; CREATE TABLE `eb_store_product_label` ( `product_label_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `label_name` varchar(50) DEFAULT NULL COMMENT '標簽名', `status` tinyint(1) DEFAULT NULL COMMENT '狀態', `info` varchar(255) DEFAULT NULL COMMENT '說明', `sort` int(11) DEFAULT NULL COMMENT '排序', `type` int(11) DEFAULT '0' COMMENT '類型 ', `mer_id` int(11) DEFAULT '0' COMMENT '商戶ID', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `is_del` tinyint(1) DEFAULT '0', PRIMARY KEY (`product_label_id`) ) ENGINE=InnoDB AUTO_INCREMENT=88 DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for eb_store_product_presell -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_presell`; CREATE TABLE `eb_store_product_presell` ( `product_presell_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `start_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '預售開始時間', `end_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '預售結束時間', `final_start_time` varchar(30) DEFAULT '' COMMENT '尾款支付開始時間', `final_end_time` varchar(30) DEFAULT '' COMMENT '尾款支付結時間', `status` int(11) unsigned NOT NULL DEFAULT '1' COMMENT '平臺控制狀態：1開啟，0.結束', `presell_type` int(1) unsigned NOT NULL DEFAULT '0' COMMENT '預售類型：1.全款預售，2.定金預售', `pay_count` int(11) unsigned DEFAULT '0' COMMENT '限購數量，0為不限制', `delivery_type` int(2) unsigned NOT NULL DEFAULT '0' COMMENT '發貨類型：1.支付成功后； 2. 預售結束后', `delivery_day` int(11) unsigned DEFAULT '0' COMMENT '發貨時間', `product_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商品ID', `price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '預售最低價', `is_show` tinyint(1) unsigned DEFAULT NULL COMMENT '商戶控制狀態 0.下架；1.上架', `store_name` varchar(128) NOT NULL COMMENT '商品活動標題', `mer_id` int(11) unsigned NOT NULL DEFAULT '0', `store_info` varchar(255) DEFAULT NULL COMMENT '商品簡介', `is_del` int(11) unsigned NOT NULL DEFAULT '0', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `product_status` int(11) DEFAULT '0' COMMENT '審核狀態；0.待審核，1審核通過，-1 審核失敗，-2 強制下架', `refusal` varchar(255) DEFAULT NULL, `action_status` int(11) DEFAULT '1' COMMENT '活動狀態1開啟，-1 結束', PRIMARY KEY (`product_presell_id`), KEY `start_time` (`start_time`,`end_time`) USING BTREE, KEY `product_id` (`product_id`) USING BTREE, KEY `mer_id` (`mer_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=316 DEFAULT CHARSET=utf8 COMMENT='商品預售活動表'; -- ---------------------------- -- Table structure for eb_store_product_presell_sku -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_presell_sku`; CREATE TABLE `eb_store_product_presell_sku` ( `product_presell_id` int(11) unsigned NOT NULL DEFAULT '0', `product_id` int(11) unsigned NOT NULL, `unique` char(12) NOT NULL, `presell_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '預售價', `stock` int(11) unsigned NOT NULL DEFAULT '0', `stock_count` int(11) NOT NULL DEFAULT '0' COMMENT '總限購', `down_price` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '訂金', `final_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '尾款金額', `one_take` int(11) unsigned DEFAULT '0' COMMENT '第一階段參與人數', `one_pay` int(11) unsigned DEFAULT '0' COMMENT '第一階段支付人數', `two_pay` int(11) unsigned DEFAULT '0' COMMENT '第二階段支付人數', `seles` int(11) unsigned DEFAULT '0' COMMENT '銷量', KEY `product_presell_id` (`product_presell_id`,`product_id`) USING BTREE, KEY `unique` (`unique`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for eb_store_product_reply -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_reply`; CREATE TABLE `eb_store_product_reply` ( `reply_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '評論ID', `uid` int(11) NOT NULL COMMENT '用戶ID', `mer_id` int(10) unsigned NOT NULL COMMENT '商戶 id', `order_product_id` int(11) NOT NULL COMMENT '訂單商品ID', `unique` char(12) DEFAULT NULL COMMENT '商品 sku', `product_id` int(11) NOT NULL COMMENT '商品id', `product_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0=普通商品', `product_score` tinyint(1) NOT NULL COMMENT '商品分數', `service_score` tinyint(1) NOT NULL COMMENT '服務分數', `postage_score` tinyint(1) NOT NULL COMMENT '物流分數', `rate` float(2,1) DEFAULT '5.0' COMMENT '平均值', `comment` varchar(512) NOT NULL COMMENT '評論內容', `pics` text NOT NULL COMMENT '評論圖片', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '評論時間', `merchant_reply_content` varchar(300) DEFAULT NULL COMMENT '管理員回復內容', `merchant_reply_time` timestamp NULL DEFAULT NULL COMMENT '管理員回復時間', `sort` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT '商家排序', `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0未刪除1已刪除', `is_reply` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0未回復1已回復', `is_virtual` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0不是虛擬評價1是虛擬評價', `nickname` varchar(64) NOT NULL COMMENT '用戶名稱', `avatar` varchar(255) NOT NULL COMMENT '用戶頭像', PRIMARY KEY (`reply_id`) USING BTREE, UNIQUE KEY `order_id` (`order_product_id`,`unique`) USING BTREE, KEY `uid` (`uid`) USING BTREE, KEY `product_id` (`product_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=860 DEFAULT CHARSET=utf8 COMMENT='商品評論表'; -- ---------------------------- -- Table structure for eb_store_product_take -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_take`; CREATE TABLE `eb_store_product_take` ( `product_take_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `product_id` int(11) DEFAULT NULL, `unique` char(12) DEFAULT NULL, `status` int(2) unsigned DEFAULT '0' COMMENT '默認0，發送 1', `uid` int(11) DEFAULT NULL COMMENT '用戶', `type` varchar(255) DEFAULT NULL COMMENT '1.PC,2.公眾號,3.小程序', `is_del` int(11) DEFAULT '0', PRIMARY KEY (`product_take_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8 COMMENT='用戶到貨通知記錄'; -- ---------------------------- -- Table structure for eb_store_refund_order -- ---------------------------- DROP TABLE IF EXISTS `eb_store_refund_order`; CREATE TABLE `eb_store_refund_order` ( `refund_order_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '退款單id', `refund_order_sn` varchar(32) NOT NULL COMMENT '退款單號', `order_id` int(11) unsigned NOT NULL COMMENT '訂單id', `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用戶 id', `mer_id` int(10) unsigned NOT NULL COMMENT '商戶 id', `extension_one` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '退還一級傭金', `extension_two` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '退還二級傭金', `integral` int(8) unsigned DEFAULT '0' COMMENT '退還積分', `delivery_type` varchar(32) DEFAULT NULL COMMENT '快遞公司', `delivery_id` varchar(32) DEFAULT NULL COMMENT '快遞單號', `delivery_mark` varchar(200) DEFAULT NULL COMMENT '快遞備注', `delivery_pics` varchar(255) DEFAULT NULL COMMENT '快遞憑證', `delivery_phone` varchar(18) DEFAULT NULL COMMENT '聯系電話', `mer_delivery_user` varchar(32) DEFAULT NULL COMMENT '收貨人', `mer_delivery_address` varchar(32) DEFAULT NULL COMMENT '收貨地址', `phone` varchar(18) DEFAULT NULL COMMENT '聯系電話', `mark` varchar(200) DEFAULT NULL COMMENT '備注', `mer_mark` varchar(255) DEFAULT NULL COMMENT '商戶備注', `admin_mark` varchar(255) DEFAULT NULL COMMENT '平臺備注', `pics` varchar(255) DEFAULT NULL COMMENT '圖片', `refund_type` tinyint(1) NOT NULL COMMENT '退款類型 1:退款 2:退款退貨', `refund_message` varchar(128) NOT NULL COMMENT '退款原因', `refund_price` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '退款金額', `refund_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '退款數', `fail_message` varchar(200) DEFAULT NULL COMMENT '未通過原因', `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '狀態 0:待審核 -1:審核未通過 1:待退貨 2:待收貨 3:已退款', `status_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '狀態改變時間', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `reconciliation_id` int(10) unsigned DEFAULT '0' COMMENT '對賬id', `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0', `is_system_del` tinyint(1) DEFAULT '0' COMMENT '商戶刪除', PRIMARY KEY (`refund_order_id`) USING BTREE, UNIQUE KEY `refund_order_sn` (`refund_order_sn`) USING BTREE, KEY `oid` (`order_id`) USING BTREE, KEY `uid` (`uid`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=856 DEFAULT CHARSET=utf8 COMMENT='訂單退款表'; -- ---------------------------- -- Table structure for eb_store_refund_product -- ---------------------------- DROP TABLE IF EXISTS `eb_store_refund_product`; CREATE TABLE `eb_store_refund_product` ( `refund_product_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '訂單產品 id', `refund_order_id` int(10) unsigned NOT NULL COMMENT '退款單', `order_product_id` int(11) unsigned NOT NULL COMMENT '訂單產品id', `refund_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '退貨數', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`refund_product_id`) USING BTREE, KEY `refund_order_id` (`refund_order_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=933 DEFAULT CHARSET=utf8 COMMENT='退款單產品表'; -- ---------------------------- -- Table structure for eb_store_refund_status -- ---------------------------- DROP TABLE IF EXISTS `eb_store_refund_status`; CREATE TABLE `eb_store_refund_status` ( `refund_order_id` int(10) unsigned NOT NULL COMMENT '退款單訂單id', `change_type` varchar(32) NOT NULL COMMENT '操作類型', `change_message` varchar(256) NOT NULL COMMENT '操作備注', `change_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '操作時間', KEY `refund_order_id` (`refund_order_id`) USING BTREE, KEY `change_type` (`change_type`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='訂單操作記錄表'; -- ---------------------------- -- Table structure for eb_store_seckill_active -- ---------------------------- DROP TABLE IF EXISTS `eb_store_seckill_active`; CREATE TABLE `eb_store_seckill_active` ( `seckill_active_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID', `start_day` datetime NOT NULL COMMENT '開始日期', `end_day` datetime NOT NULL COMMENT '結束日期', `start_time` int(10) unsigned NOT NULL COMMENT '開始時間', `end_time` int(10) unsigned NOT NULL COMMENT '結束時間', `mer_id` int(11) unsigned NOT NULL COMMENT '商戶ID', `product_id` int(11) unsigned NOT NULL COMMENT '商品ID', `once_pay_count` int(11) unsigned DEFAULT '0' COMMENT '活動期間每人每日購買數量，0不限制', `all_pay_count` int(11) unsigned DEFAULT '0' COMMENT '全部活動期間，用戶購買總數限制，0不限制', `status` tinyint(1) unsigned DEFAULT '0' COMMENT '0.活動進行中，-1.活動過時', PRIMARY KEY (`seckill_active_id`) USING BTREE, KEY `start_day` (`start_day`,`end_day`) USING BTREE, KEY `mer_id` (`mer_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=250 DEFAULT CHARSET=utf8 COMMENT='商戶設置秒殺商品關聯表'; -- ---------------------------- -- Table structure for eb_store_seckill_time -- ---------------------------- DROP TABLE IF EXISTS `eb_store_seckill_time`; CREATE TABLE `eb_store_seckill_time` ( `seckill_time_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT '', `start_time` int(11) unsigned NOT NULL COMMENT '開始時間', `end_time` int(11) unsigned NOT NULL COMMENT '結束時間', `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1，0狀態', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `pic` varchar(255) DEFAULT NULL COMMENT '圖片', PRIMARY KEY (`seckill_time_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COMMENT='秒殺時間段配置'; -- ---------------------------- -- Table structure for eb_store_service -- ---------------------------- DROP TABLE IF EXISTS `eb_store_service`; CREATE TABLE `eb_store_service` ( `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) NOT NULL COMMENT '客服頭像', `nickname` varchar(50) NOT NULL COMMENT '代理名稱', `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0隱藏1顯示', `notify` int(2) DEFAULT '0' COMMENT '訂單通知1開啟0關閉', `phone` varchar(18) DEFAULT '' COMMENT '電話', `customer` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否展示統計管理', `is_verify` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否有核銷權限', `sort` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加時間', `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否刪除', PRIMARY KEY (`service_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=136 DEFAULT CHARSET=utf8 COMMENT='客服表'; -- ---------------------------- -- Table structure for eb_store_service_log -- ---------------------------- DROP TABLE IF EXISTS `eb_store_service_log`; CREATE TABLE `eb_store_service_log` ( `service_log_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '客服用戶對話記錄表ID', `mer_id` int(11) NOT NULL DEFAULT '0' COMMENT '商戶id', `msn` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_estonian_ci NOT NULL COMMENT '消息內容', `uid` int(11) NOT NULL COMMENT '發送人uid', `service_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '客服 id', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '發送時間', `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否已讀（0：否；1：是；）', `service_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '客服是否已讀（0：否；1：是；）', `remind` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否提醒過（0：否；1：是；）', `send_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0:用戶發送 1:客服回復', `msn_type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '消息類型 1=文字 2=表情 3=圖片 4=商品 5=訂單 6=退款單', PRIMARY KEY (`service_log_id`) USING BTREE, KEY `mer_id` (`mer_id`) USING BTREE, KEY `uid` (`uid`) USING BTREE, KEY `service_id` (`service_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=2922 DEFAULT CHARSET=utf8 COMMENT='客服用戶對話記錄表'; -- ---------------------------- -- Table structure for eb_store_spu -- ---------------------------- DROP TABLE IF EXISTS `eb_store_spu`; CREATE TABLE `eb_store_spu` ( `spu_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `mer_id` int(10) unsigned DEFAULT '0' COMMENT '商戶ID', `product_id` int(10) unsigned DEFAULT '0' COMMENT '商品ID', `product_type` int(255) unsigned DEFAULT '0' COMMENT '活動類型0普通，1秒殺，2預售，3助力', `activity_id` int(10) unsigned DEFAULT '0' COMMENT '活動ID', `status` int(11) DEFAULT '0' COMMENT '0.下架，1.上架', `store_name` varchar(128) DEFAULT NULL COMMENT '商品名稱', `keyword` varchar(255) DEFAULT NULL COMMENT '關鍵詞', `price` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '最低價格', `rank` int(11) DEFAULT NULL COMMENT '排序', `create_time` datetime DEFAULT NULL, `temp_id` int(11) unsigned DEFAULT '0' COMMENT '運費模板', `sort` int(11) unsigned DEFAULT '0' COMMENT '商戶排序', `star` int(11) DEFAULT '1' COMMENT '星級', `image` varchar(255) DEFAULT NULL COMMENT '主圖', `is_del` int(11) unsigned DEFAULT '0', `mer_labels` varchar(255) DEFAULT '' COMMENT '標簽id', `sys_labels` varchar(255) DEFAULT '' COMMENT '標簽id', PRIMARY KEY (`spu_id`), KEY `mer_id` (`mer_id`,`product_id`), KEY `activity_id` (`activity_id`,`product_type`) ) ENGINE=InnoDB AUTO_INCREMENT=2833 DEFAULT CHARSET=utf8 COMMENT='商品搜索信息表'; -- ---------------------------- -- Table structure for eb_system_admin -- ---------------------------- DROP TABLE IF EXISTS `eb_system_admin`; CREATE TABLE `eb_system_admin` ( `admin_id` int(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '后臺管理員表ID', `account` varchar(32) NOT NULL COMMENT '后臺管理員賬號', `pwd` varchar(64) NOT NULL COMMENT '后臺管理員密碼', `real_name` varchar(16) NOT NULL COMMENT '后臺管理員姓名', `phone` varchar(12) DEFAULT NULL COMMENT '聯系電話', `roles` varchar(128) NOT NULL COMMENT '后臺管理員權限(role_id), 多個逗號分隔', `last_ip` varchar(16) DEFAULT NULL COMMENT '后臺管理員最后一次登錄ip', `last_time` timestamp NULL DEFAULT NULL COMMENT '后臺管理員最后一次登錄時間', `login_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '登錄次數', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '后臺管理員狀態 1有效0無效', `level` tinyint(3) unsigned NOT NULL DEFAULT '1', `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '后臺管理員添加時間', `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '后臺管理員編輯時間', PRIMARY KEY (`admin_id`) USING BTREE, KEY `account` (`account`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COMMENT='后臺管理員表'; -- ---------------------------- -- Table structure for eb_system_attachment -- ---------------------------- DROP TABLE IF EXISTS `eb_system_attachment`; CREATE TABLE `eb_system_attachment` ( `attachment_id` int(11) NOT NULL AUTO_INCREMENT, `attachment_category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '分類ID 0編輯器,1產品圖片,2拼團圖片,3砍價圖片,4秒殺圖片,5文章圖片,6組合數據圖', `attachment_name` varchar(100) NOT NULL COMMENT '附件名稱', `attachment_src` varchar(200) NOT NULL COMMENT '附件路徑', `upload_type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '圖片上傳類型 1本地 2七牛云 3OSS 4COS ', `user_type` int(11) NOT NULL DEFAULT '0' COMMENT '圖片上傳模塊類型 0總后臺后臺 >0商戶后臺 -1用戶生成', `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上傳用戶的 id', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '上傳時間', PRIMARY KEY (`attachment_id`) USING BTREE, KEY `attachment_category_id` (`attachment_category_id`) USING BTREE, KEY `user_type` (`user_type`,`user_id`,`upload_type`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=13633 DEFAULT CHARSET=utf8 COMMENT='附件管理表'; -- ---------------------------- -- Table structure for eb_system_attachment_category -- ---------------------------- DROP TABLE IF EXISTS `eb_system_attachment_category`; CREATE TABLE `eb_system_attachment_category` ( `attachment_category_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `pid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '父級ID', `path` varchar(512) NOT NULL DEFAULT '' COMMENT '路徑', `attachment_category_name` varchar(32) NOT NULL COMMENT '分類名稱', `attachment_category_enname` varchar(16) NOT NULL COMMENT '分類目錄', `sort` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `mer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商戶 id', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`attachment_category_id`) USING BTREE, KEY `mer_id` (`mer_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=utf8 COMMENT='附件分類表'; -- ---------------------------- -- Table structure for eb_system_city -- ---------------------------- DROP TABLE IF EXISTS `eb_system_city`; CREATE TABLE `eb_system_city` ( `id` int(11) unsigned 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) NOT NULL DEFAULT '' COMMENT '區號', `name` varchar(100) NOT NULL DEFAULT '' COMMENT '名稱', `merger_name` varchar(255) NOT NULL DEFAULT '' COMMENT '合并名稱', `lng` varchar(50) NOT NULL DEFAULT '' COMMENT '經度', `lat` varchar(50) NOT NULL DEFAULT '' COMMENT '緯度', `is_show` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否展示', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, KEY `level` (`level`) USING BTREE, KEY `city_id` (`city_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=3946 DEFAULT CHARSET=utf8 COMMENT='城市表'; -- ---------------------------- -- Table structure for eb_system_config -- ---------------------------- DROP TABLE IF EXISTS `eb_system_config`; CREATE TABLE `eb_system_config` ( `config_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '配置id', `config_classify_id` int(10) unsigned NOT NULL COMMENT '配置分類id', `config_name` varchar(64) NOT NULL COMMENT '字段名稱', `config_key` varchar(64) NOT NULL COMMENT '字段 key', `config_type` varchar(20) NOT NULL DEFAULT 'input' COMMENT '配置類型', `config_rule` varchar(255) DEFAULT NULL COMMENT '規則', `config_props` varchar(255) DEFAULT '' COMMENT '配置', `required` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '必填', `info` varchar(128) DEFAULT '' COMMENT '配置說明', `sort` smallint(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `user_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0=總后臺配置 1=商戶后臺配置', `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否顯示', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`config_id`) USING BTREE, UNIQUE KEY `config_name` (`config_key`) USING BTREE, KEY `config_classify_id` (`config_classify_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=396 DEFAULT CHARSET=utf8 COMMENT='配置表'; -- ---------------------------- -- Table structure for eb_system_config_classify -- ---------------------------- DROP TABLE IF EXISTS `eb_system_config_classify`; CREATE TABLE `eb_system_config_classify` ( `config_classify_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '配置分類id', `pid` int(10) DEFAULT '0' COMMENT '父級ID', `classify_name` varchar(255) NOT NULL COMMENT '配置分類名稱', `classify_key` varchar(255) NOT NULL COMMENT '配置分類英文名稱', `info` varchar(30) DEFAULT NULL COMMENT '配置分類說明', `sort` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `icon` varchar(30) DEFAULT NULL COMMENT '圖標', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '配置分類狀態', PRIMARY KEY (`config_classify_id`) USING BTREE, UNIQUE KEY `classify_key` (`classify_key`) USING BTREE, KEY `pid` (`pid`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8 COMMENT='配置分類表'; -- ---------------------------- -- Table structure for eb_system_config_value -- ---------------------------- DROP TABLE IF EXISTS `eb_system_config_value`; CREATE TABLE `eb_system_config_value` ( `config_value_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '配置id', `config_key` varchar(32) NOT NULL COMMENT '配置分類key', `value` varchar(2000) NOT NULL COMMENT '值', `mer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商戶 id', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`config_value_id`) USING BTREE, UNIQUE KEY `config_name` (`config_key`,`mer_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=1096 DEFAULT CHARSET=utf8 COMMENT='配置表'; -- ---------------------------- -- Table structure for eb_system_group -- ---------------------------- DROP TABLE IF EXISTS `eb_system_group`; CREATE TABLE `eb_system_group` ( `group_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '組合數據ID', `group_name` varchar(50) NOT NULL COMMENT '數據組名稱', `group_info` varchar(256) NOT NULL COMMENT '數據提示', `group_key` varchar(50) NOT NULL COMMENT '數據字段', `fields` text COMMENT '數據組字段以及類型（json數據）', `user_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0=總后臺配置 1=商戶后臺配置', `sort` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`group_id`) USING BTREE, UNIQUE KEY `group_key` (`group_key`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8 COMMENT='組合數據表'; -- ---------------------------- -- Table structure for eb_system_group_data -- ---------------------------- DROP TABLE IF EXISTS `eb_system_group_data`; CREATE TABLE `eb_system_group_data` ( `group_data_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '組合數據詳情ID', `group_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '對應的數據組id', `value` text NOT NULL COMMENT '數據組對應的數據值（json數據）', `sort` int(11) NOT NULL DEFAULT '0' COMMENT '數據排序', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '狀態（1：開啟；0：關閉；）', `mer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商戶 id', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加數據時間', PRIMARY KEY (`group_data_id`) USING BTREE, KEY `group_id` (`group_id`) USING BTREE, KEY `mer_id` (`mer_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=606 DEFAULT CHARSET=utf8 COMMENT='組合數據詳情表'; -- ---------------------------- -- Table structure for eb_system_log -- ---------------------------- DROP TABLE IF EXISTS `eb_system_log`; CREATE TABLE `eb_system_log` ( `log_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '管理員操作記錄ID', `admin_id` int(10) unsigned NOT NULL COMMENT '管理員id', `admin_name` varchar(64) NOT NULL COMMENT '管理員姓名', `route` varchar(128) NOT NULL COMMENT '路由', `method` varchar(12) NOT NULL COMMENT '方式', `url` varchar(256) NOT NULL COMMENT '鏈接', `ip` varchar(16) NOT NULL COMMENT '登錄IP', `mer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商戶id', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`log_id`) USING BTREE, KEY `admin_id` (`admin_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=150962 DEFAULT CHARSET=utf8 COMMENT='管理員操作記錄表'; -- ---------------------------- -- Table structure for eb_system_menu -- ---------------------------- DROP TABLE IF EXISTS `eb_system_menu`; CREATE TABLE `eb_system_menu` ( `menu_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '菜單ID', `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父級id', `path` varchar(512) NOT NULL COMMENT '路徑', `icon` varchar(32) DEFAULT '' COMMENT '圖標', `menu_name` varchar(128) NOT NULL DEFAULT '' COMMENT '按鈕名', `route` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '路由名稱', `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 '是否顯示', `is_mer` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '模塊，1 平臺， 2商戶', `is_menu` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '類型，1菜單 2 權限', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創建時間', `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '創建時間', PRIMARY KEY (`menu_id`) USING BTREE, KEY `pid` (`pid`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=1617 DEFAULT CHARSET=utf8 COMMENT='菜單表'; -- ---------------------------- -- Table structure for eb_system_notice -- ---------------------------- DROP TABLE IF EXISTS `eb_system_notice`; CREATE TABLE `eb_system_notice` ( `notice_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `admin_id` int(10) unsigned NOT NULL COMMENT '管理員 id', `notice_title` varchar(128) NOT NULL COMMENT '通知標題', `notice_content` text NOT NULL COMMENT '通知內容', `type` tinyint(1) unsigned NOT NULL COMMENT '通知類型', `type_str` varchar(512) NOT NULL COMMENT '通知說明', `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0:正常 1:刪除', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`notice_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for eb_system_notice_config -- ---------------------------- DROP TABLE IF EXISTS `eb_system_notice_config`; CREATE TABLE `eb_system_notice_config` ( `notice_config_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `notice_title` varchar(20) DEFAULT NULL COMMENT '消息名稱', `notice_key` varchar(100) DEFAULT NULL COMMENT '消息鍵名稱', `notice_info` varchar(50) DEFAULT NULL COMMENT '消息說明', `notice_sys` tinyint(2) DEFAULT '-1' COMMENT '站內消息', `notice_wechat` tinyint(2) DEFAULT '-1' COMMENT '公眾號模板消息', `notice_routine` tinyint(2) DEFAULT '-1' COMMENT '小程序訂閱消息', `notice_sms` tinyint(2) DEFAULT '-1' COMMENT '短信消息', `mer_id` int(11) unsigned DEFAULT '0' COMMENT '商戶ID', `type` int(11) unsigned DEFAULT '0' COMMENT '1商戶通知， 0用戶通知', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創建時間 ', PRIMARY KEY (`notice_config_id`), UNIQUE KEY `notic_config_id` (`notice_config_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for eb_system_notice_log -- ---------------------------- DROP TABLE IF EXISTS `eb_system_notice_log`; CREATE TABLE `eb_system_notice_log` ( `notice_log_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `mer_id` int(10) unsigned NOT NULL COMMENT '商戶 id', `notice_id` int(10) unsigned NOT NULL COMMENT '公告 id', `is_read` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否已讀', `read_time` timestamp NULL DEFAULT NULL COMMENT '讀取時間', `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否刪除', PRIMARY KEY (`notice_log_id`) USING BTREE, KEY `mer_id` (`mer_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=1279 DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for eb_system_role -- ---------------------------- DROP TABLE IF EXISTS `eb_system_role`; CREATE TABLE `eb_system_role` ( `role_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '身份管理id', `role_name` varchar(32) NOT NULL COMMENT '身份管理名稱', `rules` text NOT NULL COMMENT '身份管理權限(menus_id)', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '狀態', `mer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商戶 id', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創建時間', `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新時間', PRIMARY KEY (`role_id`) USING BTREE, KEY `mer_id` (`mer_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8 COMMENT='身份管理表'; -- ---------------------------- -- Table structure for eb_template_message -- ---------------------------- DROP TABLE IF EXISTS `eb_template_message`; CREATE TABLE `eb_template_message` ( `template_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '模板id', `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0=訂閱消息,1=微信模板消息', `tempkey` char(50) NOT NULL COMMENT '模板編號', `name` char(100) NOT NULL COMMENT '模板名', `content` varchar(1000) NOT NULL COMMENT '回復內容', `tempid` char(100) DEFAULT NULL COMMENT '模板ID', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '添加時間', `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '狀態', `kid` char(100) DEFAULT '0', PRIMARY KEY (`template_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COMMENT='微信模板'; -- ---------------------------- -- 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', `wechat_user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '微信用戶 id', `account` varchar(32) NOT NULL COMMENT '用戶賬號', `pwd` varchar(128) NOT NULL COMMENT '用戶密碼', `real_name` varchar(25) NOT NULL DEFAULT '' COMMENT '真實姓名', `sex` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '性別', `birthday` date DEFAULT NULL COMMENT '生日', `card_id` varchar(20) NOT NULL DEFAULT '' COMMENT '身份證號碼', `mark` varchar(255) NOT NULL DEFAULT '' COMMENT '用戶備注', `label_id` varchar(64) DEFAULT NULL COMMENT '用戶標簽 id', `group_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用戶分組id', `nickname` varchar(16) NOT NULL COMMENT '用戶昵稱', `avatar` varchar(256) NOT NULL COMMENT '用戶頭像', `phone` char(15) DEFAULT NULL COMMENT '手機號碼', `addres` varchar(128) DEFAULT NULL COMMENT '地址', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加時間', `last_time` timestamp NULL DEFAULT NULL COMMENT '最后一次登錄時間', `last_ip` varchar(16) NOT NULL 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 '傭金金額', `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1為正常，0為禁止', `spread_uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '推廣員id', `spread_time` timestamp NULL DEFAULT NULL COMMENT '推廣員關聯時間', `spread_limit` timestamp NULL DEFAULT NULL COMMENT '推廣員到期時間', `brokerage_level` int(10) unsigned DEFAULT '0' COMMENT '推廣員等級', `user_type` varchar(32) NOT NULL COMMENT '用戶類型', `promoter_time` timestamp NULL DEFAULT NULL COMMENT '成功推廣時間', `is_promoter` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否為推廣員', `main_uid` int(10) unsigned DEFAULT '0' COMMENT '主賬號', `pay_count` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用戶購買次數', `pay_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '用戶消費金額', `spread_count` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '下級人數', `spread_pay_count` int(11) unsigned DEFAULT '0' COMMENT '下級訂單數', `spread_pay_price` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '下級訂單金額', `integral` int(11) unsigned DEFAULT '0' COMMENT '積分', `member_level` int(11) unsigned DEFAULT '0' COMMENT '免費會員等級', `member_value` int(11) unsigned DEFAULT '0' COMMENT '免費會員成長值', `count_start` int(11) unsigned DEFAULT '0' COMMENT '用戶獲贊數', `count_fans` int(11) unsigned DEFAULT '0' COMMENT '用戶粉絲數', PRIMARY KEY (`uid`) USING BTREE, KEY `account` (`account`) USING BTREE, KEY `spreaduid` (`spread_uid`) USING BTREE, KEY `wechat_user_id` (`wechat_user_id`) USING BTREE, KEY `main_uid` (`main_uid`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=9371 DEFAULT CHARSET=utf8 COMMENT='用戶表'; -- ---------------------------- -- Table structure for eb_user_address -- ---------------------------- DROP TABLE IF EXISTS `eb_user_address`; CREATE TABLE `eb_user_address` ( `address_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '用戶地址id', `uid` int(10) unsigned NOT NULL COMMENT '用戶id', `real_name` varchar(32) NOT NULL DEFAULT '' COMMENT '收貨人姓名', `phone` varchar(16) NOT NULL DEFAULT '' COMMENT '收貨人電話', `province` varchar(64) NOT NULL DEFAULT '' COMMENT '收貨人所在省', `province_id` int(10) unsigned DEFAULT '0' COMMENT '省 id', `city` varchar(64) NOT NULL DEFAULT '' COMMENT '收貨人所在市', `city_id` int(11) NOT NULL DEFAULT '0' COMMENT '城市id', `district` varchar(64) NOT NULL DEFAULT '' COMMENT '收貨人所在區', `district_id` int(10) unsigned DEFAULT '0' COMMENT '區域 id', `street` varchar(64) DEFAULT NULL COMMENT '街/鎮', `street_id` int(10) unsigned DEFAULT '0' COMMENT '街鎮 id', `detail` varchar(256) NOT NULL DEFAULT '' COMMENT '收貨人詳細地址', `post_code` int(10) unsigned NOT NULL COMMENT '郵編', `longitude` varchar(16) NOT NULL DEFAULT '0' COMMENT '經度', `latitude` varchar(16) 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 '是否刪除', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加時間', PRIMARY KEY (`address_id`) USING BTREE, KEY `uid` (`uid`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=466 DEFAULT CHARSET=utf8 COMMENT='用戶地址表'; -- ---------------------------- -- Table structure for eb_user_bill -- ---------------------------- DROP TABLE IF EXISTS `eb_user_bill`; CREATE TABLE `eb_user_bill` ( `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) NOT NULL DEFAULT '0' COMMENT '關聯id', `pm` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0 = 支出 1 = 獲得', `title` varchar(64) NOT NULL COMMENT '賬單標題', `category` varchar(64) NOT NULL COMMENT '明細種類', `type` varchar(64) 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) NOT NULL COMMENT '備注', `mer_id` int(10) unsigned DEFAULT '0' COMMENT '商戶 id', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加時間', `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0 = 待確定 1 = 有效 -1 = 無效', PRIMARY KEY (`bill_id`) USING BTREE, KEY `uid` (`uid`) USING BTREE, KEY `create_time` (`create_time`) USING BTREE, KEY `type` (`category`,`type`,`link_id`) USING BTREE, KEY `mer_id` (`mer_id`) ) ENGINE=InnoDB AUTO_INCREMENT=24528 DEFAULT CHARSET=utf8 COMMENT='用戶賬單表'; -- ---------------------------- -- Table structure for eb_user_brokerage -- ---------------------------- DROP TABLE IF EXISTS `eb_user_brokerage`; CREATE TABLE `eb_user_brokerage` ( `user_brokerage_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `brokerage_level` tinyint(3) unsigned NOT NULL COMMENT '等級', `brokerage_name` varchar(32) NOT NULL COMMENT 'vip 名稱', `brokerage_icon` varchar(128) NOT NULL COMMENT 'vip 圖標', `brokerage_rule` varchar(1500) NOT NULL COMMENT '升級規則', `user_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'vip 人數', `extension_one` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '一級傭金', `extension_two` decimal(8,2) unsigned NOT NULL COMMENT '二級傭金', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創建時間', `type` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '默認0分銷會員等級，1 免費會員等級', PRIMARY KEY (`user_brokerage_id`) USING BTREE, UNIQUE KEY `vip_level` (`brokerage_level`,`type`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for eb_user_extract -- ---------------------------- DROP TABLE IF EXISTS `eb_user_extract`; CREATE TABLE `eb_user_extract` ( `extract_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uid` int(10) unsigned DEFAULT '0' COMMENT '用戶 id', `extract_sn` varchar(255) DEFAULT NULL, `real_name` varchar(64) DEFAULT NULL COMMENT '姓名', `extract_type` tinyint(1) DEFAULT '0' COMMENT '0 銀行卡 1 支付寶 2微信 3 零錢', `bank_code` varchar(32) DEFAULT '0' COMMENT '銀行卡', `bank_address` varchar(256) DEFAULT '' COMMENT '開戶地址', `alipay_code` varchar(64) DEFAULT '' COMMENT '支付寶賬號', `wechat` varchar(15) DEFAULT NULL COMMENT '微信號', `extract_pic` varchar(128) DEFAULT NULL COMMENT '收款碼', `extract_price` decimal(8,2) unsigned DEFAULT '0.00' COMMENT '提現金額', `balance` decimal(8,2) unsigned DEFAULT '0.00' COMMENT '余額', `mark` varchar(512) DEFAULT NULL COMMENT '管理員備注', `admin_id` int(10) DEFAULT '0' COMMENT '審核管理員', `fail_msg` varchar(128) DEFAULT NULL COMMENT '無效原因', `status_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '無效時間', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加時間', `status` tinyint(2) DEFAULT '0' COMMENT '-1 未通過 0 審核中 1 已提現', PRIMARY KEY (`extract_id`) USING BTREE, KEY `uid` (`uid`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=224 DEFAULT CHARSET=utf8 COMMENT='用戶提現表'; -- ---------------------------- -- Table structure for eb_user_group -- ---------------------------- DROP TABLE IF EXISTS `eb_user_group`; CREATE TABLE `eb_user_group` ( `group_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `group_name` varchar(64) NOT NULL COMMENT '用戶分組名稱', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`group_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8 COMMENT='用戶分組表'; -- ---------------------------- -- Table structure for eb_user_history -- ---------------------------- DROP TABLE IF EXISTS `eb_user_history`; CREATE TABLE `eb_user_history` ( `user_history_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `res_id` int(11) unsigned DEFAULT NULL COMMENT '歷史記錄對象的ID', `res_type` int(11) DEFAULT NULL COMMENT '歷史記錄類型', `uid` int(11) DEFAULT NULL, `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `update_time` int(11) DEFAULT NULL, PRIMARY KEY (`user_history_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=3163 DEFAULT CHARSET=utf8 COMMENT='瀏覽記錄表'; -- ---------------------------- -- Table structure for eb_user_label -- ---------------------------- DROP TABLE IF EXISTS `eb_user_label`; CREATE TABLE `eb_user_label` ( `label_id` int(11) NOT NULL AUTO_INCREMENT, `label_name` varchar(255) NOT NULL DEFAULT '' COMMENT '標簽名稱', `mer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商戶 id', `type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0=手動標簽 1=自動標簽', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`label_id`) USING BTREE, KEY `mer_id` (`mer_id`) ) ENGINE=InnoDB AUTO_INCREMENT=198 DEFAULT CHARSET=utf8 COMMENT='用戶標簽表'; -- ---------------------------- -- Table structure for eb_user_merchant -- ---------------------------- DROP TABLE IF EXISTS `eb_user_merchant`; CREATE TABLE `eb_user_merchant` ( `user_merchant_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uid` int(10) unsigned NOT NULL COMMENT '用戶 id', `mer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商戶 id', `first_pay_time` timestamp NULL DEFAULT NULL COMMENT '首次消費時間', `last_pay_time` timestamp NULL DEFAULT NULL COMMENT '最后一次消費時間', `pay_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '消費次數', `pay_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '消費金額', `label_id` varchar(256) DEFAULT NULL COMMENT '用戶標簽', `last_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后一次訪問時間', `status` tinyint(1) unsigned DEFAULT '1' COMMENT '狀態', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`user_merchant_id`), UNIQUE KEY `uid` (`uid`,`mer_id`) USING BTREE, KEY `mer_id` (`mer_id`) ) ENGINE=InnoDB AUTO_INCREMENT=387 DEFAULT CHARSET=utf8 COMMENT='商戶用戶表'; -- ---------------------------- -- Table structure for eb_user_receipt -- ---------------------------- DROP TABLE IF EXISTS `eb_user_receipt`; CREATE TABLE `eb_user_receipt` ( `user_receipt_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `receipt_type` tinyint(1) DEFAULT '0' COMMENT '發票類型：1.普通發票，2.增值稅發票', `receipt_title` varchar(128) DEFAULT '' COMMENT '發票抬頭', `receipt_title_type` varchar(255) DEFAULT '0' COMMENT '發票抬頭類型：1.個人，2.企業', `duty_paragraph` varchar(255) DEFAULT '' COMMENT '稅號', `email` varchar(255) DEFAULT '' COMMENT '郵箱', `bank_name` varchar(255) DEFAULT '' COMMENT '開戶行', `bank_code` varchar(255) DEFAULT '0' COMMENT '銀行賬號', `address` varchar(255) DEFAULT '' COMMENT '企業地址', `tel` varchar(255) DEFAULT '' COMMENT '企業電話', `is_default` tinyint(2) NOT NULL DEFAULT '0' COMMENT '是否默認', `uid` int(11) NOT NULL DEFAULT '0' COMMENT '用戶ID', `is_del` tinyint(1) DEFAULT '0', `create_time` timestamp NULL DEFAULT NULL, PRIMARY KEY (`user_receipt_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=84 DEFAULT CHARSET=utf8 COMMENT='用戶發票信息'; -- ---------------------------- -- Table structure for eb_user_recharge -- ---------------------------- DROP TABLE IF EXISTS `eb_user_recharge`; CREATE TABLE `eb_user_recharge` ( `recharge_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uid` int(10) unsigned NOT NULL COMMENT '充值用戶UID', `order_id` varchar(32) NOT NULL COMMENT '訂單號', `price` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '充值金額', `give_price` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '購買贈送金額', `recharge_type` varchar(32) NOT NULL COMMENT '充值類型', `paid` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否充值', `pay_time` timestamp NULL DEFAULT NULL COMMENT '充值支付時間', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '充值時間', `refund_price` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '退款金額', PRIMARY KEY (`recharge_id`) USING BTREE, UNIQUE KEY `order_id` (`order_id`) USING BTREE, KEY `uid` (`uid`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=207 DEFAULT CHARSET=utf8 COMMENT='用戶充值表'; -- ---------------------------- -- Table structure for eb_user_relation -- ---------------------------- DROP TABLE IF EXISTS `eb_user_relation`; CREATE TABLE `eb_user_relation` ( `uid` int(10) unsigned NOT NULL COMMENT '用戶ID', `type_id` int(10) unsigned NOT NULL COMMENT '類型的 id', `type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '關聯類型(0 普通商品、1秒殺2、預售3、助力4、拼團、10 = 店鋪、12=購買過)', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加時間', UNIQUE KEY `uid` (`type`,`type_id`,`uid`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用戶記錄表'; -- ---------------------------- -- Table structure for eb_user_sign -- ---------------------------- DROP TABLE IF EXISTS `eb_user_sign`; CREATE TABLE `eb_user_sign` ( `sign_id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL DEFAULT '0' COMMENT '用戶uid', `title` varchar(255) NOT NULL DEFAULT '' COMMENT '簽到說明', `number` int(11) NOT NULL DEFAULT '0' COMMENT '獲得積分', `integral` int(11) NOT NULL DEFAULT '0' COMMENT '剩余積分', `sign_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '連續簽到天數', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加時間', PRIMARY KEY (`sign_id`) USING BTREE, KEY `uid` (`uid`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=155 DEFAULT CHARSET=utf8 COMMENT='簽到記錄表'; -- ---------------------------- -- Table structure for eb_user_spread_log -- ---------------------------- DROP TABLE IF EXISTS `eb_user_spread_log`; CREATE TABLE `eb_user_spread_log` ( `user_spread_log_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uid` int(10) unsigned NOT NULL COMMENT 'uid', `old_spread_uid` int(10) unsigned NOT NULL COMMENT '原來的推薦人uid', `spread_uid` int(10) unsigned NOT NULL COMMENT '新的推薦人 uid', `admin_id` int(10) unsigned NOT NULL COMMENT '修改的管理員', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`user_spread_log_id`), KEY `uid` (`uid`) ) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for eb_user_visit -- ---------------------------- DROP TABLE IF EXISTS `eb_user_visit`; CREATE TABLE `eb_user_visit` ( `user_visit_id` int(10) NOT NULL AUTO_INCREMENT, `uid` int(11) DEFAULT NULL COMMENT '用戶ID', `type` varchar(32) NOT NULL COMMENT '記錄類型', `type_id` int(11) NOT NULL DEFAULT '0' COMMENT '商品ID', `content` varchar(255) DEFAULT NULL COMMENT '備注描述', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加時間', PRIMARY KEY (`user_visit_id`) USING BTREE, KEY `uid` (`uid`) USING BTREE, KEY `type` (`type`,`type_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=241132 DEFAULT CHARSET=utf8 COMMENT='商品瀏覽分析表'; -- ---------------------------- -- Table structure for eb_wechat_news -- ---------------------------- DROP TABLE IF EXISTS `eb_wechat_news`; CREATE TABLE `eb_wechat_news` ( `wechat_news_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '圖文消息管理ID', `mer_id` int(11) DEFAULT '0' COMMENT '商戶id', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '狀態', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加時間', PRIMARY KEY (`wechat_news_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8 COMMENT='圖文消息管理表'; -- ---------------------------- -- Table structure for eb_wechat_qrcode -- ---------------------------- DROP TABLE IF EXISTS `eb_wechat_qrcode`; CREATE TABLE `eb_wechat_qrcode` ( `wechat_qrcode_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '微信二維碼ID', `third_type` varchar(32) NOT NULL COMMENT '二維碼類型', `third_id` int(11) unsigned NOT NULL COMMENT '類型id', `ticket` varchar(255) NOT NULL COMMENT '二維碼參數', `expire_seconds` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '二維碼有效時間', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '狀態', `url` varchar(255) NOT NULL COMMENT '微信訪問url', `qrcode_url` varchar(255) NOT NULL COMMENT '微信二維碼url', `scan` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '被掃的次數', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加時間', PRIMARY KEY (`wechat_qrcode_id`) USING BTREE, UNIQUE KEY `third_type` (`third_type`,`third_id`) USING BTREE, KEY `ticket` (`ticket`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='微信二維碼管理表'; -- ---------------------------- -- Table structure for eb_wechat_reply -- ---------------------------- DROP TABLE IF EXISTS `eb_wechat_reply`; CREATE TABLE `eb_wechat_reply` ( `wechat_reply_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '微信關鍵字回復id', `key` varchar(64) NOT NULL COMMENT '關鍵字', `type` varchar(32) NOT NULL COMMENT '回復類型', `data` text NOT NULL COMMENT '回復數據', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '0=不可用 1 =可用', `hidden` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否顯示', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`wechat_reply_id`) USING BTREE, UNIQUE KEY `key` (`key`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8 COMMENT='微信關鍵字回復表'; -- ---------------------------- -- Table structure for eb_wechat_user -- ---------------------------- DROP TABLE IF EXISTS `eb_wechat_user`; CREATE TABLE `eb_wechat_user` ( `wechat_user_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '微信用戶id', `unionid` varchar(60) DEFAULT NULL COMMENT '只有在用戶將公眾號綁定到微信開放平臺帳號后，才會出現該字段', `openid` varchar(30) DEFAULT NULL COMMENT '用戶的標識，對當前公眾號唯一', `routine_openid` varchar(32) DEFAULT NULL COMMENT '小程序唯一身份ID', `nickname` varchar(64) NOT NULL COMMENT '用戶的昵稱', `headimgurl` varchar(256) NOT NULL COMMENT '用戶頭像', `sex` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '用戶的性別，值為1時是男性，值為2時是女性，值為0時是未知', `city` varchar(32) NOT NULL COMMENT '用戶所在城市', `language` varchar(32) NOT NULL COMMENT '用戶的語言，簡體中文為zh_CN', `province` varchar(32) NOT NULL COMMENT '用戶所在省份', `country` varchar(32) NOT NULL COMMENT '用戶所在國家', `remark` varchar(256) DEFAULT NULL COMMENT '公眾號運營者對粉絲的備注，公眾號運營者可在微信公眾平臺用戶管理界面對粉絲添加備注', `groupid` smallint(5) unsigned DEFAULT '0' COMMENT '用戶所在的分組ID（兼容舊的用戶分組接口）', `tagid_list` varchar(256) DEFAULT NULL COMMENT '用戶被打上的標簽ID列表', `subscribe` tinyint(3) unsigned DEFAULT '0' COMMENT '用戶是否訂閱該公眾號標識', `subscribe_time` int(10) unsigned DEFAULT NULL COMMENT '關注公眾號時間', `session_key` varchar(32) DEFAULT NULL COMMENT '小程序用戶會話密匙', `user_type` varchar(32) DEFAULT 'wechat' COMMENT '用戶類型', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創建時間', PRIMARY KEY (`wechat_user_id`) USING BTREE, KEY `groupid` (`groupid`) USING BTREE, KEY `subscribe_time` (`subscribe_time`) USING BTREE, KEY `unionid` (`unionid`) USING BTREE, KEY `routine_openid` (`routine_openid`) USING BTREE, KEY `openid` (`openid`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=9015 DEFAULT CHARSET=utf8 COMMENT='微信用戶表'; ```