# 自增
serial
sequence
# without oids;
# constraint g_201708_state_dlsj_check
# 氧气数据库结构
~~~[sql]
DROP TABLE IF EXISTS `dp_admin_access`;
CREATE TABLE `dp_admin_access` (
`module` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '模型名称',
`group` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '权限分组标识',
`uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户id',
`nid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '授权节点id'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '统一授权表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for dp_admin_action
-- ----------------------------
DROP TABLE IF EXISTS `dp_admin_action`;
CREATE TABLE `dp_admin_action` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`module` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '所属模块名',
`name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '行为唯一标识',
`title` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '行为标题',
`remark` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '行为描述',
`rule` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '行为规则',
`log` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '日志规则',
`status` tinyint(2) NOT NULL DEFAULT 0 COMMENT '状态',
`create_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 44 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统行为表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for dp_admin_attachment
-- ----------------------------
DROP TABLE IF EXISTS `dp_admin_attachment`;
CREATE TABLE `dp_admin_attachment` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户id',
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '文件名',
`module` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '模块名，由哪个模块上传的',
`path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '文件路径',
`thumb` 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 '文件链接',
`mime` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '文件mime类型',
`ext` char(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '文件类型',
`size` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '文件大小',
`md5` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '文件md5',
`sha1` char(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'sha1 散列值',
`driver` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'local' COMMENT '上传驱动',
`download` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '下载次数',
`create_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '上传时间',
`update_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
`sort` int(11) NOT NULL DEFAULT 100 COMMENT '排序',
`status` tinyint(2) NOT NULL DEFAULT 1 COMMENT '状态',
`width` int(8) UNSIGNED NOT NULL DEFAULT 0 COMMENT '图片宽度',
`height` int(8) UNSIGNED NOT NULL DEFAULT 0 COMMENT '图片高度',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 234 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '附件表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for dp_admin_config
-- ----------------------------
DROP TABLE IF EXISTS `dp_admin_config`;
CREATE TABLE `dp_admin_config` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '名称',
`title` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '标题',
`group` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '配置分组',
`type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '类型',
`value` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '配置值',
`options` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '配置项',
`tips` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '配置提示',
`ajax_url` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '联动下拉框ajax地址',
`next_items` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '联动下拉框的下级下拉框名，多个以逗号隔开',
`param` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '联动下拉框请求参数名',
`format` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '格式，用于格式文本',
`table` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '表名，只用于快速联动类型',
`level` tinyint(2) UNSIGNED NOT NULL DEFAULT 2 COMMENT '联动级别，只用于快速联动类型',
`key` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '键字段，只用于快速联动类型',
`option` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '值字段，只用于快速联动类型',
`pid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '父级id字段，只用于快速联动类型',
`ak` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '百度地图appkey',
`create_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
`sort` int(11) NOT NULL DEFAULT 100 COMMENT '排序',
`status` tinyint(2) NOT NULL DEFAULT 1 COMMENT '状态：0禁用，1启用',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 41 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统配置表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for dp_admin_hook
-- ----------------------------
DROP TABLE IF EXISTS `dp_admin_hook`;
CREATE TABLE `dp_admin_hook` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '钩子名称',
`plugin` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '钩子来自哪个插件',
`description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '钩子描述',
`system` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否为系统钩子',
`create_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
`status` tinyint(2) NOT NULL DEFAULT 1 COMMENT '状态',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '钩子表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for dp_admin_hook_plugin
-- ----------------------------
DROP TABLE IF EXISTS `dp_admin_hook_plugin`;
CREATE TABLE `dp_admin_hook_plugin` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`hook` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '钩子id',
`plugin` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '插件标识',
`create_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加时间',
`update_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
`sort` int(11) UNSIGNED NOT NULL DEFAULT 100 COMMENT '排序',
`status` tinyint(2) NOT NULL DEFAULT 1 COMMENT '状态',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '钩子-插件对应表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for dp_admin_icon
-- ----------------------------
DROP TABLE IF EXISTS `dp_admin_icon`;
CREATE TABLE `dp_admin_icon` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(32) 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 '图标css地址',
`prefix` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '图标前缀',
`font_family` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '字体名',
`create_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
`status` tinyint(1) UNSIGNED 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 dp_admin_icon_list
-- ----------------------------
DROP TABLE IF EXISTS `dp_admin_icon_list`;
CREATE TABLE `dp_admin_icon_list` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`icon_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '所属图标id',
`title` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '图标标题',
`class` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '图标类名',
`code` varchar(128) 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 dp_admin_log
-- ----------------------------
DROP TABLE IF EXISTS `dp_admin_log`;
CREATE TABLE `dp_admin_log` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`action_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '行为id',
`user_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '执行用户id',
`action_ip` bigint(20) NOT NULL COMMENT '执行行为者ip',
`model` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '触发行为的表',
`record_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '触发行为的数据id',
`remark` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '日志备注',
`status` tinyint(2) NOT NULL DEFAULT 1 COMMENT '状态',
`create_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '执行行为的时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `action_ip_ix`(`action_ip`) USING BTREE,
INDEX `action_id_ix`(`action_id`) USING BTREE,
INDEX `user_id_ix`(`user_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 249 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '行为日志表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for dp_admin_menu
-- ----------------------------
DROP TABLE IF EXISTS `dp_admin_menu`;
CREATE TABLE `dp_admin_menu` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`pid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '上级菜单id',
`module` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '模块名称',
`title` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '菜单标题',
`icon` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '菜单图标',
`url_type` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '链接类型（link：外链，module：模块）',
`url_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '链接地址',
`url_target` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '_self' COMMENT '链接打开方式：_blank,_self',
`online_hide` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '网站上线后是否隐藏',
`create_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
`sort` int(11) NOT NULL DEFAULT 100 COMMENT '排序',
`system_menu` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否为系统菜单，系统菜单不可删除',
`status` tinyint(2) NOT NULL DEFAULT 1 COMMENT '状态',
`params` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '参数',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 423 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '后台菜单表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for dp_admin_message
-- ----------------------------
DROP TABLE IF EXISTS `dp_admin_message`;
CREATE TABLE `dp_admin_message` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`uid_receive` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '接收消息的用户id',
`uid_send` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '发送消息的用户id',
`type` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '消息分类',
`content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '消息内容',
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '状态',
`create_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
`read_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '阅读时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '消息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for dp_admin_module
-- ----------------------------
DROP TABLE IF EXISTS `dp_admin_module`;
CREATE TABLE `dp_admin_module` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '模块名称（标识）',
`title` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '模块标题',
`icon` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '图标',
`description` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '描述',
`author` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '作者',
`author_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '作者主页',
`config` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '配置信息',
`access` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '授权配置',
`version` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '版本号',
`identifier` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '模块唯一标识符',
`system_module` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否为系统模块',
`create_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
`sort` int(11) NOT NULL DEFAULT 100 COMMENT '排序',
`status` tinyint(2) NOT NULL DEFAULT 1 COMMENT '状态',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '模块表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for dp_admin_packet
-- ----------------------------
DROP TABLE IF EXISTS `dp_admin_packet`;
CREATE TABLE `dp_admin_packet` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '数据包名',
`title` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '数据包标题',
`author` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '作者',
`author_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '作者url',
`version` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`tables` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '数据表名',
`create_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
`status` tinyint(2) NOT NULL DEFAULT 1 COMMENT '状态',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '数据包表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for dp_admin_plugin
-- ----------------------------
DROP TABLE IF EXISTS `dp_admin_plugin`;
CREATE TABLE `dp_admin_plugin` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '插件名称',
`title` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '插件标题',
`icon` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '图标',
`description` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '插件描述',
`author` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '作者',
`author_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '作者主页',
`config` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '配置信息',
`version` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '版本号',
`identifier` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '插件唯一标识符',
`admin` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否有后台管理',
`create_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '安装时间',
`update_time` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',
`sort` int(11) NOT NULL DEFAULT 100 COMMENT '排序',
`status` tinyint(2) NOT NULL DEFAULT 1 COMMENT '状态',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '插件表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for dp_admin_role
-- ----------------------------
DROP TABLE IF EXISTS `dp_admin_role`;
CREATE TABLE `dp_admin_role` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '角色id',
`pid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '上级角色',
`name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '角色名称',
`description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '角色描述',
`menu_auth` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜单权限',
`sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序',
`create_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
`status` tinyint(2) NOT NULL DEFAULT 1 COMMENT '状态',
`access` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否可登录后台',
`default_module` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '默认访问模块',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for dp_admin_user
-- ----------------------------
DROP TABLE IF EXISTS `dp_admin_user`;
CREATE TABLE `dp_admin_user` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`username` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户名',
`nickname` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '昵称',
`password` varchar(96) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '密码',
`email` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '邮箱地址',
`email_bind` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否绑定邮箱地址',
`mobile` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '手机号码',
`mobile_bind` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否绑定手机号码',
`avatar` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '头像',
`money` decimal(11, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '余额',
`score` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '积分',
`role` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '角色ID',
`group` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '部门id',
`signup_ip` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '注册ip',
`create_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
`last_login_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最后一次登录时间',
`last_login_ip` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '登录ip',
`sort` int(11) NOT NULL DEFAULT 100 COMMENT '排序',
`status` tinyint(2) NOT NULL DEFAULT 0 COMMENT '状态：0禁用，1启用',
`no` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '工号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for dp_crontab
-- ----------------------------
DROP TABLE IF EXISTS `dp_crontab`;
CREATE TABLE `dp_crontab` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
`type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '类型',
`title` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标题',
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '内容',
`schedule` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Cron 表达式',
`sleep` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '延迟秒数执行',
`maximums` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最大执行次数 0为不限',
`executes` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '已经执行的次数',
`create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
`begin_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '开始时间',
`end_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '结束时间',
`execute_time` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '最后执行时间',
`weigh` int(10) NOT NULL DEFAULT 0 COMMENT '权重',
`status` enum('completed','expired','disable','normal') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'normal' COMMENT '状态',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '定时任务表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for dp_crontab_log
-- ----------------------------
DROP TABLE IF EXISTS `dp_crontab_log`;
CREATE TABLE `dp_crontab_log` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '类型',
`cid` int(10) UNSIGNED NOT NULL COMMENT '任务的ID',
`title` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标题',
`remark` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注',
`create_time` int(10) UNSIGNED NOT NULL COMMENT '执行时间',
`status` tinyint(1) NOT NULL COMMENT '状态 0:失败 1:成功',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5763 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '定时任务日志表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for dp_dingding_app
-- ----------------------------
DROP TABLE IF EXISTS `dp_dingding_app`;
CREATE TABLE `dp_dingding_app` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`corpid` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`corpsecret` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`access_token` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`create_at` datetime(0) NULL DEFAULT NULL,
`expire_at` datetime(0) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 28770 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for dp_jobs
-- ----------------------------
DROP TABLE IF EXISTS `dp_jobs`;
CREATE TABLE `dp_jobs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`queue` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`payload` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`attempts` tinyint(3) UNSIGNED NOT NULL,
`reserved` tinyint(3) UNSIGNED NOT NULL,
`reserved_at` int(10) UNSIGNED NULL DEFAULT NULL,
`available_at` int(10) UNSIGNED NOT NULL,
`created_at` int(10) UNSIGNED NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for dp_packet_wechat_area
-- ----------------------------
DROP TABLE IF EXISTS `dp_packet_wechat_area`;
CREATE TABLE `dp_packet_wechat_area` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`country` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '国家名称',
`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 '城市名称',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 482 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '地区信息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for geo
-- ----------------------------
DROP TABLE IF EXISTS `geo`;
CREATE TABLE `geo` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`lon` double(12, 8) NOT NULL COMMENT '经度',
`lat` double(12, 8) NOT NULL COMMENT '纬度',
`title` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '地名',
`geohash` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT 'geohash',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_geohash`(`geohash`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_activity
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_activity`;
CREATE TABLE `oxygen_activity` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '名称',
`start_time` datetime(0) NULL DEFAULT NULL COMMENT '开始时间',
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '结束时间',
`sort` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '排序 小在前面',
`status` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '1-开启 0-暂停',
`renew` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '1-续租可用 0-续租不可用',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '活动表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_activity_detail
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_activity_detail`;
CREATE TABLE `oxygen_activity_detail` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`activity_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '活动id',
`discount` float(3, 2) UNSIGNED NULL DEFAULT 1.00 COMMENT '折扣 1.00 ',
`days` int(11) UNSIGNED NULL DEFAULT 1 COMMENT '天',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '活动明细表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_admin_message
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_admin_message`;
CREATE TABLE `oxygen_admin_message` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_balance
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_balance`;
CREATE TABLE `oxygen_balance` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`title` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '标题',
`money` float(10, 2) NOT NULL DEFAULT 0.00 COMMENT '金额',
`left_money` float(10, 2) NULL DEFAULT 0.00 COMMENT '剩余损额',
`type` enum('租赁单','报损单') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '租赁单' COMMENT '类型',
`uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '对应表id',
`user_type` enum('服务员','租赁点','导游','业务员','用户') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '服务员' COMMENT '用户类型',
`wxuid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户uid',
`order_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '关联订单id',
`class` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '分类',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '记录时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 121 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '收支表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_bank_cnaps
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_bank_cnaps`;
CREATE TABLE `oxygen_bank_cnaps` (
`code` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`code`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_ccb_area
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_ccb_area`;
CREATE TABLE `oxygen_ccb_area` (
`code` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '地区码',
`name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
PRIMARY KEY (`code`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_ccb_banks
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_ccb_banks`;
CREATE TABLE `oxygen_ccb_banks` (
`code` char(3) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
`status` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '1-启用 0-禁用',
PRIMARY KEY (`code`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_ccb_cnaps
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_ccb_cnaps`;
CREATE TABLE `oxygen_ccb_cnaps` (
`cnaps` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '连行号',
`bank_code` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '银行code',
`area_code` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地区码',
`name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '支行名称',
PRIMARY KEY (`cnaps`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_comment
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_comment`;
CREATE TABLE `oxygen_comment` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`order_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '订单id',
`content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '内容',
`wxuid` bigint(20) UNSIGNED NULL DEFAULT 0 COMMENT '用户uid',
`customer_tel` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '顾客手机号',
`rent_leasehold_id` bigint(20) UNSIGNED NULL DEFAULT 0 COMMENT '租赁点uid',
`rent_leasehold_score` float(2, 1) UNSIGNED NULL DEFAULT 0.0 COMMENT '租赁点评分1-5分',
`rent_server_id` bigint(20) UNSIGNED NULL DEFAULT 0 COMMENT '租赁点服务员uid',
`rent_server_score` float(2, 1) UNSIGNED NULL DEFAULT 0.0 COMMENT '租赁点服务员评分1-5分',
`rent_guide_id` bigint(11) UNSIGNED NULL DEFAULT 0 COMMENT '租赁导游uid',
`rent_guide_score` float(2, 1) UNSIGNED NULL DEFAULT NULL COMMENT '租赁导游评分',
`return_server_id` bigint(20) UNSIGNED NULL DEFAULT 0 COMMENT '归还点 服务员uid',
`return_server_score` float(2, 1) UNSIGNED NULL DEFAULT 0.0 COMMENT '归还点服务员评分',
`return_leasehold_id` bigint(20) UNSIGNED NULL DEFAULT 0 COMMENT '归还租赁点uid',
`return_leasehold_score` float(2, 1) UNSIGNED NULL DEFAULT 0.0 COMMENT '归还点拼分1-5分',
`return_guide_id` bigint(11) NULL DEFAULT NULL COMMENT '归还导游uid',
`return_guide_score` float(2, 1) UNSIGNED NULL DEFAULT 0.0 COMMENT '归还导游评分',
`device_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '设备id',
`device_score` float(2, 1) UNSIGNED NULL DEFAULT 0.0 COMMENT '设备评分',
`remark` varchar(10000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',
`create_time` datetime(0) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '评论表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_compensate
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_compensate`;
CREATE TABLE `oxygen_compensate` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`product_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '产品id',
`position` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '赔偿部位',
`price` float(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '价格',
`sort` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '排序',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '赔偿表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_device
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_device`;
CREATE TABLE `oxygen_device` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`sn` char(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'sn',
`bind_uid` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '绑定uid',
`bind_type` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '绑定身份 1-服务员 2-导游',
`bind_time` datetime(0) NULL DEFAULT NULL COMMENT '绑定时间',
`status` enum('激活','已绑定','租赁中','异常','丢失') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '激活' COMMENT '状态',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '激活时间',
`leasehold_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '绑定租赁点id',
`connect_time` datetime(0) NULL DEFAULT NULL COMMENT '通信时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 85 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '设备表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_device_errmsg
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_device_errmsg`;
CREATE TABLE `oxygen_device_errmsg` (
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`status` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '开启忽略 1-开启 0-不开启',
PRIMARY KEY (`name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_device_message
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_device_message`;
CREATE TABLE `oxygen_device_message` (
`sn` char(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'sn',
`type` int(2) UNSIGNED NULL DEFAULT 1 COMMENT '事件类型1-租赁中 2-租赁结束 3-激活',
`state` int(2) UNSIGNED NULL DEFAULT 1 COMMENT '目标状态',
`etime` datetime(0) NULL DEFAULT NULL COMMENT '结束时间',
`create_time` datetime(0) NULL DEFAULT NULL,
`status` int(1) UNSIGNED NULL DEFAULT 0 COMMENT '0-未处理 1-已处理',
PRIMARY KEY (`sn`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_device_remark
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_device_remark`;
CREATE TABLE `oxygen_device_remark` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`sn` char(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备sn',
`server_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '服务员id',
`guide_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '导游id',
`content` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '内容',
`pics` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '图片id',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
`server_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '服务员名称',
`leasehold_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '租赁点名称',
`guide_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '导游名称',
`salesman_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '业务员名称',
PRIMARY KEY (`id`) USING BTREE,
INDEX `sn`(`sn`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 37 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '设备备注表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_entry
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_entry`;
CREATE TABLE `oxygen_entry` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`order_id` bigint(20) UNSIGNED NULL DEFAULT 0 COMMENT '订单id',
`order_no` char(14) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '订单号',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`nickname` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '微信昵称',
`tel` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '手机号',
`type` enum('押金','租赁费','销售费','续租费','赔偿费','超时费','报损费') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '押金' COMMENT '类型',
`pay_method` enum('微信','支付宝','提成抵扣','押金抵扣') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '支付方式',
`usrmsg` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '支付账号',
`salesman_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '业务员id',
`salesman_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '业务员名称',
`money` float(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '金额',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 52 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '入账表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_guide
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_guide`;
CREATE TABLE `oxygen_guide` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '姓名',
`sex` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '1-男 0-女',
`pic` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '图片',
`id_no` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '身份证号',
`id_pic` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '身份证图片',
`guide_no` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '导游证编号',
`guide_pic` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '导游证图片',
`nation` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '民族',
`salesman_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '业务员id',
`order_num` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '订单数',
`return_left` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '归还数',
`score` float(2, 1) UNSIGNED NULL DEFAULT 0.0 COMMENT '评分',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '上次登录时间',
`status` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '状态 1-启用 0-禁用',
`device` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '设备数',
`parts` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '配件数',
`delivery_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '送货地址',
`qrcode` int(10) UNSIGNED NULL DEFAULT 31 COMMENT '导游小程序码图片',
`bankcard` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '银行卡号',
`bank` varchar(48) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '总行',
`cnap` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '联行号',
`bank_account_type` enum('对私','对公') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '对私' COMMENT '银行账号类型 对私 or 对公',
`bank_account` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '开户名',
`report_lose_left` float(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '剩余报错额',
`report_lose_total` float(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '报损总额',
`tel` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '手机号',
`rent_rate` float(4, 1) UNSIGNED NOT NULL DEFAULT 0.0 COMMENT '租赁提成比例',
`return_rate` float(4, 1) UNSIGNED NOT NULL DEFAULT 0.0 COMMENT '归还提成比例',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '导游表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_leasehold
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_leasehold`;
CREATE TABLE `oxygen_leasehold` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`salesman_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '业务员id',
`name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '名称',
`class_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '分类',
`level_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '级别',
`province` varchar(48) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '省',
`city` varchar(48) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '市',
`country` varchar(48) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '区',
`address` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址',
`head_pic` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '门头照',
`start_time` char(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '营业开始时间',
`end_time` char(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '营业结束时间',
`realname` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '负责人',
`tel` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '负责人手机号',
`wx_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '负责微信昵称',
`id_no` varchar(18) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '负责人身份证号',
`id_pic` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '负责人身份证图片',
`auto_assign` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '是否自动分配 1-是 0-否',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '申请时间',
`last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '上次登录时间',
`check_time` datetime(0) NULL DEFAULT NULL,
`check_name` varchar(14) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '配货人姓名',
`status` int(2) NULL DEFAULT -1 COMMENT '-1 申请中 1 启用 0-禁用',
`lat` double(12, 8) NULL DEFAULT NULL COMMENT '纬度',
`lon` double(12, 8) NULL DEFAULT NULL COMMENT '经度',
`geohash` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT 'geohash',
`qrcode` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '导游小程序码图片',
`score` float(2, 1) UNSIGNED NULL DEFAULT 0.0 COMMENT '评分',
`bankcard` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '银行卡号',
`bank` varchar(48) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '总行',
`cnap` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '联行号',
`bank_account_type` enum('对私','对公') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '对私' COMMENT '银行账号类型 对私 or 对公',
`bank_account` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '开户名',
`report_lose_total` float(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '报损总额',
`report_lose_left` float(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '剩余总额',
`rent_rate` float(4, 1) UNSIGNED NULL DEFAULT 0.0 COMMENT '租赁提成比例',
`return_rate` float(4, 1) UNSIGNED NULL DEFAULT 0.0 COMMENT '归还提成比例',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '租赁点' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_leasehold_class
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_leasehold_class`;
CREATE TABLE `oxygen_leasehold_class` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '32',
`sort` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '排序',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '租赁点分类' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_leasehold_level
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_leasehold_level`;
CREATE TABLE `oxygen_leasehold_level` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '名称',
`rent_rate` float(4, 1) UNSIGNED NOT NULL DEFAULT 0.0 COMMENT '租赁提成比例',
`return_rate` float(4, 1) UNSIGNED NOT NULL DEFAULT 0.0 COMMENT '归还提成比例',
`default` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '是否默认',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '租赁点级别' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_message
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_message`;
CREATE TABLE `oxygen_message` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`wxuid` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '收到人uid',
`content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '内容',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '新增时间',
`type` enum('业务员','租赁点','服务员','导游','公众号','站内信','用户') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '业务员' COMMENT '类型',
`status` enum('未读','已读','已删除') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '未读' COMMENT '状态',
`read_time` datetime(0) NULL DEFAULT NULL COMMENT '阅读时间',
`data_type` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '数据类型',
`data_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '关联id',
PRIMARY KEY (`id`) USING BTREE,
INDEX `wxuid`(`wxuid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 165 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '消息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_mpmenu
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_mpmenu`;
CREATE TABLE `oxygen_mpmenu` (
`id` bigint(16) UNSIGNED NOT NULL AUTO_INCREMENT,
`pindex` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '父id',
`type` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单类型 null主菜单 link链接 keys关键字 event事件',
`name` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单名称',
`content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '文字内容',
`sort` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '排序',
`status` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '状态(0禁用1启用)',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_order
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_order`;
CREATE TABLE `oxygen_order` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`no` char(14) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '订单编号',
`wxuid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户uid',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`type` enum('租赁单','换货单','续租单','赔偿单') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '租赁单' COMMENT '类型',
`device_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '设备id',
`relate_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '关联id',
`remark` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',
`status` enum('待支付','租赁中','已结束','已关闭') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '待支付' COMMENT '状态',
`days` int(11) UNSIGNED NOT NULL DEFAULT 1 COMMENT '租赁天数',
`finish_time` datetime(0) NOT NULL COMMENT '应当结束时间',
`fail_time` datetime(0) NULL DEFAULT NULL COMMENT '支付失败时间',
`pay_method` enum('微信','支付宝','系统后台') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '支付方式',
`pay_time` datetime(0) NULL DEFAULT NULL COMMENT '支付时间',
`pay_status` enum('未支付','已支付','支付失败') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '未支付' COMMENT '支付状态',
`activity_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '活动id',
`activity_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '活动名称',
`discount` float(3, 2) UNSIGNED NOT NULL DEFAULT 1.00 COMMENT '折扣',
`money` float(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '订单总价',
`rent_money` float(10, 2) NOT NULL COMMENT '租赁费',
`sale_money` float(10, 2) NOT NULL COMMENT '销售费',
`overtime_money` float(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '超时费',
`deposit` float(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '押金',
`rent_guide_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '租赁时导游id',
`rent_guide_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '租赁导游姓名',
`rent_server_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '租赁时服务员id',
`rent_server_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '租赁时服务员姓名',
`rent_leasehold_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '租赁时租赁点id',
`rent_leasehold_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '租赁时租赁点名称',
`rent_salesman_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '租赁时业务员id',
`rent_salesman_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '租赁业务员名称',
`return_server_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '归还时服务员id',
`return_server_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '归还时服务员名称',
`return_leasehold_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '归还时租赁点id',
`return_leasehold_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '归还时租赁点名称',
`return_guide_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '归还时导游id',
`return_guide_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '归还时导游姓名',
`back_deposit` float(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '退还押金',
`back_money` float(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '提前还租',
`usrmsg` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '支付账号',
`close_time` datetime(0) NULL DEFAULT NULL COMMENT '确认结束时间',
`customer_tel` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '顾客手机号',
`customer_nickname` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '顾客昵称',
`confirm_status` enum('无需确认','待确认','已确认') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '无需确认',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '订单表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_order_blank
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_order_blank`;
CREATE TABLE `oxygen_order_blank` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`no` char(14) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '单号',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '申请时间',
`check_time` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',
`name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '网点名称',
`delivery_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '收货人姓名',
`delivery_tel` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '收货手机号',
`delivery_time` datetime(0) NULL DEFAULT NULL COMMENT '收货时间',
`delivery_address` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '配货地址',
`status` enum('待审核','配货中','已入库') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '待审核',
`leasehold_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '当时租赁点id',
`guide_id` int(11) NULL DEFAULT NULL COMMENT '当时导游id',
`user_type` enum('导游','租赁点') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '租赁点' COMMENT '网点类型',
`uid` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '网点uid',
`creator_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '申请人姓名',
`send_name` varchar(14) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '配货人姓名',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '配货单' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_order_blank_detail
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_order_blank_detail`;
CREATE TABLE `oxygen_order_blank_detail` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`order_blank_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '配货单id',
`product_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品id',
`name` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '项目名称',
`amount` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '数量',
`unit` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '单位',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '配货单明细' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_order_detail
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_order_detail`;
CREATE TABLE `oxygen_order_detail` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`product_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '商品id',
`order_id` bigint(20) UNSIGNED NULL DEFAULT 0 COMMENT '订单id',
`name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '产品名称',
`price` float(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '价格',
`mode` enum('出租','销售') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '出租' COMMENT '租售模式',
`amount` int(11) UNSIGNED NULL DEFAULT 1 COMMENT '数量',
`total` float(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '总价',
`sn` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '序列号',
`unit` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '单位',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 45 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '订单明细' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_order_reminder
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_order_reminder`;
CREATE TABLE `oxygen_order_reminder` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`order_id` int(11) UNSIGNED NULL DEFAULT NULL,
`tel` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '手机号',
`near_time` datetime(0) NULL DEFAULT NULL COMMENT '快到期前时间',
`near_send` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '是否发过',
`just_pass_time` datetime(0) NULL DEFAULT NULL COMMENT '刚刚过去',
`just_pass_send` tinyint(3) UNSIGNED NULL DEFAULT 0 COMMENT '是否刚超时',
`overtime_oneday` datetime(0) NULL DEFAULT NULL COMMENT '超时一天',
`oneday_send` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '超过一天发送',
`overtime_threeday` datetime(0) NULL DEFAULT NULL COMMENT '超时三天',
`threeday_send` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '是否超时3天发送',
`closed` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '是否订单结束',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_product
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_product`;
CREATE TABLE `oxygen_product` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`type` enum('产品','配件') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '产品' COMMENT '类型',
`name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '名称',
`unit` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '单位',
`mode` enum('出租','销售') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '出租' COMMENT '租售模式',
`price` int(11) UNSIGNED NOT NULL DEFAULT 1 COMMENT '金额',
`create_time` datetime(0) NULL DEFAULT NULL,
`status` tinyint(1) NULL DEFAULT 1 COMMENT '1-启用 0-禁用',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
`stock` int(11) NULL DEFAULT 0 COMMENT '总库存',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '产品表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_product_stock
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_product_stock`;
CREATE TABLE `oxygen_product_stock` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`product_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '商品id',
`product_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '商品名称',
`num` int(11) NULL DEFAULT 0 COMMENT '数量',
`type` int(2) UNSIGNED NULL DEFAULT 1 COMMENT '分类 1-总部 2-租赁点 3-导游 4-用户',
`relate_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '关联表id',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_product_idtype_id`(`type`, `relate_id`, `product_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 35 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '产品库存' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_repaire
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_repaire`;
CREATE TABLE `oxygen_repaire` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`no` char(14) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '单号',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '申请时间',
`uid` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '网点uid',
`delivery_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收货人姓名',
`delivery_address` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '收货地址',
`delivery_tel` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '收货手机号',
`delivery_time` datetime(0) NULL DEFAULT NULL COMMENT '收货时间',
`leasehold_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '当时租赁点id',
`guide_id` int(11) NULL DEFAULT NULL COMMENT '当时导游id',
`user_type` enum('导游','租赁点') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '租赁点' COMMENT '网点类型',
`check_time` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',
`stock_time` datetime(0) NULL DEFAULT NULL COMMENT '入库时间',
`name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '网点名称',
`status` enum('待审核','取货中','已取货') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '待审核' COMMENT '状态',
`check_uid` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '审核人uid',
`stock_uid` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '入库uid',
`creator_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '申请人姓名',
`send_name` varchar(14) CHARACTER SET utf8 COLLATE utf8_general_ci 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 oxygen_repaire_detail
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_repaire_detail`;
CREATE TABLE `oxygen_repaire_detail` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`repaire_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '报修单id',
`name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '商品名称',
`amount` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '数据',
`unit` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '单位',
`product_id` int(11) UNSIGNED NULL DEFAULT 0 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 oxygen_report_lose
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_report_lose`;
CREATE TABLE `oxygen_report_lose` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`no` char(24) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '单号',
`order_no` varchar(14) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '关联订单号',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '申请时间',
`uid` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '业务员uid',
`leasehold_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '租赁点id',
`guide_id` int(11) NULL DEFAULT NULL COMMENT '当时导游id',
`server_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '服务员id',
`user_type` enum('导游','租赁点','服务员') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '租赁点' COMMENT '网点类型',
`delivery_address` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '收货地址',
`delivery_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收货人姓名',
`delivery_tel` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '收货手机号',
`delivery_time` datetime(0) NULL DEFAULT NULL COMMENT '收货时间',
`check_time` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',
`stock_time` datetime(0) NULL DEFAULT NULL COMMENT '入库时间',
`name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '网点名称',
`status` enum('待确认','已确认') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '待确认' COMMENT '状态',
`money` float(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '应赔金额',
`money_real` float(10, 2) NULL DEFAULT 0.00 COMMENT '实付金额',
`money_left` float(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '剩余赔付状态',
`creator_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '申请人姓名',
`send_name` varchar(14) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '配货人姓名',
`salesman_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '业务员姓名',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 29 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '报损单' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_report_lose_detail
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_report_lose_detail`;
CREATE TABLE `oxygen_report_lose_detail` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`report_lose_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '报损单id',
`product_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品id',
`name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '产品名称',
`amount` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '数量',
`unit` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '单位',
`price` float(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '金额',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '报损单明细' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_return
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_return`;
CREATE TABLE `oxygen_return` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`no` char(14) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '编号',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '申请时间',
`uid` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '网点uid',
`user_type` enum('导游','租赁点') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '租赁点' COMMENT '网点类型',
`name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '网点名称',
`delivery_address` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '收货地址',
`delivery_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收货人姓名',
`delivery_time` datetime(0) NULL DEFAULT NULL COMMENT '收货时间',
`delivery_tel` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '收货手机号',
`check_time` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',
`stock_time` datetime(0) NULL DEFAULT NULL COMMENT '入库时间',
`status` enum('待审核','取货中','已取货') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '待审核',
`creator_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '申请人姓名',
`send_name` varchar(14) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '配货人姓名',
`leasehold_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '当时租赁点id',
`guide_id` int(11) NULL DEFAULT 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 oxygen_return_detail
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_return_detail`;
CREATE TABLE `oxygen_return_detail` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`return_id` int(11) UNSIGNED NULL DEFAULT 0,
`name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '名称',
`amount` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '数量',
`unit` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '单位',
`product_id` int(11) UNSIGNED NOT NULL DEFAULT 0 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 oxygen_salesman
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_salesman`;
CREATE TABLE `oxygen_salesman` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`no` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工号',
`name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '姓名',
`tel` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '手机号',
`create_time` datetime(0) NULL DEFAULT NULL,
`last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '上次登录时间',
`status` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '1-启用 0-禁用',
`company_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '集团id 默认0 交投写死1',
`qrcode` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '导游小程序码图片',
`bankcard` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '银行卡号',
`bank` varchar(48) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '总行',
`cnap` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '联行号',
`bank_account_type` enum('对私','对公') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '对私' COMMENT '银行账号类型 对私 or 对公',
`bank_account` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '开户名',
`update_time` datetime(0) NULL DEFAULT NULL,
`rate` float(4, 1) UNSIGNED NOT NULL DEFAULT 0.0 COMMENT '租赁提成比例',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '业务员' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_server
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_server`;
CREATE TABLE `oxygen_server` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`leasehold_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '服务员id',
`name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '姓名',
`tel` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '负责人手机号',
`sex` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '1-男 0-女',
`order_num` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '订单数',
`return_num` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '归还数',
`score` float(2, 1) UNSIGNED NULL DEFAULT 0.0 COMMENT '评分',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '上次登录时间',
`status` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '状态 1-启用 0-禁用',
`bankcard` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '银行卡号',
`bank` varchar(48) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '总行',
`cnap` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '联行号',
`bank_account_type` enum('对私','对公') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '对私' COMMENT '银行账号类型 对私 or 对公',
`bank_account` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '开户名',
`update_time` datetime(0) NULL DEFAULT NULL,
`rent_rate` float(4, 1) UNSIGNED NULL DEFAULT 0.0 COMMENT '租赁提成比例',
`return_rate` float(4, 1) UNSIGNED NULL DEFAULT 0.0 COMMENT '归还提成比例',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '服务员表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_ticket
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_ticket`;
CREATE TABLE `oxygen_ticket` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`wxuid` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'wxuid',
`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '抬头',
`type` enum('个人','企业单位') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '个人' COMMENT '类型',
`tax_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '税号',
`money` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '金额',
`item` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '发票项目',
`remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',
`email` varchar(380) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电子邮箱',
`status` tinyint(1) NULL DEFAULT -1 COMMENT '-1 待审核 1已审核 0-拒绝',
`create_time` datetime(0) NOT NULL COMMENT '申请时间',
`check_time` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_user_tmp_auth
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_user_tmp_auth`;
CREATE TABLE `oxygen_user_tmp_auth` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`admin_uid` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '授权人uid',
`wxuid` int(11) UNSIGNED NULL DEFAULT 0 COMMENT 'wxuid',
`create_time` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '开始时间',
`end_time` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最后允许时间',
`type` int(2) UNSIGNED NULL DEFAULT 1 COMMENT '1-修改结账信息',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_withdraw_change
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_withdraw_change`;
CREATE TABLE `oxygen_withdraw_change` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`type` enum('取消出账','修改支付账户','修改付款金额') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '变更单类型',
`multi` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '是否影响同类型账号',
`withdraw_log_id` bigint(20) UNSIGNED NULL DEFAULT 0 COMMENT '主出账记录id',
`withdraw_log_ids` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '出账记录ids,逗号分隔',
`money` float(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '提成',
`status` tinyint(1) NULL DEFAULT -1 COMMENT '状态 1-已审核 -1-待审核 0-已拒绝',
`check_uid` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '审核人id',
`uid` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '提交人',
`order_no` char(14) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '订单no',
`refuse_reason` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '拒绝理由',
`reason` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
`create_time` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
`update_time` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
`bankcard` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '银行卡号',
`bank` varchar(48) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '总行',
`cnap` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '联行号',
`bank_account` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci 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 oxygen_withdraw_log
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_withdraw_log`;
CREATE TABLE `oxygen_withdraw_log` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '最迟处理时间',
`order_id` bigint(20) UNSIGNED NULL DEFAULT 0 COMMENT '订单id',
`order_no` char(14) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '订单no',
`status` enum('待结算','结算中','已结算','结算失败','变更中','已取消') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '待结算' COMMENT '状态',
`remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注',
`balance_id` bigint(20) UNSIGNED NULL DEFAULT 0 COMMENT '收支id',
`type` enum('订单取消','退还押金','提前还租','订单提成') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '订单取消' COMMENT '类型',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '操作时间',
`tel` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '手机号',
`nickname` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '微信昵称',
`user_type` enum('服务员','租赁点','导游','业务员','用户') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '服务员' COMMENT '用户类型',
`bankcard` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '银行卡号',
`bank` varchar(48) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '总行',
`cnap` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '联行号',
`bank_account` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '开户名',
`bank_account_type` enum('对私','对公') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '对私' COMMENT '银行账号类型 对私 or 对公',
`money` float(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '转出金额',
`fee` float(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '手续费',
`salesman_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '业务员id',
`salesman_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '业务员名称',
`update_time` datetime(0) NULL DEFAULT NULL,
`trans_type` enum('转账','退款','报损抵扣') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '转账',
`trans_result` varchar(2048) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '转账结果序列化',
`query_result` varchar(2048) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '查询结果',
`errors` varchar(10240) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '错误信息',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 73 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '提现记录表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for oxygen_wxuser
-- ----------------------------
DROP TABLE IF EXISTS `oxygen_wxuser`;
CREATE TABLE `oxygen_wxuser` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id',
`appid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '微信appid',
`session_key` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT 'session_key',
`openid` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'openid',
`unionid` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '开放平台openid',
`type` enum('小程序','公众号') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '小程序' COMMENT '类型',
`nickname` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '昵称',
`sex` enum('男','女','未知') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '未知' COMMENT '性别',
`language` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '语言',
`province` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '省',
`city` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '市',
`country` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '国家',
`headimgurl` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '头像',
`rent_times` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '租赁次数',
`rent_time` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '租赁时长',
`rent_money` float(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '租赁金额',
`last_rent_time` datetime(0) NULL DEFAULT NULL COMMENT '最后租赁时间',
`last_return_time` datetime(0) NULL DEFAULT NULL COMMENT '最后归还时间',
`last_rent_money` float(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '最后租赁金额',
`user_type` enum('用户','服务员','导游','租赁点','业务员') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '用户' COMMENT '前端用户类型 1-用户 2-服务员 3-导游 4-租赁点 5-业务员',
`relate_id` bigint(20) UNSIGNED NULL DEFAULT 0 COMMENT '关联用户id',
`tel` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '手机号',
`create_time` datetime(0) NULL DEFAULT NULL,
`update_time` datetime(0) NULL DEFAULT NULL,
`status` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '1-启用 0-禁用',
`cost` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '消费总额',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 63 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '微信用户表' ROW_FORMAT = Dynamic;
~~~
~~~[sql]
CREATE TABLE `oxygen_device_report` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`sn` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '设备编号',
`lon` double(12, 8) NULL DEFAULT NULL COMMENT '经度',
`lat` double(12, 8) NULL DEFAULT NULL COMMENT '纬度',
`height` double(10, 2) NULL DEFAULT NULL COMMENT '海拔',
`percent` int(3) NULL DEFAULT 1 COMMENT '电量百分比',
`open` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '是否制氧',
`charge` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '是否充电',
`reg` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '是否注册',
`create_time` datetime(0) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3963 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
~~~
