pgsql · 老楊的問題

# 自增 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; ~~~