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