```[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='微信用戶表';
```
- 序言
- 系統簡介
- 系統介紹
- 前端腦圖
- 項目介紹
- 新手入門(源碼安裝)
- 運行環境
- 服務器配置及安裝
- 視頻安裝教程
- 服務器及環境搭建
- 服務器購買
- 域名購買
- 域名解析
- 服務器配置
- 寶塔配置
- 創建站點
- 安裝項目
- 1.源碼上傳(必看內容)
- 2.PHP擴展安裝
- 3.環境配置
- 4.運行服務
- 5.一鍵安裝
- 注意事項(很重要)
- 重啟swoole服務
- linux安裝swoole方法
- 特別注意事項
- mysql 5.7注意事項
- https域名
- ssl證書申請
- 公眾號配置
- 公眾號配置
- 公眾號開發配置
- 公眾號菜單
- 設置公眾號菜單
- 關鍵字
- 跳轉網頁
- 跳轉小程序
- 小程序配置
- 1.微信平臺配置
- 2.CRMEB后臺配置
- 3.前端提交審核
- 4.確認發布
- 支付配置
- 支付配置
- 公眾號支付
- 小程序支付
- 支付寶支付
- 其他配置
- 公眾號模板消息
- 小程序訂閱消息
- 商業授權
- 授權說明
- 申請授權
- 安裝常見問題匯總
- 請修改sql_mode文件為NO_AUTO提示
- 版本更新
- 客服設置
- uni-app 打包H5、公眾號
- 版本更新
- 清空數據
- 測試域名
- 部署多套多商戶
- 使用說明
- 商品分類
- 分類說明
- 分類管理
- 品牌分類
- 商品標簽
- 商品管理
- 發布商品
- 商品規格
- 配置說明
- 文件上傳
- 移動端展示說明
- 首頁
- 分類頁
- 個人中心
- 熱門搜索
- 分銷規則
- 分銷配置
- 分銷員管理
- 分銷規則說明
- 分銷員等級
- 分銷禮包
- 傭金說明
- 用戶管理
- 商戶用戶管理
- 平臺用戶管理
- 用戶協議
- 用戶搜索記錄
- 秒殺
- 秒殺規則
- 開啟秒殺活動
- 直播
- 主播實名認證
- 開啟直播
- 添加直播商品
- 預售
- 開啟全款預售
- 開啟定金預售
- 預售協議
- 專題
- 后臺配置
- 前端展示
- 助力
- 開啟助力
- 查看助力活動
- 拼團
- 虛擬拼團設置
- 開啟拼團
- 查看拼團活動
- 積分
- 積分設置
- 積分來源
- 積分使用
- 提現
- 提現規則
- 提現步驟
- 新聞資訊
- 新聞頁面
- 發布資訊
- 賬戶管理
- 賬號信息
- 賬戶資金
- 優惠券
- 添加優惠券
- 發布優惠券
- 領取及使用
- 發放優惠券
- 訂單管理
- 后臺訂單處理
- 前端訂單處理
- 訂單退款
- 訂單打印
- 客服管理
- 添加客服
- 客服權限
- 門店自提
- 開啟門店自提
- 設置核銷權限
- 訂單核銷說明
- 商戶管理
- 商戶分類
- 商戶入駐
- 商戶列表
- 商戶菜單管理
- 店鋪類型
- 財務
- 財務對賬
- 發票管理
- 自動分賬(v1.5及以后版本)
- 郵費說明
- 運費設置
- 運費組成
- 運費模板
- 物流配置
- 公告管理
- 店鋪相關
- 店鋪定位設置
- 店鋪街入口
- 店鋪活動
- 店鋪基本信息設置
- 小票打印
- 小票打印機配置
- 小票打印機設置
- 技術文檔
- 開發規范
- 數據字典
- 目錄結構
- 移動端路由
- 系統配置
- 后臺表單說明
- 短信設置
- 短信賬戶
- 短信配置
- 短信模板
- 一號通
- 電子面單
- 短信提醒
- 商品采集
- 物流查詢
- 付費采集商品配置
- PC端展示說明
- PC端開啟
- PC端平臺頁面配置
- PC端店鋪頁面配置
- 保障服務
- 移動端商品管理
- 開啟移動端商品管理
- 功能說明
- 會員管理
- 會員管理
- 會員權益
- 會員配置
- 社區功能
- 社區分類
- 社區話題
- 社區文章
- 社區評論
- 社區配置
- 通知管理
- 移動前端
- 目錄結構
- 配置說明
- 頁面路徑
- 后臺前端說明
- 總后臺目錄結構
- 商戶后臺目錄結構
- 開發和構建
- APP 打包
- 基礎配置
- 開發調試
- 打包上線
- App打包
- PC端說明
- 安裝教程
- 目錄結構
- 打包教程
- 常見問題
- 服務器問題
- 服務器環境說明
- MySQL 5.7注意事項
- PHP fileinfo擴展安裝
- 后臺登錄頁幻燈片
- 后臺登錄頁logo
- 論壇常見問題匯總
- 個人中心菜單加鏈接
- 子賬號登錄名
- 前后端分離配置
- 重啟swoole進程
- 開論壇勛章
- 源碼下載地址
- 查看/隱藏版本號
- 搜索商品后服務掛了
- 開發文檔
- 架構
- config配置文件
- 容器和依賴注入
- 異常處理
- 路由
- 控制器模塊
- 日志處理
- 自定義指令
- CRMEB類庫
- Basic基類
- Exceptions異常處理
- Interfaces接口類
- Jobs消息隊列
- services服務類
- traits
- listens定時監聽類
- 接口流程
- Controller
- Repository
- Dao
- Model
- 流程
- 訂單流程
- 下單流程
- 退款流程
- 二開教程
- 定義新的接口
- 創建新的頁面
- 創建新的組合數據
- 更換短信模板