# 数据字典 ```[sql] -- ---------------------------- -- Table structure for eb_agreement -- ---------------------------- DROP TABLE IF EXISTS `eb_agreement`; CREATE TABLE `eb_agreement` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '协议类型 1：会员协议', `title` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '协议名称', `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '协议内容', `sort` int(10) NOT NULL DEFAULT 0 COMMENT '排序倒序', `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1：显示：0：不显示', `add_time` int(50) NOT NULL DEFAULT 0 COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `type`(`type`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '会员协议' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for eb_article -- ---------------------------- DROP TABLE IF EXISTS `eb_article`; CREATE TABLE `eb_article` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '文章管理ID', `cid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '分类id', `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文章标题', `author` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文章作者', `image_input` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文章图片', `synopsis` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文章简介', `share_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文章分享标题', `share_synopsis` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文章分享简介', `visit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '浏览次数', `sort` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序', `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '原文链接', `status` tinyint(1) UNSIGNED NOT NULL COMMENT '状态', `add_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '添加时间', `hide` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否隐藏', `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '管理员id', `mer_id` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '商户id', `product_id` int(10) NOT NULL DEFAULT 0 COMMENT '商品关联id', `is_hot` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否热门(小程序)', `is_banner` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否轮播图(小程序)', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '文章管理表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_article_category -- ---------------------------- DROP TABLE IF EXISTS `eb_article_category`; CREATE TABLE `eb_article_category` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '文章分类id', `pid` int(11) NOT NULL DEFAULT 0 COMMENT '父级ID', `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文章分类标题', `intr` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文章分类简介', `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文章分类图片', `status` tinyint(1) UNSIGNED NOT NULL COMMENT '状态', `sort` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序', `is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '1删除0未删除', `add_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '添加时间', `hidden` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否隐藏', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '文章分类表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_article_content -- ---------------------------- DROP TABLE IF EXISTS `eb_article_content`; CREATE TABLE `eb_article_content` ( `nid` int(10) UNSIGNED NOT NULL COMMENT '文章id', `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文章内容', UNIQUE INDEX `nid`(`nid`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '文章内容表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_auxiliary -- ---------------------------- DROP TABLE IF EXISTS `eb_auxiliary`; CREATE TABLE `eb_auxiliary` ( `id` int(10) NOT NULL AUTO_INCREMENT, `binding_id` int(10) NOT NULL DEFAULT 0 COMMENT '绑定id', `relation_id` int(10) NOT NULL DEFAULT 0 COMMENT '关联id', `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '类型0=客服转接辅助，1=商品和分类辅助，2=优惠券和商品辅助', `other` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '其他数据为json', `update_time` int(10) NOT NULL DEFAULT 0 COMMENT '更新时间', `add_time` int(10) NOT NULL DEFAULT 0 COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '辅助表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_cache -- ---------------------------- DROP TABLE IF EXISTS `eb_cache`; CREATE TABLE `eb_cache` ( `key` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `result` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '缓存数据', `expire_time` int(11) NOT NULL DEFAULT 0 COMMENT '失效时间0=永久', `add_time` int(10) NULL DEFAULT NULL COMMENT '缓存时间', PRIMARY KEY (`key`) USING BTREE, INDEX `key`(`key`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '微信缓存表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_category -- ---------------------------- DROP TABLE IF EXISTS `eb_category`; CREATE TABLE `eb_category` ( `id` int(10) NOT NULL AUTO_INCREMENT, `pid` int(10) NOT NULL DEFAULT 0 COMMENT '上级id', `owner_id` int(10) NOT NULL DEFAULT 0 COMMENT '所属人，为全部', `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '分类名称', `sort` int(10) NOT NULL DEFAULT 0 COMMENT '排序', `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '分类类型0=标签分类，1=快捷短语分类', `other` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '其他参数', `add_time` int(10) NOT NULL DEFAULT 0 COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `pid`(`pid`) USING BTREE, INDEX `name`(`name`) USING BTREE, INDEX `is_be`(`owner_id`, `type`, `id`) USING BTREE, INDEX `cate`(`owner_id`, `type`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '标签分类' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_delivery_service -- ---------------------------- DROP TABLE IF EXISTS `eb_delivery_service`; CREATE TABLE `eb_delivery_service` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id', `uid` int(11) NOT NULL COMMENT '配送员uid', `avatar` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '配送员头像', `nickname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '配送员名称', `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '手机号码', `add_time` int(11) NOT NULL COMMENT '添加时间', `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '0隐藏1显示', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '配送员表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for eb_diy -- ---------------------------- DROP TABLE IF EXISTS `eb_diy`; CREATE TABLE `eb_diy` ( `id` int(11) NOT NULL AUTO_INCREMENT, `version` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '版本号', `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '页面名称', `template_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', `value` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '页面数据', `default_value` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `add_time` int(11) NULL DEFAULT NULL COMMENT '添加时间', `update_time` int(11) NULL DEFAULT NULL COMMENT '更新时间', `status` tinyint(1) NULL DEFAULT 0 COMMENT '是否使用', `type` tinyint(1) NULL DEFAULT NULL COMMENT '页面类型', `is_del` tinyint(1) NULL DEFAULT 0 COMMENT '是否删除', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'DIY数据表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_express -- ---------------------------- DROP TABLE IF EXISTS `eb_express`; CREATE TABLE `eb_express` ( `id` mediumint(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '快递公司id', `code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '快递公司简称', `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '快递公司全称', `partner_id` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否需要月结账号', `partner_key` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否需要月结密码', `net` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否需要取件网店', `account` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '账号', `key` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '密码', `net_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '网点名称', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序', `is_show` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否显示', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否可用', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `code`(`code`) USING BTREE, INDEX `is_show`(`is_show`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '快递公司表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_live_anchor -- ---------------------------- DROP TABLE IF EXISTS `eb_live_anchor`; CREATE TABLE `eb_live_anchor` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '主播名称', `cover_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '主播图像', `wechat` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '主播微信号', `phone` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '手机号', `is_show` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否显示', `is_del` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除', `add_time` int(10) NOT NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_live_goods -- ---------------------------- DROP TABLE IF EXISTS `eb_live_goods`; CREATE TABLE `eb_live_goods` ( `id` int(10) NOT NULL AUTO_INCREMENT, `goods_id` int(10) NOT NULL DEFAULT 0 COMMENT '微信商品ID', `audit_id` int(10) NOT NULL DEFAULT 0 COMMENT '审核ID', `product_id` int(10) NOT NULL DEFAULT 0 COMMENT '商品id', `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品名称', `cover_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品图片链接', `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品小程序链接', `price_type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '价格类型（1:一口价，此时读price字段; 2:价格区间，此时price字段为左边界，price2字段为右边界; 3:折扣价，此时price字段为原价，price2字段为现价；）', `cost_price` decimal(10, 2) NOT NULL DEFAULT 0.00, `price` decimal(10, 2) NOT NULL DEFAULT 0.00, `price2` decimal(10, 2) NOT NULL DEFAULT 0.00, `audit_status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '审核状态（0：未审核，1：审核中，2:审核通过，3审核失败）', `third_part_tag` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1、2：表示是为 API 添加商品，否则是直播控制台添加的商品', `sort` smallint(5) NOT NULL DEFAULT 0, `is_show` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否显示', `is_del` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除', `add_time` int(10) NOT NULL DEFAULT 0 COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_live_room -- ---------------------------- DROP TABLE IF EXISTS `eb_live_room`; CREATE TABLE `eb_live_room` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `room_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '直播间 id', `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '直播间名字', `cover_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '背景图', `share_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分享图', `start_time` int(10) NOT NULL DEFAULT 0 COMMENT '直播计划开始时间', `end_time` int(10) NOT NULL DEFAULT 0 COMMENT '直播计划结束时间', `anchor_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '主播昵称', `anchor_wechat` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '主播微信号', `phone` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' 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 '是否关闭评论', `error_msg` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' 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) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '备注', `replay_status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '回放状态', `sort` smallint(5) NOT NULL DEFAULT 0, `is_show` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否显示', `is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否删除', `add_time` int(10) NOT NULL DEFAULT 0 COMMENT '添加时间', PRIMARY KEY (`id`, `phone`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '直播间表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for eb_live_room_goods -- ---------------------------- DROP TABLE IF EXISTS `eb_live_room_goods`; CREATE TABLE `eb_live_room_goods` ( `live_room_id` int(10) UNSIGNED NOT NULL, `live_goods_id` int(10) UNSIGNED NOT NULL, INDEX `broadcast_room_id`(`live_room_id`, `live_goods_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '直播间导入商品表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for eb_member_card -- ---------------------------- DROP TABLE IF EXISTS `eb_member_card`; CREATE TABLE `eb_member_card` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `card_batch_id` int(11) UNSIGNED NOT NULL COMMENT '卡批次id', `card_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '卡号', `card_password` char(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码', `use_uid` int(11) NOT NULL DEFAULT 0 COMMENT '使用用户', `use_time` int(10) NOT NULL DEFAULT 0 COMMENT '使用时间', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '卡状态：0：冻结；1：激活', `add_time` int(10) NOT NULL DEFAULT 0, `update_time` int(10) NOT NULL DEFAULT 0, PRIMARY KEY (`id`, `card_batch_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '会员卡表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for eb_member_card_batch -- ---------------------------- DROP TABLE IF EXISTS `eb_member_card_batch`; CREATE TABLE `eb_member_card_batch` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '批次名称', `total_num` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '生成卡数量', `use_start_time` int(10) UNSIGNED NOT NULL DEFAULT 7 COMMENT '体验开始时间', `use_end_time` int(10) NOT NULL DEFAULT 0 COMMENT '体验结束时间', `use_day` int(10) NOT NULL DEFAULT 0 COMMENT '体验天数', `use_num` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '使用', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否生效,控制此批次所有卡0：不生效；1：生效', `sort` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序', `qrcode` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '二维码图路径', `remark` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '备注', `add_time` int(10) NOT NULL DEFAULT 0, `update_time` int(10) NOT NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '会员卡批次表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for eb_member_right -- ---------------------------- DROP TABLE IF EXISTS `eb_member_right`; CREATE TABLE `eb_member_right` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `right_type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '权益类别', `title` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ' 权益名称', `show_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '显示权益名称', `image` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '权益图标', `explain` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '权益介绍', `number` int(2) NOT NULL DEFAULT 1 COMMENT '规则数字', `sort` int(10) NOT NULL COMMENT '排序倒序', `status` tinyint(1) NOT NULL COMMENT '0:禁用，1：启用', `add_time` int(50) NOT NULL COMMENT '添加时间', PRIMARY KEY (`id`, `right_type`) USING BTREE, INDEX `type`(`right_type`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '会员权益' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for eb_member_ship -- ---------------------------- DROP TABLE IF EXISTS `eb_member_ship`; CREATE TABLE `eb_member_ship` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'month' COMMENT '会员类别month:月卡会员；quarter:季卡；year:年卡；ever:永久；free:免费', `title` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '会员名称', `vip_day` int(10) NOT NULL COMMENT '会员时间(天)', `price` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '原价', `pre_price` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '优惠后价格', `sort` int(10) NOT NULL COMMENT '排序倒序', `is_del` int(2) NOT NULL COMMENT '删除', `add_time` int(50) NOT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `type`(`type`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '会员类型' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for eb_other_order -- ---------------------------- DROP TABLE IF EXISTS `eb_other_order`; CREATE TABLE `eb_other_order` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `uid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户uid', `type` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '区别 \r\n0：免费领取\r\n1：购买会员卡 \r\n2：卡密领取会员卡', `order_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '订单号', `member_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '会员类型 \r\n月卡：month\r\n季卡：quarter\r\n年卡：year\r\n永久：ever\r\n免费：free', `code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '卡号', `pay_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '支付方式', `paid` tinyint(1) NOT NULL DEFAULT 0 COMMENT '支付状态 0: 未支付 1：已支付', `pay_price` decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '支付金额', `member_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '会员卡价格', `pay_time` int(50) UNSIGNED NOT NULL DEFAULT 0 COMMENT '会员购买时间', `trade_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '支付宝支付,支付宝交易订单号', `channel_type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '支付渠道(微信公众号 h5 小程序)', `is_free` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否免费', `is_permanent` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否永久', `overdue_time` int(50) UNSIGNED NOT NULL DEFAULT 0 COMMENT '会员过期时间', `is_del` tinyint(1) NOT NULL DEFAULT 0 COMMENT '删除', `vip_day` int(10) NOT NULL DEFAULT 0 COMMENT '会员有效天数', `add_time` int(50) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加时间', `money` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '原价格', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '会员购买记录表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for eb_other_order_status -- ---------------------------- DROP TABLE IF EXISTS `eb_other_order_status`; CREATE TABLE `eb_other_order_status` ( `oid` int(10) UNSIGNED NOT NULL COMMENT '订单id', `change_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '操作类型', `change_message` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '操作备注', `shop_type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '订单类型 1：会员卡', `change_time` int(10) NOT NULL DEFAULT 0, INDEX `oid`(`oid`) USING BTREE, INDEX `change_type`(`change_type`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '订单操作记录表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for eb_qrcode -- ---------------------------- DROP TABLE IF EXISTS `eb_qrcode`; CREATE TABLE `eb_qrcode` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '微信二维码ID', `third_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '二维码类型', `third_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户id', `ticket` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '二维码参数', `expire_seconds` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '二维码有效时间', `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态', `add_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '添加时间', `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '微信访问url', `qrcode_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '微信二维码url', `scan` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '被扫的次数', `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '二维码所属平台1=小程序，2=公众号，3=H5', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `third_type`(`third_type`, `third_id`) USING BTREE, INDEX `ticket`(`ticket`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '微信二维码管理表' ROW_FORMAT = COMPACT; -- ---------------------------- -- Table structure for eb_routine_access_token -- ---------------------------- DROP TABLE IF EXISTS `eb_routine_access_token`; CREATE TABLE `eb_routine_access_token` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '小程序access_token表ID', `access_token` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'openid', `stop_time` int(11) UNSIGNED NOT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '小程序access_token表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_routine_form_id -- ---------------------------- DROP TABLE IF EXISTS `eb_routine_form_id`; CREATE TABLE `eb_routine_form_id` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表单ID表ID', `uid` int(11) NULL DEFAULT 0 COMMENT '用户uid', `form_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '表单ID', `stop_time` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '表单ID失效时间', `status` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '状态1 未使用 2不能使用', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '表单id表记录表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_routine_qrcode -- ---------------------------- DROP TABLE IF EXISTS `eb_routine_qrcode`; CREATE TABLE `eb_routine_qrcode` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '微信二维码ID', `third_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '二维码类型 spread(用户推广) product_spread(商品推广)', `third_id` int(11) UNSIGNED NOT NULL COMMENT '用户id', `status` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '状态 0不可用 1可用', `add_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '添加时间', `page` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '小程序页面路径带参数', `qrcode_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '小程序二维码路径', `url_time` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '二维码添加时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '小程序二维码管理表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_shipping_templates -- ---------------------------- DROP TABLE IF EXISTS `eb_shipping_templates`; CREATE TABLE `eb_shipping_templates` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号', `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模板名称', `type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '计费方式', `appoint` tinyint(1) NOT NULL DEFAULT 0 COMMENT '指定包邮', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序', `add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '运费模板表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_shipping_templates_free -- ---------------------------- DROP TABLE IF EXISTS `eb_shipping_templates_free`; CREATE TABLE `eb_shipping_templates_free` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号', `province_id` int(11) NOT NULL DEFAULT 0 COMMENT '省ID', `temp_id` int(11) NOT NULL DEFAULT 0 COMMENT '模板ID', `city_id` int(11) NOT NULL DEFAULT 0 COMMENT '城市ID', `number` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '包邮件数', `price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '包邮金额', `type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '计费方式', `uniqid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分组唯一值', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '运费模板指定城市运费表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_shipping_templates_region -- ---------------------------- DROP TABLE IF EXISTS `eb_shipping_templates_region`; CREATE TABLE `eb_shipping_templates_region` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号', `province_id` int(11) NOT NULL DEFAULT 0 COMMENT '省ID', `temp_id` int(11) NOT NULL DEFAULT 0 COMMENT '模板ID', `city_id` int(11) NOT NULL DEFAULT 0 COMMENT '城市ID', `first` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '首件', `first_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '首件运费', `continue` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '续件', `continue_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '续件运费', `type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '计费方式', `uniqid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分组唯一值', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '运费模板指定包邮关联表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_sms_record -- ---------------------------- DROP TABLE IF EXISTS `eb_sms_record`; CREATE TABLE `eb_sms_record` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '短信发送记录编号', `uid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '短信平台账号', `phone` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '接受短信的手机号', `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '短信内容', `add_time` int(11) UNSIGNED NOT NULL COMMENT '发送短信时间', `add_ip` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '添加记录ip', `template` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '短信模板ID', `resultcode` int(6) UNSIGNED NULL DEFAULT NULL COMMENT '状态码 100=成功,130=失败,131=空号,132=停机,133=关机,134=无状态', `record_id` int(11) UNSIGNED NOT NULL COMMENT '发送记录id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '短信发送记录表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_bargain -- ---------------------------- DROP TABLE IF EXISTS `eb_store_bargain`; CREATE TABLE `eb_store_bargain` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '砍价商品ID', `product_id` int(11) UNSIGNED NOT NULL COMMENT '关联商品ID', `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '砍价活动名称', `image` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '砍价活动图片', `unit_name` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单位名称', `stock` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '库存', `sales` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '销量', `images` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '砍价商品轮播图', `start_time` int(11) UNSIGNED NOT NULL COMMENT '砍价开启时间', `stop_time` int(11) UNSIGNED NOT NULL COMMENT '砍价结束时间', `store_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '砍价商品名称', `price` decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT '砍价金额', `min_price` decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT '砍价商品最低价', `num` int(11) UNSIGNED NOT NULL DEFAULT 1 COMMENT '可购买砍价商品数量', `bargain_max_price` decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT '用户每次砍价的最大金额', `bargain_min_price` decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT '用户每次砍价的最小金额', `bargain_num` int(11) UNSIGNED NOT NULL DEFAULT 1 COMMENT '用户帮砍的次数', `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '砍价状态 0(到砍价时间不自动开启) 1(到砍价时间自动开启时间)', `give_integral` decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '反多少积分', `info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '砍价活动简介', `cost` decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT '成本价', `sort` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序', `is_hot` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否推荐0不推荐1推荐', `is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否删除 0未删除 1删除', `add_time` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '添加时间', `is_postage` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否包邮 0不包邮 1包邮', `postage` decimal(10, 2) UNSIGNED NULL DEFAULT NULL COMMENT '邮费', `rule` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '砍价规则', `look` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '砍价商品浏览量', `share` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '砍价商品分享量', `temp_id` int(11) NULL DEFAULT NULL COMMENT '运费模板ID', `weight` decimal(8, 2) NULL DEFAULT 0.00 COMMENT '重量', `volume` decimal(8, 2) NULL DEFAULT 0.00 COMMENT '体积', `quota` int(10) NOT NULL DEFAULT 0 COMMENT '限购总数', `quota_show` int(10) NOT NULL DEFAULT 0 COMMENT '限量总数显示', `people_num` int(11) NOT NULL DEFAULT 1 COMMENT '用户帮砍的次数', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '砍价表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_bargain_user -- ---------------------------- DROP TABLE IF EXISTS `eb_store_bargain_user`; CREATE TABLE `eb_store_bargain_user` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用户参与砍价表ID', `uid` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '用户ID', `bargain_id` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '砍价商品id', `bargain_price_min` decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT '砍价的最低价', `bargain_price` decimal(8, 2) NULL DEFAULT NULL COMMENT '砍价金额', `price` decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT '砍掉的价格', `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '状态 1参与中 2 活动结束参与失败 3活动结束参与成功', `add_time` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '参与时间', `is_del` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否取消', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户参与砍价表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_bargain_user_help -- ---------------------------- DROP TABLE IF EXISTS `eb_store_bargain_user_help`; CREATE TABLE `eb_store_bargain_user_help` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '砍价用户帮助表ID', `uid` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '帮助的用户id', `bargain_id` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '砍价商品ID', `bargain_user_id` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '用户参与砍价表id', `price` decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT '帮助砍价多少金额', `add_time` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '添加时间', `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否自己砍价', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '砍价用户帮助表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_cart -- ---------------------------- DROP TABLE IF EXISTS `eb_store_cart`; CREATE TABLE `eb_store_cart` ( `id` bigint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '购物车表ID', `uid` int(10) UNSIGNED NOT NULL COMMENT '用户ID', `type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '类型', `product_id` int(10) UNSIGNED NOT NULL COMMENT '商品ID', `product_attr_unique` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品属性', `cart_num` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品数量', `add_time` int(10) UNSIGNED NOT NULL COMMENT '添加时间', `is_pay` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0 = 未购买 1 = 已购买', `is_del` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除', `is_new` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否为立即购买', `combination_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '拼团id', `seckill_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '秒杀商品ID', `bargain_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '砍价id', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '购物车商品状态', PRIMARY KEY (`id`) USING BTREE, INDEX `user_id`(`uid`) USING BTREE, INDEX `goods_id`(`product_id`) USING BTREE, INDEX `uid`(`uid`, `is_pay`) USING BTREE, INDEX `uid_2`(`uid`, `is_del`) USING BTREE, INDEX `uid_3`(`uid`, `is_new`) USING BTREE, INDEX `type`(`type`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '购物车表' ROW_FORMAT = COMPACT; -- ---------------------------- -- Table structure for eb_store_category -- ---------------------------- DROP TABLE IF EXISTS `eb_store_category`; CREATE TABLE `eb_store_category` ( `id` mediumint(11) NOT NULL AUTO_INCREMENT COMMENT '商品分类表ID', `pid` mediumint(11) NOT NULL COMMENT '父id', `cate_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '分类名称', `sort` mediumint(11) NOT NULL COMMENT '排序', `pic` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '图标', `is_show` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否推荐', `add_time` int(11) NOT NULL COMMENT '添加时间', `big_pic` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分类大图', PRIMARY KEY (`id`) USING BTREE, INDEX `pid`(`pid`) USING BTREE, INDEX `is_base`(`is_show`) USING BTREE, INDEX `sort`(`sort`) USING BTREE, INDEX `add_time`(`add_time`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品分类表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_combination -- ---------------------------- DROP TABLE IF EXISTS `eb_store_combination`; CREATE TABLE `eb_store_combination` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `product_id` int(10) UNSIGNED NOT NULL COMMENT '商品id', `mer_id` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '商户id', `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '推荐图', `images` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '轮播图', `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '活动标题', `attr` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '活动属性', `people` int(2) UNSIGNED NOT NULL COMMENT '参团人数', `info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '简介', `price` decimal(10, 2) UNSIGNED NOT NULL COMMENT '价格', `sort` int(10) UNSIGNED NOT NULL COMMENT '排序', `sales` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '销量', `stock` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '库存', `add_time` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '添加时间', `is_host` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '推荐', `is_show` tinyint(1) UNSIGNED NOT NULL COMMENT '商品状态', `is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0, `combination` tinyint(1) UNSIGNED NOT NULL DEFAULT 1, `mer_use` tinyint(1) UNSIGNED NULL DEFAULT NULL COMMENT '商户是否可用1可用0不可用', `is_postage` tinyint(1) UNSIGNED NOT NULL COMMENT '是否包邮1是0否', `postage` decimal(10, 2) UNSIGNED NOT NULL COMMENT '邮费', `start_time` int(11) UNSIGNED NOT NULL COMMENT '拼团开始时间', `stop_time` int(11) UNSIGNED NOT NULL COMMENT '拼团结束时间', `effective_time` int(11) NOT NULL DEFAULT 0 COMMENT '拼团订单有效时间', `cost` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '拼图商品成本', `browse` int(11) NULL DEFAULT 0 COMMENT '浏览量', `unit_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '单位名', `temp_id` int(11) NULL DEFAULT NULL COMMENT '运费模板ID', `weight` decimal(8, 2) NULL DEFAULT 0.00 COMMENT '重量', `volume` decimal(8, 2) NULL DEFAULT 0.00 COMMENT '体积', `num` int(11) NULL DEFAULT NULL COMMENT '单次购买数量', `once_num` int(11) NOT NULL DEFAULT 0 COMMENT '每个订单可购买数量', `quota` int(10) NOT NULL DEFAULT 0 COMMENT '限购总数', `quota_show` int(10) NOT NULL DEFAULT 0 COMMENT '限量总数显示', `virtual` int(11) NOT NULL DEFAULT 100 COMMENT '虚拟成团百分比', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '拼团商品表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_coupon -- ---------------------------- DROP TABLE IF EXISTS `eb_store_coupon`; CREATE TABLE `eb_store_coupon` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '优惠券表ID', `title` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '优惠券名称', `integral` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '兑换消耗积分值', `coupon_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '兑换的优惠券面值', `use_min_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '最低消费多少金额可用优惠券', `coupon_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '优惠券有效期限（单位：天）', `sort` int(11) UNSIGNED NOT NULL DEFAULT 1 COMMENT '排序', `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '状态（0：关闭，1：开启）', `add_time` int(11) UNSIGNED NOT NULL COMMENT '兑换项目添加时间', `is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否删除', `product_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '所属商品id', `category_id` int(11) NOT NULL DEFAULT 0 COMMENT '分类id', `type` tinyint(2) NOT NULL DEFAULT 0 COMMENT '优惠券类型 0-通用 1-品类券 2-商品券', PRIMARY KEY (`id`) USING BTREE, INDEX `state`(`status`) USING BTREE, INDEX `add_time`(`add_time`) USING BTREE, INDEX `coupon_time`(`coupon_time`) USING BTREE, INDEX `is_del`(`is_del`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '优惠券表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_coupon_issue -- ---------------------------- DROP TABLE IF EXISTS `eb_store_coupon_issue`; CREATE TABLE `eb_store_coupon_issue` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `cid` int(10) NULL DEFAULT NULL COMMENT '优惠券ID', `coupon_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '优惠券名称', `start_time` int(10) NULL DEFAULT NULL COMMENT '优惠券领取开启时间', `end_time` int(10) NULL DEFAULT NULL COMMENT '优惠券领取结束时间', `total_count` int(10) NULL DEFAULT NULL COMMENT '优惠券领取数量', `remain_count` int(10) NULL DEFAULT NULL COMMENT '优惠券剩余领取数量', `is_permanent` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否无限张数', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1 正常 0 未开启 -1 已无效', `is_give_subscribe` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否首次关注赠送 0-否(默认) 1-是', `is_full_give` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否满赠0-否(默认) 1-是', `full_reduction` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '消费满多少赠送优惠券', `is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0, `add_time` int(10) NULL DEFAULT NULL COMMENT '优惠券添加时间', `title` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '优惠券名称', `integral` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '兑换消耗积分值', `coupon_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '兑换的优惠券面值', `use_min_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '最低消费多少金额可用优惠券', `coupon_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '优惠券有效期限（单位：天）', `product_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '所属商品id', `category_id` int(11) NOT NULL DEFAULT 0 COMMENT '分类id', `type` tinyint(2) NOT NULL DEFAULT 0 COMMENT '优惠券类型 0-通用 1-品类券 2-商品券', `receive_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '1 手动领取，2 新人券，3赠送券，4会员券', `start_use_time` int(11) NOT NULL DEFAULT 0 COMMENT '优惠券使用开始时间', `end_use_time` int(11) NOT NULL DEFAULT 0 COMMENT '优惠券使用结束时间', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序', PRIMARY KEY (`id`) USING BTREE, INDEX `cid`(`cid`) USING BTREE, INDEX `start_time`(`start_time`, `end_time`) USING BTREE, INDEX `remain_count`(`remain_count`) USING BTREE, INDEX `status`(`status`) USING BTREE, INDEX `coupon_time`(`coupon_time`) USING BTREE, INDEX `is_del`(`is_del`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '优惠券前台领取表' ROW_FORMAT = COMPACT; -- ---------------------------- -- Table structure for eb_store_coupon_issue_user -- ---------------------------- DROP TABLE IF EXISTS `eb_store_coupon_issue_user`; CREATE TABLE `eb_store_coupon_issue_user` ( `uid` int(10) NULL DEFAULT NULL COMMENT '领取优惠券用户ID', `issue_coupon_id` int(10) NULL DEFAULT NULL COMMENT '优惠券前台领取ID', `add_time` int(10) NULL DEFAULT NULL COMMENT '领取时间', UNIQUE INDEX `uid`(`uid`, `issue_coupon_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '优惠券前台用户领取记录表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_coupon_product -- ---------------------------- DROP TABLE IF EXISTS `eb_store_coupon_product`; CREATE TABLE `eb_store_coupon_product` ( `coupon_id` int(11) NOT NULL DEFAULT 0 COMMENT '优惠卷模板id', `product_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品id', INDEX `coupon_id`(`coupon_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '优惠卷模板关联列表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_coupon_user -- ---------------------------- DROP TABLE IF EXISTS `eb_store_coupon_user`; CREATE TABLE `eb_store_coupon_user` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '优惠券发放记录id', `cid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '兑换的项目id', `uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '优惠券所属用户', `coupon_title` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '优惠券名称', `coupon_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '优惠券的面值', `use_min_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '最低消费多少金额可用优惠券', `add_time` int(11) UNSIGNED NOT NULL COMMENT '优惠券创建时间', `start_time` int(11) NOT NULL DEFAULT 0, `end_time` int(11) UNSIGNED NOT NULL COMMENT '优惠券结束时间', `use_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '使用时间', `type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'send' COMMENT '获取方式', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态（0：未使用，1：已使用, 2:已过期）', `is_fail` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否有效', PRIMARY KEY (`id`) USING BTREE, INDEX `cid`(`cid`) USING BTREE, INDEX `uid`(`uid`) USING BTREE, INDEX `add_time`(`add_time`) USING BTREE, INDEX `end_time`(`end_time`) USING BTREE, INDEX `status`(`status`) USING BTREE, INDEX `is_fail`(`is_fail`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '优惠券发放记录表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_order -- ---------------------------- DROP TABLE IF EXISTS `eb_store_order`; CREATE TABLE `eb_store_order` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '订单ID', `order_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单号', `trade_no` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '支付宝订单号', `uid` int(11) UNSIGNED NOT NULL COMMENT '用户id', `real_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户姓名', `user_phone` varchar(18) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户电话', `user_address` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '详细地址', `cart_id` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '[]' COMMENT '购物车id', `freight_price` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '运费金额', `total_num` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '订单商品总数', `total_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '订单总价', `total_postage` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '邮费', `pay_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '实际支付金额', `pay_postage` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '支付邮费', `deduction_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '抵扣金额', `coupon_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '优惠券id', `coupon_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '优惠券金额', `paid` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '支付状态', `pay_time` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '支付时间', `pay_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '支付方式', `add_time` int(11) UNSIGNED NOT NULL COMMENT '创建时间', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '订单状态（-1 : 申请退款 -2 : 退货成功 0：待发货；1：待收货；2：已收货；3：待评价；-1：已退款）', `refund_status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '0 未退款 1 申请中 2 已退款', `refund_reason_wap_img` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '退款图片', `refund_reason_wap_explain` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '退款用户说明', `refund_reason_time` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '退款时间', `refund_reason_wap` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '前台退款原因', `refund_reason` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '不退款的理由', `refund_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '退款金额', `delivery_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '快递名称/送货人姓名', `delivery_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '快递公司编码', `delivery_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发货类型', `delivery_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '快递单号/手机号', `fictitious_content` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '虚拟发货内容', `delivery_uid` int(11) NOT NULL DEFAULT 0 COMMENT '配送员id', `gain_integral` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '消费赚取积分', `use_integral` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '使用积分', `back_integral` decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT '给用户退了多少积分', `mark` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '备注', `is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否删除', `unique` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '唯一id(md5加密)类似id', `remark` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理员备注', `mer_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商户ID', `is_mer_check` tinyint(3) UNSIGNED NOT NULL DEFAULT 0, `combination_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '拼团商品id0一般商品', `pink_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '拼团id 0没有拼团', `cost` decimal(8, 2) UNSIGNED NOT NULL COMMENT '成本价', `seckill_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '秒杀商品ID', `bargain_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '砍价id', `verify_code` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '核销码', `store_id` int(11) NOT NULL DEFAULT 0 COMMENT '门店id', `shipping_type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '配送方式 1=快递 ，2=门店自提', `clerk_id` int(11) NOT NULL DEFAULT 0 COMMENT '店员id', `is_channel` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '支付渠道(0微信公众号1微信小程序)', `is_remind` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '消息提醒', `is_system_del` tinyint(1) NULL DEFAULT 0 COMMENT '后台是否删除', `channel_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户访问端标识', `province` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户省份', `express_dump` varchar(502) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '订单面单打印信息', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `order_id_2`(`order_id`, `uid`) USING BTREE, UNIQUE INDEX `unique`(`unique`) USING BTREE, INDEX `uid`(`uid`) USING BTREE, INDEX `add_time`(`add_time`) USING BTREE, INDEX `pay_price`(`pay_price`) USING BTREE, INDEX `paid`(`paid`) USING BTREE, INDEX `pay_time`(`pay_time`) USING BTREE, INDEX `pay_type`(`pay_type`) USING BTREE, INDEX `status`(`status`) USING BTREE, INDEX `is_del`(`is_del`) USING BTREE, INDEX `coupon_id`(`coupon_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '订单表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_order_cart_info -- ---------------------------- DROP TABLE IF EXISTS `eb_store_order_cart_info`; CREATE TABLE `eb_store_order_cart_info` ( `oid` int(11) UNSIGNED NOT NULL COMMENT '订单id', `cart_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '购物车id', `product_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品ID', `cart_info` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '购买东西的详细信息', `unique` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '唯一id', UNIQUE INDEX `oid`(`oid`, `unique`) USING BTREE, INDEX `cart_id`(`cart_id`) USING BTREE, INDEX `product_id`(`product_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '订单购物详情表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_order_economize -- ---------------------------- DROP TABLE IF EXISTS `eb_store_order_economize`; CREATE TABLE `eb_store_order_economize` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '订单ID', `order_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单号', `uid` int(11) UNSIGNED NOT NULL COMMENT '用户id', `order_type` tinyint(1) UNSIGNED ZEROFILL NOT NULL DEFAULT 1 COMMENT '配送方式 1=商品订单 ，2=线下订单', `pay_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '实际支付金额', `postage_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '邮费优惠金额', `member_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '会员优惠金额', `offline_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '线下优惠金额', `coupon_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '优惠券优惠金额', `add_time` int(11) UNSIGNED NOT NULL COMMENT '创建时间', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态', PRIMARY KEY (`id`, `order_id`, `uid`) USING BTREE, UNIQUE INDEX `order_id_2`(`order_id`, `uid`) USING BTREE, INDEX `uid`(`uid`) USING BTREE, INDEX `add_time`(`add_time`) USING BTREE, INDEX `pay_price`(`pay_price`) USING BTREE, INDEX `status`(`status`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户资金节省表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_order_invoice -- ---------------------------- DROP TABLE IF EXISTS `eb_store_order_invoice`; CREATE TABLE `eb_store_order_invoice` ( `id` int(10) NOT NULL AUTO_INCREMENT, `uid` int(10) NOT NULL DEFAULT 0 COMMENT '用户uid', `category` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'order' COMMENT '开票分类 order:订单', `order_id` int(10) NOT NULL DEFAULT 0 COMMENT '订单id', `invoice_id` int(10) NOT NULL DEFAULT 0 COMMENT '发票id', `header_type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '抬头类型', `type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '发票类型', `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '名称（发票抬头）', `duty_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '税号', `drawer_phone` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '开票人手机号', `email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '开票人邮箱', `tell` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '注册电话', `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '注册地址', `bank` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '开户行', `card_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '银行卡号', `is_pay` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否支付', `is_refund` tinyint(1) NOT NULL DEFAULT 0 COMMENT '订单是否退款', `is_invoice` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开票', `invoice_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '开票票号', `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '备注', `invoice_time` int(10) NOT NULL DEFAULT 0 COMMENT '开票时间', `add_time` int(10) NOT NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_order_status -- ---------------------------- DROP TABLE IF EXISTS `eb_store_order_status`; CREATE TABLE `eb_store_order_status` ( `oid` int(10) UNSIGNED NOT NULL COMMENT '订单id', `change_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '操作类型', `change_message` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '操作备注', `change_time` int(10) UNSIGNED NOT NULL COMMENT '操作时间', INDEX `oid`(`oid`) USING BTREE, INDEX `change_type`(`change_type`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '订单操作记录表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_pink -- ---------------------------- DROP TABLE IF EXISTS `eb_store_pink`; CREATE TABLE `eb_store_pink` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uid` int(10) UNSIGNED NOT NULL COMMENT '用户id', `nickname` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户昵称', `avatar` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户头像', `order_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单id 生成', `order_id_key` int(10) UNSIGNED NOT NULL COMMENT '订单id 数据库', `total_num` int(10) UNSIGNED NOT NULL COMMENT '购买商品个数', `total_price` decimal(10, 2) UNSIGNED NOT NULL COMMENT '购买总金额', `cid` int(10) UNSIGNED NOT NULL COMMENT '拼团商品id', `pid` int(10) UNSIGNED NOT NULL COMMENT '商品id', `people` int(10) UNSIGNED NOT NULL COMMENT '拼图总人数', `price` decimal(10, 2) UNSIGNED NOT NULL COMMENT '拼团商品单价', `add_time` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '开始时间', `stop_time` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `k_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '团长id 0为团长', `is_tpl` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否发送模板消息0未发送1已发送', `is_refund` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否退款 0未退款 1已退款', `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态1进行中2已完成3未完成', `is_virtual` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否虚拟拼团', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '拼团表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_product -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product`; CREATE TABLE `eb_store_product` ( `id` mediumint(11) NOT NULL AUTO_INCREMENT COMMENT '商品id', `mer_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商户Id(0为总后台管理员创建,不为0的时候是商户后台创建)', `image` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品图片', `recommend_image` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '推荐图', `slider_image` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '轮播图', `store_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品名称', `store_info` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品简介', `keyword` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '关键字', `bar_code` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品条码（一维码）', `cate_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '分类id', `price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '商品价格', `vip_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '会员价格', `ot_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '市场价', `postage` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '邮费', `unit_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '单位名', `sort` smallint(11) NOT NULL DEFAULT 0 COMMENT '排序', `sales` mediumint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '销量', `stock` mediumint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '库存', `is_show` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态（0：未上架，1：上架）', `is_hot` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否热卖', `is_benefit` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否优惠', `is_best` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否精品', `is_new` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否新品', `add_time` int(11) UNSIGNED NOT NULL COMMENT '添加时间', `is_postage` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否包邮', `is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否删除', `mer_use` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商户是否代理 0不可代理1可代理', `give_integral` decimal(8, 2) UNSIGNED NOT NULL COMMENT '获得积分', `cost` decimal(8, 2) UNSIGNED NOT NULL COMMENT '成本价', `is_seckill` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '秒杀状态 0 未开启 1已开启', `is_bargain` tinyint(1) UNSIGNED NULL DEFAULT NULL COMMENT '砍价状态 0未开启 1开启', `is_good` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否优品推荐', `is_sub` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否单独分佣', `is_vip` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开启会员价格', `ficti` mediumint(11) NULL DEFAULT 100 COMMENT '虚拟销量', `browse` int(11) NULL DEFAULT 0 COMMENT '浏览量', `code_path` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品二维码地址(用户小程序海报)', `soure_link` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '淘宝京东1688类型', `video_link` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '主图视频链接', `temp_id` int(11) NOT NULL DEFAULT 1 COMMENT '运费模板ID', `spec_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '规格 0单 1多', `activity` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '活动显示排序1=秒杀，2=砍价，3=拼团', `spu` char(13) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品SPU', `label_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '标签ID', `command_word` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '复制口令', PRIMARY KEY (`id`) USING BTREE, INDEX `cate_id`(`cate_id`) USING BTREE, INDEX `is_hot`(`is_hot`) USING BTREE, INDEX `is_benefit`(`is_benefit`) USING BTREE, INDEX `is_best`(`is_best`) USING BTREE, INDEX `is_new`(`is_new`) USING BTREE, INDEX `toggle_on_sale, is_del`(`is_del`) USING BTREE, INDEX `price`(`price`) USING BTREE, INDEX `is_show`(`is_show`) USING BTREE, INDEX `sort`(`sort`) USING BTREE, INDEX `sales`(`sales`) USING BTREE, INDEX `add_time`(`add_time`) USING BTREE, INDEX `is_postage`(`is_postage`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_product_attr -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_attr`; CREATE TABLE `eb_store_product_attr` ( `id` int(10) NOT NULL AUTO_INCREMENT, `product_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品ID', `attr_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '属性名', `attr_values` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '属性值', `type` tinyint(1) NULL DEFAULT 0 COMMENT '活动类型 0=商品，1=秒杀，2=砍价，3=拼团', PRIMARY KEY (`id`) USING BTREE, INDEX `store_id`(`product_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品属性表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_product_attr_result -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_attr_result`; CREATE TABLE `eb_store_product_attr_result` ( `product_id` int(10) UNSIGNED NOT NULL COMMENT '商品ID', `result` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品属性参数', `change_time` int(10) UNSIGNED NOT NULL COMMENT '上次修改时间', `type` tinyint(1) NULL DEFAULT 0 COMMENT '活动类型 0=商品，1=秒杀，2=砍价，3=拼团', INDEX `product_id`(`product_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品属性详情表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_product_attr_value -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_attr_value`; CREATE TABLE `eb_store_product_attr_value` ( `product_id` int(10) UNSIGNED NOT NULL COMMENT '商品ID', `suk` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品属性索引值 (attr_value|attr_value[|....])', `stock` int(10) UNSIGNED NOT NULL COMMENT '属性对应的库存', `sales` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '销量', `price` decimal(8, 2) UNSIGNED NOT NULL COMMENT '属性金额', `image` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片', `unique` char(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '唯一值', `cost` decimal(8, 2) UNSIGNED NOT NULL COMMENT '成本价', `bar_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品条码', `ot_price` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '原价', `vip_price` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '会员专享价', `weight` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '重量', `volume` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '体积', `brokerage` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '一级返佣', `brokerage_two` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '二级返佣', `type` tinyint(1) NULL DEFAULT 0 COMMENT '活动类型 0=商品，1=秒杀，2=砍价，3=拼团', `quota` int(11) NULL DEFAULT NULL COMMENT '活动限购数量', `quota_show` int(11) NULL DEFAULT NULL COMMENT '活动限购数量显示', INDEX `unique`(`unique`, `suk`) USING BTREE, INDEX `store_id`(`product_id`, `suk`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品属性值表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_product_cate -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_cate`; CREATE TABLE `eb_store_product_cate` ( `id` int(11) NOT NULL AUTO_INCREMENT, `product_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品id', `cate_id` int(11) NOT NULL DEFAULT 0 COMMENT '分类id', `add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间', `cate_pid` int(11) NOT NULL DEFAULT 0 COMMENT '一级分类id', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '商品状态', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品分类辅助表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_product_coupon -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_coupon`; CREATE TABLE `eb_store_product_coupon` ( `id` int(10) NOT NULL AUTO_INCREMENT, `product_id` int(10) NOT NULL DEFAULT 0 COMMENT '商品id', `issue_coupon_id` int(10) NOT NULL DEFAULT 0 COMMENT '优惠劵id', `add_time` int(10) NOT NULL DEFAULT 0 COMMENT '添加时间', `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '优惠券名称', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_product_description -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_description`; CREATE TABLE `eb_store_product_description` ( `product_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品ID', `description` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品详情', `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '商品类型', INDEX `product_id`(`product_id`, `type`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品详情表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_product_log -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_log`; CREATE TABLE `eb_store_product_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type` enum('visit','cart','order','pay','collect','refund') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '类型', `product_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品ID', `uid` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID', `visit_num` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否浏览', `cart_num` int(11) NOT NULL DEFAULT 0 COMMENT '加入购物车数量', `order_num` int(11) NOT NULL DEFAULT 0 COMMENT '下单数量', `pay_num` int(11) NOT NULL DEFAULT 0 COMMENT '支付数量', `pay_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '支付金额', `cost_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '商品成本价', `pay_uid` int(11) NOT NULL DEFAULT 0 COMMENT '支付用户ID', `refund_num` int(11) NOT NULL DEFAULT 0 COMMENT '退款数量', `refund_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '退款金额', `collect_num` tinyint(1) NOT NULL DEFAULT 0 COMMENT '收藏', `add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品统计' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_product_relation -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_relation`; CREATE TABLE `eb_store_product_relation` ( `uid` int(10) UNSIGNED NOT NULL COMMENT '用户ID', `product_id` int(10) UNSIGNED NOT NULL COMMENT '商品ID', `type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '类型(收藏(collect）、点赞(like))', `category` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '某种类型的商品(普通商品、秒杀商品)', `add_time` int(10) UNSIGNED NOT NULL COMMENT '添加时间', UNIQUE INDEX `uid`(`uid`, `product_id`, `type`, `category`) USING BTREE, INDEX `type`(`type`) USING BTREE, INDEX `category`(`category`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品点赞和收藏表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_product_reply -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_reply`; CREATE TABLE `eb_store_product_reply` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '评论ID', `uid` int(11) NOT NULL COMMENT '用户ID', `oid` int(11) NOT NULL COMMENT '订单ID', `unique` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '唯一id', `product_id` int(11) NOT NULL COMMENT '商品id', `reply_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'product' COMMENT '某种商品类型(普通商品、秒杀商品）', `product_score` tinyint(1) NOT NULL COMMENT '商品分数', `service_score` tinyint(1) NOT NULL COMMENT '服务分数', `comment` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论内容', `pics` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论图片', `add_time` int(11) NOT NULL COMMENT '评论时间', `merchant_reply_content` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理员回复内容', `merchant_reply_time` int(11) NULL DEFAULT NULL COMMENT '管理员回复时间', `is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '0未删除1已删除', `is_reply` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0未回复1已回复', `nickname` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名称', `avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户头像', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `order_id_2`(`oid`, `unique`) USING BTREE, INDEX `add_time`(`add_time`) USING BTREE, INDEX `parent_id`(`reply_type`) USING BTREE, INDEX `is_del`(`is_del`) USING BTREE, INDEX `product_score`(`product_score`) USING BTREE, INDEX `service_score`(`service_score`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '评论表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_product_rule -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_rule`; CREATE TABLE `eb_store_product_rule` ( `id` int(10) NOT NULL AUTO_INCREMENT, `rule_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '规格名称', `rule_value` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '规格值', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品规则值(规格)表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_seckill -- ---------------------------- DROP TABLE IF EXISTS `eb_store_seckill`; CREATE TABLE `eb_store_seckill` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '商品秒杀商品表id', `product_id` int(10) UNSIGNED NOT NULL COMMENT '商品id', `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '推荐图', `images` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '轮播图', `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '活动标题', `info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '简介', `price` decimal(10, 2) UNSIGNED NOT NULL COMMENT '价格', `cost` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '成本', `ot_price` decimal(10, 2) UNSIGNED NOT NULL COMMENT '原价', `give_integral` decimal(10, 2) UNSIGNED NOT NULL COMMENT '返多少积分', `sort` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序', `stock` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '库存', `sales` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '销量', `unit_name` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '单位名', `postage` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '邮费', `description` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '内容', `start_time` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '开始时间', `stop_time` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '结束时间', `add_time` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '添加时间', `status` tinyint(1) UNSIGNED NOT NULL COMMENT '商品状态', `is_postage` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否包邮', `is_hot` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '热门推荐', `is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '删除 0未删除1已删除', `num` int(11) UNSIGNED NOT NULL DEFAULT 1 COMMENT '最多秒杀几个', `is_show` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '显示', `time_id` int(11) NULL DEFAULT NULL COMMENT '时间段ID', `temp_id` int(11) NULL DEFAULT NULL COMMENT '运费模板ID', `weight` decimal(8, 2) NULL DEFAULT 0.00 COMMENT '商品重量', `volume` decimal(8, 2) NULL DEFAULT 0.00 COMMENT '商品体积', `quota` int(10) NOT NULL DEFAULT 0 COMMENT '限购总数', `quota_show` int(10) NOT NULL DEFAULT 0 COMMENT '限购总数显示', `once_num` int(11) NOT NULL DEFAULT 0 COMMENT '单次购买个数', PRIMARY KEY (`id`) USING BTREE, INDEX `product_id`(`product_id`) USING BTREE, INDEX `start_time`(`start_time`, `stop_time`) USING BTREE, INDEX `is_del`(`is_del`) USING BTREE, INDEX `is_hot`(`is_hot`) USING BTREE, INDEX `is_show`(`status`) USING BTREE, INDEX `add_time`(`add_time`) USING BTREE, INDEX `sort`(`sort`) USING BTREE, INDEX `is_postage`(`is_postage`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品秒杀商品表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_seckill_time -- ---------------------------- DROP TABLE IF EXISTS `eb_store_seckill_time`; CREATE TABLE `eb_store_seckill_time` ( `seckill_id` int(10) NOT NULL DEFAULT 0 COMMENT '秒杀活动ID', `time_id` int(10) NOT NULL DEFAULT 0 COMMENT '秒杀时间段ID' ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '秒杀时段表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_service -- ---------------------------- DROP TABLE IF EXISTS `eb_store_service`; CREATE TABLE `eb_store_service` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '客服id', `mer_id` int(11) NOT NULL DEFAULT 0 COMMENT '商户id', `uid` int(11) NOT NULL COMMENT '客服uid', `online` tinyint(1) NOT NULL COMMENT '是否在线', `account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '账号', `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '密码', `avatar` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '客服头像', `nickname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '代理名称', `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '客服电话', `add_time` int(11) NOT NULL COMMENT '添加时间', `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '0隐藏1显示', `notify` int(2) NULL DEFAULT 0 COMMENT '订单通知1开启0关闭', `customer` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否展示统计管理', `uniqid` varchar(35) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客服表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_service_feedback -- ---------------------------- DROP TABLE IF EXISTS `eb_store_service_feedback`; CREATE TABLE `eb_store_service_feedback` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(10) NOT NULL DEFAULT 0 COMMENT '用户UID', `rela_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '姓名', `phone` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '电话', `content` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '反馈内容', `make` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '备注', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态0=未查看，1=已查看', `add_time` int(10) NOT NULL DEFAULT 0 COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `uid`(`uid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '反馈' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_service_log -- ---------------------------- DROP TABLE IF EXISTS `eb_store_service_log`; CREATE TABLE `eb_store_service_log` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '客服用户对话记录表ID', `mer_id` int(11) NOT NULL DEFAULT 0 COMMENT '商户id', `msn` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '消息内容', `uid` int(11) NOT NULL COMMENT '发送人uid', `to_uid` int(11) NOT NULL COMMENT '接收人uid', `is_tourist` tinyint(1) NOT NULL DEFAULT 0 COMMENT '1=游客模式，0=非游客', `time_node` tinyint(1) NOT NULL DEFAULT 0 COMMENT '时间节点', `add_time` int(11) NOT NULL COMMENT '发送时间', `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已读（0：否；1：是；）', `remind` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否提醒过', `msn_type` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '消息类型 1=文字 2=表情 3=图片 4=语音', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客服用户对话记录表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_service_record -- ---------------------------- DROP TABLE IF EXISTS `eb_store_service_record`; CREATE TABLE `eb_store_service_record` ( `id` int(10) NOT NULL AUTO_INCREMENT, `user_id` int(10) NOT NULL DEFAULT 0 COMMENT '发送人的uid', `to_uid` int(10) NOT NULL DEFAULT 0 COMMENT '送达人的uid', `nickname` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '用户昵称', `avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '用户头像', `is_tourist` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否是游客', `online` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否在线', `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0 = pc,1=微信，2=小程序，3=H5', `add_time` int(10) NOT NULL DEFAULT 0 COMMENT '添加时间', `update_time` int(10) NOT NULL DEFAULT 0 COMMENT '更新时间', `mssage_num` int(10) NOT NULL DEFAULT 0 COMMENT '消息条数', `message` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '内容', `message_type` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE, INDEX `to_uid`(`to_uid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '客服聊天用户记录表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_service_speechcraft -- ---------------------------- DROP TABLE IF EXISTS `eb_store_service_speechcraft`; CREATE TABLE `eb_store_service_speechcraft` ( `id` int(11) NOT NULL AUTO_INCREMENT, `kefu_id` int(10) NOT NULL DEFAULT 0 COMMENT '0为全局话术', `cate_id` int(10) NOT NULL DEFAULT 0 COMMENT '0为不分类全局话术', `title` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '话术标题', `message` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '话术内容', `sort` int(10) NOT NULL DEFAULT 0 COMMENT '排序', `add_time` int(10) NOT NULL DEFAULT 0 COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `kefu_id`(`kefu_id`) USING BTREE, INDEX `cate_id`(`cate_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '客服话术' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_store_visit -- ---------------------------- DROP TABLE IF EXISTS `eb_store_visit`; CREATE TABLE `eb_store_visit` ( `id` int(10) NOT NULL AUTO_INCREMENT, `product_id` int(11) NULL DEFAULT NULL COMMENT '商品ID', `product_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品类型', `cate_id` int(11) NULL DEFAULT NULL COMMENT '商品分类ID', `type` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品类型', `uid` int(11) NULL DEFAULT NULL COMMENT '用户ID', `count` int(11) NULL DEFAULT NULL COMMENT '访问次数', `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注描述', `add_time` int(11) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `product_id`(`product_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品浏览分析表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_system_admin -- ---------------------------- DROP TABLE IF EXISTS `eb_system_admin`; CREATE TABLE `eb_system_admin` ( `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '后台管理员表ID', `account` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '后台管理员账号', `head_pic` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', `pwd` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '后台管理员密码', `real_name` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '后台管理员姓名', `roles` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '后台管理员权限(menus_id)', `last_ip` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '后台管理员最后一次登录ip', `last_time` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '后台管理员最后一次登录时间', `add_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '后台管理员添加时间', `login_count` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '登录次数', `level` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '后台管理员级别', `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '后台管理员状态 1有效0无效', `is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE, INDEX `account`(`account`) USING BTREE, INDEX `status`(`status`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '后台管理员表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_system_attachment -- ---------------------------- DROP TABLE IF EXISTS `eb_system_attachment`; CREATE TABLE `eb_system_attachment` ( `att_id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '附件名称', `att_dir` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '附件路径', `satt_dir` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '压缩图片路径', `att_size` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '附件大小', `att_type` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '附件类型', `pid` int(10) NOT NULL DEFAULT 0 COMMENT '分类ID0编辑器,1商品图片,2拼团图片,3砍价图片,4秒杀图片,5文章图片,6组合数据图', `time` int(11) NOT NULL DEFAULT 0 COMMENT '上传时间', `image_type` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '图片上传类型 1本地 2七牛云 3OSS 4COS ', `module_type` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '图片上传模块类型 1 后台上传 2 用户生成', `real_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '原始文件名', PRIMARY KEY (`att_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '附件管理表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_system_attachment_category -- ---------------------------- DROP TABLE IF EXISTS `eb_system_attachment_category`; CREATE TABLE `eb_system_attachment_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `pid` int(11) NULL DEFAULT 0 COMMENT '父级ID', `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分类名称', `enname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分类目录', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `id`(`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '附件分类表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_system_city -- ---------------------------- DROP TABLE IF EXISTS `eb_system_city`; CREATE TABLE `eb_system_city` ( `id` int(11) NOT NULL AUTO_INCREMENT, `city_id` int(11) NOT NULL DEFAULT 0 COMMENT '城市id', `level` int(11) NOT NULL DEFAULT 0 COMMENT '省市级别', `parent_id` int(11) NOT NULL DEFAULT 0 COMMENT '父级id', `area_code` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '区号', `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '名称', `merger_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '合并名称', `lng` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '经度', `lat` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '纬度', `is_show` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否展示', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '城市表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_system_config -- ---------------------------- DROP TABLE IF EXISTS `eb_system_config`; CREATE TABLE `eb_system_config` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '配置id', `menu_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字段名称', `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '类型(文本框,单选按钮...)', `input_type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'input' COMMENT '表单类型', `config_tab_id` int(10) UNSIGNED NOT NULL COMMENT '配置分类id', `parameter` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '规则 单选框和多选框', `upload_type` tinyint(1) UNSIGNED NULL DEFAULT NULL COMMENT '上传文件格式1单图2多图3文件', `required` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '规则', `width` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '多行文本框的宽度', `high` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '多行文框的高度', `value` varchar(5000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '默认值', `info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '配置名称', `desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '配置简介', `sort` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序', `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否隐藏', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '配置表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_system_config_tab -- ---------------------------- DROP TABLE IF EXISTS `eb_system_config_tab`; CREATE TABLE `eb_system_config_tab` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '配置分类id', `pid` int(11) NOT NULL DEFAULT 0 COMMENT '上级分类id', `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '配置分类名称', `eng_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '配置分类英文名称', `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '配置分类状态', `info` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '配置分类是否显示', `icon` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图标', `type` int(2) NULL DEFAULT 0 COMMENT '配置类型', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '配置分类表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_system_file -- ---------------------------- DROP TABLE IF EXISTS `eb_system_file`; CREATE TABLE `eb_system_file` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '文件对比ID', `cthash` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '文件内容', `filename` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '文价名称', `atime` char(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '上次访问时间', `mtime` char(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '上次修改时间', `ctime` char(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '上次改变时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '文件对比表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_system_group -- ---------------------------- DROP TABLE IF EXISTS `eb_system_group`; CREATE TABLE `eb_system_group` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '组合数据ID', `cate_id` int(11) NOT NULL DEFAULT 0 COMMENT '分类id', `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '数据组名称', `info` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '数据提示', `config_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '数据字段', `fields` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '数据组字段以及类型（json数据）', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `config_name`(`config_name`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '组合数据表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_system_group_data -- ---------------------------- DROP TABLE IF EXISTS `eb_system_group_data`; CREATE TABLE `eb_system_group_data` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '组合数据详情ID', `gid` int(11) NOT NULL DEFAULT 0 COMMENT '对应的数据组id', `value` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '数据组对应的数据值（json数据）', `add_time` int(10) NOT NULL DEFAULT 0 COMMENT '添加数据时间', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '数据排序', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态（1：开启；2：关闭；）', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '组合数据详情表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_system_log -- ---------------------------- DROP TABLE IF EXISTS `eb_system_log`; CREATE TABLE `eb_system_log` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '管理员操作记录ID', `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '管理员id', `admin_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '管理员姓名', `path` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '链接', `page` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '行为', `method` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '访问类型', `ip` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '登录IP', `type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '类型', `add_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '操作时间', `merchant_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商户id', PRIMARY KEY (`id`) USING BTREE, INDEX `admin_id`(`admin_id`) USING BTREE, INDEX `add_time`(`add_time`) USING BTREE, INDEX `type`(`type`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '管理员操作记录表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_system_menus -- ---------------------------- DROP TABLE IF EXISTS `eb_system_menus`; CREATE TABLE `eb_system_menus` ( `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '菜单ID', `pid` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT '父级id', `icon` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '图标', `menu_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '按钮名', `module` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '模块名', `controller` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '控制器', `action` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '方法名', `api_url` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'api接口地址', `methods` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '提交方式POST GET PUT DELETE', `params` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '[]' COMMENT '参数', `sort` tinyint(3) NOT NULL DEFAULT 1 COMMENT '排序', `is_show` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否为隐藏菜单0=隐藏菜单,1=显示菜单', `is_show_path` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否为隐藏菜单供前台使用', `access` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '子管理员是否可用', `menu_path` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '路由名称 前端使用', `auth_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否为菜单 1菜单 2功能', `header` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '顶部菜单标示', `is_header` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否顶部菜单1是0否', `unique_auth` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '前台唯一标识', `is_del` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除', PRIMARY KEY (`id`) USING BTREE, INDEX `pid`(`pid`) USING BTREE, INDEX `is_show`(`is_show`) USING BTREE, INDEX `access`(`access`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '菜单表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_system_notice -- ---------------------------- DROP TABLE IF EXISTS `eb_system_notice`; CREATE TABLE `eb_system_notice` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '通知模板id', `title` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '通知标题', `type` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '通知类型', `icon` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '图标', `url` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '链接', `table_title` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '通知数据', `template` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '通知模板', `push_admin` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '通知管理员id', `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `type`(`type`) USING BTREE, INDEX `status`(`status`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '通知模板表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_system_notice_admin -- ---------------------------- DROP TABLE IF EXISTS `eb_system_notice_admin`; CREATE TABLE `eb_system_notice_admin` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '通知记录ID', `notice_type` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '通知类型', `admin_id` smallint(5) UNSIGNED NOT NULL COMMENT '通知的管理员', `link_id` int(10) UNSIGNED NOT NULL COMMENT '关联ID', `table_data` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '通知的数据', `is_click` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '点击次数', `is_visit` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数', `visit_time` int(11) NOT NULL COMMENT '访问时间', `add_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '通知时间', PRIMARY KEY (`id`) USING BTREE, INDEX `admin_id`(`admin_id`, `notice_type`) USING BTREE, INDEX `add_time`(`add_time`) USING BTREE, INDEX `is_visit`(`is_visit`) USING BTREE, INDEX `is_click`(`is_click`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '通知记录表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_system_role -- ---------------------------- DROP TABLE IF EXISTS `eb_system_role`; CREATE TABLE `eb_system_role` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '身份管理id', `role_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '身份管理名称', `rules` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '身份管理权限(menus_id)', `level` tinyint(3) UNSIGNED NOT NULL DEFAULT 0, `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态', PRIMARY KEY (`id`) USING BTREE, INDEX `status`(`status`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '身份管理表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_system_store -- ---------------------------- DROP TABLE IF EXISTS `eb_system_store`; CREATE TABLE `eb_system_store` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '门店名称', `introduction` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '简介', `phone` char(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '手机号码', `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '省市区', `detailed_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '详细地址', `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '门店logo', `latitude` char(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '纬度', `longitude` char(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '经度', `valid_time` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '核销有效日期', `day_time` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '每日营业开关时间', `add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间', `is_show` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否显示', `is_del` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除', PRIMARY KEY (`id`) USING BTREE, INDEX `phone`(`phone`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '门店自提' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_system_store_staff -- ---------------------------- DROP TABLE IF EXISTS `eb_system_store_staff`; CREATE TABLE `eb_system_store_staff` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `uid` int(10) UNSIGNED NOT NULL COMMENT '微信用户id', `avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '店员头像', `store_id` int(11) NOT NULL COMMENT '门店id', `staff_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '店员名称', `phone` char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号码', `verify_status` tinyint(2) NOT NULL DEFAULT 0 COMMENT '核销开关', `status` tinyint(2) NULL DEFAULT 1 COMMENT '状态', `add_time` int(10) NULL DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '门店店员表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_system_user_level -- ---------------------------- DROP TABLE IF EXISTS `eb_system_user_level`; CREATE TABLE `eb_system_user_level` ( `id` int(11) NOT NULL AUTO_INCREMENT, `mer_id` int(11) NOT NULL DEFAULT 0 COMMENT '商户id', `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '会员名称', `money` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '购买金额', `valid_date` int(11) NOT NULL DEFAULT 0 COMMENT '有效时间', `is_forever` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否为永久会员', `is_pay` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否购买,1=购买,0=不购买', `is_show` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否显示 1=显示,0=隐藏', `grade` int(11) NOT NULL DEFAULT 0 COMMENT '会员等级', `discount` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '享受折扣', `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '会员卡背景', `icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '会员图标', `explain` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '说明', `add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间', `is_del` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除.1=删除,0=未删除', `exp_num` int(10) NOT NULL DEFAULT 0 COMMENT '升级经验', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '设置用户等级表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_system_user_task -- ---------------------------- DROP TABLE IF EXISTS `eb_system_user_task`; CREATE TABLE `eb_system_user_task` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '任务名称', `real_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '配置原名', `task_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '任务类型', `number` int(11) NOT NULL DEFAULT 0 COMMENT '限定数', `level_id` int(11) NOT NULL DEFAULT 0 COMMENT '等级id', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序', `is_show` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否显示', `is_must` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否务必达成任务,1务必达成,0=满足其一', `illustrate` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '任务说明', `add_time` int(11) NOT NULL DEFAULT 0 COMMENT '新增时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '等级任务设置' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_template_message -- ---------------------------- DROP TABLE IF EXISTS `eb_template_message`; CREATE TABLE `eb_template_message` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '模板id', `type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0=订阅消息,1=微信模板消息', `tempkey` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模板编号', `name` char(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模板名', `kid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', `content` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '回复内容', `tempid` char(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板ID', `add_time` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '添加时间', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '状态', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '微信模板' ROW_FORMAT = COMPACT; -- ---------------------------- -- Table structure for eb_user -- ---------------------------- DROP TABLE IF EXISTS `eb_user`; CREATE TABLE `eb_user` ( `uid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用户id', `account` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户账号', `pwd` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户密码', `real_name` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '真实姓名', `birthday` int(11) NOT NULL DEFAULT 0 COMMENT '生日', `card_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '身份证号码', `mark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户备注', `partner_id` int(11) NOT NULL DEFAULT 0 COMMENT '合伙人id', `group_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户分组id', `nickname` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户昵称', `avatar` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户头像', `phone` char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号码', `add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加时间', `add_ip` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '添加ip', `last_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最后一次登录时间', `last_ip` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '最后一次登录ip', `now_money` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '用户余额', `brokerage_price` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '佣金金额', `integral` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户剩余积分', `exp` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '会员经验', `sign_num` int(11) NOT NULL DEFAULT 0 COMMENT '连续签到天数', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1为正常，0为禁止', `level` tinyint(2) UNSIGNED NOT NULL DEFAULT 0 COMMENT '等级', `spread_uid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '推广元id', `spread_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '推广员关联时间', `user_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户类型', `is_promoter` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否为推广员', `pay_count` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '用户购买次数', `spread_count` int(11) NULL DEFAULT 0 COMMENT '下级人数', `clean_time` int(11) NULL DEFAULT 0 COMMENT '清理会员时间', `addres` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '详细地址', `adminid` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '管理员编号 ', `login_type` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户登陆类型，h5,wechat,routine', `record_phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '记录临时电话', `is_money_level` tinyint(1) NOT NULL DEFAULT 0 COMMENT '会员来源 0: 购买商品升级 1：花钱购买的会员2: 会员卡领取', `is_ever_level` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否永久性会员 0: 非永久会员 1：永久会员', `overdue_time` int(10) NOT NULL DEFAULT 0 COMMENT '会员到期时间', `uniqid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', PRIMARY KEY (`uid`) USING BTREE, INDEX `account`(`account`) USING BTREE, INDEX `spreaduid`(`spread_uid`) USING BTREE, INDEX `level`(`level`) USING BTREE, INDEX `status`(`status`) USING BTREE, INDEX `is_promoter`(`is_promoter`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_user_address -- ---------------------------- DROP TABLE IF EXISTS `eb_user_address`; CREATE TABLE `eb_user_address` ( `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用户地址id', `uid` int(10) UNSIGNED NOT NULL COMMENT '用户id', `real_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '收货人姓名', `phone` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '收货人电话', `province` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '收货人所在省', `city` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '收货人所在市', `city_id` int(11) NOT NULL DEFAULT 0 COMMENT '城市id', `district` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '收货人所在区', `detail` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '收货人详细地址', `post_code` int(10) UNSIGNED NOT NULL COMMENT '邮编', `longitude` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '经度', `latitude` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '纬度', `is_default` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否默认', `is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否删除', `add_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `uid`(`uid`) USING BTREE, INDEX `is_default`(`is_default`) USING BTREE, INDEX `is_del`(`is_del`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户地址表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_user_bill -- ---------------------------- DROP TABLE IF EXISTS `eb_user_bill`; CREATE TABLE `eb_user_bill` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用户账单id', `uid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户uid', `link_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '关联id', `pm` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '0 = 支出 1 = 获得', `title` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '账单标题', `category` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '明细种类', `type` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '明细类型', `number` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '明细数字', `balance` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '剩余', `mark` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '备注', `add_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加时间', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '0 = 带确定 1 = 有效 -1 = 无效', `take` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0 = 未收货 1 = 已收货', PRIMARY KEY (`id`) USING BTREE, INDEX `openid`(`uid`) USING BTREE, INDEX `status`(`status`) USING BTREE, INDEX `add_time`(`add_time`) USING BTREE, INDEX `pm`(`pm`) USING BTREE, INDEX `type`(`category`, `type`, `link_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户账单表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_user_brokerage_frozen -- ---------------------------- DROP TABLE IF EXISTS `eb_user_brokerage_frozen`; CREATE TABLE `eb_user_brokerage_frozen` ( `id` int(10) NOT NULL AUTO_INCREMENT, `uid` int(10) NOT NULL DEFAULT 0 COMMENT '用户uid', `price` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '金额', `uill_id` int(10) NOT NULL DEFAULT 0 COMMENT '关联id', `frozen_time` int(10) NOT NULL COMMENT '冻结到期时间', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否有效', `add_time` int(10) NOT NULL DEFAULT 0 COMMENT '添加时间', `order_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '订单id', PRIMARY KEY (`id`) USING BTREE, INDEX `uid`(`uid`, `status`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '用户佣金冻结记录表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_user_enter -- ---------------------------- DROP TABLE IF EXISTS `eb_user_enter`; CREATE TABLE `eb_user_enter` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '商户申请ID', `uid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户ID', `province` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商户所在省', `city` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商户所在市', `district` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商户所在区', `address` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商户详细地址', `merchant_name` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商户名称', `link_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', `link_tel` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商户电话', `charter` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商户证书', `add_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加时间', `apply_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '审核时间', `success_time` int(11) NOT NULL COMMENT '通过时间', `fail_message` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '未通过原因', `fail_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '未通过时间', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '-1 审核未通过 0未审核 1审核通过', `is_lock` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '0 = 开启 1= 关闭', `is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否删除', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uid`(`uid`) USING BTREE, INDEX `province`(`province`, `city`, `district`) USING BTREE, INDEX `is_lock`(`is_lock`) USING BTREE, INDEX `is_del`(`is_del`) USING BTREE, INDEX `status`(`status`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商户申请表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_user_extract -- ---------------------------- DROP TABLE IF EXISTS `eb_user_extract`; CREATE TABLE `eb_user_extract` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uid` int(10) UNSIGNED NULL DEFAULT NULL, `real_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称', `extract_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'bank' COMMENT 'bank = 银行卡 alipay = 支付宝wx=微信', `bank_code` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '银行卡', `bank_address` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '开户地址', `alipay_code` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '支付宝账号', `extract_price` decimal(8, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '提现金额', `mark` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `balance` decimal(8, 2) UNSIGNED NULL DEFAULT 0.00, `fail_msg` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '无效原因', `fail_time` int(10) UNSIGNED NULL DEFAULT NULL, `add_time` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '添加时间', `status` tinyint(2) NULL DEFAULT 0 COMMENT '-1 未通过 0 审核中 1 已提现', `wechat` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微信号', `qrcode_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '二维码地址', PRIMARY KEY (`id`) USING BTREE, INDEX `extract_type`(`extract_type`) USING BTREE, INDEX `status`(`status`) USING BTREE, INDEX `add_time`(`add_time`) USING BTREE, INDEX `openid`(`uid`) USING BTREE, INDEX `fail_time`(`fail_time`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户提现表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_user_friends -- ---------------------------- DROP TABLE IF EXISTS `eb_user_friends`; CREATE TABLE `eb_user_friends` ( `id` int(10) NOT NULL AUTO_INCREMENT, `uid` int(10) NOT NULL DEFAULT 0 COMMENT '用户uid', `friends_uid` int(10) NOT NULL DEFAULT 0 COMMENT '好友uid', `add_time` int(10) NOT NULL DEFAULT 0 COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `uid`(`uid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '用户好友关系' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_user_group -- ---------------------------- DROP TABLE IF EXISTS `eb_user_group`; CREATE TABLE `eb_user_group` ( `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, `group_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户分组名称', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户分组表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_user_invoice -- ---------------------------- DROP TABLE IF EXISTS `eb_user_invoice`; CREATE TABLE `eb_user_invoice` ( `id` int(10) NOT NULL AUTO_INCREMENT, `uid` int(10) NOT NULL DEFAULT 0, `header_type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '抬头类型1:个人2：企业', `type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '发票类型1：普通2：专用', `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '名称（发票抬头）', `duty_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '税号', `drawer_phone` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '开票人手机号', `email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '开票人邮箱', `tell` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '注册电话', `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '注册地址', `bank` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '注册开户银行', `card_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '银行卡号', `is_default` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否默认', `is_del` tinyint(1) NOT NULL DEFAULT 0, `add_time` int(10) NOT NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户发票管理表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for eb_user_label -- ---------------------------- DROP TABLE IF EXISTS `eb_user_label`; CREATE TABLE `eb_user_label` ( `id` int(11) NOT NULL AUTO_INCREMENT, `label_cate` int(10) NULL DEFAULT 0 COMMENT '标签分类', `label_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '标签名称', PRIMARY KEY (`id`) USING BTREE, INDEX `label_cate`(`label_cate`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户标签表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_user_label_relation -- ---------------------------- DROP TABLE IF EXISTS `eb_user_label_relation`; CREATE TABLE `eb_user_label_relation` ( `uid` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID', `label_id` int(11) NOT NULL DEFAULT 0 COMMENT '标签ID' ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户标签关联表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_user_level -- ---------------------------- DROP TABLE IF EXISTS `eb_user_level`; CREATE TABLE `eb_user_level` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL DEFAULT 0 COMMENT '用户uid', `level_id` int(11) NOT NULL DEFAULT 0 COMMENT '等级vip', `grade` int(11) NOT NULL DEFAULT 0 COMMENT '会员等级', `valid_time` int(11) NOT NULL DEFAULT 0 COMMENT '过期时间', `is_forever` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否永久', `mer_id` int(11) NOT NULL DEFAULT 0 COMMENT '商户id', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0:禁止,1:正常', `mark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '备注', `remind` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已通知', `is_del` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除,0=未删除,1=删除', `add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间', `discount` int(11) NOT NULL DEFAULT 0 COMMENT '享受折扣', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `id`(`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户等级记录表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_user_notice -- ---------------------------- DROP TABLE IF EXISTS `eb_user_notice`; CREATE TABLE `eb_user_notice` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '接收消息的用户id（类型：json数据）', `type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '消息通知类型（1：系统消息；2：用户通知）', `user` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '发送人', `title` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '通知消息的标题信息', `content` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '通知消息的内容', `add_time` int(11) NOT NULL DEFAULT 0 COMMENT '通知消息发送的时间', `is_send` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否发送（0：未发送；1：已发送）', `send_time` int(11) NOT NULL COMMENT '发送时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户通知表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_user_notice_see -- ---------------------------- DROP TABLE IF EXISTS `eb_user_notice_see`; CREATE TABLE `eb_user_notice_see` ( `id` int(11) NOT NULL AUTO_INCREMENT, `nid` int(11) NOT NULL DEFAULT 0 COMMENT '查看的通知id', `uid` int(11) NOT NULL DEFAULT 0 COMMENT '查看通知的用户id', `add_time` int(11) NOT NULL DEFAULT 0 COMMENT '查看通知的时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户通知发送记录表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_user_recharge -- ---------------------------- DROP TABLE IF EXISTS `eb_user_recharge`; CREATE TABLE `eb_user_recharge` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `uid` int(10) NULL DEFAULT NULL COMMENT '充值用户UID', `order_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '订单号', `price` decimal(8, 2) NULL DEFAULT NULL COMMENT '充值金额', `give_price` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '购买赠送金额', `recharge_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '充值类型', `paid` tinyint(1) NULL DEFAULT NULL COMMENT '是否充值', `pay_time` int(10) NULL DEFAULT NULL COMMENT '充值支付时间', `add_time` int(12) NULL DEFAULT NULL COMMENT '充值时间', `refund_price` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '退款金额', `channel_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户访问端标识', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `order_id`(`order_id`) USING BTREE, INDEX `uid`(`uid`) USING BTREE, INDEX `recharge_type`(`recharge_type`) USING BTREE, INDEX `paid`(`paid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户充值表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_user_search -- ---------------------------- DROP TABLE IF EXISTS `eb_user_search`; CREATE TABLE `eb_user_search` ( `id` int(10) NOT NULL AUTO_INCREMENT, `uid` int(10) NOT NULL DEFAULT 0 COMMENT '用户uid', `keyword` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '搜索关键词', `num` int(8) NOT NULL DEFAULT 1 COMMENT '搜索次数', `result` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '搜索结果', `is_del` tinyint(1) NOT NULL DEFAULT 0 COMMENT '删除', `add_time` int(10) NOT NULL DEFAULT 0 COMMENT '时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_user_sign -- ---------------------------- DROP TABLE IF EXISTS `eb_user_sign`; CREATE TABLE `eb_user_sign` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL DEFAULT 0 COMMENT '用户uid', `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '签到说明', `number` int(11) NOT NULL DEFAULT 0 COMMENT '获得积分', `balance` int(11) NOT NULL DEFAULT 0 COMMENT '剩余积分', `add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, INDEX `uid`(`uid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '签到记录表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_user_task_finish -- ---------------------------- DROP TABLE IF EXISTS `eb_user_task_finish`; CREATE TABLE `eb_user_task_finish` ( `id` int(11) NOT NULL AUTO_INCREMENT, `task_id` int(11) NOT NULL DEFAULT 0 COMMENT '任务id', `uid` int(11) NOT NULL DEFAULT 0 COMMENT '用户id', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否有效', `add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `id`(`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户任务完成记录表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_user_token -- ---------------------------- DROP TABLE IF EXISTS `eb_user_token`; CREATE TABLE `eb_user_token` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(10) UNSIGNED NOT NULL COMMENT '用户 id', `token` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'token', `create_time` datetime(0) NOT NULL COMMENT '创建时间', `expires_time` datetime(0) NOT NULL COMMENT '到期事件', `login_ip` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录ip', PRIMARY KEY (`id`) USING BTREE, INDEX `uid`(`uid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_user_visit -- ---------------------------- DROP TABLE IF EXISTS `eb_user_visit`; CREATE TABLE `eb_user_visit` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL COMMENT '用户uid', `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '访问路径', `ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户ip', `stay_time` int(11) NOT NULL DEFAULT 0 COMMENT '页面停留时间(秒)', `add_time` int(11) NOT NULL DEFAULT 0 COMMENT '访问时间', `channel_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户访问端标识', `province` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '用户省份', PRIMARY KEY (`id`) USING BTREE, INDEX `time`(`channel_type`, `add_time`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户访问表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_wechat_key -- ---------------------------- DROP TABLE IF EXISTS `eb_wechat_key`; CREATE TABLE `eb_wechat_key` ( `id` mediumint(8) NOT NULL AUTO_INCREMENT, `reply_id` mediumint(8) NOT NULL COMMENT '回复内容id', `keys` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '关键词', PRIMARY KEY (`id`) USING BTREE ) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '微信回复关键词辅助表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for eb_wechat_media -- ---------------------------- DROP TABLE IF EXISTS `eb_wechat_media`; CREATE TABLE `eb_wechat_media` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '微信视频音频id', `type` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '回复类型', `path` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '文件路径', `media_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '微信服务器返回的id', `url` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '地址', `temporary` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否永久或者临时 0永久1临时', `add_time` int(10) UNSIGNED NOT NULL COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `type`(`type`, `media_id`) USING BTREE, INDEX `type_2`(`type`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '微信回复表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_wechat_message -- ---------------------------- DROP TABLE IF EXISTS `eb_wechat_message`; CREATE TABLE `eb_wechat_message` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用户行为记录id', `openid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户openid', `type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '操作类型', `result` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '操作详细记录', `add_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '操作时间', PRIMARY KEY (`id`) USING BTREE, INDEX `openid`(`openid`) USING BTREE, INDEX `type`(`type`) USING BTREE, INDEX `add_time`(`add_time`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户行为记录表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_wechat_news_category -- ---------------------------- DROP TABLE IF EXISTS `eb_wechat_news_category`; CREATE TABLE `eb_wechat_news_category` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '图文消息管理ID', `cate_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '图文名称', `sort` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序', `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态', `new_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '文章id', `add_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '图文消息管理表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_wechat_qrcode -- ---------------------------- DROP TABLE IF EXISTS `eb_wechat_qrcode`; CREATE TABLE `eb_wechat_qrcode` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '微信二维码ID', `third_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '二维码类型', `third_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户id', `ticket` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '二维码参数', `expire_seconds` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '二维码有效时间', `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态', `add_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '添加时间', `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '微信访问url', `qrcode_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '微信二维码url', `scan` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '被扫的次数', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `third_type`(`third_type`, `third_id`) USING BTREE, INDEX `ticket`(`ticket`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '微信二维码管理表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_wechat_reply -- ---------------------------- DROP TABLE IF EXISTS `eb_wechat_reply`; CREATE TABLE `eb_wechat_reply` ( `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '微信关键字回复id', `type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '回复类型', `data` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '回复数据', `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '0=不可用 1 =可用', `hide` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否隐藏', PRIMARY KEY (`id`) USING BTREE, INDEX `type`(`type`) USING BTREE, INDEX `status`(`status`) USING BTREE, INDEX `hide`(`hide`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '微信关键字回复表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for eb_wechat_user -- ---------------------------- DROP TABLE IF EXISTS `eb_wechat_user`; CREATE TABLE `eb_wechat_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(10) UNSIGNED NOT NULL COMMENT '微信用户id', `unionid` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '只有在用户将公众号绑定到微信开放平台帐号后，才会出现该字段', `openid` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户的标识，对当前公众号唯一', `nickname` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户的昵称', `headimgurl` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户头像', `sex` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户的性别，值为1时是男性，值为2时是女性，值为0时是未知', `city` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户所在城市', `language` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户的语言，简体中文为zh_CN', `province` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户所在省份', `country` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户所在国家', `remark` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公众号运营者对粉丝的备注，公众号运营者可在微信公众平台用户管理界面对粉丝添加备注', `groupid` smallint(5) UNSIGNED NULL DEFAULT 0 COMMENT '用户所在的分组ID（兼容旧的用户分组接口）', `tagid_list` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户被打上的标签ID列表', `subscribe` tinyint(3) UNSIGNED NULL DEFAULT 1 COMMENT '用户是否订阅该公众号标识', `subscribe_time` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '关注公众号时间', `add_time` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '添加时间', `second` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '二级推荐人', `user_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'wechat' COMMENT '用户类型', `is_complete` tinyint(1) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `openid`(`openid`) USING BTREE, INDEX `groupid`(`groupid`) USING BTREE, INDEX `subscribe_time`(`subscribe_time`) USING BTREE, INDEX `add_time`(`add_time`) USING BTREE, INDEX `subscribe`(`subscribe`) USING BTREE, INDEX `unionid`(`unionid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '微信用户表' ROW_FORMAT = Dynamic;