From e145bb81724645e5289e3140f87018c19e1eea14 Mon Sep 17 00:00:00 2001 From: puzhibing <393733352@qq.com> Date: 星期四, 09 二月 2023 23:17:23 +0800 Subject: [PATCH] 新增加司机端接口 --- super_save_driving.sql | 64 +++++++++++++++++++++++++++++++- 1 files changed, 62 insertions(+), 2 deletions(-) diff --git a/super_save_driving.sql b/super_save_driving.sql index 45556bd..12dfcf8 100644 --- a/super_save_driving.sql +++ b/super_save_driving.sql @@ -11,7 +11,7 @@ Target Server Version : 50637 File Encoding : 65001 - Date: 09/02/2023 00:20:49 + Date: 09/02/2023 23:16:27 */ SET NAMES utf8mb4; @@ -418,6 +418,48 @@ INSERT INTO `t_branch_office` VALUES (1, 1, 'test', '1566666666', '393733352@qq.com', '510000', '四川省', '510100', '成都市', '510107', '武侯区', 1, '2023-02-03 14:53:48'); -- ---------------------------- +-- Table structure for t_commercial +-- ---------------------------- +DROP TABLE IF EXISTS `t_commercial`; +CREATE TABLE `t_commercial` ( + `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键', + `type` int(1) NULL DEFAULT NULL COMMENT '类型（1=弹窗广告，2=底部广告）', + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '名称', + `device` int(1) NULL DEFAULT NULL COMMENT '设备（1=小程序，2=司机端）', + `isJump` int(1) NULL DEFAULT NULL COMMENT '是否跳转（0=否，1=是）', + `jumpType` int(1) NULL DEFAULT NULL COMMENT '跳转类型（1=内部跳转，2=外部跳转）', + `jumpUrl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '跳转连接', + `html` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '富文本', + `sort` int(11) NULL DEFAULT NULL COMMENT '排序', + `status` int(1) NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=删除）', + `createTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间', + `createUserId` int(11) NULL DEFAULT NULL COMMENT '添加人员id', + `updateTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', + `updateUserId` int(11) NULL DEFAULT NULL COMMENT '更新人员id', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '广告' ROW_FORMAT = Compact; + +-- ---------------------------- +-- Records of t_commercial +-- ---------------------------- + +-- ---------------------------- +-- Table structure for t_commercial_user_eject +-- ---------------------------- +DROP TABLE IF EXISTS `t_commercial_user_eject`; +CREATE TABLE `t_commercial_user_eject` ( + `id` bigint(20) NOT NULL COMMENT '主键', + `userType` int(1) NULL DEFAULT NULL COMMENT '用户类型（1=用户，2=司机）', + `userId` int(11) NULL DEFAULT NULL COMMENT '用户id', + `lastDate` date NULL DEFAULT NULL COMMENT '最后浏览日期', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户浏览弹框广告记录' ROW_FORMAT = Compact; + +-- ---------------------------- +-- Records of t_commercial_user_eject +-- ---------------------------- + +-- ---------------------------- -- Table structure for t_complaint -- ---------------------------- DROP TABLE IF EXISTS `t_complaint`; @@ -474,6 +516,7 @@ `inviterId` int(11) NULL DEFAULT NULL COMMENT '邀约人id', `agentId` int(11) NULL DEFAULT NULL COMMENT '代理商id', `branchOfficeId` int(11) NULL DEFAULT NULL COMMENT '分公司id', + `balance` decimal(10, 2) NULL DEFAULT NULL COMMENT '账户余额', `approvalStatus` int(1) NULL DEFAULT NULL COMMENT '审核状态（1=待审核，2=已同意，3=已拒绝）', `approvalNotes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '审核注释', `approvalUserId` int(11) NULL DEFAULT NULL COMMENT '审核用户id', @@ -486,7 +529,24 @@ -- ---------------------------- -- Records of t_driver -- ---------------------------- -INSERT INTO `t_driver` VALUES (1, '6450492139306606', NULL, '11', '15828353127', NULL, NULL, NULL, 'kk', '18382330577', NULL, '11', NULL, '11', '11', 1, 11, 1, 1, 1, '', NULL, NULL, 1, '2023-02-08 23:48:29'); +INSERT INTO `t_driver` VALUES (1, '6450492139306606', NULL, '11', '15828353127', NULL, NULL, NULL, 'kk', '18382330577', NULL, '11', NULL, '11', '11', 1, 11, 1, 1, NULL, 1, '', NULL, NULL, 1, '2023-02-08 23:48:29'); + +-- ---------------------------- +-- Table structure for t_driver_work +-- ---------------------------- +DROP TABLE IF EXISTS `t_driver_work`; +CREATE TABLE `t_driver_work` ( + `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', + `driverId` int(11) NULL DEFAULT NULL COMMENT '司机id', + `workTime` datetime(0) NULL DEFAULT NULL COMMENT '上班时间', + `offWorkTime` datetime(0) NULL DEFAULT NULL COMMENT '下班时间', + `onlineTime` bigint(20) NULL DEFAULT NULL COMMENT '在线时长（秒）', + PRIMARY KEY (`id`) USING BTREE +) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '司机上下班记录' ROW_FORMAT = Compact; + +-- ---------------------------- +-- Records of t_driver_work +-- ---------------------------- -- ---------------------------- -- Table structure for t_evaluate -- Gitblit v1.7.1