# 数据字典
```[sql]
-- ----------------------------
-- Table structure for eb_article
-- ----------------------------
DROP TABLE IF EXISTS `eb_article`;
CREATE TABLE `eb_article` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '文章管理ID',
`cid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '分类id',
`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文章标题',
`author` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文章作者',
`image_input` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文章图片',
`synopsis` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文章简介',
`share_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文章分享标题',
`share_synopsis` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文章分享简介',
`visit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '浏览次数',
`sort` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序',
`url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '原文链接',
`status` tinyint(1) UNSIGNED NOT NULL COMMENT '状态',
`add_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '添加时间',
`hide` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否隐藏',
`admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '管理员id',
`mer_id` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '商户id',
`product_id` int(10) NOT NULL DEFAULT 0 COMMENT '商品关联id',
`is_hot` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否热门(小程序)',
`is_banner` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否轮播图(小程序)',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '文章管理表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_article_category
-- ----------------------------
DROP TABLE IF EXISTS `eb_article_category`;
CREATE TABLE `eb_article_category` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '文章分类id',
`pid` int(11) NOT NULL DEFAULT 0 COMMENT '父级ID',
`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文章分类标题',
`intr` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文章分类简介',
`image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文章分类图片',
`status` tinyint(1) UNSIGNED NOT NULL COMMENT '状态',
`sort` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序',
`is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '1删除0未删除',
`add_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '添加时间',
`hidden` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否隐藏',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '文章分类表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_article_content
-- ----------------------------
DROP TABLE IF EXISTS `eb_article_content`;
CREATE TABLE `eb_article_content` (
`nid` int(10) UNSIGNED NOT NULL COMMENT '文章id',
`content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文章内容',
UNIQUE INDEX `nid`(`nid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '文章内容表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_cache
-- ----------------------------
DROP TABLE IF EXISTS `eb_cache`;
CREATE TABLE `eb_cache` (
`key` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`result` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '缓存数据',
`expire_time` int(11) NOT NULL DEFAULT 0 COMMENT '失效时间0=永久',
`add_time` int(10) NULL DEFAULT NULL COMMENT '缓存时间',
PRIMARY KEY (`key`) USING BTREE,
INDEX `key`(`key`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '微信缓存表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_diy
-- ----------------------------
DROP TABLE IF EXISTS `eb_diy`;
CREATE TABLE `eb_diy` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`version` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '版本号',
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '页面名称',
`value` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '页面数据',
`add_time` int(11) NULL DEFAULT NULL COMMENT '添加时间',
`update_time` int(11) NULL DEFAULT NULL COMMENT '更新时间',
`status` tinyint(1) NULL DEFAULT 0 COMMENT '是否使用',
`type` tinyint(1) NULL DEFAULT NULL COMMENT '页面类型',
`is_del` tinyint(1) NULL DEFAULT 0 COMMENT '是否删除',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'DIY数据表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for eb_express
-- ----------------------------
DROP TABLE IF EXISTS `eb_express`;
CREATE TABLE `eb_express` (
`id` mediumint(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '快递公司id',
`code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '快递公司简称',
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '快递公司全称',
`sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序',
`is_show` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否显示',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `code`(`code`) USING BTREE,
INDEX `is_show`(`is_show`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 427 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '快递公司表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_qrcode
-- ----------------------------
DROP TABLE IF EXISTS `eb_qrcode`;
CREATE TABLE `eb_qrcode` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '微信二维码ID',
`third_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '二维码类型',
`third_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户id',
`ticket` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '二维码参数',
`expire_seconds` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '二维码有效时间',
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态',
`add_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '添加时间',
`url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '微信访问url',
`qrcode_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '微信二维码url',
`scan` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '被扫的次数',
`type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '二维码所属平台1=小程序,2=公众号,3=H5',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `third_type`(`third_type`, `third_id`) USING BTREE,
INDEX `ticket`(`ticket`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '微信二维码管理表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_routine_access_token
-- ----------------------------
DROP TABLE IF EXISTS `eb_routine_access_token`;
CREATE TABLE `eb_routine_access_token` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '小程序access_token表ID',
`access_token` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'openid',
`stop_time` int(11) UNSIGNED NOT NULL COMMENT '添加时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '小程序access_token表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_routine_form_id
-- ----------------------------
DROP TABLE IF EXISTS `eb_routine_form_id`;
CREATE TABLE `eb_routine_form_id` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表单ID表ID',
`uid` int(11) NULL DEFAULT 0 COMMENT '用户uid',
`form_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '表单ID',
`stop_time` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '表单ID失效时间',
`status` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '状态1 未使用 2不能使用',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '表单id表记录表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_routine_qrcode
-- ----------------------------
DROP TABLE IF EXISTS `eb_routine_qrcode`;
CREATE TABLE `eb_routine_qrcode` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '微信二维码ID',
`third_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '二维码类型 spread(用户推广) product_spread(商品推广)',
`third_id` int(11) UNSIGNED NOT NULL COMMENT '用户id',
`status` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '状态 0不可用 1可用',
`add_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '添加时间',
`page` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '小程序页面路径带参数',
`qrcode_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '小程序二维码路径',
`url_time` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '二维码添加时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '小程序二维码管理表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_shipping_templates
-- ----------------------------
DROP TABLE IF EXISTS `eb_shipping_templates`;
CREATE TABLE `eb_shipping_templates` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模板名称',
`type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '计费方式',
`appoint` tinyint(1) NOT NULL DEFAULT 0 COMMENT '指定包邮',
`sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序',
`add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 COMMENT = '运费模板' CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_shipping_templates_free
-- ----------------------------
DROP TABLE IF EXISTS `eb_shipping_templates_free`;
CREATE TABLE `eb_shipping_templates_free` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
`province_id` int(11) NOT NULL DEFAULT 0 COMMENT '省ID',
`temp_id` int(11) NOT NULL DEFAULT 0 COMMENT '模板ID',
`city_id` int(11) NOT NULL DEFAULT 0 COMMENT '城市ID',
`number` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '包邮件数',
`price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '包邮金额',
`type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '计费方式',
`uniqid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分组唯一值',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 COMMENT = '指定包邮表' CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_shipping_templates_region
-- ----------------------------
DROP TABLE IF EXISTS `eb_shipping_templates_region`;
CREATE TABLE `eb_shipping_templates_region` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
`province_id` int(11) NOT NULL DEFAULT 0 COMMENT '省ID',
`temp_id` int(11) NOT NULL DEFAULT 0 COMMENT '模板ID',
`city_id` int(11) NOT NULL DEFAULT 0 COMMENT '城市ID',
`first` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '首件',
`first_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '首件运费',
`continue` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '续件',
`continue_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '续件运费',
`type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '计费方式',
`uniqid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分组唯一值',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 COMMENT = '指定运费表' CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_sms_record
-- ----------------------------
DROP TABLE IF EXISTS `eb_sms_record`;
CREATE TABLE `eb_sms_record` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '短信发送记录编号',
`uid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '短信平台账号',
`phone` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '接受短信的手机号',
`content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '短信内容',
`add_time` int(11) UNSIGNED NOT NULL COMMENT '发送短信时间',
`add_ip` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '添加记录ip',
`template` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '短信模板ID',
`resultcode` int(6) UNSIGNED NULL DEFAULT NULL COMMENT '状态码 100=成功,130=失败,131=空号,132=停机,133=关机,134=无状态',
`record_id` int(11) UNSIGNED NOT NULL COMMENT '发送记录id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '短信发送记录表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_store_bargain
-- ----------------------------
DROP TABLE IF EXISTS `eb_store_bargain`;
CREATE TABLE `eb_store_bargain` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '砍价商品ID',
`product_id` int(11) UNSIGNED NOT NULL COMMENT '关联商品ID',
`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '砍价活动名称',
`image` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '砍价活动图片',
`unit_name` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单位名称',
`stock` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '库存',
`sales` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '销量',
`images` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '砍价商品轮播图',
`start_time` int(11) UNSIGNED NOT NULL COMMENT '砍价开启时间',
`stop_time` int(11) UNSIGNED NOT NULL COMMENT '砍价结束时间',
`store_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '砍价商品名称',
`price` decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT '砍价金额',
`min_price` decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT '砍价商品最低价',
`num` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '每次购买的砍价商品数量',
`bargain_max_price` decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT '用户每次砍价的最大金额',
`bargain_min_price` decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT '用户每次砍价的最小金额',
`bargain_num` int(11) UNSIGNED NOT NULL DEFAULT 1 COMMENT '用户每次砍价的次数',
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '砍价状态 0(到砍价时间不自动开启) 1(到砍价时间自动开启时间)',
`give_integral` decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '反多少积分',
`info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '砍价活动简介',
`cost` decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT '成本价',
`sort` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序',
`is_hot` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否推荐0不推荐1推荐',
`is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否删除 0未删除 1删除',
`add_time` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '添加时间',
`is_postage` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否包邮 0不包邮 1包邮',
`postage` decimal(10, 2) UNSIGNED NULL DEFAULT NULL COMMENT '邮费',
`rule` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '砍价规则',
`look` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '砍价商品浏览量',
`share` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '砍价商品分享量',
`temp_id` int(11) NULL DEFAULT NULL COMMENT '运费模板ID',
`weight` decimal(8, 2) NULL DEFAULT 0.00 COMMENT '重量',
`volume` decimal(8, 2) NULL DEFAULT 0.00 COMMENT '体积',
`quota` int(10) NOT NULL DEFAULT 0 COMMENT '限购总数',
`quota_show` int(10) NOT NULL DEFAULT 0 COMMENT '限量总数显示',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '砍价表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_store_bargain_user
-- ----------------------------
DROP TABLE IF EXISTS `eb_store_bargain_user`;
CREATE TABLE `eb_store_bargain_user` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用户参与砍价表ID',
`uid` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '用户ID',
`bargain_id` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '砍价商品id',
`bargain_price_min` decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT '砍价的最低价',
`bargain_price` decimal(8, 2) NULL DEFAULT NULL COMMENT '砍价金额',
`price` decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT '砍掉的价格',
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '状态 1参与中 2 活动结束参与失败 3活动结束参与成功',
`add_time` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '参与时间',
`is_del` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否取消',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户参与砍价表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_store_bargain_user_help
-- ----------------------------
DROP TABLE IF EXISTS `eb_store_bargain_user_help`;
CREATE TABLE `eb_store_bargain_user_help` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '砍价用户帮助表ID',
`uid` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '帮助的用户id',
`bargain_id` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '砍价商品ID',
`bargain_user_id` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '用户参与砍价表id',
`price` decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT '帮助砍价多少金额',
`add_time` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '添加时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '砍价用户帮助表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_store_cart
-- ----------------------------
DROP TABLE IF EXISTS `eb_store_cart`;
CREATE TABLE `eb_store_cart` (
`id` bigint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '购物车表ID',
`uid` int(10) UNSIGNED NOT NULL COMMENT '用户ID',
`type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '类型',
`product_id` int(10) UNSIGNED NOT NULL COMMENT '商品ID',
`product_attr_unique` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品属性',
`cart_num` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品数量',
`status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '购物车商品状态 1=正常,0=失效,2无货',
`add_time` int(10) UNSIGNED NOT NULL COMMENT '添加时间',
`is_pay` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0 = 未购买 1 = 已购买',
`is_del` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除',
`is_new` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否为立即购买',
`combination_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '拼团id',
`seckill_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '秒杀商品ID',
`bargain_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '砍价id',
PRIMARY KEY (`id`) USING BTREE,
INDEX `user_id`(`uid`) USING BTREE,
INDEX `goods_id`(`product_id`) USING BTREE,
INDEX `uid`(`uid`, `is_pay`) USING BTREE,
INDEX `uid_2`(`uid`, `is_del`) USING BTREE,
INDEX `uid_3`(`uid`, `is_new`) USING BTREE,
INDEX `type`(`type`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '购物车表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_store_category
-- ----------------------------
DROP TABLE IF EXISTS `eb_store_category`;
CREATE TABLE `eb_store_category` (
`id` mediumint(11) NOT NULL AUTO_INCREMENT COMMENT '商品分类表ID',
`pid` mediumint(11) NOT NULL COMMENT '父id',
`cate_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '分类名称',
`sort` mediumint(11) NOT NULL COMMENT '排序',
`pic` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '图标',
`is_show` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否推荐',
`add_time` int(11) NOT NULL COMMENT '添加时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `pid`(`pid`) USING BTREE,
INDEX `is_base`(`is_show`) USING BTREE,
INDEX `sort`(`sort`) USING BTREE,
INDEX `add_time`(`add_time`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品分类表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_store_combination
-- ----------------------------
DROP TABLE IF EXISTS `eb_store_combination`;
CREATE TABLE `eb_store_combination` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`product_id` int(10) UNSIGNED NOT NULL COMMENT '商品id',
`mer_id` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '商户id',
`image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '推荐图',
`images` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '轮播图',
`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '活动标题',
`attr` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '活动属性',
`people` int(2) UNSIGNED NOT NULL COMMENT '参团人数',
`info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '简介',
`price` decimal(10, 2) UNSIGNED NOT NULL COMMENT '价格',
`sort` int(10) UNSIGNED NOT NULL COMMENT '排序',
`sales` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '销量',
`stock` int(10) UNSIGNED NOT NULL COMMENT '库存',
`add_time` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '添加时间',
`is_host` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '推荐',
`is_show` tinyint(1) UNSIGNED NOT NULL COMMENT '商品状态',
`is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
`combination` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`mer_use` tinyint(1) UNSIGNED NULL DEFAULT NULL COMMENT '商户是否可用1可用0不可用',
`is_postage` tinyint(1) UNSIGNED NOT NULL COMMENT '是否包邮1是0否',
`postage` decimal(10, 2) UNSIGNED NOT NULL COMMENT '邮费',
`start_time` int(11) UNSIGNED NOT NULL COMMENT '拼团开始时间',
`stop_time` int(11) UNSIGNED NOT NULL COMMENT '拼团结束时间',
`effective_time` int(11) NOT NULL DEFAULT 0 COMMENT '拼团订单有效时间',
`cost` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '拼图商品成本',
`browse` int(11) NULL DEFAULT 0 COMMENT '浏览量',
`unit_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '单位名',
`temp_id` int(11) NULL DEFAULT NULL COMMENT '运费模板ID',
`weight` decimal(8, 2) NULL DEFAULT 0.00 COMMENT '重量',
`volume` decimal(8, 2) NULL DEFAULT 0.00 COMMENT '体积',
`num` int(11) NULL DEFAULT NULL COMMENT '单次购买数量',
`quota` int(10) NOT NULL DEFAULT 0 COMMENT '限购总数',
`quota_show` int(10) NOT NULL DEFAULT 0 COMMENT '限量总数显示',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '拼团商品表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_store_coupon
-- ----------------------------
DROP TABLE IF EXISTS `eb_store_coupon`;
CREATE TABLE `eb_store_coupon` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '优惠券表ID',
`title` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '优惠券名称',
`integral` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '兑换消耗积分值',
`coupon_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '兑换的优惠券面值',
`use_min_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '最低消费多少金额可用优惠券',
`coupon_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '优惠券有效期限(单位:天)',
`sort` int(11) UNSIGNED NOT NULL DEFAULT 1 COMMENT '排序',
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '状态(0:关闭,1:开启)',
`add_time` int(11) UNSIGNED NOT NULL COMMENT '兑换项目添加时间',
`is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否删除',
`product_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '所属商品id',
`category_id` int(11) NOT NULL DEFAULT 0 COMMENT '分类id',
`type` tinyint(2) NOT NULL DEFAULT 0 COMMENT '优惠券类型 0-通用 1-品类券 2-商品券',
PRIMARY KEY (`id`) USING BTREE,
INDEX `state`(`status`) USING BTREE,
INDEX `add_time`(`add_time`) USING BTREE,
INDEX `coupon_time`(`coupon_time`) USING BTREE,
INDEX `is_del`(`is_del`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '优惠券表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_store_coupon_issue
-- ----------------------------
DROP TABLE IF EXISTS `eb_store_coupon_issue`;
CREATE TABLE `eb_store_coupon_issue` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`cid` int(10) NULL DEFAULT NULL COMMENT '优惠券ID',
`coupon_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '优惠券名称',
`start_time` int(10) NULL DEFAULT NULL COMMENT '优惠券领取开启时间',
`end_time` int(10) NULL DEFAULT NULL COMMENT '优惠券领取结束时间',
`total_count` int(10) NULL DEFAULT NULL COMMENT '优惠券领取数量',
`remain_count` int(10) NULL DEFAULT NULL COMMENT '优惠券剩余领取数量',
`is_permanent` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否无限张数',
`status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1 正常 0 未开启 -1 已无效',
`is_give_subscribe` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否首次关注赠送 0-否(默认) 1-是',
`is_full_give` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否满赠0-否(默认) 1-是',
`full_reduction` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '消费满多少赠送优惠券',
`is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
`add_time` int(10) NULL DEFAULT NULL COMMENT '优惠券添加时间',
`title` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '优惠券名称',
`integral` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '兑换消耗积分值',
`coupon_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '兑换的优惠券面值',
`use_min_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '最低消费多少金额可用优惠券',
`coupon_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '优惠券有效期限(单位:天)',
`product_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '所属商品id',
`category_id` int(11) NOT NULL DEFAULT 0 COMMENT '分类id',
`type` tinyint(2) NOT NULL DEFAULT 0 COMMENT '优惠券类型 0-通用 1-品类券 2-商品券',
PRIMARY KEY (`id`) USING BTREE,
INDEX `cid`(`cid`) USING BTREE,
INDEX `start_time`(`start_time`, `end_time`) USING BTREE,
INDEX `remain_count`(`remain_count`) USING BTREE,
INDEX `status`(`status`) USING BTREE,
INDEX `coupon_time`(`coupon_time`) USING BTREE,
INDEX `is_del`(`is_del`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '优惠券前台领取表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_store_coupon_issue_bak
-- ----------------------------
DROP TABLE IF EXISTS `eb_store_coupon_issue_bak`;
CREATE TABLE `eb_store_coupon_issue_bak` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`cid` int(10) NULL DEFAULT NULL COMMENT '优惠券ID',
`coupon_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '优惠券名称',
`start_time` int(10) NULL DEFAULT NULL COMMENT '优惠券领取开启时间',
`end_time` int(10) NULL DEFAULT NULL COMMENT '优惠券领取结束时间',
`total_count` int(10) NULL DEFAULT NULL COMMENT '优惠券领取数量',
`remain_count` int(10) NULL DEFAULT NULL COMMENT '优惠券剩余领取数量',
`is_permanent` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否无限张数',
`status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1 正常 0 未开启 -1 已无效',
`is_give_subscribe` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否首次关注赠送 0-否(默认) 1-是',
`is_full_give` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否满赠0-否(默认) 1-是',
`full_reduction` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '消费满多少赠送优惠券',
`is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
`add_time` int(10) NULL DEFAULT NULL COMMENT '优惠券添加时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `cid`(`cid`) USING BTREE,
INDEX `start_time`(`start_time`, `end_time`) USING BTREE,
INDEX `remain_count`(`remain_count`) USING BTREE,
INDEX `status`(`status`) USING BTREE,
INDEX `is_del`(`is_del`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '优惠券前台领取表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_store_coupon_issue_user
-- ----------------------------
DROP TABLE IF EXISTS `eb_store_coupon_issue_user`;
CREATE TABLE `eb_store_coupon_issue_user` (
`uid` int(10) NULL DEFAULT NULL COMMENT '领取优惠券用户ID',
`issue_coupon_id` int(10) NULL DEFAULT NULL COMMENT '优惠券前台领取ID',
`add_time` int(10) NULL DEFAULT NULL COMMENT '领取时间',
UNIQUE INDEX `uid`(`uid`, `issue_coupon_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '优惠券前台用户领取记录表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_store_coupon_product
-- ----------------------------
DROP TABLE IF EXISTS `eb_store_coupon_product`;
CREATE TABLE `eb_store_coupon_product` (
`coupon_id` int(11) NOT NULL DEFAULT 0 COMMENT '优惠卷模板id',
`product_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品id',
INDEX `coupon_id`(`coupon_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '优惠卷模板关联列表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for eb_store_coupon_user
-- ----------------------------
DROP TABLE IF EXISTS `eb_store_coupon_user`;
CREATE TABLE `eb_store_coupon_user` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '优惠券发放记录id',
`cid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '兑换的项目id',
`uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '优惠券所属用户',
`coupon_title` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '优惠券名称',
`coupon_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '优惠券的面值',
`use_min_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '最低消费多少金额可用优惠券',
`add_time` int(11) UNSIGNED NOT NULL COMMENT '优惠券创建时间',
`end_time` int(11) UNSIGNED NOT NULL COMMENT '优惠券结束时间',
`use_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '使用时间',
`type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'send' COMMENT '获取方式',
`status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态(0:未使用,1:已使用, 2:已过期)',
`is_fail` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否有效',
PRIMARY KEY (`id`) USING BTREE,
INDEX `cid`(`cid`) USING BTREE,
INDEX `uid`(`uid`) USING BTREE,
INDEX `add_time`(`add_time`) USING BTREE,
INDEX `end_time`(`end_time`) USING BTREE,
INDEX `status`(`status`) USING BTREE,
INDEX `is_fail`(`is_fail`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '优惠券发放记录表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_store_order
-- ----------------------------
DROP TABLE IF EXISTS `eb_store_order`;
CREATE TABLE `eb_store_order` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '订单ID',
`order_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单号',
`uid` int(11) UNSIGNED NOT NULL COMMENT '用户id',
`real_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户姓名',
`user_phone` varchar(18) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户电话',
`user_address` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '详细地址',
`cart_id` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '[]' COMMENT '购物车id',
`freight_price` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '运费金额',
`total_num` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '订单商品总数',
`total_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '订单总价',
`total_postage` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '邮费',
`pay_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '实际支付金额',
`pay_postage` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '支付邮费',
`deduction_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '抵扣金额',
`coupon_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '优惠券id',
`coupon_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '优惠券金额',
`paid` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '支付状态',
`pay_time` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '支付时间',
`pay_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '支付方式',
`add_time` int(11) UNSIGNED NOT NULL COMMENT '创建时间',
`status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '订单状态(-1 : 申请退款 -2 : 退货成功 0:待发货;1:待收货;2:已收货;3:待评价;-1:已退款)',
`refund_status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '0 未退款 1 申请中 2 已退款',
`refund_reason_wap_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '退款图片',
`refund_reason_wap_explain` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '退款用户说明',
`refund_reason_time` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '退款时间',
`refund_reason_wap` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '前台退款原因',
`refund_reason` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '不退款的理由',
`refund_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '退款金额',
`delivery_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '快递名称/送货人姓名',
`delivery_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发货类型',
`delivery_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '快递单号/手机号',
`gain_integral` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '消费赚取积分',
`use_integral` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '使用积分',
`back_integral` decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT '给用户退了多少积分',
`mark` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '备注',
`is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否删除',
`unique` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '唯一id(md5加密)类似id',
`remark` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理员备注',
`mer_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商户ID',
`is_mer_check` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
`combination_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '拼团商品id0一般商品',
`pink_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '拼团id 0没有拼团',
`cost` decimal(8, 2) UNSIGNED NOT NULL COMMENT '成本价',
`seckill_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '秒杀商品ID',
`bargain_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '砍价id',
`verify_code` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '核销码',
`store_id` int(11) NOT NULL DEFAULT 0 COMMENT '门店id',
`shipping_type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '配送方式 1=快递 ,2=门店自提',
`clerk_id` int(11) NOT NULL DEFAULT 0 COMMENT '店员id',
`is_channel` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '支付渠道(0微信公众号1微信小程序)',
`is_remind` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '消息提醒',
`is_system_del` tinyint(1) NULL DEFAULT 0 COMMENT '后台是否删除',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `order_id_2`(`order_id`, `uid`) USING BTREE,
UNIQUE INDEX `unique`(`unique`) USING BTREE,
INDEX `uid`(`uid`) USING BTREE,
INDEX `add_time`(`add_time`) USING BTREE,
INDEX `pay_price`(`pay_price`) USING BTREE,
INDEX `paid`(`paid`) USING BTREE,
INDEX `pay_time`(`pay_time`) USING BTREE,
INDEX `pay_type`(`pay_type`) USING BTREE,
INDEX `status`(`status`) USING BTREE,
INDEX `is_del`(`is_del`) USING BTREE,
INDEX `coupon_id`(`coupon_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '订单表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_store_order_cart_info
-- ----------------------------
DROP TABLE IF EXISTS `eb_store_order_cart_info`;
CREATE TABLE `eb_store_order_cart_info` (
`oid` int(11) UNSIGNED NOT NULL COMMENT '订单id',
`cart_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '购物车id',
`product_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品ID',
`cart_info` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '购买东西的详细信息',
`unique` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '唯一id',
UNIQUE INDEX `oid`(`oid`, `unique`) USING BTREE,
INDEX `cart_id`(`cart_id`) USING BTREE,
INDEX `product_id`(`product_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '订单购物详情表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_store_order_status
-- ----------------------------
DROP TABLE IF EXISTS `eb_store_order_status`;
CREATE TABLE `eb_store_order_status` (
`oid` int(10) UNSIGNED NOT NULL COMMENT '订单id',
`change_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '操作类型',
`change_message` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '操作备注',
`change_time` int(10) UNSIGNED NOT NULL COMMENT '操作时间',
INDEX `oid`(`oid`) USING BTREE,
INDEX `change_type`(`change_type`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '订单操作记录表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_store_pink
-- ----------------------------
DROP TABLE IF EXISTS `eb_store_pink`;
CREATE TABLE `eb_store_pink` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`uid` int(10) UNSIGNED NOT NULL COMMENT '用户id',
`order_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单id 生成',
`order_id_key` int(10) UNSIGNED NOT NULL COMMENT '订单id 数据库',
`total_num` int(10) UNSIGNED NOT NULL COMMENT '购买商品个数',
`total_price` decimal(10, 2) UNSIGNED NOT NULL COMMENT '购买总金额',
`cid` int(10) UNSIGNED NOT NULL COMMENT '拼团商品id',
`pid` int(10) UNSIGNED NOT NULL COMMENT '商品id',
`people` int(10) UNSIGNED NOT NULL COMMENT '拼图总人数',
`price` decimal(10, 2) UNSIGNED NOT NULL COMMENT '拼团商品单价',
`add_time` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '开始时间',
`stop_time` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`k_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '团长id 0为团长',
`is_tpl` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否发送模板消息0未发送1已发送',
`is_refund` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否退款 0未退款 1已退款',
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态1进行中2已完成3未完成',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '拼团表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_store_product
-- ----------------------------
DROP TABLE IF EXISTS `eb_store_product`;
CREATE TABLE `eb_store_product` (
`id` mediumint(11) NOT NULL AUTO_INCREMENT COMMENT '商品id',
`mer_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商户Id(0为总后台管理员创建,不为0的时候是商户后台创建)',
`image` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品图片',
`slider_image` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '轮播图',
`store_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品名称',
`store_info` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品简介',
`keyword` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '关键字',
`bar_code` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品条码(一维码)',
`cate_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '分类id',
`price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '商品价格',
`vip_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '会员价格',
`ot_price` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '市场价',
`postage` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '邮费',
`unit_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '单位名',
`sort` smallint(11) NOT NULL DEFAULT 0 COMMENT '排序',
`sales` mediumint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '销量',
`stock` mediumint(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '库存',
`is_show` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态(0:未上架,1:上架)',
`is_hot` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否热卖',
`is_benefit` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否优惠',
`is_best` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否精品',
`is_new` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否新品',
`add_time` int(11) UNSIGNED NOT NULL COMMENT '添加时间',
`is_postage` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否包邮',
`is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否删除',
`mer_use` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商户是否代理 0不可代理1可代理',
`give_integral` decimal(8, 2) UNSIGNED NOT NULL COMMENT '获得积分',
`cost` decimal(8, 2) UNSIGNED NOT NULL COMMENT '成本价',
`is_seckill` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '秒杀状态 0 未开启 1已开启',
`is_bargain` tinyint(1) UNSIGNED NULL DEFAULT NULL COMMENT '砍价状态 0未开启 1开启',
`is_good` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否优品推荐',
`is_sub` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否单独分佣',
`ficti` mediumint(11) NULL DEFAULT 100 COMMENT '虚拟销量',
`browse` int(11) NULL DEFAULT 0 COMMENT '浏览量',
`code_path` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品二维码地址(用户小程序海报)',
`soure_link` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '淘宝京东1688类型',
`video_link` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '主图视频链接',
`temp_id` int(11) NOT NULL DEFAULT 1 COMMENT '运费模板ID',
`spec_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '规格 0单 1多',
`activity` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '活动显示排序1=秒杀,2=砍价,3=拼团',
`spu` char(13) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`label_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '标签ID',
PRIMARY KEY (`id`) USING BTREE,
INDEX `cate_id`(`cate_id`) USING BTREE,
INDEX `is_hot`(`is_hot`) USING BTREE,
INDEX `is_benefit`(`is_benefit`) USING BTREE,
INDEX `is_best`(`is_best`) USING BTREE,
INDEX `is_new`(`is_new`) USING BTREE,
INDEX `toggle_on_sale, is_del`(`is_del`) USING BTREE,
INDEX `price`(`price`) USING BTREE,
INDEX `sort`(`sort`) USING BTREE,
INDEX `sales`(`sales`) USING BTREE,
INDEX `add_time`(`add_time`) USING BTREE,
INDEX `is_postage`(`is_postage`) USING BTREE,
INDEX `is_show`(`is_show`, `is_del`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_store_product_attr
-- ----------------------------
DROP TABLE IF EXISTS `eb_store_product_attr`;
CREATE TABLE `eb_store_product_attr` (
`product_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品ID',
`attr_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '属性名',
`attr_values` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '属性值',
`type` tinyint(1) NULL DEFAULT 0 COMMENT '活动类型 0=商品,1=秒杀,2=砍价,3=拼团',
INDEX `store_id`(`product_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品属性表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_store_product_attr_result
-- ----------------------------
DROP TABLE IF EXISTS `eb_store_product_attr_result`;
CREATE TABLE `eb_store_product_attr_result` (
`product_id` int(10) UNSIGNED NOT NULL COMMENT '商品ID',
`result` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品属性参数',
`change_time` int(10) UNSIGNED NOT NULL COMMENT '上次修改时间',
`type` tinyint(1) NULL DEFAULT 0 COMMENT '活动类型 0=商品,1=秒杀,2=砍价,3=拼团',
INDEX `product_id`(`product_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品属性详情表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_store_product_attr_value
-- ----------------------------
DROP TABLE IF EXISTS `eb_store_product_attr_value`;
CREATE TABLE `eb_store_product_attr_value` (
`product_id` int(10) UNSIGNED NOT NULL COMMENT '商品ID',
`suk` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品属性索引值 (attr_value|attr_value[|....])',
`stock` int(10) UNSIGNED NOT NULL COMMENT '属性对应的库存',
`sales` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '销量',
`price` decimal(8, 2) UNSIGNED NOT NULL COMMENT '属性金额',
`image` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片',
`unique` char(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '唯一值',
`cost` decimal(8, 2) UNSIGNED NOT NULL COMMENT '成本价',
`bar_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品条码',
`ot_price` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '原价',
`weight` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '重量',
`volume` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '体积',
`brokerage` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '一级返佣',
`brokerage_two` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '二级返佣',
`type` tinyint(1) NULL DEFAULT 0 COMMENT '活动类型 0=商品,1=秒杀,2=砍价,3=拼团',
`quota` int(11) NULL DEFAULT NULL COMMENT '活动限购数量',
`quota_show` int(11) NULL DEFAULT NULL COMMENT '活动限购数量显示',
INDEX `unique`(`unique`, `suk`) USING BTREE,
INDEX `store_id`(`product_id`, `suk`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品属性值表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_store_product_cate
-- ----------------------------
DROP TABLE IF EXISTS `eb_store_product_cate`;
CREATE TABLE `eb_store_product_cate` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`product_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品id',
`cate_id` int(11) NOT NULL DEFAULT 0 COMMENT '分类id',
`add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品分类辅助表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_store_product_coupon
-- ----------------------------
DROP TABLE IF EXISTS `eb_store_product_coupon`;
CREATE TABLE `eb_store_product_coupon` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`product_id` int(10) NOT NULL DEFAULT 0 COMMENT '商品id',
`issue_coupon_id` int(10) NOT NULL DEFAULT 0 COMMENT '优惠劵id',
`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '优惠券名称',
`add_time` int(10) NOT NULL DEFAULT 0 COMMENT '添加时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品关联优惠券' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for eb_store_product_description
-- ----------------------------
DROP TABLE IF EXISTS `eb_store_product_description`;
CREATE TABLE `eb_store_product_description` (
`product_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品ID',
`description` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品详情',
`type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '商品类型',
INDEX `product_id`(`product_id`, `type`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品详情表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_store_product_relation
-- ----------------------------
DROP TABLE IF EXISTS `eb_store_product_relation`;
CREATE TABLE `eb_store_product_relation` (
`uid` int(10) UNSIGNED NOT NULL COMMENT '用户ID',
`product_id` int(10) UNSIGNED NOT NULL COMMENT '商品ID',
`type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '类型(收藏(collect)、点赞(like))',
`category` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '某种类型的商品(普通商品、秒杀商品)',
`add_time` int(10) UNSIGNED NOT NULL COMMENT '添加时间',
UNIQUE INDEX `uid`(`uid`, `product_id`, `type`, `category`) USING BTREE,
INDEX `type`(`type`) USING BTREE,
INDEX `category`(`category`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品点赞和收藏表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_store_product_reply
-- ----------------------------
DROP TABLE IF EXISTS `eb_store_product_reply`;
CREATE TABLE `eb_store_product_reply` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '评论ID',
`uid` int(11) NOT NULL COMMENT '用户ID',
`oid` int(11) NOT NULL COMMENT '订单ID',
`unique` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '唯一id',
`product_id` int(11) NOT NULL COMMENT '商品id',
`reply_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'product' COMMENT '某种商品类型(普通商品、秒杀商品)',
`product_score` tinyint(1) NOT NULL COMMENT '商品分数',
`service_score` tinyint(1) NOT NULL COMMENT '服务分数',
`comment` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论内容',
`pics` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论图片',
`add_time` int(11) NOT NULL COMMENT '评论时间',
`merchant_reply_content` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理员回复内容',
`merchant_reply_time` int(11) NULL DEFAULT NULL COMMENT '管理员回复时间',
`is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '0未删除1已删除',
`is_reply` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0未回复1已回复',
`nickname` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名称',
`avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户头像',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `order_id_2`(`oid`, `unique`) USING BTREE,
INDEX `add_time`(`add_time`) USING BTREE,
INDEX `parent_id`(`reply_type`) USING BTREE,
INDEX `is_del`(`is_del`) USING BTREE,
INDEX `product_score`(`product_score`) USING BTREE,
INDEX `service_score`(`service_score`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '评论表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_store_product_rule
-- ----------------------------
DROP TABLE IF EXISTS `eb_store_product_rule`;
CREATE TABLE `eb_store_product_rule` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`rule_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '规格名称',
`rule_value` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '规格值',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品规则值(规格)表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_store_seckill
-- ----------------------------
DROP TABLE IF EXISTS `eb_store_seckill`;
CREATE TABLE `eb_store_seckill` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '商品秒杀商品表id',
`product_id` int(10) UNSIGNED NOT NULL COMMENT '商品id',
`image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '推荐图',
`images` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '轮播图',
`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '活动标题',
`info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '简介',
`price` decimal(10, 2) UNSIGNED NOT NULL COMMENT '价格',
`cost` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '成本',
`ot_price` decimal(10, 2) UNSIGNED NOT NULL COMMENT '原价',
`give_integral` decimal(10, 2) UNSIGNED NOT NULL COMMENT '返多少积分',
`sort` int(10) UNSIGNED NOT NULL COMMENT '排序',
`stock` int(10) UNSIGNED NOT NULL COMMENT '库存',
`sales` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '销量',
`unit_name` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '单位名',
`postage` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '邮费',
`description` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '内容',
`start_time` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '开始时间',
`stop_time` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '结束时间',
`add_time` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '添加时间',
`status` tinyint(1) UNSIGNED NOT NULL COMMENT '商品状态',
`is_postage` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否包邮',
`is_hot` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '热门推荐',
`is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '删除 0未删除1已删除',
`num` int(11) UNSIGNED NOT NULL COMMENT '最多秒杀几个',
`is_show` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '显示',
`time_id` int(11) NULL DEFAULT NULL COMMENT '时间段ID',
`temp_id` int(11) NULL DEFAULT NULL COMMENT '运费模板ID',
`weight` decimal(8, 2) NULL DEFAULT 0.00 COMMENT '商品重量',
`volume` decimal(8, 2) NULL DEFAULT 0.00 COMMENT '商品体积',
`quota` int(10) NOT NULL DEFAULT 0 COMMENT '限购总数',
`quota_show` int(10) NOT NULL DEFAULT 0 COMMENT '限购总数显示',
PRIMARY KEY (`id`) USING BTREE,
INDEX `product_id`(`product_id`) USING BTREE,
INDEX `start_time`(`start_time`, `stop_time`) USING BTREE,
INDEX `is_del`(`is_del`) USING BTREE,
INDEX `is_hot`(`is_hot`) USING BTREE,
INDEX `is_show`(`status`) USING BTREE,
INDEX `add_time`(`add_time`) USING BTREE,
INDEX `sort`(`sort`) USING BTREE,
INDEX `is_postage`(`is_postage`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品秒杀商品表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_store_seckill_time
-- ----------------------------
DROP TABLE IF EXISTS `eb_store_seckill_time`;
CREATE TABLE `eb_store_seckill_time` (
`seckill_id` int(10) NOT NULL DEFAULT 0 COMMENT '秒杀活动ID',
`time_id` int(10) NOT NULL DEFAULT 0 COMMENT '秒杀时间段ID'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '秒杀时段表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_store_service
-- ----------------------------
DROP TABLE IF EXISTS `eb_store_service`;
CREATE TABLE `eb_store_service` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '客服id',
`mer_id` int(11) NOT NULL DEFAULT 0 COMMENT '商户id',
`uid` int(11) NOT NULL COMMENT '客服uid',
`avatar` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '客服头像',
`nickname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '代理名称',
`phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '客服手机号',
`add_time` int(11) NOT NULL COMMENT '添加时间',
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '0隐藏1显示',
`notify` int(2) NULL DEFAULT 0 COMMENT '订单通知1开启0关闭',
`customer` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否展示统计管理',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客服表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_store_service_log
-- ----------------------------
DROP TABLE IF EXISTS `eb_store_service_log`;
CREATE TABLE `eb_store_service_log` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '客服用户对话记录表ID',
`mer_id` int(11) NOT NULL DEFAULT 0 COMMENT '商户id',
`msn` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '消息内容',
`uid` int(11) NOT NULL COMMENT '发送人uid',
`to_uid` int(11) NOT NULL COMMENT '接收人uid',
`add_time` int(11) NOT NULL COMMENT '发送时间',
`type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已读(0:否;1:是;)',
`remind` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否提醒过',
`msn_type` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '消息类型 1=文字 2=表情 3=图片 4=语音',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客服用户对话记录表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_store_visit
-- ----------------------------
DROP TABLE IF EXISTS `eb_store_visit`;
CREATE TABLE `eb_store_visit` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`product_id` int(11) NULL DEFAULT NULL COMMENT '商品ID',
`product_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品类型',
`cate_id` int(11) NULL DEFAULT NULL COMMENT '商品分类ID',
`type` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品类型',
`uid` int(11) NULL DEFAULT NULL COMMENT '用户ID',
`count` int(11) NULL DEFAULT NULL COMMENT '访问次数',
`content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注描述',
`add_time` int(11) NULL DEFAULT NULL COMMENT '添加时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品浏览分析表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_system_admin
-- ----------------------------
DROP TABLE IF EXISTS `eb_system_admin`;
CREATE TABLE `eb_system_admin` (
`id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '后台管理员表ID',
`account` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '后台管理员账号',
`head_pic` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`pwd` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '后台管理员密码',
`real_name` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '后台管理员姓名',
`roles` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '后台管理员权限(menus_id)',
`last_ip` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '后台管理员最后一次登录ip',
`last_time` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '后台管理员最后一次登录时间',
`add_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '后台管理员添加时间',
`login_count` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '登录次数',
`level` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '后台管理员级别',
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '后台管理员状态 1有效0无效',
`is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (`id`) USING BTREE,
INDEX `account`(`account`) USING BTREE,
INDEX `status`(`status`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '后台管理员表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_system_attachment
-- ----------------------------
DROP TABLE IF EXISTS `eb_system_attachment`;
CREATE TABLE `eb_system_attachment` (
`att_id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '附件名称',
`att_dir` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '附件路径',
`satt_dir` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '压缩图片路径',
`att_size` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '附件大小',
`att_type` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '附件类型',
`pid` int(10) NOT NULL DEFAULT 0 COMMENT '分类ID0编辑器,1商品图片,2拼团图片,3砍价图片,4秒杀图片,5文章图片,6组合数据图',
`time` int(11) NOT NULL DEFAULT 0 COMMENT '上传时间',
`image_type` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '图片上传类型 1本地 2七牛云 3OSS 4COS ',
`module_type` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '图片上传模块类型 1 后台上传 2 用户生成',
PRIMARY KEY (`att_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '附件管理表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_system_attachment_category
-- ----------------------------
DROP TABLE IF EXISTS `eb_system_attachment_category`;
CREATE TABLE `eb_system_attachment_category` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`pid` int(11) NULL DEFAULT 0 COMMENT '父级ID',
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分类名称',
`enname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分类目录',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `id`(`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '附件分类表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_system_city
-- ----------------------------
DROP TABLE IF EXISTS `eb_system_city`;
CREATE TABLE `eb_system_city` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`city_id` int(11) NOT NULL DEFAULT 0 COMMENT '城市id',
`level` int(11) NOT NULL DEFAULT 0 COMMENT '省市级别',
`parent_id` int(11) NOT NULL DEFAULT 0 COMMENT '父级id',
`area_code` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '区号',
`name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '名称',
`merger_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '合并名称',
`lng` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '经度',
`lat` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '纬度',
`is_show` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否展示',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3975 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '城市表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_system_config
-- ----------------------------
DROP TABLE IF EXISTS `eb_system_config`;
CREATE TABLE `eb_system_config` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '配置id',
`menu_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字段名称',
`type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '类型(文本框,单选按钮...)',
`input_type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'input' COMMENT '表单类型',
`config_tab_id` int(10) UNSIGNED NOT NULL COMMENT '配置分类id',
`parameter` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '规则 单选框和多选框',
`upload_type` tinyint(1) UNSIGNED NULL DEFAULT NULL COMMENT '上传文件格式1单图2多图3文件',
`required` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '规则',
`width` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '多行文本框的宽度',
`high` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '多行文框的高度',
`value` varchar(5000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '默认值',
`info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '配置名称',
`desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '配置简介',
`sort` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序',
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否隐藏',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 193 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '配置表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_system_config_tab
-- ----------------------------
DROP TABLE IF EXISTS `eb_system_config_tab`;
CREATE TABLE `eb_system_config_tab` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '配置分类id',
`pid` int(11) NOT NULL DEFAULT 0 COMMENT '上级分类id',
`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '配置分类名称',
`eng_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '配置分类英文名称',
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '配置分类状态',
`info` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '配置分类是否显示',
`icon` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图标',
`type` int(2) NULL DEFAULT 0 COMMENT '配置类型',
`sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 38 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '配置分类表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_system_file
-- ----------------------------
DROP TABLE IF EXISTS `eb_system_file`;
CREATE TABLE `eb_system_file` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '文件对比ID',
`cthash` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '文件内容',
`filename` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '文价名称',
`atime` char(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '上次访问时间',
`mtime` char(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '上次修改时间',
`ctime` char(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '上次改变时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 537 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '文件对比表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_system_group
-- ----------------------------
DROP TABLE IF EXISTS `eb_system_group`;
CREATE TABLE `eb_system_group` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '组合数据ID',
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '数据组名称',
`info` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '数据提示',
`config_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '数据字段',
`fields` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '数据组字段以及类型(json数据)',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `config_name`(`config_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 73 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '组合数据表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_system_group_data
-- ----------------------------
DROP TABLE IF EXISTS `eb_system_group_data`;
CREATE TABLE `eb_system_group_data` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '组合数据详情ID',
`gid` int(11) NOT NULL DEFAULT 0 COMMENT '对应的数据组id',
`value` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '数据组对应的数据值(json数据)',
`add_time` int(10) NOT NULL DEFAULT 0 COMMENT '添加数据时间',
`sort` int(11) NOT NULL DEFAULT 0 COMMENT '数据排序',
`status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态(1:开启;2:关闭;)',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 209 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '组合数据详情表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_system_log
-- ----------------------------
DROP TABLE IF EXISTS `eb_system_log`;
CREATE TABLE `eb_system_log` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '管理员操作记录ID',
`admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '管理员id',
`admin_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '管理员姓名',
`path` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '链接',
`page` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '行为',
`method` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '访问类型',
`ip` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '登录IP',
`type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '类型',
`add_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '操作时间',
`merchant_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商户id',
PRIMARY KEY (`id`) USING BTREE,
INDEX `admin_id`(`admin_id`) USING BTREE,
INDEX `add_time`(`add_time`) USING BTREE,
INDEX `type`(`type`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1129 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '管理员操作记录表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_system_menus
-- ----------------------------
DROP TABLE IF EXISTS `eb_system_menus`;
CREATE TABLE `eb_system_menus` (
`id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
`pid` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT '父级id',
`icon` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '图标',
`menu_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '按钮名',
`module` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '模块名',
`controller` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '控制器',
`action` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '方法名',
`api_url` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'api接口地址',
`methods` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '提交方式POST GET PUT DELETE',
`params` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '[]' COMMENT '参数',
`sort` tinyint(3) NOT NULL DEFAULT 1 COMMENT '排序',
`is_show` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否为隐藏菜单0=隐藏菜单,1=显示菜单',
`is_show_path` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否为隐藏菜单供前台使用',
`access` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '子管理员是否可用',
`menu_path` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '路由名称 前端使用',
`auth_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否为菜单 1菜单 2功能',
`header` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '顶部菜单标示',
`is_header` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否顶部菜单1是0否',
`unique_auth` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '前台唯一标识',
`is_del` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除',
PRIMARY KEY (`id`) USING BTREE,
INDEX `pid`(`pid`) USING BTREE,
INDEX `is_show`(`is_show`) USING BTREE,
INDEX `access`(`access`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 659 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '菜单表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_system_notice
-- ----------------------------
DROP TABLE IF EXISTS `eb_system_notice`;
CREATE TABLE `eb_system_notice` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '通知模板id',
`title` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '通知标题',
`type` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '通知类型',
`icon` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '图标',
`url` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '链接',
`table_title` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '通知数据',
`template` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '通知模板',
`push_admin` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '通知管理员id',
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `type`(`type`) USING BTREE,
INDEX `status`(`status`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '通知模板表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_system_notice_admin
-- ----------------------------
DROP TABLE IF EXISTS `eb_system_notice_admin`;
CREATE TABLE `eb_system_notice_admin` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '通知记录ID',
`notice_type` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '通知类型',
`admin_id` smallint(5) UNSIGNED NOT NULL COMMENT '通知的管理员',
`link_id` int(10) UNSIGNED NOT NULL COMMENT '关联ID',
`table_data` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '通知的数据',
`is_click` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '点击次数',
`is_visit` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '访问次数',
`visit_time` int(11) NOT NULL COMMENT '访问时间',
`add_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '通知时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `admin_id`(`admin_id`, `notice_type`) USING BTREE,
INDEX `add_time`(`add_time`) USING BTREE,
INDEX `is_visit`(`is_visit`) USING BTREE,
INDEX `is_click`(`is_click`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '通知记录表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_system_role
-- ----------------------------
DROP TABLE IF EXISTS `eb_system_role`;
CREATE TABLE `eb_system_role` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '身份管理id',
`role_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '身份管理名称',
`rules` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '身份管理权限(menus_id)',
`level` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态',
PRIMARY KEY (`id`) USING BTREE,
INDEX `status`(`status`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '身份管理表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_system_store
-- ----------------------------
DROP TABLE IF EXISTS `eb_system_store`;
CREATE TABLE `eb_system_store` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '门店名称',
`introduction` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '简介',
`phone` char(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '手机号码',
`address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '省市区',
`detailed_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '详细地址',
`image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '门店logo',
`latitude` char(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '纬度',
`longitude` char(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '经度',
`valid_time` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '核销有效日期',
`day_time` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '每日营业开关时间',
`add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
`is_show` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否显示',
`is_del` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除',
PRIMARY KEY (`id`) USING BTREE,
INDEX `phone`(`phone`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '门店自提' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_system_store_staff
-- ----------------------------
DROP TABLE IF EXISTS `eb_system_store_staff`;
CREATE TABLE `eb_system_store_staff` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`uid` int(10) UNSIGNED NOT NULL COMMENT '微信用户id',
`avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '店员头像',
`store_id` int(11) NOT NULL COMMENT '门店id',
`staff_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '店员名称',
`phone` char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号码',
`verify_status` tinyint(2) NOT NULL DEFAULT 0 COMMENT '核销开关',
`status` tinyint(2) NULL DEFAULT 1 COMMENT '状态',
`add_time` int(10) NULL DEFAULT NULL COMMENT '添加时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '门店店员表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_system_user_level
-- ----------------------------
DROP TABLE IF EXISTS `eb_system_user_level`;
CREATE TABLE `eb_system_user_level` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`mer_id` int(11) NOT NULL DEFAULT 0 COMMENT '商户id',
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '会员名称',
`money` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '购买金额',
`valid_date` int(11) NOT NULL DEFAULT 0 COMMENT '有效时间',
`is_forever` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否为永久会员',
`is_pay` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否购买,1=购买,0=不购买',
`is_show` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否显示 1=显示,0=隐藏',
`grade` int(11) NOT NULL DEFAULT 0 COMMENT '会员等级',
`discount` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '享受折扣',
`image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '会员卡背景',
`icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '会员图标',
`explain` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '说明',
`add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
`is_del` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除.1=删除,0=未删除',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '设置用户等级表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_system_user_task
-- ----------------------------
DROP TABLE IF EXISTS `eb_system_user_task`;
CREATE TABLE `eb_system_user_task` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '任务名称',
`real_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '配置原名',
`task_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '任务类型',
`number` int(11) NOT NULL DEFAULT 0 COMMENT '限定数',
`level_id` int(11) NOT NULL DEFAULT 0 COMMENT '等级id',
`sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序',
`is_show` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否显示',
`is_must` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否务必达成任务,1务必达成,0=满足其一',
`illustrate` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '任务说明',
`add_time` int(11) NOT NULL DEFAULT 0 COMMENT '新增时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 30 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '等级任务设置' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_template_message
-- ----------------------------
DROP TABLE IF EXISTS `eb_template_message`;
CREATE TABLE `eb_template_message` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '模板id',
`type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0=订阅消息,1=微信模板消息',
`tempkey` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模板编号',
`name` char(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模板名',
`content` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '回复内容',
`tempid` char(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板ID',
`add_time` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '添加时间',
`status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '状态',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 29 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '微信模板' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_user
-- ----------------------------
DROP TABLE IF EXISTS `eb_user`;
CREATE TABLE `eb_user` (
`uid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用户id',
`account` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户账号',
`pwd` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户密码',
`real_name` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '真实姓名',
`birthday` int(11) NOT NULL DEFAULT 0 COMMENT '生日',
`card_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '身份证号码',
`mark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户备注',
`partner_id` int(11) NOT NULL DEFAULT 0 COMMENT '合伙人id',
`group_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户分组id',
`nickname` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户昵称',
`avatar` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户头像',
`phone` char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号码',
`add_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加时间',
`add_ip` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '添加ip',
`last_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最后一次登录时间',
`last_ip` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '最后一次登录ip',
`now_money` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '用户余额',
`brokerage_price` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '佣金金额',
`integral` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '用户剩余积分',
`sign_num` int(11) NOT NULL DEFAULT 0 COMMENT '连续签到天数',
`status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1为正常,0为禁止',
`level` tinyint(2) UNSIGNED NOT NULL DEFAULT 0 COMMENT '等级',
`spread_uid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '推广元id',
`spread_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '推广员关联时间',
`user_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户类型',
`is_promoter` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否为推广员',
`pay_count` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '用户购买次数',
`spread_count` int(11) NULL DEFAULT 0 COMMENT '下级人数',
`clean_time` int(11) NULL DEFAULT 0 COMMENT '清理会员时间',
`addres` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '详细地址',
`adminid` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '管理员编号 ',
`login_type` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户登陆类型,h5,wechat,routine',
PRIMARY KEY (`uid`) USING BTREE,
INDEX `account`(`account`) USING BTREE,
INDEX `spreaduid`(`spread_uid`) USING BTREE,
INDEX `level`(`level`) USING BTREE,
INDEX `status`(`status`) USING BTREE,
INDEX `is_promoter`(`is_promoter`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_user_address
-- ----------------------------
DROP TABLE IF EXISTS `eb_user_address`;
CREATE TABLE `eb_user_address` (
`id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用户地址id',
`uid` int(10) UNSIGNED NOT NULL COMMENT '用户id',
`real_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '收货人姓名',
`phone` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '收货人电话',
`province` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '收货人所在省',
`city` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '收货人所在市',
`city_id` int(11) NOT NULL DEFAULT 0 COMMENT '城市id',
`district` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '收货人所在区',
`detail` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '收货人详细地址',
`post_code` int(10) UNSIGNED NOT NULL COMMENT '邮编',
`longitude` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '经度',
`latitude` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '纬度',
`is_default` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否默认',
`is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否删除',
`add_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `uid`(`uid`) USING BTREE,
INDEX `is_default`(`is_default`) USING BTREE,
INDEX `is_del`(`is_del`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户地址表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_user_bill
-- ----------------------------
DROP TABLE IF EXISTS `eb_user_bill`;
CREATE TABLE `eb_user_bill` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用户账单id',
`uid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户uid',
`link_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '关联id',
`pm` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '0 = 支出 1 = 获得',
`title` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '账单标题',
`category` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '明细种类',
`type` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '明细类型',
`number` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '明细数字',
`balance` decimal(8, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '剩余',
`mark` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '备注',
`add_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加时间',
`status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '0 = 带确定 1 = 有效 -1 = 无效',
`take` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0 = 未收货 1 = 已收货',
PRIMARY KEY (`id`) USING BTREE,
INDEX `openid`(`uid`) USING BTREE,
INDEX `status`(`status`) USING BTREE,
INDEX `add_time`(`add_time`) USING BTREE,
INDEX `pm`(`pm`) USING BTREE,
INDEX `type`(`category`, `type`, `link_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户账单表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_user_enter
-- ----------------------------
DROP TABLE IF EXISTS `eb_user_enter`;
CREATE TABLE `eb_user_enter` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '商户申请ID',
`uid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户ID',
`province` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商户所在省',
`city` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商户所在市',
`district` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商户所在区',
`address` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商户详细地址',
`merchant_name` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商户名称',
`link_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`link_tel` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商户电话',
`charter` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商户证书',
`add_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加时间',
`apply_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '审核时间',
`success_time` int(11) NOT NULL COMMENT '通过时间',
`fail_message` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '未通过原因',
`fail_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '未通过时间',
`status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '-1 审核未通过 0未审核 1审核通过',
`is_lock` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '0 = 开启 1= 关闭',
`is_del` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否删除',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `uid`(`uid`) USING BTREE,
INDEX `province`(`province`, `city`, `district`) USING BTREE,
INDEX `is_lock`(`is_lock`) USING BTREE,
INDEX `is_del`(`is_del`) USING BTREE,
INDEX `status`(`status`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商户申请表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_user_extract
-- ----------------------------
DROP TABLE IF EXISTS `eb_user_extract`;
CREATE TABLE `eb_user_extract` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`uid` int(10) UNSIGNED NULL DEFAULT NULL,
`real_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
`extract_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'bank' COMMENT 'bank = 银行卡 alipay = 支付宝wx=微信',
`bank_code` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '银行卡',
`bank_address` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '开户地址',
`alipay_code` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '支付宝账号',
`extract_price` decimal(8, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '提现金额',
`mark` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`balance` decimal(8, 2) UNSIGNED NULL DEFAULT 0.00,
`fail_msg` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '无效原因',
`fail_time` int(10) UNSIGNED NULL DEFAULT NULL,
`add_time` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '添加时间',
`status` tinyint(2) NULL DEFAULT 0 COMMENT '-1 未通过 0 审核中 1 已提现',
`wechat` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微信号',
PRIMARY KEY (`id`) USING BTREE,
INDEX `extract_type`(`extract_type`) USING BTREE,
INDEX `status`(`status`) USING BTREE,
INDEX `add_time`(`add_time`) USING BTREE,
INDEX `openid`(`uid`) USING BTREE,
INDEX `fail_time`(`fail_time`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户提现表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_user_group
-- ----------------------------
DROP TABLE IF EXISTS `eb_user_group`;
CREATE TABLE `eb_user_group` (
`id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
`group_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户分组名称',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户分组表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_user_label
-- ----------------------------
DROP TABLE IF EXISTS `eb_user_label`;
CREATE TABLE `eb_user_label` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`label_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '标签名称',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户标签表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_user_label_relation
-- ----------------------------
DROP TABLE IF EXISTS `eb_user_label_relation`;
CREATE TABLE `eb_user_label_relation` (
`uid` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
`label_id` int(11) NOT NULL DEFAULT 0 COMMENT '标签ID'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户标签关联表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_user_level
-- ----------------------------
DROP TABLE IF EXISTS `eb_user_level`;
CREATE TABLE `eb_user_level` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL DEFAULT 0 COMMENT '用户uid',
`level_id` int(11) NOT NULL DEFAULT 0 COMMENT '等级vip',
`grade` int(11) NOT NULL DEFAULT 0 COMMENT '会员等级',
`valid_time` int(11) NOT NULL DEFAULT 0 COMMENT '过期时间',
`is_forever` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否永久',
`mer_id` int(11) NOT NULL DEFAULT 0 COMMENT '商户id',
`status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0:禁止,1:正常',
`mark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '备注',
`remind` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已通知',
`is_del` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除,0=未删除,1=删除',
`add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
`discount` int(11) NOT NULL DEFAULT 0 COMMENT '享受折扣',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `id`(`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户等级记录表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_user_notice
-- ----------------------------
DROP TABLE IF EXISTS `eb_user_notice`;
CREATE TABLE `eb_user_notice` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '接收消息的用户id(类型:json数据)',
`type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '消息通知类型(1:系统消息;2:用户通知)',
`user` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '发送人',
`title` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '通知消息的标题信息',
`content` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '通知消息的内容',
`add_time` int(11) NOT NULL DEFAULT 0 COMMENT '通知消息发送的时间',
`is_send` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否发送(0:未发送;1:已发送)',
`send_time` int(11) NOT NULL COMMENT '发送时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户通知表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_user_notice_see
-- ----------------------------
DROP TABLE IF EXISTS `eb_user_notice_see`;
CREATE TABLE `eb_user_notice_see` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nid` int(11) NOT NULL DEFAULT 0 COMMENT '查看的通知id',
`uid` int(11) NOT NULL DEFAULT 0 COMMENT '查看通知的用户id',
`add_time` int(11) NOT NULL DEFAULT 0 COMMENT '查看通知的时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户通知发送记录表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_user_recharge
-- ----------------------------
DROP TABLE IF EXISTS `eb_user_recharge`;
CREATE TABLE `eb_user_recharge` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`uid` int(10) NULL DEFAULT NULL COMMENT '充值用户UID',
`order_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '订单号',
`price` decimal(8, 2) NULL DEFAULT NULL COMMENT '充值金额',
`give_price` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '购买赠送金额',
`recharge_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '充值类型',
`paid` tinyint(1) NULL DEFAULT NULL COMMENT '是否充值',
`pay_time` int(10) NULL DEFAULT NULL COMMENT '充值支付时间',
`add_time` int(12) NULL DEFAULT NULL COMMENT '充值时间',
`refund_price` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '退款金额',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `order_id`(`order_id`) USING BTREE,
INDEX `uid`(`uid`) USING BTREE,
INDEX `recharge_type`(`recharge_type`) USING BTREE,
INDEX `paid`(`paid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户充值表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_user_sign
-- ----------------------------
DROP TABLE IF EXISTS `eb_user_sign`;
CREATE TABLE `eb_user_sign` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL DEFAULT 0 COMMENT '用户uid',
`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '签到说明',
`number` int(11) NOT NULL DEFAULT 0 COMMENT '获得积分',
`balance` int(11) NOT NULL DEFAULT 0 COMMENT '剩余积分',
`add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `uid`(`uid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '签到记录表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_user_task_finish
-- ----------------------------
DROP TABLE IF EXISTS `eb_user_task_finish`;
CREATE TABLE `eb_user_task_finish` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`task_id` int(11) NOT NULL DEFAULT 0 COMMENT '任务id',
`uid` int(11) NOT NULL DEFAULT 0 COMMENT '用户id',
`status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否有效',
`add_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `id`(`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户任务完成记录表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_user_visit
-- ----------------------------
DROP TABLE IF EXISTS `eb_user_visit`;
CREATE TABLE `eb_user_visit` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL COMMENT '用户uid',
`url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '访问路径',
`ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户ip',
`stay_time` int(11) NOT NULL DEFAULT 0 COMMENT '页面停留时间(秒)',
`add_time` int(11) NOT NULL DEFAULT 0 COMMENT '访问时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 112 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户访问表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_wechat_key
-- ----------------------------
DROP TABLE IF EXISTS `eb_wechat_key`;
CREATE TABLE `eb_wechat_key` (
`id` mediumint(8) NOT NULL AUTO_INCREMENT,
`reply_id` mediumint(8) NOT NULL COMMENT '回复内容id',
`keys` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '关键词',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '微信回复关键词辅助表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for eb_wechat_media
-- ----------------------------
DROP TABLE IF EXISTS `eb_wechat_media`;
CREATE TABLE `eb_wechat_media` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '微信视频音频id',
`type` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '回复类型',
`path` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '文件路径',
`media_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '微信服务器返回的id',
`url` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '地址',
`temporary` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否永久或者临时 0永久1临时',
`add_time` int(10) UNSIGNED NOT NULL COMMENT '添加时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `type`(`type`, `media_id`) USING BTREE,
INDEX `type_2`(`type`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '微信回复表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_wechat_message
-- ----------------------------
DROP TABLE IF EXISTS `eb_wechat_message`;
CREATE TABLE `eb_wechat_message` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用户行为记录id',
`openid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户openid',
`type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '操作类型',
`result` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '操作详细记录',
`add_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '操作时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `openid`(`openid`) USING BTREE,
INDEX `type`(`type`) USING BTREE,
INDEX `add_time`(`add_time`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户行为记录表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_wechat_news_category
-- ----------------------------
DROP TABLE IF EXISTS `eb_wechat_news_category`;
CREATE TABLE `eb_wechat_news_category` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '图文消息管理ID',
`cate_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '图文名称',
`sort` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序',
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态',
`new_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '文章id',
`add_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '添加时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '图文消息管理表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_wechat_reply
-- ----------------------------
DROP TABLE IF EXISTS `eb_wechat_reply`;
CREATE TABLE `eb_wechat_reply` (
`id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '微信关键字回复id',
`type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '回复类型',
`data` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '回复数据',
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '0=不可用 1 =可用',
`hide` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否隐藏',
PRIMARY KEY (`id`) USING BTREE,
INDEX `type`(`type`) USING BTREE,
INDEX `status`(`status`) USING BTREE,
INDEX `hide`(`hide`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '微信关键字回复表' ROW_FORMAT = Compact;
-- ----------------------------
-- Table structure for eb_wechat_user
-- ----------------------------
DROP TABLE IF EXISTS `eb_wechat_user`;
CREATE TABLE `eb_wechat_user` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`uid` int(10) NOT NULL COMMENT '微信用户id',
`unionid` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '只有在用户将公众号绑定到微信开放平台帐号后,才会出现该字段',
`openid` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户的标识,对当前公众号唯一',
`routine_openid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '小程序唯一身份ID',
`nickname` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户的昵称',
`headimgurl` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户头像',
`sex` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户的性别,值为1时是男性,值为2时是女性,值为0时是未知',
`city` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户所在城市',
`language` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户的语言,简体中文为zh_CN',
`province` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户所在省份',
`country` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户所在国家',
`remark` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公众号运营者对粉丝的备注,公众号运营者可在微信公众平台用户管理界面对粉丝添加备注',
`groupid` smallint(5) UNSIGNED NULL DEFAULT 0 COMMENT '用户所在的分组ID(兼容旧的用户分组接口)',
`tagid_list` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户被打上的标签ID列表',
`subscribe` tinyint(3) UNSIGNED NULL DEFAULT 1 COMMENT '用户是否订阅该公众号标识',
`subscribe_time` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '关注公众号时间',
`add_time` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '添加时间',
`stair` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '一级推荐人',
`second` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '二级推荐人',
`order_stair` int(11) NULL DEFAULT NULL COMMENT '一级推荐人订单',
`order_second` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '二级推荐人订单',
`now_money` decimal(8, 2) UNSIGNED NULL DEFAULT NULL COMMENT '佣金',
`session_key` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '小程序用户会话密匙',
`user_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'wechat' COMMENT '用户类型',
PRIMARY KEY (`id`) USING BTREE,
INDEX `groupid`(`groupid`) USING BTREE,
INDEX `subscribe_time`(`subscribe_time`) USING BTREE,
INDEX `add_time`(`add_time`) USING BTREE,
INDEX `subscribe`(`subscribe`) USING BTREE,
INDEX `unionid`(`unionid`) USING BTREE,
INDEX `openid`(`openid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '微信用户表' ROW_FORMAT = Compact;
- 序言
- 系统简介
- 系统介绍
- 前端脑图
- 项目介绍
- 程序源码安装
- 运行环境
- 服务器及域名准备
- 服务器购买
- 服务器配置端口
- 域名购买
- 域名解析
- SSL证书申请
- 证书申请注意事项
- 宝塔申请SSL
- 阿里云申请SSL
- 腾讯云申请SSL
- https域名配置
- 新手推荐-宝塔环境安装
- 【视频安装教程】
- 1.服务器配置
- 阿里云平台
- 腾讯云平台
- 2.登录宝塔
- 3.环境配置
- 安装软件
- 数据库配置
- PHP配置
- 4.源码安装
- 5.程序一键安装
- 6.宝塔启动命令
- 消息队列
- 长连接
- 定时任务
- window+phpstudy8安装
- 安装前配置
- 安装系统
- windows下的站点配置
- window启动命令
- 消息队列
- 长连接
- 定时任务
- Linux环境安装
- Linux启动命令
- 消息队列
- Linux命令行开启长连接
- 开启定时任务
- 手动安装
- 配置检查
- 安装常见问题
- mysql修改sql_mode
- 后台空白
- 验证码不显示
- 程序配置
- 应用配置
- 公众号配置
- 公众号配置
- 公众号开发配置
- 公众号菜单
- 设置公众号菜单
- 关键字
- 跳转网页
- 跳转小程序
- 小程序配置
- 1.微信平台配置
- 2.CRMEB后台配置
- 3.打包上传
- 前端提交审核(4.3.1之前版本)
- 前端提交审核(4.3.1及以后版本)
- 4.确认发布
- PC端
- PC安装
- PC设置
- PC端微信扫码登录配置
- 支付配置
- 微信支付
- 支付宝支付
- 客服配置
- 标准版客服配置
- 客服配置详解
- 旧版本客服配置
- 公众号客服
- 小程序客服
- 客服配置(4.3.1及以后版本)
- 反向代理
- Nginx反向代理
- Apache反向代理
- 一号通
- 一号通账号
- 短信
- 商品采集
- 物流配置
- 电子面单
- 其他配置
- 公众号模板消息
- 小程序订阅消息
- 小程序直播配置
- 小票打印配置
- 付费采集
- 用户账号多端同步
- 图标logo更换(4.3.1以上版本)
- 云存储配置
- 存储说明
- 阿里云OSS
- 腾讯云COS
- 七牛云存储
- 消息管理
- 通知会员
- 微信模板消息
- 微信小程序提醒
- 通知平台
- 系统通知
- 企业微信通知
- 功能说明
- 页面跳转链接
- 普通产品
- 发布商品
- 商品规格
- 商品评价
- 前台页面
- 设置商品口令
- 虚拟商品
- 商品分类
- 分类说明
- 分类管理
- 订单管理
- 后台订单处理
- 前端订单处理
- 订单退款
- 订单打印
- 客服订单提醒
- 二维码收银订单
- 订单配送
- 订单拆单发货(4.3+)
- 订单拆单退款(4.3+)
- 用户管理
- 账户管理
- 账号信息
- 账户资金
- 会员
- 用户等级
- 付费会员
- 分销规则
- 分销配置
- 关于分销
- 提现
- 佣金提现
- 提现规则
- 发起提现
- 后台审核
- 分销员管理
- 分销规则说明
- 分销等级
- 客服管理
- 客服添加
- 客服工作台
- 营销管理
- 优惠券
- 优惠券模板
- 发布优惠券
- 领取及使用
- 砍价
- 砍价规则
- 新建砍价活动
- 拼团
- 拼团规则
- 新建拼团活动
- 秒杀
- 秒杀规则
- 新建秒杀活动
- 积分
- 积分商城(4.3+)
- 积分商城介绍
- 创建积分商品
- 积分设置
- 积分来源
- 积分使用
- 小程序直播
- 开启直播
- 直播使用说明
- 直播间管理
- 九宫格抽奖(4.3+)
- 抽奖规则
- 创建抽奖活动
- 全款预售(4.3+)
- 预售说明
- 添加预售商品
- 新闻资讯
- 新闻页面
- 发布资讯
- 邮费说明
- 邮费组成
- 商城运费设置
- 运费模板
- 门店自提
- 开启门店自提
- 门店及店员管理
- 订单核销说明
- 库存说明
- 前端说明
- 首页
- 分类页
- 个人中心
- 页面管理(4.3+)
- 页面设计
- 数据配置
- 主题风格
- PC商城
- 常见问题
- 客服消息发送失败
- 公众号重复无限刷新登陆
- 配置了小程序订阅消息不生效
- windows下点击workerman.bat文件闪退
- 多项目部署Socket链接失败
- 自动收货功能不生效
- 后台忘记密码
- 支付成功订单状态没改
- 小程序发布之后无法生成海报问题
- 安装首页数据库链接失败
- 技术文档
- 打包教程
- 前台打包教程
- 公众号、H5打包
- 小程序打包
- 后台打包教程
- PC端打包教程
- APP打包
- 1.基础配置
- 2.开发调试
- 3.打包上线
- App打包
- 移动前端
- 目录结构
- 移动端前端本地运行
- 页面路径
- 后台前端说明
- 后台前端目录结构
- 后台前端本地运行和打包
- 后台前端页面路径
- 前端开发配置
- 前端配置说明
- 前端添加页面
- 前端引用组件
- 前端构建和发布
- 开发规范
- 目录结构
- 数据字典
- 标准版目录结构
- 标准版数据字典
- 移动端路由
- 事件
- 系统配置
- 系统常用函数
- 后台表单说明
- 驱动
- 后端路由
- 消息队列
- URL重写
- 长连接
- 定时任务
- 修改端口
- 商业授权
- 授权说明
- 申请授权