# 自增
serial
sequence
# without oids;
# constraint g_201708_state_dlsj_check
# 氧氣數(shù)據(jù)庫結(jié)構(gòu)
~~~[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 '權(quán)限分組標(biāo)識(shí)',
`uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用戶id',
`nid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '授權(quán)節(jié)點(diǎn)id'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '統(tǒng)一授權(quán)表' 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 '行為唯一標(biāo)識(shí)',
`title` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '行為標(biāo)題',
`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 '行為規(guī)則',
`log` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '日志規(guī)則',
`status` tinyint(2) NOT NULL DEFAULT 0 COMMENT '狀態(tài)',
`create_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '創(chuàng)建時(shí)間',
`update_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時(shí)間',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 44 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系統(tǒng)行為表' 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 '模塊名，由哪個(gè)模塊上傳的',
`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 '上傳驅(qū)動(dòng)',
`download` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '下載次數(shù)',
`create_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '上傳時(shí)間',
`update_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時(shí)間',
`sort` int(11) NOT NULL DEFAULT 100 COMMENT '排序',
`status` tinyint(2) NOT NULL DEFAULT 1 COMMENT '狀態(tài)',
`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 '標(biāo)題',
`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 '配置項(xiàng)',
`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 '聯(lián)動(dòng)下拉框ajax地址',
`next_items` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '聯(lián)動(dòng)下拉框的下級(jí)下拉框名，多個(gè)以逗號(hào)隔開',
`param` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '聯(lián)動(dòng)下拉框請(qǐng)求參數(shù)名',
`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 '表名，只用于快速聯(lián)動(dòng)類型',
`level` tinyint(2) UNSIGNED NOT NULL DEFAULT 2 COMMENT '聯(lián)動(dòng)級(jí)別，只用于快速聯(lián)動(dòng)類型',
`key` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '鍵字段，只用于快速聯(lián)動(dòng)類型',
`option` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '值字段，只用于快速聯(lián)動(dòng)類型',
`pid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '父級(jí)id字段，只用于快速聯(lián)動(dòng)類型',
`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 '創(chuàng)建時(shí)間',
`update_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時(shí)間',
`sort` int(11) NOT NULL DEFAULT 100 COMMENT '排序',
`status` tinyint(2) NOT NULL DEFAULT 1 COMMENT '狀態(tài)：0禁用，1啟用',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 41 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系統(tǒng)配置表' 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 '鉤子來自哪個(gè)插件',
`description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '鉤子描述',
`system` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否為系統(tǒng)鉤子',
`create_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '創(chuàng)建時(shí)間',
`update_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時(shí)間',
`status` tinyint(2) NOT NULL DEFAULT 1 COMMENT '狀態(tài)',
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 '插件標(biāo)識(shí)',
`create_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加時(shí)間',
`update_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時(shí)間',
`sort` int(11) UNSIGNED NOT NULL DEFAULT 100 COMMENT '排序',
`status` tinyint(2) NOT NULL DEFAULT 1 COMMENT '狀態(tài)',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鉤子-插件對(duì)應(yīng)表' 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 '圖標(biāo)名稱',
`url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '圖標(biāo)css地址',
`prefix` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '圖標(biāo)前綴',
`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 '創(chuàng)建時(shí)間',
`update_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時(shí)間',
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '狀態(tài)',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '圖標(biāo)表' 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 '所屬圖標(biāo)id',
`title` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '圖標(biāo)標(biāo)題',
`class` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '圖標(biāo)類名',
`code` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '圖標(biāo)關(guān)鍵詞',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '詳細(xì)圖標(biāo)列表' 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 '執(zhí)行用戶id',
`action_ip` bigint(20) NOT NULL COMMENT '執(zhí)行行為者ip',
`model` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '觸發(fā)行為的表',
`record_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '觸發(fā)行為的數(shù)據(jù)id',
`remark` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '日志備注',
`status` tinyint(2) NOT NULL DEFAULT 1 COMMENT '狀態(tài)',
`create_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '執(zhí)行行為的時(shí)間',
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 '上級(jí)菜單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 '菜單標(biāo)題',
`icon` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '菜單圖標(biāo)',
`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 '網(wǎng)站上線后是否隱藏',
`create_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '創(chuàng)建時(shí)間',
`update_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時(shí)間',
`sort` int(11) NOT NULL DEFAULT 100 COMMENT '排序',
`system_menu` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否為系統(tǒng)菜單，系統(tǒng)菜單不可刪除',
`status` tinyint(2) NOT NULL DEFAULT 1 COMMENT '狀態(tài)',
`params` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '參數(shù)',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 423 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '后臺(tái)菜單表' 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 '發(fā)送消息的用戶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 '消息內(nèi)容',
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '狀態(tài)',
`create_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '創(chuàng)建時(shí)間',
`update_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時(shí)間',
`read_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '閱讀時(shí)間',
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 '模塊名稱（標(biāo)識(shí)）',
`title` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '模塊標(biāo)題',
`icon` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '圖標(biāo)',
`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 '授權(quán)配置',
`version` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '版本號(hào)',
`identifier` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '模塊唯一標(biāo)識(shí)符',
`system_module` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否為系統(tǒng)模塊',
`create_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '創(chuàng)建時(shí)間',
`update_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時(shí)間',
`sort` int(11) NOT NULL DEFAULT 100 COMMENT '排序',
`status` tinyint(2) NOT NULL DEFAULT 1 COMMENT '狀態(tài)',
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 '數(shù)據(jù)包名',
`title` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '數(shù)據(jù)包標(biāo)題',
`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 '數(shù)據(jù)表名',
`create_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '創(chuàng)建時(shí)間',
`update_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時(shí)間',
`status` tinyint(2) NOT NULL DEFAULT 1 COMMENT '狀態(tài)',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '數(shù)據(jù)包表' 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 '插件標(biāo)題',
`icon` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '圖標(biāo)',
`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 '版本號(hào)',
`identifier` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '插件唯一標(biāo)識(shí)符',
`admin` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否有后臺(tái)管理',
`create_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '安裝時(shí)間',
`update_time` int(11) NOT NULL DEFAULT 0 COMMENT '更新時(shí)間',
`sort` int(11) NOT NULL DEFAULT 100 COMMENT '排序',
`status` tinyint(2) NOT NULL DEFAULT 1 COMMENT '狀態(tài)',
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 '上級(jí)角色',
`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 '菜單權(quán)限',
`sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序',
`create_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '創(chuàng)建時(shí)間',
`update_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時(shí)間',
`status` tinyint(2) NOT NULL DEFAULT 1 COMMENT '狀態(tài)',
`access` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否可登錄后臺(tái)',
`default_module` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '默認(rèn)訪問模塊',
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 '手機(jī)號(hào)碼',
`mobile_bind` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否綁定手機(jī)號(hào)碼',
`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 '角色I(xiàn)D',
`group` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '部門id',
`signup_ip` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '注冊(cè)ip',
`create_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '創(chuàng)建時(shí)間',
`update_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時(shí)間',
`last_login_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最后一次登錄時(shí)間',
`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 '狀態(tài)：0禁用，1啟用',
`no` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '工號(hào)',
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 '標(biāo)題',
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '內(nèi)容',
`schedule` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Cron 表達(dá)式',
`sleep` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '延遲秒數(shù)執(zhí)行',
`maximums` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最大執(zhí)行次數(shù) 0為不限',
`executes` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '已經(jīng)執(zhí)行的次數(shù)',
`create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '創(chuàng)建時(shí)間',
`update_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新時(shí)間',
`begin_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '開始時(shí)間',
`end_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '結(jié)束時(shí)間',
`execute_time` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '最后執(zhí)行時(shí)間',
`weigh` int(10) NOT NULL DEFAULT 0 COMMENT '權(quán)重',
`status` enum('completed','expired','disable','normal') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'normal' COMMENT '狀態(tài)',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '定時(shí)任務(wù)表' 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 '任務(wù)的ID',
`title` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '標(biāo)題',
`remark` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '備注',
`create_time` int(10) UNSIGNED NOT NULL COMMENT '執(zhí)行時(shí)間',
`status` tinyint(1) NOT NULL COMMENT '狀態(tài) 0:失敗 1:成功',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5763 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '定時(shí)任務(wù)日志表' 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 = '地區(qū)信息表' 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 '經(jīng)度',
`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 '開始時(shí)間',
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '結(jié)束時(shí)間',
`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-續(xù)租可用 0-續(xù)租不可用',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '活動(dòng)表' 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 '活動(dòng)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 = '活動(dòng)明細(xì)表' 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 '標(biāo)題',
`money` float(10, 2) NOT NULL DEFAULT 0.00 COMMENT '金額',
`left_money` float(10, 2) NULL DEFAULT 0.00 COMMENT '剩余損額',
`type` enum('租賃單','報(bào)損單') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '租賃單' COMMENT '類型',
`uid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '對(duì)應(yīng)表id',
`user_type` enum('服務(wù)員','租賃點(diǎn)','導(dǎo)游','業(yè)務(wù)員','用戶') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '服務(wù)員' COMMENT '用戶類型',
`wxuid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用戶uid',
`order_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '關(guān)聯(lián)訂單id',
`class` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '分類',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '記錄時(shí)間',
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 '地區(qū)碼',
`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 '連行號(hào)',
`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 '地區(qū)碼',
`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 '內(nèi)容',
`wxuid` bigint(20) UNSIGNED NULL DEFAULT 0 COMMENT '用戶uid',
`customer_tel` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '顧客手機(jī)號(hào)',
`rent_leasehold_id` bigint(20) UNSIGNED NULL DEFAULT 0 COMMENT '租賃點(diǎn)uid',
`rent_leasehold_score` float(2, 1) UNSIGNED NULL DEFAULT 0.0 COMMENT '租賃點(diǎn)評(píng)分1-5分',
`rent_server_id` bigint(20) UNSIGNED NULL DEFAULT 0 COMMENT '租賃點(diǎn)服務(wù)員uid',
`rent_server_score` float(2, 1) UNSIGNED NULL DEFAULT 0.0 COMMENT '租賃點(diǎn)服務(wù)員評(píng)分1-5分',
`rent_guide_id` bigint(11) UNSIGNED NULL DEFAULT 0 COMMENT '租賃導(dǎo)游uid',
`rent_guide_score` float(2, 1) UNSIGNED NULL DEFAULT NULL COMMENT '租賃導(dǎo)游評(píng)分',
`return_server_id` bigint(20) UNSIGNED NULL DEFAULT 0 COMMENT '歸還點(diǎn) 服務(wù)員uid',
`return_server_score` float(2, 1) UNSIGNED NULL DEFAULT 0.0 COMMENT '歸還點(diǎn)服務(wù)員評(píng)分',
`return_leasehold_id` bigint(20) UNSIGNED NULL DEFAULT 0 COMMENT '歸還租賃點(diǎn)uid',
`return_leasehold_score` float(2, 1) UNSIGNED NULL DEFAULT 0.0 COMMENT '歸還點(diǎn)拼分1-5分',
`return_guide_id` bigint(11) NULL DEFAULT NULL COMMENT '歸還導(dǎo)游uid',
`return_guide_score` float(2, 1) UNSIGNED NULL DEFAULT 0.0 COMMENT '歸還導(dǎo)游評(píng)分',
`device_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '設(shè)備id',
`device_score` float(2, 1) UNSIGNED NULL DEFAULT 0.0 COMMENT '設(shè)備評(píng)分',
`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 = '評(píng)論表' 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 '產(chǎn)品id',
`position` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '賠償部位',
`price` float(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '價(jià)格',
`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-服務(wù)員 2-導(dǎo)游',
`bind_time` datetime(0) NULL DEFAULT NULL COMMENT '綁定時(shí)間',
`status` enum('激活','已綁定','租賃中','異常','丟失') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '激活' COMMENT '狀態(tài)',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '激活時(shí)間',
`leasehold_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '綁定租賃點(diǎn)id',
`connect_time` datetime(0) NULL DEFAULT NULL COMMENT '通信時(shí)間',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 85 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '設(shè)備表' 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-租賃結(jié)束 3-激活',
`state` int(2) UNSIGNED NULL DEFAULT 1 COMMENT '目標(biāo)狀態(tài)',
`etime` datetime(0) NULL DEFAULT NULL COMMENT '結(jié)束時(shí)間',
`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 '設(shè)備sn',
`server_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '服務(wù)員id',
`guide_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '導(dǎo)游id',
`content` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '內(nèi)容',
`pics` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '圖片id',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加時(shí)間',
`server_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '服務(wù)員名稱',
`leasehold_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '租賃點(diǎn)名稱',
`guide_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '導(dǎo)游名稱',
`salesman_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '業(yè)務(wù)員名稱',
PRIMARY KEY (`id`) USING BTREE,
INDEX `sn`(`sn`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 37 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '設(shè)備備注表' 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 '訂單號(hào)',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '創(chuàng)建時(shí)間',
`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 '手機(jī)號(hào)',
`type` enum('押金','租賃費(fèi)','銷售費(fèi)','續(xù)租費(fèi)','賠償費(fèi)','超時(shí)費(fèi)','報(bào)損費(fèi)') 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 '支付賬號(hào)',
`salesman_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '業(yè)務(wù)員id',
`salesman_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '業(yè)務(wù)員名稱',
`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 '身份證號(hào)',
`id_pic` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '身份證圖片',
`guide_no` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '導(dǎo)游證編號(hào)',
`guide_pic` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '導(dǎo)游證圖片',
`nation` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '民族',
`salesman_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '業(yè)務(wù)員id',
`order_num` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '訂單數(shù)',
`return_left` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '歸還數(shù)',
`score` float(2, 1) UNSIGNED NULL DEFAULT 0.0 COMMENT '評(píng)分',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '創(chuàng)建時(shí)間',
`last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '上次登錄時(shí)間',
`status` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '狀態(tài) 1-啟用 0-禁用',
`device` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '設(shè)備數(shù)',
`parts` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '配件數(shù)',
`delivery_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '送貨地址',
`qrcode` int(10) UNSIGNED NULL DEFAULT 31 COMMENT '導(dǎo)游小程序碼圖片',
`bankcard` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '銀行卡號(hào)',
`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 '聯(lián)行號(hào)',
`bank_account_type` enum('對(duì)私','對(duì)公') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '對(duì)私' COMMENT '銀行賬號(hào)類型 對(duì)私 or 對(duì)公',
`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 '剩余報(bào)錯(cuò)額',
`report_lose_total` float(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '報(bào)損總額',
`tel` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '手機(jī)號(hào)',
`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 = '導(dǎo)游表' 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 '業(yè)務(wù)員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 '級(jí)別',
`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 '區(qū)',
`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 '營業(yè)開始時(shí)間',
`end_time` char(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '營業(yè)結(jié)束時(shí)間',
`realname` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '負(fù)責(zé)人',
`tel` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '負(fù)責(zé)人手機(jī)號(hào)',
`wx_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '負(fù)責(zé)微信昵稱',
`id_no` varchar(18) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '負(fù)責(zé)人身份證號(hào)',
`id_pic` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '負(fù)責(zé)人身份證圖片',
`auto_assign` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '是否自動(dòng)分配 1-是 0-否',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '申請(qǐng)時(shí)間',
`last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '上次登錄時(shí)間',
`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 申請(qǐng)中 1 啟用 0-禁用',
`lat` double(12, 8) NULL DEFAULT NULL COMMENT '緯度',
`lon` double(12, 8) NULL DEFAULT NULL COMMENT '經(jīng)度',
`geohash` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT 'geohash',
`qrcode` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '導(dǎo)游小程序碼圖片',
`score` float(2, 1) UNSIGNED NULL DEFAULT 0.0 COMMENT '評(píng)分',
`bankcard` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '銀行卡號(hào)',
`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 '聯(lián)行號(hào)',
`bank_account_type` enum('對(duì)私','對(duì)公') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '對(duì)私' COMMENT '銀行賬號(hào)類型 對(duì)私 or 對(duì)公',
`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 '報(bào)損總額',
`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 = '租賃點(diǎn)' 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 = '租賃點(diǎn)分類' 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 '是否默認(rèn)',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '租賃點(diǎn)級(jí)別' 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 '內(nèi)容',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '新增時(shí)間',
`type` enum('業(yè)務(wù)員','租賃點(diǎn)','服務(wù)員','導(dǎo)游','公眾號(hào)','站內(nèi)信','用戶') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '業(yè)務(wù)員' COMMENT '類型',
`status` enum('未讀','已讀','已刪除') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '未讀' COMMENT '狀態(tài)',
`read_time` datetime(0) NULL DEFAULT NULL COMMENT '閱讀時(shí)間',
`data_type` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '數(shù)據(jù)類型',
`data_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '關(guān)聯(lián)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關(guān)鍵字 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 '文字內(nèi)容',
`sort` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '排序',
`status` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '狀態(tài)(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 '訂單編號(hào)',
`wxuid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用戶uid',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '創(chuàng)建時(shí)間',
`type` enum('租賃單','換貨單','續(xù)租單','賠償單') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '租賃單' COMMENT '類型',
`device_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '設(shè)備id',
`relate_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '關(guān)聯(lián)id',
`remark` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '備注',
`status` enum('待支付','租賃中','已結(jié)束','已關(guān)閉') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '待支付' COMMENT '狀態(tài)',
`days` int(11) UNSIGNED NOT NULL DEFAULT 1 COMMENT '租賃天數(shù)',
`finish_time` datetime(0) NOT NULL COMMENT '應(yīng)當(dāng)結(jié)束時(shí)間',
`fail_time` datetime(0) NULL DEFAULT NULL COMMENT '支付失敗時(shí)間',
`pay_method` enum('微信','支付寶','系統(tǒng)后臺(tái)') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '支付方式',
`pay_time` datetime(0) NULL DEFAULT NULL COMMENT '支付時(shí)間',
`pay_status` enum('未支付','已支付','支付失敗') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '未支付' COMMENT '支付狀態(tài)',
`activity_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '活動(dòng)id',
`activity_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '活動(dòng)名稱',
`discount` float(3, 2) UNSIGNED NOT NULL DEFAULT 1.00 COMMENT '折扣',
`money` float(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '訂單總價(jià)',
`rent_money` float(10, 2) NOT NULL COMMENT '租賃費(fèi)',
`sale_money` float(10, 2) NOT NULL COMMENT '銷售費(fèi)',
`overtime_money` float(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '超時(shí)費(fèi)',
`deposit` float(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '押金',
`rent_guide_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '租賃時(shí)導(dǎo)游id',
`rent_guide_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '租賃導(dǎo)游姓名',
`rent_server_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '租賃時(shí)服務(wù)員id',
`rent_server_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '租賃時(shí)服務(wù)員姓名',
`rent_leasehold_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '租賃時(shí)租賃點(diǎn)id',
`rent_leasehold_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '租賃時(shí)租賃點(diǎn)名稱',
`rent_salesman_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '租賃時(shí)業(yè)務(wù)員id',
`rent_salesman_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '租賃業(yè)務(wù)員名稱',
`return_server_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '歸還時(shí)服務(wù)員id',
`return_server_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '歸還時(shí)服務(wù)員名稱',
`return_leasehold_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '歸還時(shí)租賃點(diǎn)id',
`return_leasehold_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '歸還時(shí)租賃點(diǎn)名稱',
`return_guide_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '歸還時(shí)導(dǎo)游id',
`return_guide_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '歸還時(shí)導(dǎo)游姓名',
`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 '支付賬號(hào)',
`close_time` datetime(0) NULL DEFAULT NULL COMMENT '確認(rèn)結(jié)束時(shí)間',
`customer_tel` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '顧客手機(jī)號(hào)',
`customer_nickname` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '顧客昵稱',
`confirm_status` enum('無需確認(rèn)','待確認(rèn)','已確認(rèn)') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '無需確認(rèn)',
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 '單號(hào)',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '申請(qǐng)時(shí)間',
`check_time` datetime(0) NULL DEFAULT NULL COMMENT '審核時(shí)間',
`name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '網(wǎng)點(diǎn)名稱',
`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 '收貨手機(jī)號(hào)',
`delivery_time` datetime(0) NULL DEFAULT NULL COMMENT '收貨時(shí)間',
`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 '當(dāng)時(shí)租賃點(diǎn)id',
`guide_id` int(11) NULL DEFAULT NULL COMMENT '當(dāng)時(shí)導(dǎo)游id',
`user_type` enum('導(dǎo)游','租賃點(diǎn)') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '租賃點(diǎn)' COMMENT '網(wǎng)點(diǎn)類型',
`uid` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '網(wǎng)點(diǎn)uid',
`creator_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '申請(qǐng)人姓名',
`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 '項(xiàng)目名稱',
`amount` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '數(shù)量',
`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 = '配貨單明細(xì)' 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 '產(chǎn)品名稱',
`price` float(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '價(jià)格',
`mode` enum('出租','銷售') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '出租' COMMENT '租售模式',
`amount` int(11) UNSIGNED NULL DEFAULT 1 COMMENT '數(shù)量',
`total` float(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '總價(jià)',
`sn` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '序列號(hào)',
`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 = '訂單明細(xì)' 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 '手機(jī)號(hào)',
`near_time` datetime(0) NULL DEFAULT NULL COMMENT '快到期前時(shí)間',
`near_send` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '是否發(fā)過',
`just_pass_time` datetime(0) NULL DEFAULT NULL COMMENT '剛剛過去',
`just_pass_send` tinyint(3) UNSIGNED NULL DEFAULT 0 COMMENT '是否剛超時(shí)',
`overtime_oneday` datetime(0) NULL DEFAULT NULL COMMENT '超時(shí)一天',
`oneday_send` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '超過一天發(fā)送',
`overtime_threeday` datetime(0) NULL DEFAULT NULL COMMENT '超時(shí)三天',
`threeday_send` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '是否超時(shí)3天發(fā)送',
`closed` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '是否訂單結(jié)束',
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('產(chǎn)品','配件') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '產(chǎn)品' 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 '更新時(shí)間',
`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 = '產(chǎn)品表' 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 '數(shù)量',
`type` int(2) UNSIGNED NULL DEFAULT 1 COMMENT '分類 1-總部 2-租賃點(diǎn) 3-導(dǎo)游 4-用戶',
`relate_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '關(guān)聯(lián)表id',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '創(chuàng)建時(shí)間',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新時(shí)間',
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 = '產(chǎn)品庫存' 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 '單號(hào)',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '申請(qǐng)時(shí)間',
`uid` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '網(wǎng)點(diǎn)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 '收貨手機(jī)號(hào)',
`delivery_time` datetime(0) NULL DEFAULT NULL COMMENT '收貨時(shí)間',
`leasehold_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '當(dāng)時(shí)租賃點(diǎn)id',
`guide_id` int(11) NULL DEFAULT NULL COMMENT '當(dāng)時(shí)導(dǎo)游id',
`user_type` enum('導(dǎo)游','租賃點(diǎn)') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '租賃點(diǎn)' COMMENT '網(wǎng)點(diǎn)類型',
`check_time` datetime(0) NULL DEFAULT NULL COMMENT '審核時(shí)間',
`stock_time` datetime(0) NULL DEFAULT NULL COMMENT '入庫時(shí)間',
`name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '網(wǎng)點(diǎn)名稱',
`status` enum('待審核','取貨中','已取貨') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '待審核' COMMENT '狀態(tài)',
`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 '申請(qǐng)人姓名',
`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 = '報(bào)修單' 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 '報(bào)修單id',
`name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '商品名稱',
`amount` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '數(shù)據(jù)',
`unit` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '單位',
`product_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '產(chǎn)品id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '報(bào)修單明細(xì)' 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 '單號(hào)',
`order_no` varchar(14) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '關(guān)聯(lián)訂單號(hào)',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '申請(qǐng)時(shí)間',
`uid` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '業(yè)務(wù)員uid',
`leasehold_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '租賃點(diǎn)id',
`guide_id` int(11) NULL DEFAULT NULL COMMENT '當(dāng)時(shí)導(dǎo)游id',
`server_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '服務(wù)員id',
`user_type` enum('導(dǎo)游','租賃點(diǎn)','服務(wù)員') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '租賃點(diǎn)' COMMENT '網(wǎng)點(diǎn)類型',
`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 '收貨手機(jī)號(hào)',
`delivery_time` datetime(0) NULL DEFAULT NULL COMMENT '收貨時(shí)間',
`check_time` datetime(0) NULL DEFAULT NULL COMMENT '審核時(shí)間',
`stock_time` datetime(0) NULL DEFAULT NULL COMMENT '入庫時(shí)間',
`name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '網(wǎng)點(diǎn)名稱',
`status` enum('待確認(rèn)','已確認(rèn)') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '待確認(rèn)' COMMENT '狀態(tài)',
`money` float(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '應(yīng)賠金額',
`money_real` float(10, 2) NULL DEFAULT 0.00 COMMENT '實(shí)付金額',
`money_left` float(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '剩余賠付狀態(tài)',
`creator_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '申請(qǐng)人姓名',
`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 '業(yè)務(wù)員姓名',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 29 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '報(bào)損單' 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 '報(bào)損單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 '產(chǎn)品名稱',
`amount` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '數(shù)量',
`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 = '報(bào)損單明細(xì)' 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 '編號(hào)',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '申請(qǐng)時(shí)間',
`uid` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '網(wǎng)點(diǎn)uid',
`user_type` enum('導(dǎo)游','租賃點(diǎn)') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '租賃點(diǎn)' COMMENT '網(wǎng)點(diǎn)類型',
`name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '網(wǎng)點(diǎn)名稱',
`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 '收貨時(shí)間',
`delivery_tel` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '收貨手機(jī)號(hào)',
`check_time` datetime(0) NULL DEFAULT NULL COMMENT '審核時(shí)間',
`stock_time` datetime(0) NULL DEFAULT NULL COMMENT '入庫時(shí)間',
`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 '申請(qǐng)人姓名',
`send_name` varchar(14) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '配貨人姓名',
`leasehold_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '當(dāng)時(shí)租賃點(diǎn)id',
`guide_id` int(11) NULL DEFAULT NULL COMMENT '當(dāng)時(shí)導(dǎo)游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 '數(shù)量',
`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 = '退貨單明細(xì)' 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 '工號(hào)',
`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 '手機(jī)號(hào)',
`create_time` datetime(0) NULL DEFAULT NULL,
`last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '上次登錄時(shí)間',
`status` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '1-啟用 0-禁用',
`company_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '集團(tuán)id 默認(rèn)0 交投寫死1',
`qrcode` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '導(dǎo)游小程序碼圖片',
`bankcard` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '銀行卡號(hào)',
`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 '聯(lián)行號(hào)',
`bank_account_type` enum('對(duì)私','對(duì)公') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '對(duì)私' COMMENT '銀行賬號(hào)類型 對(duì)私 or 對(duì)公',
`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 = '業(yè)務(wù)員' 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 '服務(wù)員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 '負(fù)責(zé)人手機(jī)號(hào)',
`sex` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '1-男 0-女',
`order_num` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '訂單數(shù)',
`return_num` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '歸還數(shù)',
`score` float(2, 1) UNSIGNED NULL DEFAULT 0.0 COMMENT '評(píng)分',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '創(chuàng)建時(shí)間',
`last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '上次登錄時(shí)間',
`status` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '狀態(tài) 1-啟用 0-禁用',
`bankcard` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '銀行卡號(hào)',
`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 '聯(lián)行號(hào)',
`bank_account_type` enum('對(duì)私','對(duì)公') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '對(duì)私' COMMENT '銀行賬號(hào)類型 對(duì)私 or 對(duì)公',
`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 = '服務(wù)員表' 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('個(gè)人','企業(yè)單位') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '個(gè)人' COMMENT '類型',
`tax_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '稅號(hào)',
`money` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '金額',
`item` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '發(fā)票項(xiàng)目',
`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 '申請(qǐng)時(shí)間',
`check_time` datetime(0) NULL DEFAULT NULL COMMENT '審核時(shí)間',
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 '授權(quán)人uid',
`wxuid` int(11) UNSIGNED NULL DEFAULT 0 COMMENT 'wxuid',
`create_time` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '開始時(shí)間',
`end_time` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最后允許時(shí)間',
`type` int(2) UNSIGNED NULL DEFAULT 1 COMMENT '1-修改結(jié)賬信息',
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 '是否影響同類型賬號(hào)',
`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,逗號(hào)分隔',
`money` float(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '提成',
`status` tinyint(1) NULL DEFAULT -1 COMMENT '狀態(tài) 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 '銀行卡號(hào)',
`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 '聯(lián)行號(hào)',
`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 = '提現(xiàn)變更單' 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 '最遲處理時(shí)間',
`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('待結(jié)算','結(jié)算中','已結(jié)算','結(jié)算失敗','變更中','已取消') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '待結(jié)算' COMMENT '狀態(tài)',
`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 '操作時(shí)間',
`tel` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '手機(jī)號(hào)',
`nickname` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '微信昵稱',
`user_type` enum('服務(wù)員','租賃點(diǎn)','導(dǎo)游','業(yè)務(wù)員','用戶') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '服務(wù)員' COMMENT '用戶類型',
`bankcard` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '銀行卡號(hào)',
`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 '聯(lián)行號(hào)',
`bank_account` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '開戶名',
`bank_account_type` enum('對(duì)私','對(duì)公') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '對(duì)私' COMMENT '銀行賬號(hào)類型 對(duì)私 or 對(duì)公',
`money` float(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '轉(zhuǎn)出金額',
`fee` float(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '手續(xù)費(fèi)',
`salesman_id` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '業(yè)務(wù)員id',
`salesman_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '業(yè)務(wù)員名稱',
`update_time` datetime(0) NULL DEFAULT NULL,
`trans_type` enum('轉(zhuǎn)賬','退款','報(bào)損抵扣') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '轉(zhuǎn)賬',
`trans_result` varchar(2048) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '轉(zhuǎn)賬結(jié)果序列化',
`query_result` varchar(2048) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '查詢結(jié)果',
`errors` varchar(10240) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '錯(cuò)誤信息',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 73 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '提現(xiàn)記錄表' 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 '開放平臺(tái)openid',
`type` enum('小程序','公眾號(hào)') 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 '租賃次數(shù)',
`rent_time` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '租賃時(shí)長(zhǎng)',
`rent_money` float(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '租賃金額',
`last_rent_time` datetime(0) NULL DEFAULT NULL COMMENT '最后租賃時(shí)間',
`last_return_time` datetime(0) NULL DEFAULT NULL COMMENT '最后歸還時(shí)間',
`last_rent_money` float(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '最后租賃金額',
`user_type` enum('用戶','服務(wù)員','導(dǎo)游','租賃點(diǎn)','業(yè)務(wù)員') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '用戶' COMMENT '前端用戶類型 1-用戶 2-服務(wù)員 3-導(dǎo)游 4-租賃點(diǎn) 5-業(yè)務(wù)員',
`relate_id` bigint(20) UNSIGNED NULL DEFAULT 0 COMMENT '關(guān)聯(lián)用戶id',
`tel` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '手機(jī)號(hào)',
`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 '消費(fèi)總額',
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 '設(shè)備編號(hào)',
`lon` double(12, 8) NULL DEFAULT NULL COMMENT '經(jīng)度',
`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 '是否注冊(cè)',
`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;
~~~
- 序
- 前端
- 通用
- bootstrap
- angular
- ui-router
- controller
- react
- 后端
- php
- mysql
- 自定義函數(shù)
- 運(yùn)維
- appveyor ci構(gòu)建php擴(kuò)展
- api
- weixin
- geo
- 西陸整理
- 人員
- 目錄結(jié)構(gòu)
- 數(shù)據(jù)庫結(jié)構(gòu)
- 項(xiàng)目初始化
- 小記憶
- 分頁函數(shù)
- 系統(tǒng)函數(shù)庫
- 常用函數(shù)庫
- 操作數(shù)據(jù)庫
- 幫助演示
- ct高級(jí)搜索
- 測(cè)試代碼極客tags
- 服務(wù)器
- java
- yar
- 簡(jiǎn)歷
- tcp
- efi分區(qū)加載
- 氧庫測(cè)試
- 測(cè)試
- pgsql
- 轉(zhuǎn)換