-- MySQL dump 10.14 Distrib 5.5.60-MariaDB, for Linux (x86_64) -- -- Host: rm-bp1916f5yvb569opv.mysql.rds.aliyuncs.com Database: qicheoa -- ------------------------------------------------------ -- Server version 5.6.16-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `accident_manager` -- DROP TABLE IF EXISTS `accident_manager`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `accident_manager` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `DRIVER_ID` int(11) NOT NULL COMMENT '司机ID', `VEHICLE_ID` int(11) NOT NULL COMMENT '车辆ID', `ACCIDENT_DATE` date NOT NULL COMMENT '事故日期', `ALL_REPARATION` double NOT NULL COMMENT '赔偿总额', `INSURANCE_REPARATION` double NOT NULL COMMENT '保险公司承担', `OTHER_SIDE_REPARATION` double NOT NULL COMMENT '对方承担', `OUR_SIDE_REPARATION` double NOT NULL COMMENT '本方负责权值', `COMPANY_REPARATION` double NOT NULL COMMENT '我方公司承担', `RESPONSIBLE_REPARATION` double NOT NULL COMMENT '责任人承担', `ACCIDENT_LOCATION` varchar(45) NOT NULL COMMENT '事故地点', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `ACCIDENT_NATURE` varchar(50) DEFAULT NULL COMMENT '事故性质', `ACCIDENT_TYPE` varchar(50) DEFAULT NULL COMMENT '事故类型', `CLOSE_CASE_OK` varchar(50) DEFAULT NULL COMMENT '结案确认', `ACCIDENT_FINE` double DEFAULT NULL COMMENT '罚款', `ACCIDENT_PUNISH` varchar(50) DEFAULT NULL COMMENT '处罚', `INSURANCE_COMPANY` varchar(50) DEFAULT NULL COMMENT '保险公司名称', `REMARK` varchar(1024) DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', `COMPANY_ID` int(11) NOT NULL, `CREATE_BY` int(11) NOT NULL, `UPDATE_BY` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `driverId` (`DRIVER_ID`), KEY `vehicleId` (`VEHICLE_ID`), KEY `companyId` (`COMPANY_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=108 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `account_synchronize` -- DROP TABLE IF EXISTS `account_synchronize`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `account_synchronize` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '同步服务ID', `ACCOUNT_TYPE` int(11) NOT NULL COMMENT '同步服务类型', `IS_COMPANY` int(11) DEFAULT NULL, `USER_NAME` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户名', `PASSWORD` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '密码', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '修改人ID', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`ID`), KEY `COMPANY_ID` (`COMPANY_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `admin_info` -- DROP TABLE IF EXISTS `admin_info`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `admin_info` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '权限ID', `ROLE` int(11) NOT NULL COMMENT '角色类型', `REFERRAL` varchar(20) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '邀请码', `WEIGHT` int(11) NOT NULL DEFAULT '0' COMMENT '排序权重', `MODULE_READ` int(11) NOT NULL DEFAULT '0' COMMENT '读权限', `MODULE_NEW` int(11) NOT NULL DEFAULT '0' COMMENT '新建权限', `MODULE_UPDATE` int(11) NOT NULL DEFAULT '0' COMMENT '更新权限', `MODULE_DELETE` int(11) NOT NULL DEFAULT '0' COMMENT '删除权限', `MODULE_OTHER` int(11) NOT NULL DEFAULT '0' COMMENT '其他权限', `CREATE_BY` int(11) DEFAULT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) DEFAULT NULL COMMENT '最后更新人 ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '拓展字段（以json串存储）', PRIMARY KEY (`ID`) ) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `approval` -- DROP TABLE IF EXISTS `approval`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `approval` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '审批ID', `TYPE` int(11) NOT NULL DEFAULT '1' COMMENT '审批类型', `TYPE_ID` int(11) NOT NULL COMMENT '类型ID', `APPLICANT_ID` int(11) NOT NULL COMMENT '申请人ID', `MANAGER_ID` int(11) NOT NULL COMMENT '审批人ID', `NEXT` int(11) NOT NULL COMMENT '下一个审批ID', `APPROVAL_STATUS` int(11) NOT NULL COMMENT '审批状态', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `approval_type` (`TYPE_ID`,`TYPE`,`IS_DELETED`), KEY `app_manager` (`MANAGER_ID`,`TYPE`), KEY `approval_applicant` (`COMPANY_ID`,`APPLICANT_ID`,`TYPE`,`GMT_CREATED`) ) ENGINE=InnoDB AUTO_INCREMENT=297423 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `archives_column` -- DROP TABLE IF EXISTS `archives_column`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `archives_column` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '档案字段ID', `COLUMN_NAME` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '档案字段名字', `TABLE_ID` int(11) DEFAULT NULL COMMENT '档案表ID', `ENTITY_TYPE` int(11) DEFAULT NULL COMMENT '车辆为1，司机为2', `COMPANY_ID` int(11) DEFAULT NULL COMMENT '所属公司ID', `VALUE_SIZE` int(11) DEFAULT NULL COMMENT '字段为字符时所能允许的最大数', `COLUMN_STYLE` int(11) DEFAULT NULL COMMENT '字段类型', `IS_REQUIRED` int(11) NOT NULL DEFAULT '2' COMMENT '是否必填:1必填；2选填', `QUERYABLE` int(11) NOT NULL DEFAULT '2' COMMENT '是否查询:1查询；2不查询', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '修改人ID', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`ID`), KEY `COMPANY_ID` (`COMPANY_ID`), KEY `TABLE_ID` (`TABLE_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `archives_column_value` -- DROP TABLE IF EXISTS `archives_column_value`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `archives_column_value` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '档案字段值ID', `COLUMN_ID` int(11) NOT NULL COMMENT '档案表字段ID', `ENTITY_ID` int(11) DEFAULT NULL COMMENT '实体ID，关联司机、车辆', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `ROW_ID` int(11) NOT NULL COMMENT '自增得到，同属一条记录的VALUE,该ID一致', `COLUMN_VALUE` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '字段值', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '修改人ID', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`ID`), KEY `COMPANY_ID` (`COMPANY_ID`), KEY `ENTITY_ID` (`ENTITY_ID`), KEY `COLUMN_ID` (`COLUMN_ID`), KEY `ROW_ID` (`ROW_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=223 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `archives_table` -- DROP TABLE IF EXISTS `archives_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `archives_table` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '档案ID', `COMPANY_ID` int(11) DEFAULT NULL COMMENT '所属公司ID', `TABLE_NAME` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '档案表名', `QUERY_STYLE` int(11) DEFAULT NULL COMMENT '档案表查询方式：按关键字、按日期', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '修改人ID', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `IS_DELETED` int(11) DEFAULT '1', PRIMARY KEY (`ID`), KEY `COMPANY_ID` (`COMPANY_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `axb` -- DROP TABLE IF EXISTS `axb`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `axb` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'AXB ID', `PHONE_A` varchar(20) NOT NULL DEFAULT '' COMMENT '手机号码A', `PHONE_X` varchar(20) NOT NULL DEFAULT '' COMMENT '虚拟号', `PHONE_B` varchar(20) NOT NULL DEFAULT '' COMMENT '手机号码B', `SUBS_ID` varchar(50) NOT NULL DEFAULT '' COMMENT '绑定关系ID', `TYPE` int(11) DEFAULT NULL COMMENT '类型，1：排班；2：商品', `TYPE_ID` int(11) DEFAULT NULL COMMENT '类型ID', `EXPIRATION` datetime NOT NULL COMMENT '有效期', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) NOT NULL DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(1000) NOT NULL DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `list` (`COMPANY_ID`), KEY `find` (`PHONE_A`,`PHONE_B`,`EXPIRATION`), KEY `subs` (`SUBS_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=17455 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `billing` -- DROP TABLE IF EXISTS `billing`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `billing` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '账单ID', `DATE` date NOT NULL COMMENT '记账日期', `BILLING_TYPE` int(11) NOT NULL DEFAULT '0' COMMENT '类型，充值/消费', `AMOUNT` int(11) NOT NULL DEFAULT '0' COMMENT '金额', `SMS_NO` int(11) NOT NULL DEFAULT '0' COMMENT '短信量', `BALANCE` int(11) DEFAULT NULL COMMENT '账户余额', `SMS_BALANCE` int(11) DEFAULT NULL COMMENT '短信余额', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `EXTEND` varchar(10000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `billing_date` (`DATE`,`COMPANY_ID`,`BILLING_TYPE`), KEY `billing_company` (`COMPANY_ID`,`DATE`) ) ENGINE=InnoDB AUTO_INCREMENT=166291 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `billing_info` -- DROP TABLE IF EXISTS `billing_info`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `billing_info` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '排班账单明细ID', `DATE` date NOT NULL COMMENT '记账日期', `NOTICE_DRIVER` int(11) NOT NULL DEFAULT '0' COMMENT '通知司机次数', `AUDIO_NOTICE` int(11) NOT NULL DEFAULT '0' COMMENT '语音通知次数', `NOTICE_CUSTOMER` int(11) NOT NULL DEFAULT '0' COMMENT '通知客户次数', `ARRIVE_START` int(11) NOT NULL DEFAULT '0' COMMENT '到达起点次数', `DELETED` int(11) NOT NULL DEFAULT '0' COMMENT '删除排班次数', `FINISHED` int(11) NOT NULL DEFAULT '0' COMMENT '完成排班次数', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `EXTEND` varchar(10000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `billing_date` (`DATE`,`COMPANY_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=106200 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `billing_sms` -- DROP TABLE IF EXISTS `billing_sms`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `billing_sms` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '短信账单明细ID', `DATE` date NOT NULL COMMENT '记账日期', `SEND_SMS` int(11) NOT NULL DEFAULT '0' COMMENT '发送短信条数', `SMS_SUCCESS` int(11) NOT NULL DEFAULT '0' COMMENT '成功短信条数', `SMS_FAILED` int(11) NOT NULL DEFAULT '0' COMMENT '失败短信条数', `SEND_TTL` int(11) NOT NULL DEFAULT '0' COMMENT '发送语音分钟数', `TTL_SUCCESS` int(11) NOT NULL DEFAULT '0' COMMENT '成功语音分钟数', `TTL_FAILED` int(11) NOT NULL DEFAULT '0' COMMENT '失败语音分钟数', `WZ_CHECK` int(11) DEFAULT '0' COMMENT '违章查询次数', `WZ_SUCCESS` int(11) DEFAULT '0' COMMENT '违章成功次数', `WZ_FAILED` int(11) DEFAULT '0' COMMENT '违章失败次数', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `EXTEND` varchar(10000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `billing_date` (`DATE`,`COMPANY_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=206406 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `broad_cast` -- DROP TABLE IF EXISTS `broad_cast`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `broad_cast` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '顶部公告 ID', `TYPE` int(11) NOT NULL DEFAULT '1' COMMENT '1:公司公告 2:成交公告', `HTML_CONTENT` varchar(2048) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '内容', `START_DATE` date NOT NULL COMMENT '起始日期', `END_DATE` date NOT NULL COMMENT '结束日期', `URL` varchar(128) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '链接', `ICON_URL` varchar(128) DEFAULT NULL COMMENT '广告图片地址', `USER_TYPE` int(11) DEFAULT '1' COMMENT '接收用户类型', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '修改人ID', `COMPANY_ID` int(11) DEFAULT '0' COMMENT '公司ID', `REMARK` varchar(1024) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '备注', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '删除标识', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', PRIMARY KEY (`ID`), KEY `date_period` (`START_DATE`,`END_DATE`), KEY `start` (`START_DATE`), KEY `company_id` (`COMPANY_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=1733 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `car_hailing_order` -- DROP TABLE IF EXISTS `car_hailing_order`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `car_hailing_order` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', `ORDER_ID` bigint(20) DEFAULT NULL COMMENT '订单号', `ORDER_TYPE` int(11) NOT NULL COMMENT '网约车订单类型：1（曹操）', `START_SERVICE_TIME` datetime DEFAULT NULL COMMENT '服务开始时间', `BEGIN_CHARGE_TIME` datetime DEFAULT NULL COMMENT '开始计费时间', `DEPARTURE_TIME` datetime DEFAULT NULL COMMENT '用车时间（实时单为当前时间，预约单为预约时间）', `CALLER_PHONE` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '下单人手机号', `CITY_CODE` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '下单城市code', `START_ADDRESS` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '出发地详细地址', `REAL_START_ADDRESS` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '实际上车地详细地址', `START_NAME` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '出发地区域', `END_ADDRESS` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '目的地详细地址', `REAL_END_ADDRESS` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '实际下车地详细地址', `END_NAME` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '目的地区域', `ESTIMATE_PRICE` int(11) DEFAULT NULL COMMENT '预估金额，单位分', `EXTRA_INFO` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '拓展信息，调用下单接口时传入原样记录透传', `FROM_LOCATION_LNG` double DEFAULT NULL COMMENT '出发地经度', `FROM_LOCATION_LAT` double DEFAULT NULL COMMENT '出发地纬度', `REAL_FROM_LOCATION_LNG` double DEFAULT NULL COMMENT '实际出发地经度', `REAL_FROM_LOCATION_LAT` double DEFAULT NULL COMMENT '实际出发地纬度', `ORDER_LOCATION_LNG` double DEFAULT NULL COMMENT '下单地经度', `ORDER_LOCATION_LAT` double DEFAULT NULL COMMENT '下单地纬度', `ORDER_TIME` datetime DEFAULT NULL COMMENT '下单时间', `PASSENGER_NAME` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '乘车人姓名', `PASSENGER_PHONE` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '乘车人手机号', `REQUIRE_LEVEL` int(11) DEFAULT NULL COMMENT '订单车型', `STATUS` int(11) DEFAULT NULL COMMENT '订单状态', `INVOICED` int(11) DEFAULT NULL COMMENT '是否开票', `INVOICE_STATUS` int(11) DEFAULT NULL COMMENT '开票状态', `TO_LOCATION_LNG` double DEFAULT NULL COMMENT '目的地经度', `TO_LOCATION_LAT` double DEFAULT NULL COMMENT '目的地纬度', `REAL_TO_LOCATION_LNG` double DEFAULT NULL COMMENT '实际结束地经度', `REAL_TO_LOCATION_LAT` double DEFAULT NULL COMMENT '实际结束地纬度', `TYPE` int(11) DEFAULT NULL COMMENT '订单类型', `IS_SPECIAL_FIXED_PRICE` int(11) DEFAULT '2' COMMENT '是否尊享一口价 默认是否2', `IS_ROUTE_FIXED_PRICE` int(11) DEFAULT '2' COMMENT '是否路线一口价 默认是否2', `COMPANY_NO` int(11) DEFAULT NULL COMMENT '公司ID(网约车方提供的)', `ORIGIN` int(11) DEFAULT NULL COMMENT '订单来源：1 OPEN-API；2 个人H5；3 企业H5；4 邀约券H5；5 绿色公务APP；6 曹操出行APP；7 企业管理后台；8 客服下单；0 其他；暂时是曹操的几种类型后续扩展', `CP_DRIVER` int(11) DEFAULT '2' COMMENT '是否是加盟司机服务 默认是否2', `ACCEPT_CP_DRIVER` int(11) DEFAULT '2' COMMENT '下单时是否允许加盟司机服务 默认是否2', `TOTAL_FEE` int(11) DEFAULT NULL COMMENT '订单金额(折后金额)，单位分', `PERSONAL_PAY_AMOUNT` int(11) DEFAULT NULL COMMENT '个人支付（比如乘客现金支付，现金支付不会扣除企业余额），单位分', `COMPANY_PAY_AMOUNT` int(11) DEFAULT NULL COMMENT '企业支付的总金额（会包含改价后的总额，值=改价前支付金额+改价后补扣和退款的金额），单位分 只有企业支付后才会有值', `AVATAR` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '司机头像地址', `CAR_BRAND` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '车辆品牌（例如：吉利）', `CAR_TYPE` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '车辆型号（例如：S90L）', `CARD` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '车牌号', `COLOR` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '车辆颜色，例如 白色', `LEVEL` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '司机服务评分，最高为5.0', `NAME` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '司机姓名', `ORDER_CNT` int(11) DEFAULT NULL COMMENT '司机接单数', `PHONE` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '司机手机号（开启虚拟号服务时，为司机-叫车人之间的虚拟号）', `PHONE_PASSENGER` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '司机手机号（开启虚拟号服务时，为司机-乘车人之间的虚拟号，非代他人叫车场景，号码同上phone）', `COMPANY_FEE` int(11) DEFAULT NULL COMMENT '公司本金 单位分, failID无', `COMPANY_FEE_CHANGE` int(11) DEFAULT NULL COMMENT '公司本金变动额，发生改价时才有 单位分, failID无。价格改高为正值，价格改低为负值', `DONATE` int(11) DEFAULT NULL COMMENT '赠额 单位分，failID无', `DONATE_CHANGE` int(11) DEFAULT NULL COMMENT '赠额变动额，发生改价时才有 单位分，failID无。价格改高为正值，价格改低为负值', `NORMAL_DISTANCE` double DEFAULT NULL COMMENT '实际的行驶路程，只有当订单完结的时候才会有值，单位千米', `NORMAL_TIME` int(11) DEFAULT NULL COMMENT '实际的行驶时间，只有当订单完结的时候才会有值，单位分', `PERSONAL_PAY_METHOD` int(11) DEFAULT NULL COMMENT '订单个人支付部分使用支付方式：2 支付宝；3 现金；5 微信；8 个人余额；0 无', `SCHEDULING_ID` int(11) DEFAULT NULL COMMENT '订单ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '修改人ID', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `EXTEND` varchar(10000) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `IS_DELETED` int(11) DEFAULT '1', PRIMARY KEY (`ID`), KEY `COMPANY_ID` (`COMPANY_ID`), KEY `SCHEDULING_ID` (`SCHEDULING_ID`), KEY `ORDER_ID` (`ORDER_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `car_hailing_setting` -- DROP TABLE IF EXISTS `car_hailing_setting`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `car_hailing_setting` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `COMPANY_ID` int(11) NOT NULL, `TYPE` int(11) NOT NULL DEFAULT '0' COMMENT '0 无 1 曹操 ', `CREDIT_AMOUNT` int(11) NOT NULL DEFAULT '0' COMMENT '额度', `PAY_TYPE` int(11) NOT NULL DEFAULT '0' COMMENT '0 无 1 月结 2 预充值 ', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', `CREATE_BY` int(11) NOT NULL, `UPDATE_BY` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `companyidx` (`COMPANY_ID`,`TYPE`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='公司网约车设置 公司+网约车公司 做KEY'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `charge_item` -- DROP TABLE IF EXISTS `charge_item`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `charge_item` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '收费项ID', `ITEM_NAME` varchar(45) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '收费项目的名字', `AMOUNT` double DEFAULT NULL, `PARENT_ID` int(11) NOT NULL COMMENT '收费项上级ID', `CREATE_BY` int(11) NOT NULL, `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人 ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后修改时间', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '是否删除', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `EXTEND` varchar(10000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '拓展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `PARENT_ID` (`PARENT_ID`), KEY `item` (`ITEM_NAME`) ) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `charge_settle` -- DROP TABLE IF EXISTS `charge_settle`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `charge_settle` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', `SETTLE_DATE` date DEFAULT NULL COMMENT '日期', `PAY_TYPE` int(11) NOT NULL COMMENT '支付方式', `INVOICE_TYPE` int(11) NOT NULL COMMENT '开票方式', `YEAR` int(11) DEFAULT NULL COMMENT '使用期限', `PRICE` double NOT NULL COMMENT '单价', `QUANTITY` int(11) NOT NULL COMMENT '数量', `TOTAL_PRICE` double NOT NULL COMMENT '总价', `IS_SETTLE` int(11) NOT NULL COMMENT '是否结清', `ITEM_ID` int(11) NOT NULL COMMENT '子级项目的ID', `SALE_ID` int(11) DEFAULT NULL COMMENT '跟进销售', `COMPANY_ID` int(11) DEFAULT NULL COMMENT '客户/公司ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人 ID', `CREATE_BY` int(11) NOT NULL, `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后修改时间', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '是否删除', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `EXTEND` varchar(10000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '拓展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `SALE_ID` (`SALE_ID`), KEY `COMPANY_ID` (`COMPANY_ID`), KEY `ITEM_ID` (`ITEM_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=3694 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `city` -- DROP TABLE IF EXISTS `city`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `city` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '城市ID', `CITY_NAME` varchar(50) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '城市名字', `GROUP_CODE` bigint(20) NOT NULL DEFAULT '0' COMMENT '分组信息', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `city_company` (`COMPANY_ID`), KEY `city_name` (`COMPANY_ID`,`CITY_NAME`), KEY `city_list` (`COMPANY_ID`,`GROUP_CODE`) ) ENGINE=InnoDB AUTO_INCREMENT=271 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `comment` -- DROP TABLE IF EXISTS `comment`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `comment` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '评价ID', `STAR` int(11) NOT NULL COMMENT '星级', `CONTENT` varchar(100) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '内容', `DATE` date NOT NULL COMMENT '日期', `TYPE` int(11) DEFAULT '0' COMMENT '评价的排班类型', `SCHEDULING_ID` int(11) NOT NULL COMMENT '排班ID', `ROOT` int(11) NOT NULL COMMENT '根排班ID', `DRIVER_ID` int(11) DEFAULT NULL COMMENT '司机ID', `VEHICLE_ID` int(11) DEFAULT NULL COMMENT '车辆ID', `CREATE_BY` int(11) DEFAULT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) DEFAULT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `list` (`COMPANY_ID`,`DATE`), KEY `driver` (`DRIVER_ID`,`DATE`), KEY `scheduling` (`SCHEDULING_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=1162378 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `company` -- DROP TABLE IF EXISTS `company`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `company` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '公司ID', `COMPANY_NAME` varchar(50) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '名字', `PUBLIC_NAME` varchar(50) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '公司对外的名字', `DEFAULT_NOTICE` int(11) DEFAULT NULL COMMENT '默认通知模板ID', `UP_NOTICE_COUNT` int(11) NOT NULL DEFAULT '0' COMMENT '修改模板的次数', `IS_OPEN` int(11) DEFAULT '0' COMMENT '是否开放微信注册', `IS_BOOKING` int(11) DEFAULT '0' COMMENT '是否默认允许叫车', `AUTO_GRAB` int(11) DEFAULT '0' COMMENT '是否自动抢单', `AUTO_NOTICE` int(11) DEFAULT '0' COMMENT '是否自动通知客户', `SHOW_FEE` int(11) DEFAULT '1' COMMENT '显示费用类型', `GROUP_CODE` bigint(20) NOT NULL DEFAULT '0' COMMENT '分组信息', `GROUP_NO` int(11) NOT NULL DEFAULT '1' COMMENT '该公司的分组数', `GROUP_VALIDITY` date DEFAULT '9999-09-09' COMMENT '分组的有效期', `BEFORE_AFTER` int(11) NOT NULL DEFAULT '0' COMMENT '预付费/后付费', `COMPANY_TYPE` int(11) NOT NULL DEFAULT '0' COMMENT '公司类型', `VALIDITY` date NOT NULL COMMENT '该公司软件使用截止日期', `STORE` varchar(50) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '注册方式', `SOURCE` varchar(50) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '客户来源', `PRODUCT` varchar(50) CHARACTER SET utf8mb4 DEFAULT '车队管家' COMMENT '产品署名', `NUMBER` int(11) NOT NULL DEFAULT '10' COMMENT '该公司的车辆数', `DRIVER_COUNT` int(11) DEFAULT '0' COMMENT '司机数量', `VEHICLE_COUNT` int(11) DEFAULT '0' COMMENT '车辆数量', `IMEI_COUNT` int(11) DEFAULT '0' COMMENT 'GPS数量', `MODULE` int(11) NOT NULL DEFAULT '0' COMMENT '该公司所用的模块列表', `APPLET` int(11) NOT NULL DEFAULT '0' COMMENT '小程序模块', `WXCODE` varchar(100) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '小程序二维码', `LOGO` varchar(128) NOT NULL DEFAULT '' COMMENT '小程序logo', `HIDE_CUSTOMER` int(11) DEFAULT '2' COMMENT '小程序隐藏客户列表', `CAN_VIEW_SCH_DETAIL` int(11) NOT NULL DEFAULT '1' COMMENT '是否可见订单详情', `NEED_APPROVED_FOR_ARRANGE` int(11) NOT NULL DEFAULT '1' COMMENT '申请用车是否需要走审批流程', `REFERRAL` varchar(50) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '推荐码', `MONEY` int(11) NOT NULL DEFAULT '0' COMMENT '该公司余额', `SMS_BALANCE` int(11) NOT NULL DEFAULT '0' COMMENT '短信余量', `WZ_BALANCE` int(11) NOT NULL DEFAULT '0' COMMENT '剩余违章次数', `USE_WZ` int(11) NOT NULL DEFAULT '0' COMMENT '是否使用违章包', `USE_PLS` int(11) DEFAULT '0' COMMENT '是否使用隐私号码', `USE_GRAB` int(11) DEFAULT '2' COMMENT '是否使用通知抢单', `NEED_BOOK` int(11) NOT NULL DEFAULT '2' COMMENT '是否需要提前预约上车 ', `USE_CAR_HAILING` int(11) NOT NULL DEFAULT '1' COMMENT '是否需要网约车下单，默认用', `USE_CAR_REVOKE` int(11) NOT NULL DEFAULT '2' COMMENT '已派车订单是否允许用车人修改、撤销（默认 否 不允许）', `BOOK_CUT_OFF` double NOT NULL DEFAULT '0' COMMENT '预约截止前几小时，默认0', `BOOK_SCHEDULING_OFF` double NOT NULL DEFAULT '0' COMMENT '用车需提前预约时间(小时)，默认0', `SEND_MESSAGE_SYNCHRONIZATION` int(11) NOT NULL DEFAULT '1' COMMENT '是否「自动」同步发短信通知 （默认 否）', `UREA_PER` double DEFAULT NULL, `IDLE_THRESHOLD` int(11) NOT NULL DEFAULT '0' COMMENT '怠速', `SOLUTION_TYPE` int(11) NOT NULL DEFAULT '0', `SCH_ASSIGN_TYPE` int(11) NOT NULL DEFAULT '0', `SHOW_MSG_IN_APPLET` int(11) NOT NULL DEFAULT '0' COMMENT '用车端是否显示司机备注信息', `NEED_NEXT_STOP_INFO` int(11) NOT NULL DEFAULT '1', `QYWX_CORP_ID` varchar(128) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '企业微信ID', `FZ_APP_KEY` varchar(128) CHARACTER SET utf8mb4 DEFAULT NULL, `FZ_APP_SECRET` varchar(128) CHARACTER SET utf8mb4 DEFAULT NULL, `FZ_SESSION_KEY` varchar(128) CHARACTER SET utf8mb4 DEFAULT NULL, `AUTO_NOTICE_DRIVER` int(11) NOT NULL DEFAULT '2' COMMENT '指派司机之后 是否自动通知司机', `FZ_FORCE_DRIVER_ACCEPT` int(11) NOT NULL DEFAULT '1' COMMENT '发猪指派司机之后 是否强制接单', `ROUTE_THRESHOLD` int(11) NOT NULL DEFAULT '0' COMMENT '路径规划报警阀值（单位：米）', `STOP_THRESHOLD` int(11) NOT NULL DEFAULT '0' COMMENT '班车站点阀值（单位：米）', `NEED_DEFAULT_EXPENSE_TYPE` int(11) DEFAULT '1' COMMENT '是否使用默认费用类型', `DEFAULT_EXPENSE_TYPE_CONFIG` varchar(200) DEFAULT '' COMMENT '默认费用类型配置', `REGULAR_DEADLINE` int(11) NOT NULL DEFAULT '0' COMMENT '班车查询截止时间，如1就表示班车列表显示一小时前发车的班车', `INSPECTION_TYPE` int(11) NOT NULL DEFAULT '0' COMMENT '车辆检查类型', `AXB_CITY` varchar(50) DEFAULT NULL COMMENT 'axb 隐私号码城市', `LAST_LOGIN_TIME` timestamp NULL DEFAULT NULL COMMENT '管理员最后登录时间', `APPROVAL_PROCESS` varchar(200) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '该公司的审批流程', `GPS_DAY` int(11) DEFAULT '365' COMMENT 'GPS存储天数', `STOP_MINUTE` int(11) NOT NULL DEFAULT '5' COMMENT '静止分钟数', `TAX` varchar(50) DEFAULT '' COMMENT '税号', `BANK` varchar(50) DEFAULT '' COMMENT '开户行', `ACCOUNT` varchar(50) DEFAULT '' COMMENT '账号', `ADDRESS` varchar(50) DEFAULT '' COMMENT '地址', `CONTACTS_NAME` varchar(50) DEFAULT '' COMMENT '联系人', `PHONE` varchar(50) DEFAULT '' COMMENT '电话', `DETAIL_ID` int(11) DEFAULT NULL COMMENT '公司详情ID', `ADDRESS_ID` int(11) DEFAULT NULL COMMENT '公司地址ID', `APPID` varchar(50) DEFAULT '' COMMENT '微信ID', `SECRET` varchar(32) DEFAULT '' COMMENT '微信密钥', `ACCESS_TOKEN` varchar(512) DEFAULT '' COMMENT '微信token', `ACCESS_TIME` datetime DEFAULT NULL COMMENT 'token 获取时间', `START_SCHEDULING` varchar(50) DEFAULT '' COMMENT '开始任务的微信模板ID', `NOTICE_CUSTOMER` varchar(50) DEFAULT '' COMMENT '通知客户的微信模板ID', `ARRIVE_START` varchar(50) DEFAULT '' COMMENT '司机到达的微信模板ID', `FINISHED` varchar(50) DEFAULT '' COMMENT '司机完成的微信模板ID', `DELETED` varchar(50) DEFAULT '' COMMENT '取消订单的微信模板ID', `REGULAR` varchar(50) DEFAULT '' COMMENT '校车提醒的微信模板ID', `APPROVED` varchar(50) DEFAULT '' COMMENT '审批通过的微信模板ID', `VETOED` varchar(50) DEFAULT '' COMMENT '审批驳回的微信模板ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `REMARK` varchar(1000) DEFAULT '' COMMENT '备注', `EXTEND` varchar(10000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `company_name` (`COMPANY_NAME`), KEY `company_validity` (`VALIDITY`), KEY `c_source` (`SOURCE`), KEY `c_crm` (`GMT_CREATED`,`IS_DELETED`,`SOURCE`), KEY `c_referral` (`REFERRAL`), KEY `qywx_corp_id` (`QYWX_CORP_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=44214 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `company_address` -- DROP TABLE IF EXISTS `company_address`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `company_address` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '公司地址信息', `COMPANY_ID` int(11) NOT NULL COMMENT '公司ID', `IS_DEFAULT` int(11) DEFAULT '2' COMMENT '是否默认地址', `AREA_CODE` varchar(45) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '地址编码', `PROVINCE` varchar(50) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '省份', `CITY` varchar(50) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '城市', `COUNTY` varchar(50) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '县', `TOWN` varchar(50) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '镇', `ADDRESS_INFO` varchar(200) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '地址', `RECEIVER` varchar(50) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '收件人', `RECEIVER_PHONE` varchar(50) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '收件手机号码', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '删除状态', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `EXTEND` varchar(10000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `COMPANY` (`COMPANY_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=804 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `company_detail` -- DROP TABLE IF EXISTS `company_detail`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `company_detail` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '公司详情ID', `COMPANY_ID` int(11) NOT NULL COMMENT '公司ID', `CAR_COUNT` int(11) DEFAULT '0' COMMENT '车辆数', `CAR_TYPE` int(11) NOT NULL COMMENT '车辆类型', `OTHER_CAR_TYPE` varchar(50) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '其他类型', `FEATURE_TYPE` int(11) NOT NULL COMMENT '类型', `OTHER_FEATURE_TYPE` varchar(50) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '其他类型', `MANAGEMENT_PLAN` int(11) NOT NULL COMMENT '车队管理方案', `MANAGEMENT_PLAN_NAME` varchar(50) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '方案名称', `PROBLEM` varchar(1000) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '问题描述', `HAS_GPS` int(11) DEFAULT NULL COMMENT '是否有GPS', `GPS_NAME` varchar(45) CHARACTER SET utf8mb4 DEFAULT '' COMMENT 'GPS名称', `OTHER_COUNT` int(11) DEFAULT NULL COMMENT '外租\\挂靠车辆数', `IS_FIRST` int(11) NOT NULL DEFAULT '1' COMMENT '是否第一次完善资料，默认为1（登录时完善设为2）', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '更新人ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间', `GMT_MODIFIED` datetime NOT NULL COMMENT '更新时间', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '删除状态', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '备注', `EXTEND` varchar(10000) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `COMPANY` (`COMPANY_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=5302 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `contacts_info` -- DROP TABLE IF EXISTS `contacts_info`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contacts_info` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '联系人ID', `INVOICE` varchar(50) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '发票抬头', `ADDRESS` varchar(100) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '地址', `IS_REGULAR` int(11) NOT NULL DEFAULT '2' COMMENT '是否允许坐班车', `IS_BOOKING` int(11) NOT NULL DEFAULT '2' COMMENT '是否允许订车', `CAN_APPROVE` int(11) NOT NULL DEFAULT '2' COMMENT '是否有审批权限', `NEED_APPROVE` int(11) NOT NULL DEFAULT '1', `CUSTOMER_ID` int(11) DEFAULT NULL COMMENT '所属客户ID', `LNG` float DEFAULT NULL COMMENT '经度', `LAT` float DEFAULT NULL COMMENT '纬度', `USER_ID` int(11) DEFAULT NULL COMMENT '乘客ID', `CREATE_BY` int(11) DEFAULT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) DEFAULT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) DEFAULT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `ci_customer` (`CUSTOMER_ID`,`IS_DELETED`), KEY `ci_user` (`USER_ID`,`IS_DELETED`,`COMPANY_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=478708 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `contract` -- DROP TABLE IF EXISTS `contract`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contract` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `DATE` date NOT NULL COMMENT '合同日期', `AMOUNT` double NOT NULL COMMENT '合同金额', `FILE` varchar(1024) NOT NULL COMMENT '合同扫描件', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', `COMPANY_ID` int(11) NOT NULL, `CREATE_BY` int(11) NOT NULL, `UPDATE_BY` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `companyId` (`COMPANY_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `country` -- DROP TABLE IF EXISTS `country`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `country` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '国家ID', `NAME` varchar(30) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '中文名字', `ENGLISH` varchar(30) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '英文名字', `CODE` varchar(30) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '国家代号', `NUMBER` varchar(30) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '数字代号', `PRICE` double NOT NULL COMMENT '成本价', `COUNT` int(11) NOT NULL COMMENT '计费', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', PRIMARY KEY (`ID`), KEY `c_code` (`CODE`), KEY `c_number` (`NUMBER`) ) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `crm` -- DROP TABLE IF EXISTS `crm`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `crm` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '记录ID', `LEVEL` int(11) DEFAULT NULL COMMENT '用户等级', `ADDRESS` varchar(100) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '公司地址', `CUSTOMER_TYPE` varchar(32) CHARACTER SET utf8mb4 DEFAULT NULL, `TYPE` varchar(20) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '公司类型', `TYPE2` varchar(32) CHARACTER SET utf8mb4 DEFAULT NULL, `SALE_ID` int(11) DEFAULT NULL COMMENT '销售ID', `IS_PICK` int(11) DEFAULT '2' COMMENT '1挑入，2正常', `NEXT_TIME` date DEFAULT NULL COMMENT '下次预约日期', `LAST_TIME` date DEFAULT NULL COMMENT '上次跟进日期', `WEIXIN_NUMBER` varchar(200) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '微信号', `FOLLOW_EFFECTIVE` int(11) DEFAULT NULL COMMENT '是否是有效跟进', `CREATE_BY` int(11) NOT NULL COMMENT '注册人ID', `UPDATE_BY` int(11) DEFAULT NULL COMMENT '最后更新人 ID', `COMPANY_ID` int(11) NOT NULL COMMENT '公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后修改时间', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL DEFAULT '1', `EXTEND` varchar(10000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '拓展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `crm_company` (`COMPANY_ID`), KEY `list` (`COMPANY_ID`,`SALE_ID`,`UPDATE_BY`), KEY `created` (`GMT_CREATED`,`WEIXIN_NUMBER`(191)), KEY `sale` (`SALE_ID`), KEY `updateby` (`UPDATE_BY`), KEY `customerType` (`CUSTOMER_TYPE`) ) ENGINE=InnoDB AUTO_INCREMENT=40459 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `crm_info` -- DROP TABLE IF EXISTS `crm_info`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `crm_info` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'CRM_INFO_ID', `LEVEL` int(11) DEFAULT NULL COMMENT '用户等级', `SALE_ID` int(11) DEFAULT NULL COMMENT '销售ID', `IS_PICK` int(11) DEFAULT '2' COMMENT '1挑入产生，2正常产生', `BUILD_COMPANY_NAME` varchar(45) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '运营录入的公司名字', `BUILD_USER_PHONE` varchar(45) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '运营录入的管理员手机号码名字', `WEIXIN_NUMBER` varchar(200) CHARACTER SET utf8mb4 DEFAULT NULL, `FOLLOW_EFFECTIVE` int(11) DEFAULT NULL COMMENT '是否是有效跟进', `NEXT_TIME` date DEFAULT NULL COMMENT '下次预约日期', `LAST_TIME` date DEFAULT NULL COMMENT '上次跟进日期', `CREATE_BY` int(11) NOT NULL COMMENT '注册人ID', `UPDATE_BY` int(11) DEFAULT NULL COMMENT '最后更新人 ID', `COMPANY_ID` int(11) DEFAULT NULL COMMENT '公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后修改时间', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL DEFAULT '1', `EXTEND` varchar(10000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '拓展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `list` (`COMPANY_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=113926 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `customer` -- DROP TABLE IF EXISTS `customer`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `customer` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '客户ID', `CUSTOMER_NAME` varchar(100) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '客户名字', `CUSTOMER_TYPE` int(11) DEFAULT '3' COMMENT '单位类型', `INVOICE` varchar(50) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '发票抬头', `ADDRESS` varchar(100) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '地址', `PARENT_ID` int(11) DEFAULT NULL COMMENT '上级单位ID', `SETTLE_ID` int(11) DEFAULT NULL COMMENT '结算单位ID', `QYWX_DEPARTMENT_ID` int(11) NOT NULL DEFAULT '0' COMMENT '企业微信部门ID（唯一标识）', `QYWX_PARENT_ID` int(11) NOT NULL DEFAULT '0' COMMENT '企业微信parentId', `GROUP_CODE` bigint(20) NOT NULL DEFAULT '0' COMMENT '分组信息', `CREATE_BY` int(11) DEFAULT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) DEFAULT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `customer_name` (`COMPANY_ID`,`CUSTOMER_NAME`), KEY `qywx_department_id` (`QYWX_DEPARTMENT_ID`), KEY `qywx_parent_id` (`QYWX_PARENT_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=113796 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `customize` -- DROP TABLE IF EXISTS `customize`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `customize` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '自定义ID', `USE_TYPE` int(11) NOT NULL DEFAULT '1' COMMENT '是否客运 1客运 2货运', `MAX_PIC_COUNT` int(11) NOT NULL DEFAULT '0' COMMENT '图片最大上传限制', `NAME` varchar(50) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '字段名字', `WEIGHT` int(11) NOT NULL DEFAULT '0' COMMENT '排序权重', `TYPE` int(11) NOT NULL COMMENT '字段类型', `IS_MERGE` int(11) NOT NULL DEFAULT '2' COMMENT '是否支持合并签收，仅用于货运排班', `LIST_VALUE` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '列表值', `IS_REQUIRED` int(11) DEFAULT '0' COMMENT '是否必填', `SHOW_DRIVER` int(11) NOT NULL COMMENT '司机是否可见', `DRIVER_EDIT` int(11) NOT NULL COMMENT '司机是否可改', `SHOW_CONTACTS` int(11) NOT NULL COMMENT '联系人是否可见', `CONTACTS_EDIT` int(11) NOT NULL COMMENT '联系人是否可改', `DRIVER_POS` varchar(128) DEFAULT NULL, `CONTACTS_POS` varchar(128) DEFAULT NULL, `MANAGER_POS` varchar(128) DEFAULT NULL, `EXPENSE_TYPE_ID` int(11) DEFAULT NULL, `ORDER_TYPE_ID` int(11) NOT NULL DEFAULT '0', `GROUP_CODE` bigint(20) NOT NULL DEFAULT '2251799813685247', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `customize_list` (`COMPANY_ID`,`IS_DELETED`,`NAME`), KEY `expense_type_id` (`EXPENSE_TYPE_ID`), KEY `orderTypeId` (`ORDER_TYPE_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=46197 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `driver_info` -- DROP TABLE IF EXISTS `driver_info`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `driver_info` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '司机ID', `ID_NO` varchar(30) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '身份证号码', `LICENSE_NO` varchar(30) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '驾照号码', `HOME_ADDRESS` varchar(100) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '家庭地址', `DATE_OF_JOIN` date DEFAULT NULL COMMENT '入职日期', `VEHICLE_ID` int(11) DEFAULT NULL COMMENT '默认车辆的ID', `EMERGENCY_CONTACT` varchar(50) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '紧急联系人', `EMERGENCY_PHONE` varchar(20) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '紧急联系电话', `WEIGHT` int(11) DEFAULT '0' COMMENT '司机排序权重', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人 ID', `COMPANY_ID` int(11) DEFAULT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) DEFAULT '' COMMENT '拓展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `di_vehicle` (`VEHICLE_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=103377 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `etc_card` -- DROP TABLE IF EXISTS `etc_card`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `etc_card` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `ETC_TYPE` int(11) NOT NULL DEFAULT '0' COMMENT '卡类型：江苏、浙江、广西之类的', `USER_NAME` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户名', `PASSWORD` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '密码', `CARD_NUMBER` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '卡号码', `GROUP_CODE` bigint(20) NOT NULL DEFAULT '0' COMMENT '分组信息', `COMPANY_ID` int(11) NOT NULL, `VEHICLE_ID` int(11) NOT NULL, `IS_COMPANY` int(11) NOT NULL DEFAULT '0' COMMENT '1 是公司注册的卡 0 是个人的卡 ', `CREATE_BY` int(11) NOT NULL, `UPDATE_BY` int(11) NOT NULL, `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `EXTEND` varchar(10000) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '扩展字段（以json串存储）', `IS_DELETED` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`ID`), KEY `COMPANY` (`COMPANY_ID`), KEY `number` (`CARD_NUMBER`,`ETC_TYPE`,`COMPANY_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=3933 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `etc_card_detail` -- DROP TABLE IF EXISTS `etc_card_detail`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `etc_card_detail` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `COMPANY_ID` int(11) NOT NULL, `ETC_CARD_ID` int(11) NOT NULL, `EXPENSE_ID` int(11) DEFAULT NULL COMMENT '费用ID', `TYPE` int(11) NOT NULL DEFAULT '0' COMMENT '1 消费 2充值 4票根已开发票 8票根未开发票', `AMOUNT` double NOT NULL COMMENT '金额', `ENTRANCE_NAME` varchar(128) NOT NULL COMMENT '入口', `EXIT_NAME` varchar(128) NOT NULL COMMENT '出口', `ENTRANCE_TIME` datetime NOT NULL COMMENT '入口时间', `EXIT_TIME` datetime NOT NULL COMMENT '出口时间', `MONTH` varchar(12) DEFAULT NULL COMMENT '开发票所在的月份', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', `CREATE_BY` int(11) NOT NULL, `UPDATE_BY` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `etccardid` (`COMPANY_ID`,`ETC_CARD_ID`), KEY `expenseId` (`EXPENSE_ID`), KEY `card` (`ETC_CARD_ID`,`AMOUNT`), KEY `month` (`MONTH`,`ETC_CARD_ID`,`TYPE`) ) ENGINE=InnoDB AUTO_INCREMENT=1046331 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `etc_invoice_record` -- DROP TABLE IF EXISTS `etc_invoice_record`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `etc_invoice_record` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ETC开票记录ID', `ETC_CARD_ID` int(11) NOT NULL COMMENT 'ETC卡ID', `INVOICE_TIME` datetime NOT NULL COMMENT '开票申请时间', `INVOICE_AMOUNT` double NOT NULL COMMENT '开票金额', `INVOICE_HEADER` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '发票抬头', `INVOICE_COUNT` int(11) NOT NULL COMMENT '发票数量', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '修改人ID', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`ID`), KEY `COMPANY_ID` (`COMPANY_ID`), KEY `ETC_CARD_ID` (`ETC_CARD_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=2838 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `expense_type` -- DROP TABLE IF EXISTS `expense_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `expense_type` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '费用类型ID', `TYPE_NAME` varchar(50) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '类型名字', `IN_OUT` int(11) NOT NULL COMMENT '收入/支出类型', `CREATE_BY` int(11) DEFAULT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) DEFAULT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) DEFAULT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `et_name` (`COMPANY_ID`,`TYPE_NAME`) ) ENGINE=InnoDB AUTO_INCREMENT=2316 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `expenses` -- DROP TABLE IF EXISTS `expenses`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `expenses` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '费用ID', `TYPE_ID` int(11) NOT NULL COMMENT '费用类型ID', `TYPE_NAME` varchar(50) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '费用类型名称', `IN_OUT` int(11) NOT NULL COMMENT '收入/支出类型', `PAY_TO` int(11) NOT NULL DEFAULT '0' COMMENT '收付款人', `VEHICLE_ID` int(11) DEFAULT NULL COMMENT '车辆ID', `DRIVER_ID` int(11) DEFAULT NULL COMMENT '司机ID', `CONTACTS_ID` int(11) DEFAULT NULL COMMENT '联系人ID', `SETTLE_ID` int(11) DEFAULT NULL COMMENT '结算单位ID', `SCHEDULING_ID` int(11) DEFAULT NULL COMMENT '排班ID', `GOODS_ID` int(11) DEFAULT NULL COMMENT '商品ID', `OIL_CARD_ID` int(11) DEFAULT NULL, `OIL_CARD_DETAIL_ID` int(11) DEFAULT NULL, `TRAVEL` int(11) DEFAULT NULL COMMENT '当前总行驶里程', `FUEL_AMOUNT` double DEFAULT '0' COMMENT '燃料添加量，如油量、电量、气量等', `AMOUNT` double NOT NULL COMMENT '总金额', `CONTENT` varchar(200) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '费用内容', `INVOICE_NUMBER` bigint(20) DEFAULT NULL COMMENT '发票号', `DATE` date NOT NULL COMMENT '费用支出日期', `PIC1` varchar(200) NOT NULL DEFAULT '' COMMENT '图片一', `PIC2` varchar(200) NOT NULL DEFAULT '' COMMENT '图片二', `PIC3` varchar(200) NOT NULL DEFAULT '' COMMENT '图片三', `PIC4` varchar(200) NOT NULL DEFAULT '' COMMENT '图片四', `PIC5` varchar(200) NOT NULL DEFAULT '' COMMENT '图片五', `IS_SETTLED` int(11) NOT NULL DEFAULT '0' COMMENT '是否已结算', `SETTLEMENT_DATE` date DEFAULT NULL COMMENT '结算日期', `GROUP_CODE` bigint(20) NOT NULL DEFAULT '0' COMMENT '分组信息', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `SOURCE` varchar(45) DEFAULT NULL COMMENT '费用来源', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `expenses_scheduling` (`SCHEDULING_ID`), KEY `expenses_create` (`CREATE_BY`), KEY `expenses_join` (`VEHICLE_ID`,`DRIVER_ID`,`CONTACTS_ID`,`SETTLE_ID`), KEY `expenses_company` (`COMPANY_ID`,`DATE`), KEY `e_date` (`DATE`), KEY `e_count` (`COMPANY_ID`,`GMT_CREATED`), KEY `oil_card_id` (`OIL_CARD_ID`), KEY `oil_card_detail_id` (`OIL_CARD_DETAIL_ID`), KEY `goods_id` (`GOODS_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=4518367 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `export_column` -- DROP TABLE IF EXISTS `export_column`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `export_column` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '字段ID', `COLUMN_NAME` varchar(50) NOT NULL DEFAULT '' COMMENT '字段中文名', `COLUMN_VALUE` varchar(50) DEFAULT '' COMMENT '字段属性名', `COLUMN_TYPE` int(11) NOT NULL COMMENT '字段类型', `TABLE_NAME` varchar(50) NOT NULL DEFAULT '' COMMENT '字段表名', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(1000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `COLUMN_NAME` (`COLUMN_NAME`), KEY `TABLE_NAME` (`TABLE_NAME`) ) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `export_rule` -- DROP TABLE IF EXISTS `export_rule`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `export_rule` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '导出规则ID', `COLUMN_ID` int(11) NOT NULL COMMENT '字段表ID', `WEIGHT` int(11) NOT NULL COMMENT '排序权重', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(1000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `COMPANY_ID` (`COMPANY_ID`), KEY `COLUMN_ID` (`COLUMN_ID`), KEY `UPDATE_BY` (`UPDATE_BY`) ) ENGINE=InnoDB AUTO_INCREMENT=10429 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `favorite_menu` -- DROP TABLE IF EXISTS `favorite_menu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `favorite_menu` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', `MENU_ID` int(11) NOT NULL COMMENT '子菜单表ID', `WEIGHT` int(11) NOT NULL COMMENT '排序权重', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `COMPANY_ID` (`COMPANY_ID`), KEY `MENU_ID` (`MENU_ID`), KEY `CREATE_BY` (`CREATE_BY`) ) ENGINE=InnoDB AUTO_INCREMENT=7961 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `favorite_regular` -- DROP TABLE IF EXISTS `favorite_regular`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `favorite_regular` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `USER_ID` int(11) NOT NULL COMMENT '用车人ID', `REGULAR_ID` int(11) NOT NULL COMMENT '班车ID', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', `COMPANY_ID` int(11) NOT NULL, `CREATE_BY` int(11) NOT NULL, `UPDATE_BY` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `userId` (`USER_ID`), KEY `companyId` (`COMPANY_ID`), KEY `regularId` (`REGULAR_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=1192 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `feedback` -- DROP TABLE IF EXISTS `feedback`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `feedback` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '反馈ID', `TYPE` int(11) NOT NULL COMMENT '反馈类型', `CONTENT` varchar(1000) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '反馈内容', `PIC1` varchar(200) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '图片一', `PIC2` varchar(200) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '图片二', `PIC3` varchar(200) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '图片三', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) NOT NULL DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `deleted` (`IS_DELETED`) ) ENGINE=InnoDB AUTO_INCREMENT=164 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `fence` -- DROP TABLE IF EXISTS `fence`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fence` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '围栏ID', `FENCE_NAME` varchar(50) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '围栏名字', `LNG` double NOT NULL COMMENT '中心经度', `LAT` double NOT NULL COMMENT '中心纬度', `ADDRESS` varchar(200) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '中心地址', `RADIUS` int(11) NOT NULL COMMENT '半径', `ALARM` int(11) NOT NULL COMMENT '报警开关', `ENTER_BEGIN_TIME` time DEFAULT NULL COMMENT '进围栏提醒开始时间', `ENTER_END_TIME` time DEFAULT NULL COMMENT '进围栏提醒结束时间', `OUT_BEGIN_TIME` time DEFAULT NULL COMMENT '出围栏提醒开始时间', `OUT_END_TIME` time DEFAULT NULL COMMENT '出围栏提醒结束时间', `GROUP_CODE` bigint(20) NOT NULL DEFAULT '0' COMMENT '分组信息', `FENCE_TYPE` int(11) NOT NULL DEFAULT '1' COMMENT '1 圆形 2 多边形', `LIMIT_SPEED` int(11) DEFAULT NULL COMMENT '限制速度', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `fence_company` (`COMPANY_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=1848 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `fence_vehicle` -- DROP TABLE IF EXISTS `fence_vehicle`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fence_vehicle` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '围栏车辆ID', `FENCE_ID` int(11) NOT NULL COMMENT '围栏ID', `VEHICLE_ID` int(11) NOT NULL COMMENT '车辆ID', `STATUS` int(11) NOT NULL COMMENT '车辆状态', `TIME` datetime DEFAULT NULL COMMENT '报警时间', `GROUP_CODE` bigint(20) NOT NULL DEFAULT '0' COMMENT '分组信息', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `fv_fence` (`FENCE_ID`), KEY `fv_vehicle` (`VEHICLE_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=18697 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `file_info` -- DROP TABLE IF EXISTS `file_info`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `file_info` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '文件ID', `OSS_URL` varchar(256) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '文件地址', `RELATED_TABLE` varchar(45) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '关联table', `FILE_NAME` varchar(45) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '文件名', `RELATED_ID` int(11) NOT NULL COMMENT '关联ID', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '删除状态', PRIMARY KEY (`ID`), KEY `RelatedIndex` (`RELATED_TABLE`,`RELATED_ID`,`OSS_URL`(191)) ) ENGINE=InnoDB AUTO_INCREMENT=1748 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='相关图片表格 存放OSS的URL'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `file_library` -- DROP TABLE IF EXISTS `file_library`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `file_library` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `FILE_NAME` varchar(45) COLLATE utf8_bin NOT NULL, `FILE` varchar(1024) COLLATE utf8_bin NOT NULL COMMENT '合同扫描件', `WEIGHT` int(11) NOT NULL DEFAULT '0' COMMENT '文件排序权重', `TYPE_ID` int(11) DEFAULT NULL COMMENT '文件类型ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1024) COLLATE utf8_bin DEFAULT NULL COMMENT '备注', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '是否删除', `CREATE_BY` int(11) NOT NULL COMMENT '创建人', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人', PRIMARY KEY (`ID`), KEY `FILE_NAME` (`FILE_NAME`), KEY `TYPE_ID` (`TYPE_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=230 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `file_type` -- DROP TABLE IF EXISTS `file_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `file_type` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '文件类型ID', `TYPE_NAME` varchar(50) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '类型名字', `CREATE_BY` int(11) DEFAULT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) DEFAULT NULL COMMENT '最后更新人ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', PRIMARY KEY (`ID`), KEY `TYPE_NAME` (`TYPE_NAME`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `generic_bill` -- DROP TABLE IF EXISTS `generic_bill`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `generic_bill` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `COMPANY_ID` int(11) NOT NULL, `NUM` int(11) NOT NULL, `BALANCE` int(11) NOT NULL, `BILLING_TYPE` int(11) NOT NULL, `TYPE` int(11) NOT NULL COMMENT '记录类型 1：违章 2：积分 4：其他', `REMARK` varchar(1024) DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', `CREATE_BY` int(11) NOT NULL, `UPDATE_BY` int(11) NOT NULL, `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, PRIMARY KEY (`ID`), KEY `company_type_idx` (`COMPANY_ID`,`TYPE`,`BILLING_TYPE`) ) ENGINE=InnoDB AUTO_INCREMENT=29345 DEFAULT CHARSET=utf8mb4 COMMENT='各种包交易记录，如违章包、积分短'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `goods` -- DROP TABLE IF EXISTS `goods`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `goods` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '商品ID', `ORDER_TYPE_ID` int(11) DEFAULT NULL COMMENT '订单类型ID', `GOODS_NAME` varchar(50) NOT NULL DEFAULT '' COMMENT '商品名字', `GOODS_CODE` varchar(50) NOT NULL DEFAULT '' COMMENT '商品序列号', `QUANTITY` int(11) NOT NULL DEFAULT '1' COMMENT '商品件数', `PRICE` double DEFAULT NULL COMMENT '单价', `WEIGHT` double DEFAULT NULL COMMENT '重量', `START_NAME` varchar(200) NOT NULL DEFAULT '' COMMENT '起点', `START_LNG` double DEFAULT NULL COMMENT '起点经度', `START_LAT` double DEFAULT NULL COMMENT '起点纬度', `END_NAME` varchar(200) NOT NULL DEFAULT '' COMMENT '终点', `END_LNG` double DEFAULT NULL COMMENT '终点经度', `END_LAT` double DEFAULT NULL COMMENT '终点纬度', `DATE` date NOT NULL COMMENT '日期', `JOB_FEE` double DEFAULT NULL COMMENT '客户费用', `DRIVER_FEE` double DEFAULT NULL COMMENT '司机费用', `GOODS_STATUS` int(11) NOT NULL COMMENT '商品状态', `PHONE_X` varchar(50) NOT NULL DEFAULT '' COMMENT '隐私号码', `CONTACTS_TASK_ID` int(11) DEFAULT NULL COMMENT '客户订单ID', `MANAGER_TASK_ID` int(11) DEFAULT NULL COMMENT '管理员订单ID', `DRIVER_TASK_ID` int(11) DEFAULT NULL COMMENT '司机订单ID', `RECEIPT_TASK_ID` int(11) DEFAULT NULL COMMENT '签收单ID', `GROUP_CODE` bigint(20) NOT NULL DEFAULT '0' COMMENT '分组信息', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `goods_code` (`COMPANY_ID`,`GOODS_CODE`), KEY `m_task` (`MANAGER_TASK_ID`), KEY `c_task` (`CONTACTS_TASK_ID`), KEY `d_task` (`DRIVER_TASK_ID`), KEY `g_list` (`COMPANY_ID`,`DATE`) ) ENGINE=InnoDB AUTO_INCREMENT=1086 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `goods_task` -- DROP TABLE IF EXISTS `goods_task`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `goods_task` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '批量订单ID', `TASK_NUMBER` bigint(20) NOT NULL COMMENT '订单号码', `START_DATE` date NOT NULL COMMENT '起始日期', `START_TIME` time DEFAULT NULL COMMENT '起始时间', `END_DATE` date NOT NULL COMMENT '结束日期', `END_TIME` time DEFAULT NULL COMMENT '结束时间', `TASK_TYPE` int(11) NOT NULL COMMENT '订单类型', `TASK_STATUS` int(11) NOT NULL COMMENT '订单状态', `NOTICE_ID` int(11) DEFAULT NULL COMMENT '通知ID', `MANAGER_TASK_ID` int(11) DEFAULT NULL COMMENT '管理员订单ID', `CONTACTS_ID` int(11) DEFAULT NULL COMMENT '客户ID', `DRIVER_ID` int(11) DEFAULT NULL COMMENT '司机ID', `VEHICLE_ID` int(11) DEFAULT NULL COMMENT '车辆ID', `GROUP_CODE` bigint(20) NOT NULL DEFAULT '0' COMMENT '分组信息', `SEARCH` varchar(1000) DEFAULT '' COMMENT '搜索词', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) NOT NULL DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) NOT NULL DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `t_number` (`COMPANY_ID`,`TASK_TYPE`,`TASK_NUMBER`), KEY `m_task` (`MANAGER_TASK_ID`), KEY `t_list` (`COMPANY_ID`,`END_DATE`,`START_DATE`,`TASK_TYPE`), KEY `t_contacts` (`CONTACTS_ID`,`END_DATE`,`START_DATE`,`TASK_TYPE`), KEY `t_driver` (`DRIVER_ID`,`END_DATE`,`START_DATE`,`TASK_TYPE`) ) ENGINE=InnoDB AUTO_INCREMENT=1258 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `gps_msg` -- DROP TABLE IF EXISTS `gps_msg`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `gps_msg` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'gps报警信息ID', `IMEI` varchar(50) NOT NULL DEFAULT '' COMMENT 'imei码', `TITLE` varchar(50) NOT NULL DEFAULT '' COMMENT '标题', `LNG` double NOT NULL COMMENT '经度', `LAT` double NOT NULL COMMENT '纬度', `ADDRESS` varchar(100) NOT NULL DEFAULT '' COMMENT '地址', `CONTENT` varchar(1000) NOT NULL DEFAULT '' COMMENT '消息内容', `DATE` date NOT NULL COMMENT '报警日期', `MSG_TYPE` int(11) NOT NULL COMMENT '消息类型', `VEHICLE_ID` int(11) DEFAULT NULL COMMENT '车辆 ID', `DRIVER_ID` int(11) DEFAULT NULL COMMENT '司机 ID', `CREATE_BY` int(11) DEFAULT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) DEFAULT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) DEFAULT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`) ) ENGINE=InnoDB AUTO_INCREMENT=575226 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `history` -- DROP TABLE IF EXISTS `history`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `history` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '操作历史ID', `TYPE` int(11) NOT NULL COMMENT '历史类型', `TYPE_ID` int(11) NOT NULL COMMENT '类型ID', `CONTENT` varchar(50) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '操作内容', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(10000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(1000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `h_content` (`COMPANY_ID`,`CONTENT`), KEY `h_list` (`TYPE_ID`,`COMPANY_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=9733309 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `holiday` -- DROP TABLE IF EXISTS `holiday`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `holiday` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `CALENDER_DATE` date NOT NULL, `TYPE` int(11) NOT NULL COMMENT '1 表示节假日 2表示调休日', `FEE_TYPE` int(11) DEFAULT NULL COMMENT '1 表示休息日工资双倍 2表示节假日工资三倍', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', `CREATE_BY` int(11) NOT NULL, `UPDATE_BY` int(11) NOT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `DATEKEY` (`CALENDER_DATE`) ) ENGINE=InnoDB AUTO_INCREMENT=121 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `image_info` -- DROP TABLE IF EXISTS `image_info`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `image_info` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '图片ID', `OSS_URL` varchar(256) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '图片地址', `RELATED_TABLE` varchar(45) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '关联table', `RELATED_ID` int(11) NOT NULL COMMENT '关联ID', `FILE_NAME` varchar(50) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '证件照名字', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) DEFAULT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '删除状态', PRIMARY KEY (`ID`), KEY `RelatedIndex` (`RELATED_TABLE`,`RELATED_ID`,`OSS_URL`(191)) ) ENGINE=InnoDB AUTO_INCREMENT=12517 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='相关图片表格 存放OSS的URL'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `imei` -- DROP TABLE IF EXISTS `imei`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `imei` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'imei ID', `NUMBER` varchar(50) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT 'imei 号', `MODEL` varchar(50) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '设备型号', `START_DATE` date NOT NULL COMMENT '启用日期', `END_DATE` date NOT NULL COMMENT '截止日期', `DEVICE` varchar(50) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '设备来源', `DEVICE_TYPE` int(11) DEFAULT '1' COMMENT '设备数据类型', `SIM` varchar(50) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT 'sim 卡号', `SOURCE` varchar(50) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT 'sim 卡来源', `FLOW_DATE` date NOT NULL COMMENT '流量卡截止日期', `IS_DSM` int(11) DEFAULT NULL, `CAMERA_COUNT` int(11) DEFAULT NULL, `DEVICE_ID` varchar(50) DEFAULT NULL, `MEMORY_CARD_SIZE` int(11) DEFAULT NULL, `MEMORY_CARD_COUNT` int(11) DEFAULT NULL, `VEHICLE_ID` int(11) DEFAULT NULL COMMENT '车辆ID', `PLATE_NO` varchar(50) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '车牌号码', `STATUS` int(11) NOT NULL DEFAULT '0' COMMENT 'GPS状态', `STATUS_TIME` timestamp NULL DEFAULT NULL COMMENT '状态更新时间', `OIL` int(11) NOT NULL DEFAULT '0' COMMENT '油电状态', `HEARTBEAT` timestamp NULL DEFAULT NULL COMMENT '最后一次心跳时间', `ACC` int(11) DEFAULT NULL COMMENT '是否熄火', `ACC_TIME` timestamp NULL DEFAULT NULL COMMENT '状态改变时的时间', `VOLTAGE` int(11) DEFAULT NULL COMMENT '电量', `GPS_START` timestamp NULL DEFAULT NULL COMMENT 'GPS开始时间', `GPS_END` timestamp NULL DEFAULT NULL COMMENT 'GPS结束时间', `LNG` double DEFAULT NULL COMMENT '最后一个GPS的经度', `LAT` double DEFAULT NULL COMMENT '最后一个GPS的纬度', `SPEED` int(11) DEFAULT NULL COMMENT '最后一个GPS的速度', `PAYTYPE` int(11) DEFAULT NULL COMMENT '付款方式', `BILL` int(11) DEFAULT NULL COMMENT '发票', `RENEW_ONE_PRICE` int(11) NOT NULL DEFAULT '100' COMMENT '一年续费', `RENEW_THREE_PRICE` int(11) NOT NULL DEFAULT '200' COMMENT '三年续费', `CREATE_BY` int(11) DEFAULT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) DEFAULT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) DEFAULT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', PRIMARY KEY (`ID`), KEY `imei_number` (`NUMBER`), KEY `imei_sim` (`SIM`), KEY `imei_vehicle` (`VEHICLE_ID`), KEY `imei_company` (`COMPANY_ID`), KEY `imei_end` (`END_DATE`) ) ENGINE=InnoDB AUTO_INCREMENT=12682 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `inspection_item` -- DROP TABLE IF EXISTS `inspection_item`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `inspection_item` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', `ITEM_NAME` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '检查项目名称', `IS_REQUIRED` int(11) NOT NULL COMMENT '是否必填', `TYPE` int(11) NOT NULL COMMENT '检查类型', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '修改人ID', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`ID`), KEY `COMPANY_ID` (`COMPANY_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `inspection_item_value` -- DROP TABLE IF EXISTS `inspection_item_value`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `inspection_item_value` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', `INSPECTION_ID` int(11) NOT NULL COMMENT '记录ID', `ITEM_ID` int(11) NOT NULL COMMENT '子项ID', `ITEM_FLAG` int(11) NOT NULL COMMENT '检查项目是否通过', `ITEM_ABNORMAL` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '检查项目异常', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '修改人ID', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`ID`), KEY `COMPANY_ID` (`COMPANY_ID`), KEY `ITEM_ID` (`ITEM_ID`), KEY `INSPECTION_ID` (`INSPECTION_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `invoice` -- DROP TABLE IF EXISTS `invoice`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `invoice` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '发票ID', `ADDRESS_STR` varchar(100) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '地址', `RECEIVER` varchar(45) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '接收人', `RECEIVER_PHONE` varchar(45) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '接收人电话', `ELE_INVOICE` varchar(100) CHARACTER SET utf8mb4 DEFAULT '电子发票单号', `NORMAL_INVOICE` varchar(45) CHARACTER SET utf8mb4 DEFAULT '普通发票快递单号', `AMOUNT` double NOT NULL COMMENT '发票金额', `INVOICE_STATUS` int(11) NOT NULL COMMENT '发票状态', `INVOICE_INFO_HEAD` varchar(45) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '发票抬头', `INVOICE_TYPE` int(11) NOT NULL COMMENT '发票开具类型', `INVOICE_DATE` date DEFAULT NULL COMMENT '开票日期', `TAX_CODE` varchar(45) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '税务登记证号', `BANK_NAME` varchar(45) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '开户银行名称', `BASE_ACCOUNT` varchar(45) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '基本开户账号', `REGISTERED_ADDRESS` varchar(100) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '注册场所地址', `REGISTERED_PHONE` varchar(45) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '注册固定电话', `CREATE_BY` int(11) NOT NULL COMMENT '注册人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人 ID', `COMPANY_ID` int(11) NOT NULL COMMENT '公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后修改时间', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '是否删除', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `INFO` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '开票明细', `EXTEND` varchar(10000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '拓展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `ADDRESS_ID` (`ADDRESS_STR`) ) ENGINE=InnoDB AUTO_INCREMENT=649 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `invoice_book` -- DROP TABLE IF EXISTS `invoice_book`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `invoice_book` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `INVOICE_NUMBER` bigint(20) NOT NULL COMMENT '发票号', `PAYMENT_UNIT` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '付款单位', `AMOUNT` double DEFAULT NULL COMMENT '金额', `PAYMENT_DATE` datetime DEFAULT NULL COMMENT '付款日期', `PAYMENT_METHOD` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'method', `IS_USE` int(11) NOT NULL DEFAULT '1' COMMENT '是否使用', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '是否删除', `REMARK` varchar(10000) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '扩展字段（以json串存储）', `CREATE_BY` int(11) NOT NULL COMMENT '创建人', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', PRIMARY KEY (`ID`), KEY `INVOICE_NUMBER` (`INVOICE_NUMBER`), KEY `AMOUNT` (`AMOUNT`), KEY `IS_USE` (`IS_USE`), KEY `PAYMENT_UNIT` (`PAYMENT_UNIT`) ) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `invoice_info` -- DROP TABLE IF EXISTS `invoice_info`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `invoice_info` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '发票ID', `IS_DEFAULT` int(11) DEFAULT NULL COMMENT '是否默认，1为默认', `INVOICE_INFO_HEAD` varchar(45) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '发票抬头', `INVOICE_TYPE` int(11) NOT NULL COMMENT '发票开具类型', `TAX_CODE` varchar(45) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '税务登记证号', `BANK_NAME` varchar(45) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '开户银行名称', `BASE_ACCOUNT` varchar(45) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '基本开户账号', `REGISTERED_ADDRESS` varchar(100) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '注册场所地址', `REGISTERED_PHONE` varchar(45) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '注册固定电话', `CREATE_BY` int(11) NOT NULL COMMENT '注册人ID', `UPDATE_BY` int(11) DEFAULT NULL COMMENT '最后更新人 ID', `COMPANY_ID` int(11) DEFAULT NULL COMMENT '公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后修改时间', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '是否删除', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `EXTEND` varchar(10000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '拓展字段（以json串存储）', PRIMARY KEY (`ID`) ) ENGINE=InnoDB AUTO_INCREMENT=397 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `lang` -- DROP TABLE IF EXISTS `lang`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `lang` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `NAME` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '中文', `EN` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '英文', `AR` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '阿拉伯文', `RU` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '俄文', `JA` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '日文', `TH` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '泰文', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '是否删除', `REMARK` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '扩展字段（以json串存储）', `CREATE_BY` int(11) NOT NULL COMMENT '创建人', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人', PRIMARY KEY (`ID`), UNIQUE KEY `NAME` (`NAME`,`IS_DELETED`) ) ENGINE=InnoDB AUTO_INCREMENT=284 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `leave_application` -- DROP TABLE IF EXISTS `leave_application`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `leave_application` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '请假ID', `USER_ID` int(11) NOT NULL COMMENT '司机ID', `LEAVE_TYPE_ID` int(11) NOT NULL COMMENT '请假类型ID', `START_DATE` date NOT NULL COMMENT '起始日期', `END_DATE` date NOT NULL COMMENT '截止日期', `DAYS` double NOT NULL COMMENT '请假天数', `START_TIME` time DEFAULT NULL, `END_TIME` time DEFAULT NULL, `LEAVE_STATUS` int(11) NOT NULL DEFAULT '0' COMMENT '0司机申请；1通过（或者管理员自己创建）2否决', `REASON` varchar(1024) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '请假事由', `GROUP_CODE` bigint(20) NOT NULL DEFAULT '0' COMMENT '分组信息', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '删除状态', `EXTEND` varchar(4096) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `ForeginIndex` (`USER_ID`,`LEAVE_TYPE_ID`,`START_DATE`,`END_DATE`,`IS_DELETED`,`COMPANY_ID`), KEY `list` (`COMPANY_ID`,`START_DATE`,`END_DATE`), KEY `create_by` (`CREATE_BY`,`START_DATE`,`END_DATE`) ) ENGINE=InnoDB AUTO_INCREMENT=5208 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='司机请假表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `leave_type` -- DROP TABLE IF EXISTS `leave_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `leave_type` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '请假类型ID', `NAME` varchar(45) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '请假名称', `REMARK` varchar(1024) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '删除状态', `CREATE_BY` int(11) DEFAULT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) DEFAULT NULL COMMENT '最后更新人ID', `GMT_CREATED` datetime DEFAULT NULL COMMENT '创建时间', `GMT_MODIFIED` datetime DEFAULT NULL COMMENT '最后更新时间', PRIMARY KEY (`ID`), UNIQUE KEY `NameUniqIdx` (`NAME`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='请假类型'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `maintenance_manufactor` -- DROP TABLE IF EXISTS `maintenance_manufactor`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `maintenance_manufactor` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '厂商ID', `MANUFACTOR_NAME` varchar(50) NOT NULL DEFAULT '' COMMENT '厂商名字', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `MANUFACTOR_COUNT` int(11) NOT NULL DEFAULT '0', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `manufactor_company` (`COMPANY_ID`), KEY `manufactor_name` (`MANUFACTOR_NAME`) ) ENGINE=InnoDB AUTO_INCREMENT=730 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `maintenance_repair` -- DROP TABLE IF EXISTS `maintenance_repair`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `maintenance_repair` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `MAINTENANCE_ID` int(11) NOT NULL, `REPAIR_NAME` varchar(45) NOT NULL COMMENT '维保配件名称', `REPAIR_MODEL` varchar(45) NOT NULL DEFAULT '' COMMENT '型号', `REPAIR_DATE` date NOT NULL COMMENT '维修日期', `PRICE` double NOT NULL COMMENT '单价', `QUANTITY` int(11) NOT NULL COMMENT '数量', `WORK_FEE` double NOT NULL COMMENT '工时费', `AMOUNT` double NOT NULL COMMENT '金额', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', `COMPANY_ID` int(11) NOT NULL, `CREATE_BY` int(11) NOT NULL, `UPDATE_BY` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `maintenanceId` (`MAINTENANCE_ID`), KEY `companyId` (`COMPANY_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=5004 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `maintenance_work` -- DROP TABLE IF EXISTS `maintenance_work`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `maintenance_work` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `MAINTENANCE_ID` int(11) NOT NULL, `WORK_NAME` varchar(45) NOT NULL COMMENT '工时项目', `WORK_DATE` date NOT NULL COMMENT '维修工时日期', `AMOUNT` double NOT NULL COMMENT '金额', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', `COMPANY_ID` int(11) NOT NULL, `CREATE_BY` int(11) NOT NULL, `UPDATE_BY` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `maintenanceId` (`MAINTENANCE_ID`), KEY `companyId` (`COMPANY_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=1752 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `manager_info` -- DROP TABLE IF EXISTS `manager_info`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `manager_info` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '管理员ID', `DEFAULT_GROUP` bigint(20) NOT NULL DEFAULT '0' COMMENT '默认分组信息', `MODULE_READ` int(11) NOT NULL DEFAULT '0' COMMENT '读权限', `MODULE_NEW` int(11) NOT NULL DEFAULT '0' COMMENT '新建权限', `MODULE_UPDATE` int(11) NOT NULL DEFAULT '0' COMMENT '更新权限', `MODULE_DELETE` int(11) NOT NULL DEFAULT '0' COMMENT '删除权限', `MODULE_APPROVAL` int(11) NOT NULL DEFAULT '131071', `MODULE_MESSAGE` int(11) NOT NULL DEFAULT '131071', `MODULE_OTHER` int(11) NOT NULL DEFAULT '0' COMMENT '其他权限', `MODULE_OTHER2` int(11) NOT NULL DEFAULT '0' COMMENT '其他2权限', `CREATE_BY` int(11) DEFAULT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) DEFAULT NULL COMMENT '最后更新人 ID', `COMPANY_ID` int(11) DEFAULT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) DEFAULT '' COMMENT '拓展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `company` (`COMPANY_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=50450 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `menu` -- DROP TABLE IF EXISTS `menu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `menu` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `NAME` varchar(45) CHARACTER SET utf8mb4 NOT NULL DEFAULT '', `NO` int(11) NOT NULL, `ICON` varchar(128) CHARACTER SET utf8mb4 DEFAULT NULL, `ICON2` varchar(128) CHARACTER SET utf8mb4 DEFAULT NULL, `ORDER_WEIGHT` int(11) NOT NULL DEFAULT '0', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) CHARACTER SET utf8mb4 DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', `CREATE_BY` int(11) NOT NULL, `UPDATE_BY` int(11) NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='菜单'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `message` -- DROP TABLE IF EXISTS `message`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `message` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '消息ID', `TITLE` varchar(100) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '消息标题', `CONTENT` varchar(10000) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '消息内容', `HAS_READ` int(11) NOT NULL COMMENT '是否已读', `RECEIVER_ID` int(11) NOT NULL COMMENT '接收人ID', `MSG_TYPE` int(11) NOT NULL COMMENT '消息类型', `VEHICLE_ID` int(11) DEFAULT NULL COMMENT '车辆 ID', `DRIVER_ID` int(11) DEFAULT NULL COMMENT '司机 ID', `CREATE_BY` int(11) DEFAULT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) DEFAULT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) DEFAULT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(1000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `message_expired` (`HAS_READ`,`GMT_CREATED`,`IS_DELETED`), KEY `type` (`MSG_TYPE`,`COMPANY_ID`), KEY `m_count` (`RECEIVER_ID`,`HAS_READ`), KEY `msg_list` (`RECEIVER_ID`,`MSG_TYPE`,`IS_DELETED`) ) ENGINE=InnoDB AUTO_INCREMENT=35814556 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `message_task` -- DROP TABLE IF EXISTS `message_task`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `message_task` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '消息任务ID', `TITLE` varchar(45) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '标题', `CONTENT` varchar(600) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '内容', `RECEIVER_TYPE` int(11) NOT NULL COMMENT '接收者类型', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人 ID', `COMPANY_ID` int(11) NOT NULL COMMENT '公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后修改时间', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '是否删除', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `EXTEND` varchar(10000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '拓展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `list` (`COMPANY_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `notice` -- DROP TABLE IF EXISTS `notice`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `notice` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '通知ID', `NOTICE_NAME` varchar(50) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '通知别名', `CHECK_STATUS` int(11) NOT NULL COMMENT '审核状态', `APPROVAL` varchar(512) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '通知管理员审批', `APPROVAL_SMS` varchar(20) DEFAULT '' COMMENT '通知管理员审批的短信模板', `APPROVAL_TTS` varchar(20) DEFAULT '' COMMENT '通知管理员审批的语音模板', `APPROVAL_CONFIG` int(11) NOT NULL COMMENT '通知管理员审批的配置', `APPROVAL_OTHER` varchar(512) DEFAULT '' COMMENT '通知管理员其他审批', `APPROVAL_OTHER_SMS` varchar(20) DEFAULT '' COMMENT '通知管理员其他审批的模板', `SCHEDULING` varchar(512) DEFAULT '' COMMENT '通知调度员派车', `SCHEDULING_SMS` varchar(20) DEFAULT '' COMMENT '通知调度员派车的短信模板', `SCHEDULING_TTS` varchar(20) DEFAULT '' COMMENT '通知调度员派车的语音模板', `SCHEDULING_CONFIG` int(11) NOT NULL COMMENT '通知调度员派车的配置', `APPROVAL_CUSTOMER` varchar(512) DEFAULT '' COMMENT '通知用车人审批结果', `APPROVAL_CUSTOMER_SMS` varchar(20) DEFAULT '' COMMENT '通知用车人审批结果', `NOTICE_DRIVER` varchar(512) DEFAULT '' COMMENT '通知司机', `NOTICE_DRIVER_SMS` varchar(20) DEFAULT '' COMMENT '通知司机模板', `AUDIO_NOTICE` varchar(512) DEFAULT '' COMMENT '语音通知司机', `AUDIO_NOTICE_TTS` varchar(20) DEFAULT '' COMMENT '语音通知司机模板', `NOTICE_TIME` int(11) NOT NULL COMMENT '语音通知司机的时间间隔', `GRAB_DRIVER` varchar(512) DEFAULT '' COMMENT '语音通知司机抢单', `GRAB_DRIVER_TTS` varchar(20) DEFAULT '' COMMENT '语音通知司机抢单的模板', `GRAB_MANAGER` varchar(512) DEFAULT '' COMMENT '无人抢单短信通知管理员', `GRAB_MANAGER_SMS` varchar(20) DEFAULT '' COMMENT '无人抢单短信通知管理员的模板', `GRAB_MANAGER_CONFIG` int(11) DEFAULT '0' COMMENT '无人抢单通知管理员的配置', `NOTICE_CUSTOMER` varchar(512) DEFAULT '' COMMENT '通知客户', `NOTICE_CUSTOMER_SMS` varchar(20) DEFAULT '' COMMENT '通知客户模板', `ONE_HOUR` varchar(512) DEFAULT '' COMMENT '一小时', `ONE_HOUR_MIN` int(11) DEFAULT '0' COMMENT '一小时时间配置', `ONE_HOUR_SMS` varchar(20) DEFAULT '' COMMENT '一小时的短信模板', `ONE_HOUR_TTL` varchar(20) DEFAULT '' COMMENT '一小时的语音模板', `ONE_HOUR_CONFIG` int(11) NOT NULL COMMENT '一小时的配置', `ARRIVE_START` varchar(512) DEFAULT '' COMMENT '到达起点', `ARRIVE_START_SMS` varchar(20) DEFAULT '' COMMENT '到达起点模板', `FINISH` varchar(512) DEFAULT '' COMMENT '行程结束', `FINISH_SMS` varchar(20) DEFAULT '' COMMENT '行程结束模板', `LAST_CALL_DRIVER` varchar(512) DEFAULT '' COMMENT '最后通知司机', `LAST_CALL_DRIVER_TTS` varchar(20) DEFAULT '' COMMENT '最后通知司机模板', `LAST_CALL_DRIVER_TIME` int(11) NOT NULL DEFAULT '8' COMMENT '最后通知司机时间', `LAST_CALL_MANAGER` varchar(512) DEFAULT '' COMMENT '最后通知管理员', `LAST_CALL_MANAGER_TTS` varchar(20) DEFAULT '' COMMENT '最后通知管理员模板', `LAST_CALL_MANAGER_TIME` int(11) NOT NULL DEFAULT '4' COMMENT '最后通知管理员时间', `CANCEL_CUSTOMER` varchar(512) DEFAULT '' COMMENT '取消订单通知客户', `CANCEL_CUSTOMER_SMS` varchar(20) DEFAULT '' COMMENT '取消订单通知客户的模板', `UPDATE_DRIVER` varchar(512) DEFAULT '' COMMENT '更新订单通知司机', `UPDATE_DRIVER_SMS` varchar(20) DEFAULT '' COMMENT '更新订单通知司机模板', `UPDATE_DRIVER_CONFIG` int(11) NOT NULL DEFAULT '4' COMMENT '更新订单通知司机配置（默认4 只通知外援司机）', `CANCEL_DRIVER` varchar(512) DEFAULT '' COMMENT '取消订单通知司机', `CANCEL_DRIVER_SMS` varchar(20) DEFAULT '' COMMENT '取消订单通知司机的模板', `CANCEL_DRIVER_CONFIG` int(11) NOT NULL DEFAULT '4' COMMENT '取消订单通知司机配置（默认4 只通知外援司机）', `SPLICE_DRIVER` varchar(512) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '拆分订单通知司机', `SPLICE_DRIVER_SMS` varchar(20) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '拆分订单通知司机的模板', `UPDATE_TASK` varchar(512) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '更新商品订单通知司机', `UPDATE_TASK_SMS` varchar(20) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '更新商品订单通知司机的模板', `CANCEL_TASK` varchar(512) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '取消商品订单通知司机', `CANCEL_TASK_SMS` varchar(20) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '取消商品订单通知司机的模板', `RECOVERY` varchar(512) DEFAULT '' COMMENT '信号恢复通知管理员', `RECOVERY_SMS` varchar(20) DEFAULT '' COMMENT '信号恢复通知模板', `OFFLINE` varchar(512) DEFAULT '' COMMENT '信号断开通知管理员', `OFFLINE_SMS` varchar(20) DEFAULT '' COMMENT '信号断开通知模板', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(1000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `notice_list` (`COMPANY_ID`,`NOTICE_NAME`) ) ENGINE=InnoDB AUTO_INCREMENT=42009 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `obd_code` -- DROP TABLE IF EXISTS `obd_code`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `obd_code` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'OBD代码ID', `OBD_TYPE` int(11) NOT NULL COMMENT 'OBD代码类型', `FAULT_CODE` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '故障代码', `FAULT_EXPLAIN` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '故障说明', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `FAULT_CODE` (`FAULT_CODE`), KEY `OBD_TYPE` (`OBD_TYPE`) ) ENGINE=InnoDB AUTO_INCREMENT=4995 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `oil_box` -- DROP TABLE IF EXISTS `oil_box`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `oil_box` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '油箱ID', `IMEI` varchar(45) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT 'imei码', `BOX_TYPE` int(11) NOT NULL COMMENT '油箱类型', `LENGTH` double DEFAULT NULL COMMENT '长', `WIDTH` double DEFAULT NULL COMMENT '宽', `HEIGHT` double DEFAULT NULL COMMENT '高', `DIAMETER` double DEFAULT NULL COMMENT '直径', `VOLUME` double DEFAULT NULL COMMENT '体积', `THRESHOLD` double NOT NULL DEFAULT '20' COMMENT '油量变动阀值', `IS_FIRST` int(11) NOT NULL COMMENT '是否主油箱', `CREATE_BY` int(11) NOT NULL COMMENT '注册人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人 ID', `COMPANY_ID` int(11) DEFAULT NULL COMMENT '公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后修改时间', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '是否删除', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `EXTEND` varchar(10000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '拓展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `IMEI` (`IMEI`), KEY `list` (`COMPANY_ID`,`IMEI`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `oil_card` -- DROP TABLE IF EXISTS `oil_card`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `oil_card` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `CARD_TYPE` int(11) NOT NULL COMMENT '油卡类型', `IS_MAIN` int(11) NOT NULL DEFAULT '1' COMMENT '是否主卡（1：主卡，2：副卡）', `CARD_NUMBER` varchar(45) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '油卡号码', `CARD_MONEY` float(11,2) NOT NULL COMMENT '油卡余额', `CUR_MONEY` double DEFAULT NULL, `IS_COMPANY` int(11) NOT NULL DEFAULT '1' COMMENT '1 是公司注册的卡 0 是个人的卡 ', `CARDHOLDER` varchar(45) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '油卡持有者', `CARDER_PHONE` varchar(45) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '油卡持有者电话', `BINDING_TYPE` int(11) DEFAULT NULL COMMENT '绑定类型', `BINDING_ID` int(11) DEFAULT NULL COMMENT '绑定对象ID', `GROUP_CODE` bigint(20) NOT NULL DEFAULT '0' COMMENT '分组信息', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '备注', `EXTEND` varchar(10000) DEFAULT NULL COMMENT '扩展字段（以json串存储）', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '删除标识', PRIMARY KEY (`ID`), KEY `COMPANY` (`COMPANY_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=11518 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `oil_card_detail` -- DROP TABLE IF EXISTS `oil_card_detail`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `oil_card_detail` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `COMPANY_ID` int(11) NOT NULL, `OIL_CARD_ID` int(11) NOT NULL, `TYPE` int(11) NOT NULL DEFAULT '0' COMMENT '1 加油 2充值', `AMOUNT` double NOT NULL COMMENT '金额', `BALANCE` double NOT NULL DEFAULT '0', `VOLUME` double NOT NULL DEFAULT '0' COMMENT '升数', `DEAL_DATE` datetime NOT NULL COMMENT '交易日期', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', `CREATE_BY` int(11) NOT NULL, `UPDATE_BY` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `oilcardid` (`COMPANY_ID`,`OIL_CARD_ID`), KEY `detail` (`OIL_CARD_ID`,`AMOUNT`,`TYPE`) ) ENGINE=InnoDB AUTO_INCREMENT=104391 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `order_type` -- DROP TABLE IF EXISTS `order_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `order_type` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '订单类型ID', `USE_TYPE` int(11) NOT NULL DEFAULT '1' COMMENT '是否客运 1客运 2货运', `TYPE_NAME` varchar(50) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '类型名字', `SHORT_NAME` varchar(50) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '类型简称', `WEIGHT` int(11) NOT NULL DEFAULT '0' COMMENT '排序权重', `DRIVER_VEHICLE_TYPE` int(11) NOT NULL DEFAULT '1' COMMENT '司机车辆类型', `BASE_FEE` float DEFAULT NULL COMMENT '收客户的起步价', `FEE_FORMULA` longtext, `BASE_FEE_MIL` int(11) DEFAULT NULL COMMENT '收客户的起步里程', `MIL_EFF_FEE` float DEFAULT NULL COMMENT '收客户的里程系数', `BASE_FEE_TIME` int(11) DEFAULT NULL COMMENT '收客户的起步时间', `TIME_EFF_FEE` float DEFAULT NULL COMMENT '收客户的时间系数', `BASE_DRIVER` float DEFAULT NULL COMMENT '付司机的起步价', `DRIVER_FEE_FORMULA` longtext, `BASE_DRIVER_MIL` int(11) DEFAULT NULL COMMENT '付司机的起步里程', `MIL_EFF_DRIVER` float DEFAULT NULL COMMENT '付司机的里程系数', `BASE_DRIVER_TIME` int(11) DEFAULT NULL COMMENT '付司机的起步时间', `TIME_EFF_DRIVER` float DEFAULT NULL COMMENT '付司机的时间系数', `GROUP_CODE` bigint(20) NOT NULL DEFAULT '0' COMMENT '分组信息', `PAY_TYPE` int(11) NOT NULL DEFAULT '1' COMMENT '1 无须支付 2订单完成支付 2其他待加', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `ot_list` (`COMPANY_ID`,`TYPE_NAME`) ) ENGINE=InnoDB AUTO_INCREMENT=84897 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `parts` -- DROP TABLE IF EXISTS `parts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `parts` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '配件ID', `PARTS_NAME` varchar(45) NOT NULL COMMENT '维保配件名称', `PARTS_MODEL` varchar(45) NOT NULL COMMENT '型号', `AMOUNT_UNIT` varchar(45) NOT NULL COMMENT '金额单位', `QUANTITY_UNIT` varchar(45) NOT NULL COMMENT '单位数量', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `PARTS_NAME` (`PARTS_NAME`), KEY `PARTS_MODEL` (`PARTS_MODEL`) ) ENGINE=InnoDB AUTO_INCREMENT=123 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `parts_storage` -- DROP TABLE IF EXISTS `parts_storage`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `parts_storage` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '配件ID', `PARTS_BATCH` bigint(20) NOT NULL COMMENT '批次', `PARTS_MONTH` int(11) NOT NULL COMMENT '月份', `PARTS_ID` int(11) NOT NULL COMMENT '配件ID', `PARTS_PRICE` double NOT NULL COMMENT '单价', `PARTS_QUANTITY` double NOT NULL DEFAULT '0' COMMENT '库存数量', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `PARTS_ID` (`PARTS_ID`), KEY `key` (`PARTS_BATCH`,`PARTS_MONTH`,`COMPANY_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=298 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `parts_storage_accounting` -- DROP TABLE IF EXISTS `parts_storage_accounting`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `parts_storage_accounting` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '配件ID', `PARTS_MONTH` int(11) NOT NULL COMMENT '月份', `OPEN_BILL` int(11) NOT NULL COMMENT '开账/关帐', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`) ) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `parts_storage_history` -- DROP TABLE IF EXISTS `parts_storage_history`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `parts_storage_history` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '配件ID', `PARTS_ID` int(11) NOT NULL COMMENT '配件ID', `PARTS_PRICE` double NOT NULL COMMENT '单价', `PARTS_QUANTITY` double DEFAULT '0' COMMENT '数量', `STORAGE_TYPE` int(11) NOT NULL DEFAULT '0' COMMENT '库存类型（出库、入库、盘亏、盘盈）', `STORAGE_TIME` datetime NOT NULL COMMENT '入库时间', `PARTS_BATCH` bigint(20) NOT NULL COMMENT '批次', `PARTS_SUPPLIER` varchar(45) DEFAULT NULL COMMENT '配件供应商', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `PARTS_ID` (`PARTS_ID`), KEY `PARTS_BATCH` (`PARTS_BATCH`), KEY `STORAGE_TYPE` (`STORAGE_TYPE`), KEY `COMPANY_ID` (`COMPANY_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=276 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `path_fence` -- DROP TABLE IF EXISTS `path_fence`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `path_fence` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '路径围栏ID', `NAME` varchar(50) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '围栏名字', `GROUP_CODE` bigint(20) NOT NULL DEFAULT '0' COMMENT '分组信息', `TYPE` int(11) NOT NULL DEFAULT '1' COMMENT '类型', `ALARM` int(11) DEFAULT '0' COMMENT '报警状态', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1024) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '备注', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '删除状态', PRIMARY KEY (`ID`), KEY `uniq_idx` (`NAME`,`COMPANY_ID`,`IS_DELETED`,`TYPE`), KEY `list` (`COMPANY_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=1445 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `path_fence_vehicle` -- DROP TABLE IF EXISTS `path_fence_vehicle`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `path_fence_vehicle` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '路径车辆ID', `PATH_ID` int(11) NOT NULL COMMENT '路径ID', `VEHICLE_ID` int(11) NOT NULL COMMENT '车辆ID', `STATUS` int(11) NOT NULL COMMENT '车辆状态', `TIME` datetime DEFAULT NULL COMMENT '报警时间', `GROUP_CODE` bigint(20) NOT NULL DEFAULT '0' COMMENT '分组信息', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '删除状态', PRIMARY KEY (`ID`), KEY `idx` (`PATH_ID`,`VEHICLE_ID`,`GROUP_CODE`,`COMPANY_ID`), KEY `vehicle` (`VEHICLE_ID`), KEY `path` (`PATH_ID`), KEY `is_delete` (`IS_DELETED`) ) ENGINE=InnoDB AUTO_INCREMENT=3527 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `plate_no_city_ref` -- DROP TABLE IF EXISTS `plate_no_city_ref`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `plate_no_city_ref` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `PLATE_NO_CODE` varchar(45) NOT NULL, `CITY_NAME` varchar(45) NOT NULL, `IS_MATCH` int(11) NOT NULL DEFAULT '1', `REMARK` varchar(10000) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `plate_no` (`PLATE_NO_CODE`) ) ENGINE=InnoDB AUTO_INCREMENT=398 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `product` -- DROP TABLE IF EXISTS `product`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `product` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '产品ID', `CATEGORY_ID` int(11) NOT NULL, `NAME` varchar(45) NOT NULL DEFAULT '' COMMENT '产品名称', `ORDER_WEIGHT` int(11) NOT NULL DEFAULT '0', `DESCRIPTION` varchar(2048) DEFAULT NULL COMMENT '产品描述', `PRICE` double NOT NULL COMMENT '价格', `OLD_PRICE` double DEFAULT NULL, `QUANTITY_LIMIT` int(11) NOT NULL DEFAULT '0' COMMENT '0表示不限售', `QTY_UNIT` varchar(45) NOT NULL, `PACKAGE_NUM` int(11) NOT NULL DEFAULT '1' COMMENT '套餐包数量', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后修改时间', `REMARK` varchar(1024) DEFAULT NULL COMMENT '备注', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '删除标识', `CREATE_BY` int(11) NOT NULL COMMENT '创建人', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人', PRIMARY KEY (`ID`), KEY `p_name` (`NAME`), KEY `p_category` (`CATEGORY_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=1422 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `product_category` -- DROP TABLE IF EXISTS `product_category`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `product_category` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `NAME` varchar(45) NOT NULL, `ORDER_WEIGHT` int(11) NOT NULL DEFAULT '0', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', `CREATE_BY` int(11) NOT NULL, `UPDATE_BY` int(11) NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB AUTO_INCREMENT=1657 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `product_order` -- DROP TABLE IF EXISTS `product_order`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `product_order` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '订单ID', `PRODUCT_ID` int(11) NOT NULL COMMENT '产品ID', `INVOICE_ID` int(11) DEFAULT NULL, `INVOICE_STATUS` int(11) DEFAULT '1' COMMENT '发票状态', `ADDRESS_ID` int(11) DEFAULT NULL, `QUANTITY` double NOT NULL COMMENT '产品数量', `AMOUNT` double NOT NULL COMMENT '金额', `ORDER_NO` varchar(45) NOT NULL DEFAULT '' COMMENT '订单号', `ALI_ORDER_NO` varchar(45) DEFAULT NULL COMMENT '阿里订单号', `ORDER_STATUS` int(11) NOT NULL DEFAULT '1' COMMENT '订单状态', `USER_ID` int(11) NOT NULL COMMENT '用户ID', `COMPANY_ID` int(11) NOT NULL COMMENT '公司ID', `ALI_SELLER_ID` varchar(45) DEFAULT NULL COMMENT '同一个APP ID可能会多个SELLER_ID', `RENEW_YEAR` int(11) DEFAULT NULL, `GMT_CREATED` datetime NOT NULL COMMENT '创建时间', `GMT_MODIFIED` datetime NOT NULL COMMENT '更新时间', `REMARK` varchar(1024) DEFAULT NULL COMMENT '备注', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '删除标识', `CREATE_BY` int(11) NOT NULL COMMENT '创建人', `UPDATE_BY` int(11) NOT NULL COMMENT '更新人', `ALI_INFO` text, PRIMARY KEY (`ID`), KEY `po_list` (`COMPANY_ID`), KEY `po_product` (`PRODUCT_ID`), KEY `orderno` (`ORDER_NO`), KEY `addressId` (`ADDRESS_ID`), KEY `invoiceId` (`INVOICE_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=7526 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `question` -- DROP TABLE IF EXISTS `question`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `question` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '问题ID', `TITLE` varchar(50) NOT NULL DEFAULT '' COMMENT '问题标题', `CONTENT` varchar(1000) NOT NULL DEFAULT '' COMMENT '问题内容', `IMAGE` varchar(200) NOT NULL DEFAULT '' COMMENT '图片地址', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`) ) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `record_file_log` -- DROP TABLE IF EXISTS `record_file_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `record_file_log` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '通话记录ID', `CALL_ID` varchar(100) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '呼叫记录ID', `CALL_TIME` datetime NOT NULL COMMENT '呼叫发起时间', `RELEASE_TIME` datetime NOT NULL COMMENT '被叫挂断时间', `START_TIME` datetime NOT NULL COMMENT '被叫接听时间', `RELEASE_DIR` int(11) DEFAULT NULL COMMENT '通话释放方向', `CALL_TYPE` int(11) DEFAULT NULL COMMENT '呼叫类型', `PHONE_A` varchar(45) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT 'A端电话', `PHONE_X` varchar(45) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '虚拟号', `PHONE_B` varchar(45) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT 'B端电话', `IS_FINISH` int(11) NOT NULL COMMENT '录音是否完成', `OSS_LINK` varchar(100) DEFAULT NULL COMMENT 'OTS链接', `COMPANY_ID` int(11) NOT NULL COMMENT '公司ID', `CREATE_BY` int(11) NOT NULL COMMENT '注册人ID', `UPDATE_BY` int(11) DEFAULT NULL COMMENT '最后更新人 ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后修改时间', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '是否删除', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `EXTEND` varchar(10000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '拓展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `callid` (`CALL_ID`), KEY `phoneA` (`PHONE_A`), KEY `phoneB` (`PHONE_B`), KEY `company` (`COMPANY_ID`,`GMT_CREATED`,`IS_FINISH`), KEY `sale` (`UPDATE_BY`,`GMT_CREATED`,`IS_FINISH`) ) ENGINE=InnoDB AUTO_INCREMENT=76604 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `referral_info` -- DROP TABLE IF EXISTS `referral_info`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `referral_info` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '推荐信息ID', `REFERRAL` varchar(20) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '推荐码', `USER_ID` int(11) NOT NULL COMMENT '被推荐人ID', `REFER_ID` int(11) NOT NULL COMMENT '被推荐人公司', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `list` (`COMPANY_ID`), KEY `REFERR_ID` (`REFERRAL`), KEY `REFER` (`REFER_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=1030 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `registing` -- DROP TABLE IF EXISTS `registing`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `registing` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '注册ID', `PHONE` varchar(30) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '手机号码', `USER_TYPE` int(11) NOT NULL COMMENT '用户类型', `STORE` varchar(20) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '来源（电脑、苹果、安卓）', `SOURCE` varchar(20) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '产品（车队管家、依途）', `UNIQ` varchar(50) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '设备唯一识别码', `IP` varchar(32) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT 'IP地址', `COUNT` int(11) NOT NULL COMMENT '注册次数', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `registing_phone` (`PHONE`,`UNIQ`) ) ENGINE=InnoDB AUTO_INCREMENT=104100 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `regular` -- DROP TABLE IF EXISTS `regular`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `regular` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '班车ID', `WEEK` int(11) NOT NULL COMMENT '星期', `ROUTE_NAME` varchar(50) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '路线名', `VEHICLE_ID` int(11) DEFAULT NULL COMMENT '车辆ID', `REGULAR_SHIFT_ID` int(11) DEFAULT NULL COMMENT '班车轮班ID', `PLAN_CAP` float DEFAULT '0' COMMENT '预计容量（客运量/货运量）', `DRIVER_ID` int(11) DEFAULT NULL COMMENT '司机ID（用 user 表）', `CONTACTS_ID` int(11) NOT NULL COMMENT '联系人ID', `TRAVEL_TYPE` int(11) NOT NULL DEFAULT '1' COMMENT '行程类型，单程、往返', `ORDER_TYPE_ID` int(11) DEFAULT NULL COMMENT '订单类型ID', `START_ID` int(11) DEFAULT NULL COMMENT '起点站ID', `START_NAME` varchar(50) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '起点站名字', `START_TIME` time NOT NULL COMMENT '出发时间', `END_ID` int(11) DEFAULT NULL COMMENT '终点站ID', `END_NAME` varchar(50) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '终点站名字', `END_TIME` time DEFAULT NULL COMMENT '结束时间', `SETTLE_ID` int(11) DEFAULT NULL COMMENT '结算单位ID', `FEE_TYPE` varchar(20) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '费用类型', `JOB_FEE` float DEFAULT '0' COMMENT '任务费用', `DRIVER_FEE` float DEFAULT '0' COMMENT '司机费用', `NOTICE_ID` int(11) DEFAULT NULL COMMENT '通知ID', `WEIGHT` int(11) NOT NULL DEFAULT '0' COMMENT '班车排序权重', `GROUP_CODE` bigint(20) NOT NULL DEFAULT '0' COMMENT '分组信息', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `DRIVER_MESSAGE` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '发给司机app的信息', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `regular_vehicle` (`VEHICLE_ID`), KEY `regular_driver` (`DRIVER_ID`), KEY `regular_list` (`COMPANY_ID`,`WEEK`), KEY `regular_shift` (`REGULAR_SHIFT_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=9998 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `regular_contacts` -- DROP TABLE IF EXISTS `regular_contacts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `regular_contacts` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', `CONTACTS_ID` int(11) NOT NULL COMMENT '用车人ID', `REGULAR_ID` int(11) NOT NULL COMMENT '班车ID', `START_STOP_ID` int(11) DEFAULT '0' COMMENT '预约起始站ID', `END_STOP_ID` int(11) DEFAULT '0' COMMENT '预约结束站ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '修改人ID', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`ID`), KEY `COMPANY_ID` (`COMPANY_ID`), KEY `CONTACTS_ID` (`CONTACTS_ID`), KEY `REGULAR_ID` (`REGULAR_ID`), KEY `START_STOP_ID` (`START_STOP_ID`), KEY `END_STOP_ID` (`END_STOP_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `regular_info` -- DROP TABLE IF EXISTS `regular_info`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `regular_info` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '班车信息ID', `REGULAR_ID` int(11) NOT NULL COMMENT '班车ID', `USER_ID` int(11) NOT NULL COMMENT '乘客ID', `START_STOP_ID` int(11) NOT NULL DEFAULT '0' COMMENT '开始站点ID', `END_STOP_ID` int(11) NOT NULL DEFAULT '0' COMMENT '结束站点ID', `STATUS` int(11) NOT NULL COMMENT '状态', `DATE` date DEFAULT NULL COMMENT '乘车日期', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(200) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `list` (`COMPANY_ID`,`DATE`), KEY `REGULAR_ID` (`REGULAR_ID`), KEY `START_STOP_ID` (`START_STOP_ID`), KEY `END_STOP_ID` (`END_STOP_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=132861 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `regular_shift` -- DROP TABLE IF EXISTS `regular_shift`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `regular_shift` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `SHIFT_NAME` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '轮班名字', `GROUP_CODE` bigint(20) NOT NULL DEFAULT '0' COMMENT '分组信息', `COMPANY_ID` int(11) NOT NULL, `CREATE_BY` int(11) NOT NULL, `UPDATE_BY` int(11) NOT NULL, `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `EXTEND` varchar(10000) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '扩展字段（以json串存储）', `IS_DELETED` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`ID`), KEY `COMPANY` (`COMPANY_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `regular_stop_rel` -- DROP TABLE IF EXISTS `regular_stop_rel`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `regular_stop_rel` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '班车站点ID', `STOP_ID` int(11) NOT NULL COMMENT '站点ID', `REGULAR_ID` int(11) NOT NULL COMMENT '班车ID', `STOP_IDX` int(11) NOT NULL COMMENT '站点序号', `STOP_TIME` time DEFAULT NULL, `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '删除标识', PRIMARY KEY (`ID`), KEY `VEHICLE_STOP_IDX` (`STOP_ID`,`REGULAR_ID`,`STOP_IDX`,`COMPANY_ID`), KEY `regular` (`REGULAR_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=4340 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `rel_user_customer` -- DROP TABLE IF EXISTS `rel_user_customer`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rel_user_customer` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '关联ID', `USER_ID` int(11) NOT NULL COMMENT '用车人ID', `CUSTOMER_ID` int(11) NOT NULL COMMENT '部门ID', `CREATE_BY` int(11) DEFAULT NULL COMMENT '注册人ID', `UPDATE_BY` int(11) DEFAULT NULL COMMENT '最后更新人 ID', `COMPANY_ID` int(11) NOT NULL COMMENT '公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后修改时间', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '是否删除', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `EXTEND` varchar(10000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '拓展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `CUSTOMER_ID` (`CUSTOMER_ID`), KEY `r_user` (`USER_ID`), KEY `r_customer` (`CUSTOMER_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=96859 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `remind` -- DROP TABLE IF EXISTS `remind`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `remind` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '提醒ID', `TYPE` int(11) DEFAULT '1' COMMENT '提醒类型', `NEXT_DATE` date DEFAULT NULL COMMENT '下次提醒日期', `PERIOD` int(11) DEFAULT NULL COMMENT '提醒周期（天）', `DATE_CONFIG` int(11) DEFAULT '1' COMMENT '提醒时间配置', `MILEAGE` int(11) DEFAULT NULL COMMENT '提醒里程', `INTERVAL_MILEAGE` int(11) DEFAULT NULL COMMENT '提醒间隔里程', `CONTENT` varchar(50) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '提醒内容', `VEHICLE_ID` int(11) DEFAULT NULL COMMENT '车辆ID', `DRIVER_ID` int(11) DEFAULT NULL COMMENT '司机ID', `NEED_SMS` int(11) NOT NULL COMMENT '是否要短信提醒', `GROUP_CODE` bigint(20) NOT NULL DEFAULT '0' COMMENT '分组信息', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `remind_vehicle` (`VEHICLE_ID`), KEY `r_company` (`COMPANY_ID`,`IS_DELETED`,`NEXT_DATE`) ) ENGINE=InnoDB AUTO_INCREMENT=26118 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `remind_type` -- DROP TABLE IF EXISTS `remind_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `remind_type` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '提醒类型ID', `NAME` varchar(50) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '类型名字', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `rt_name` (`COMPANY_ID`,`NAME`) ) ENGINE=InnoDB AUTO_INCREMENT=6315 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `renew_log` -- DROP TABLE IF EXISTS `renew_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `renew_log` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `IMEI_ID` int(11) DEFAULT NULL COMMENT '设备ID', `VALIDATE_BEFORE` date NOT NULL COMMENT '续费前有效期', `VALIDATE_AFTER` date NOT NULL COMMENT '续费后有效期', `COMPANY_TYPE` int(11) DEFAULT NULL COMMENT '系统版本', `APPLET` int(11) DEFAULT NULL COMMENT '小程序功能', `GROUPS` int(11) DEFAULT NULL COMMENT '分组数', `LOG_TYPE` int(11) NOT NULL COMMENT '记录类型 1为小程序续费 2为分组续费', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', `COMPANY_ID` int(11) DEFAULT NULL, `CREATE_BY` int(11) NOT NULL, `UPDATE_BY` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `companyId` (`COMPANY_ID`), KEY `imei` (`IMEI_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=8724 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `route` -- DROP TABLE IF EXISTS `route`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `route` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `NAME` varchar(45) CHARACTER SET utf8mb4 NOT NULL DEFAULT '', `START_FENCE_ID` int(11) NOT NULL, `END_FENCE_ID` int(11) NOT NULL, `COMPANY_ID` int(11) NOT NULL, `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) CHARACTER SET utf8mb4 DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', `CREATE_BY` int(11) NOT NULL, `UPDATE_BY` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `name` (`NAME`), KEY `ids` (`START_FENCE_ID`,`END_FENCE_ID`,`COMPANY_ID`), KEY `list` (`COMPANY_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=222 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `route_vehicle` -- DROP TABLE IF EXISTS `route_vehicle`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `route_vehicle` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `ROUTE_ID` int(11) NOT NULL, `VEHICLE_ID` int(11) NOT NULL, `COMPANY_ID` int(11) NOT NULL, `STATUS` int(11) DEFAULT NULL COMMENT '车辆是否在路线内', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) CHARACTER SET utf8mb4 DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', `CREATE_BY` int(11) NOT NULL, `UPDATE_BY` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `ids` (`ROUTE_ID`,`VEHICLE_ID`,`COMPANY_ID`), KEY `vehicle` (`VEHICLE_ID`), KEY `route` (`ROUTE_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=6316 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `route_vehicle_summary` -- DROP TABLE IF EXISTS `route_vehicle_summary`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `route_vehicle_summary` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `ROUTE_ID` int(11) NOT NULL, `VEHICLE_ID` int(11) NOT NULL, `COMPANY_ID` int(11) NOT NULL, `START_TIME` datetime NOT NULL, `END_TIME` datetime NOT NULL, `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) CHARACTER SET utf8mb4 DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', `CREATE_BY` int(11) NOT NULL, `UPDATE_BY` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `ids` (`ROUTE_ID`,`VEHICLE_ID`,`COMPANY_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=64368 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `scheduling` -- DROP TABLE IF EXISTS `scheduling`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `scheduling` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '排班ID', `SCHEDULING_TYPE` int(11) NOT NULL COMMENT '排班类型', `WEEK` varchar(20) DEFAULT NULL COMMENT '星期几', `ROUTE_NAME` varchar(50) DEFAULT '' COMMENT '路线名', `VEHICLE_ID` int(11) DEFAULT NULL COMMENT '车辆ID', `PLAN_CAP` float DEFAULT '0' COMMENT '预计容量（客运量/货运量）', `DRIVER_ID` int(11) DEFAULT NULL COMMENT '司机ID（用 user 表）', `DRIVER_NAMES` text COMMENT '司机名字列表', `PHONE_X` varchar(20) DEFAULT '' COMMENT '隐私号码', `ROOT` int(11) NOT NULL DEFAULT '0' COMMENT '根排班ID', `CONTACTS_ID` int(11) NOT NULL COMMENT '联系人ID', `TRAVEL_TYPE` int(11) NOT NULL DEFAULT '1' COMMENT '行程类型，单程、往返', `CITY_ID` int(11) DEFAULT NULL COMMENT '城市ID', `ORDER_TYPE_ID` int(11) DEFAULT NULL COMMENT '订单类型ID', `START_ID` int(11) DEFAULT NULL COMMENT '起点站ID', `START_NAME` varchar(200) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '起点站名字', `START_DATE` date NOT NULL COMMENT '出发日期', `START_TIME` time NOT NULL COMMENT '出发时间', `END_ID` int(11) DEFAULT NULL COMMENT '终点站ID', `END_NAME` varchar(200) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '终点站名字', `END_DATE` date NOT NULL COMMENT '结束日期', `END_TIME` time DEFAULT NULL COMMENT '结束时间', `MINUTE` int(11) DEFAULT NULL COMMENT '任务时间，分钟', `MILEAGE` double DEFAULT NULL COMMENT '任务里程数', `SETTLE_ID` int(11) DEFAULT NULL COMMENT '结算单位ID', `FEE_TYPE` varchar(20) DEFAULT '' COMMENT '费用类型', `JOB_FEE` float DEFAULT '0' COMMENT '任务费用', `DRIVER_FEE` double DEFAULT '0' COMMENT '司机费用', `SCHEDULING_STATUS` int(11) NOT NULL COMMENT '排班状态', `APPROVAL_STATUS` int(11) NOT NULL DEFAULT '0' COMMENT '审批状态', `NOTICE_ID` int(11) DEFAULT NULL COMMENT '通知ID', `IS_GRAB` int(11) NOT NULL DEFAULT '0' COMMENT '抢单状态', `COUNTED` int(11) NOT NULL DEFAULT '0' COMMENT '是否记账', `STARTED` datetime DEFAULT NULL COMMENT '任务开始', `CLOSED` int(11) NOT NULL DEFAULT '0' COMMENT '收车次数', `GROUP_SCH_ID` int(11) NOT NULL DEFAULT '0' COMMENT '合并抢单', `REGULAR_ID` int(11) DEFAULT NULL COMMENT '班车ID', `PRODUCT_ORDER_ID` int(11) DEFAULT NULL COMMENT '关联的商品订单支付', `SCH_ASSIGN_TYPE` int(11) NOT NULL DEFAULT '0' COMMENT '车辆、司机安排类型', `NOT_SHOW_IN_PASSENGER` int(11) NOT NULL DEFAULT '0' COMMENT '在用车端显示与否', `FZ_ORDER_ID` varchar(45) DEFAULT '' COMMENT '飞猪订单ID', `GROUP_CODE` bigint(20) NOT NULL DEFAULT '0' COMMENT '分组信息', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `DRIVER_MESSAGE` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '发给司机app的信息', `ORIGINAL` varchar(200) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '原始行程', `HASH` bigint(20) NOT NULL DEFAULT '0' COMMENT '排班hash值', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `FORM_ID` varchar(32) DEFAULT '' COMMENT '小程序表单 ID', `ORDER_NUMBER` bigint(20) DEFAULT '0' COMMENT '订单号', `YZJ_DOC_NUMBER` varchar(50) DEFAULT NULL COMMENT '扬子江订单号', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `s_hash` (`HASH`), KEY `s_vehicle` (`VEHICLE_ID`), KEY `s_root` (`ROOT`), KEY `s_driver` (`DRIVER_ID`,`END_DATE`,`START_DATE`), KEY `s_end` (`END_DATE`), KEY `s_start` (`START_DATE`), KEY `all_grab` (`IS_GRAB`,`GMT_MODIFIED`), KEY `s_list` (`COMPANY_ID`,`END_DATE`,`START_DATE`,`ROOT`), KEY `s_order_no` (`COMPANY_ID`,`ORDER_NUMBER`), KEY `s_profile` (`COMPANY_ID`,`ROOT`,`SCHEDULING_STATUS`,`START_DATE`,`END_DATE`), KEY `s_count` (`COMPANY_ID`,`GMT_CREATED`), KEY `s_todo` (`COMPANY_ID`,`START_DATE`,`SCHEDULING_STATUS`,`ROOT`), KEY `group_sch_id` (`GROUP_SCH_ID`), KEY `s_regular_id` (`REGULAR_ID`), KEY `s_product_order_id` (`PRODUCT_ORDER_ID`), KEY `s_createby` (`COMPANY_ID`,`CREATE_BY`), KEY `s_contacts` (`COMPANY_ID`,`CONTACTS_ID`), KEY `list_regular` (`SCHEDULING_TYPE`,`END_DATE`,`START_DATE`), KEY `s_fz_id` (`FZ_ORDER_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=2311673 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `scheduling_route` -- DROP TABLE IF EXISTS `scheduling_route`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `scheduling_route` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `COMPANY_ID` int(11) NOT NULL, `SCHEDULING_ID` int(11) NOT NULL, `EST_TIME` double NOT NULL, `EST_FEE` double DEFAULT NULL, `EST_MILE` double NOT NULL, `PRICE` double DEFAULT NULL, `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', `CREATE_BY` int(11) NOT NULL, `UPDATE_BY` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `idx` (`SCHEDULING_ID`,`COMPANY_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=193720 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `share_lnglat` -- DROP TABLE IF EXISTS `share_lnglat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `share_lnglat` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '费用ID', `IMEI` varchar(50) NOT NULL DEFAULT '' COMMENT 'IMEI码', `VEHICLE_ID` int(11) NOT NULL COMMENT '车辆ID', `END_TIME` datetime NOT NULL COMMENT '截止时间', `FROM_TIME` datetime DEFAULT NULL COMMENT '轨迹起始时间', `TO_TIME` datetime DEFAULT NULL COMMENT '轨迹截止时间', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) DEFAULT '' COMMENT '扩展字段（以json串存储）', `TOKEN` varchar(32) NOT NULL DEFAULT '' COMMENT '登录token', PRIMARY KEY (`ID`), KEY `TOKEN` (`TOKEN`) ) ENGINE=InnoDB AUTO_INCREMENT=2231 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `smart_assign_condition` -- DROP TABLE IF EXISTS `smart_assign_condition`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `smart_assign_condition` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `COMPANY_ID` int(11) NOT NULL, `REALTIME_ASSIGN` int(11) NOT NULL DEFAULT '0' COMMENT '是否实时自动派车', `ASSIGN_GOAL` int(11) NOT NULL DEFAULT '4' COMMENT '默认车辆数最少', `ASSIGN_STRATEGY` int(11) NOT NULL DEFAULT '1' COMMENT '按ID顺序分', `START_DISTANCE_DELTA` int(11) DEFAULT '0' COMMENT '起点距离米', `END_DISTANCE_DELTA` int(11) DEFAULT '0' COMMENT '终点距离米', `START_TIME_MIN_DELTA` int(11) DEFAULT '0', `MIN_OCCUPY_PERCENTAGE` int(11) DEFAULT '0' COMMENT '满载率', `MIN_START_TIME_MINS` int(11) DEFAULT '0' COMMENT '最晚开始时间离现在几分钟', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', `CREATE_BY` int(11) NOT NULL, `UPDATE_BY` int(11) NOT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `uniq_idx` (`COMPANY_ID`,`IS_DELETED`), KEY `idx` (`COMPANY_ID`,`ID`) ) ENGINE=InnoDB AUTO_INCREMENT=188 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `sms` -- DROP TABLE IF EXISTS `sms`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sms` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '短信ID', `COUNTRY_NUMBER` varchar(20) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '国家代码', `PHONE` varchar(20) NOT NULL DEFAULT '' COMMENT '手机号码', `MODEL` varchar(128) NOT NULL DEFAULT '' COMMENT '发送流水号', `STATUS` int(11) DEFAULT NULL COMMENT '状态值', `COUNT` int(11) DEFAULT NULL COMMENT '短信条数', `FEE` int(11) DEFAULT NULL COMMENT '计费条数', `TEMPLATE` varchar(50) NOT NULL DEFAULT '' COMMENT '短信模板', `CONTENT` varchar(5000) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '短信内容', `DATE` date NOT NULL COMMENT '发送日期', `SEND_TIME` varchar(20) DEFAULT '' COMMENT '发送时间', `RECEIVE_TIME` varchar(20) DEFAULT '' COMMENT '接收时间', `RECEIVER_ID` int(11) DEFAULT NULL COMMENT '接收人ID', `SCHEDULING_ID` int(11) DEFAULT NULL COMMENT '排班ID', `PARAMS` varchar(1000) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '短信发送参数', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(1000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `model` (`MODEL`,`COMPANY_ID`), KEY `list` (`COMPANY_ID`,`DATE`), KEY `RECEIVER_ID` (`RECEIVER_ID`), KEY `SCHEDULING_ID` (`SCHEDULING_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=1530773 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `sms_mass_send_task` -- DROP TABLE IF EXISTS `sms_mass_send_task`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sms_mass_send_task` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '短信群发任务ID', `NAME` varchar(128) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '短信群发任务名称', `TEMPLATE_ID` int(11) NOT NULL COMMENT '短信模板ID', `PARAMS` varchar(1024) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '短信群发参数信息', `CONTENT` varchar(1024) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '短信内容', `RECEIVER_TYPE` int(11) NOT NULL COMMENT '收件人类型', `RECEIVER_COUNT` int(11) NOT NULL COMMENT '收件人数', `MSG_COUNT` int(11) NOT NULL COMMENT '短信发送条数', `PHONES` text CHARACTER SET utf8mb4 COMMENT '手机号码列表', `GROUP_CODE` bigint(20) NOT NULL DEFAULT '0' COMMENT '分组信息', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后修改人ID', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '删除状态', `REMARK` varchar(1000) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '备注', PRIMARY KEY (`ID`), KEY `task_list` (`COMPANY_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `sms_template` -- DROP TABLE IF EXISTS `sms_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sms_template` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '短信模板ID', `NAME` varchar(128) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '短信模板名称，公司名下唯一', `CONTENT` varchar(2048) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '模板内容', `CHECK_STATUS` int(11) NOT NULL DEFAULT '1' COMMENT '审核状态', `SMS_ID` varchar(128) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '平台短信模板ID', `FIELD_NO` int(11) NOT NULL DEFAULT '0' COMMENT '参数个数', `CREATE_BY` int(11) DEFAULT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) DEFAULT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL DEFAULT '0' COMMENT '缺省模板值是0，其他是创建模板的公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '删除状态', `REMARK` varchar(1024) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '备注', PRIMARY KEY (`ID`), KEY `sms_list` (`COMPANY_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=151 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `sms_template_field` -- DROP TABLE IF EXISTS `sms_template_field`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sms_template_field` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '参数ID', `NAME` varchar(128) COLLATE utf8_unicode_ci NOT NULL COMMENT '参数名称', `TEMPLATE_ID` int(11) NOT NULL COMMENT '所属短信模板ID', `CREATE_BY` int(11) DEFAULT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) DEFAULT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL DEFAULT '0' COMMENT '缺省模板值是0，其他是创建模板的公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '删除状态', `REMARK` varchar(1024) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '备注', PRIMARY KEY (`ID`), KEY `template` (`TEMPLATE_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=204 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `stop` -- DROP TABLE IF EXISTS `stop`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `stop` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '站点ID', `STOP_NAME` varchar(50) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '名字', `ADDRESS` text CHARACTER SET utf8mb4 COMMENT '地址', `LNG` double DEFAULT NULL COMMENT '经度', `LAT` double DEFAULT NULL COMMENT '纬度', `STOP_TYPE` int(11) NOT NULL COMMENT '类型', `COUNTED` int(11) NOT NULL DEFAULT '0' COMMENT '使用频率', `GROUP_CODE` bigint(20) NOT NULL DEFAULT '0' COMMENT '分组信息', `CREATE_BY` int(11) DEFAULT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) DEFAULT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) DEFAULT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `createby` (`CREATE_BY`,`STOP_TYPE`,`STOP_NAME`), KEY `s_list` (`COMPANY_ID`,`STOP_TYPE`,`COUNTED`) ) ENGINE=InnoDB AUTO_INCREMENT=544099 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `sub_menu` -- DROP TABLE IF EXISTS `sub_menu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sub_menu` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `NAME` varchar(45) CHARACTER SET utf8mb4 NOT NULL DEFAULT '', `NO` int(11) NOT NULL, `MENU_ID` int(11) NOT NULL, `PERMISSION` int(11) DEFAULT NULL, `URL` varchar(128) CHARACTER SET utf8mb4 NOT NULL DEFAULT '', `ICON` varchar(128) CHARACTER SET utf8mb4 DEFAULT NULL, `ICON2` varchar(128) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '未选中', `CAR_TYPE` int(11) NOT NULL DEFAULT '127' COMMENT '车辆类型', `VERSION_TYPE` int(11) NOT NULL DEFAULT '2' COMMENT '版本类型', `TYPE` int(11) NOT NULL DEFAULT '0' COMMENT '1: PC 2: ANDROID 4: IOS', `ORDER_WEIGHT` int(11) NOT NULL DEFAULT '0', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) CHARACTER SET utf8mb4 DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', `CREATE_BY` int(11) NOT NULL, `UPDATE_BY` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `idx` (`MENU_ID`), KEY `menu` (`MENU_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8 COMMENT='二级菜单'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `sub_product` -- DROP TABLE IF EXISTS `sub_product`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sub_product` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '子商品ID', `NAME` varchar(45) NOT NULL COMMENT '子商品名字', `PRODUCT_ID` int(11) NOT NULL COMMENT '商品ID', `PRICE` double NOT NULL COMMENT '价格', `OLD_PRICE` double DEFAULT NULL, `WEIGHT` int(11) NOT NULL DEFAULT '0' COMMENT '排序权重', `RENEW_YEAR` int(11) NOT NULL DEFAULT '1' COMMENT '续年', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1024) DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '删除标识', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', PRIMARY KEY (`ID`), KEY `product` (`PRODUCT_ID`), KEY `name_product` (`NAME`,`PRODUCT_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=146 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `subscribe` -- DROP TABLE IF EXISTS `subscribe`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `subscribe` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '订阅ID', `SCHEDULING_ID` int(11) NOT NULL COMMENT '排班ID', `VEHICLE_ID` int(11) NOT NULL COMMENT '车辆ID', `IMEI` varchar(50) NOT NULL DEFAULT '' COMMENT '车辆IMEI', `CONTACTS_ID` int(11) NOT NULL COMMENT '联系人ID', `LNG` float NOT NULL COMMENT '联系人经度', `LAT` float NOT NULL COMMENT '联系人纬度', `DATE` date NOT NULL COMMENT '订阅日期', `DISTANCE` int(11) NOT NULL COMMENT '距离提醒', `IS_REMINDED` int(11) NOT NULL COMMENT '是否已经提醒', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`) ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `tou_tiao` -- DROP TABLE IF EXISTS `tou_tiao`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tou_tiao` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '头条点击ID', `AID` varchar(64) DEFAULT '' COMMENT '广告计划ID', `CID` varchar(64) DEFAULT '' COMMENT '广告创意ID', `IDFA` varchar(64) DEFAULT '' COMMENT 'iOS IDFA', `IMEI` varchar(64) DEFAULT '' COMMENT 'imei 码', `ANDROIDID` varchar(64) DEFAULT '' COMMENT '安卓ID', `MAC` varchar(64) DEFAULT '' COMMENT 'MAC地址', `OS` varchar(64) DEFAULT '' COMMENT '操作系统', `TIMESTAMP` varchar(64) DEFAULT '' COMMENT '点击时间', `CALLBACK` varchar(1000) DEFAULT '' COMMENT '回调地址', `IP` varchar(64) DEFAULT '' COMMENT '用户IP', `SIGN` varchar(64) DEFAULT '' COMMENT '签名', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', PRIMARY KEY (`ID`) ) ENGINE=InnoDB AUTO_INCREMENT=459 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `traffic_restriction` -- DROP TABLE IF EXISTS `traffic_restriction`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `traffic_restriction` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `EFFECT_DATE` date NOT NULL, `CITY_CODE` varchar(45) NOT NULL, `CITY_NAME` varchar(45) NOT NULL, `FINE` varchar(1024) DEFAULT '', `RESTRICT_NO` varchar(256) DEFAULT '' COMMENT '限行尾号，用逗号分开', `IS_MATCH` int(11) DEFAULT '1', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) DEFAULT '', `IS_DELETED` int(11) NOT NULL DEFAULT '1', `CREATE_BY` int(11) NOT NULL, `UPDATE_BY` int(11) NOT NULL, `EXTEND` varchar(10000) DEFAULT '', PRIMARY KEY (`ID`), KEY `dateCityIdx` (`EFFECT_DATE`,`CITY_CODE`) ) ENGINE=InnoDB AUTO_INCREMENT=5080 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `travel` -- DROP TABLE IF EXISTS `travel`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `travel` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '行程ID', `TRAVEL_TYPE` int(11) NOT NULL DEFAULT '1' COMMENT '行程类型', `DATE` date NOT NULL COMMENT '行驶日期', `START` timestamp NULL DEFAULT NULL COMMENT '行程开始时间', `START_NAME` varchar(200) NOT NULL DEFAULT '' COMMENT '行程起点', `END` timestamp NULL DEFAULT NULL COMMENT '行程结束时间', `END_NAME` varchar(200) NOT NULL DEFAULT '' COMMENT '行程终点', `MILEAGE` int(11) NOT NULL COMMENT '总行驶里程', `SCH_MILEAGE` int(11) NOT NULL DEFAULT '0' COMMENT '任务里程', `TRAVEL_TIME` int(11) NOT NULL COMMENT '总行驶耗时', `STOP_TIME` int(11) NOT NULL COMMENT '总停留时间', `IDLE_TIME` int(11) NOT NULL DEFAULT '0' COMMENT '怠速时间', `TOTAL_TIME` int(11) DEFAULT NULL COMMENT '总时间', `AVG_SPEED` int(11) NOT NULL COMMENT '平均时速', `MAX_SPEED` int(11) NOT NULL COMMENT '最大时速', `IMEI` varchar(50) NOT NULL DEFAULT '' COMMENT '设备 imei 码', `VEHICLE_ID` int(11) DEFAULT NULL COMMENT '车辆 ID', `DRIVER_ID` int(11) DEFAULT NULL COMMENT '司机 ID', `GROUP_CODE` bigint(20) NOT NULL DEFAULT '0' COMMENT '分组信息', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(5000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `travel_list` (`COMPANY_ID`,`DATE`), KEY `travel_date` (`DATE`,`VEHICLE_ID`), KEY `travel_vehicle` (`VEHICLE_ID`,`DATE`), KEY `travel_driver` (`DRIVER_ID`), KEY `list_all` (`START`,`END`,`TRAVEL_TYPE`,`IMEI`), KEY `list_idle` (`IMEI`,`START`,`END`), KEY `end` (`END`), KEY `t_type` (`TRAVEL_TYPE`) ) ENGINE=InnoDB AUTO_INCREMENT=52802242 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `tts` -- DROP TABLE IF EXISTS `tts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tts` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '语音ID', `COUNTRY_NUMBER` varchar(20) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '国家代码', `PHONE` varchar(20) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '手机号码', `PHONE_X` varchar(45) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '虚拟号专用于隐私保护', `PHONE_B` varchar(45) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '被呼叫人专用于隐私保护', `MODEL` varchar(128) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '语音流水号', `SECONDS` int(11) DEFAULT NULL COMMENT '通话秒数', `FEE` int(11) DEFAULT NULL COMMENT '计费条数', `TEMPLATE` varchar(50) NOT NULL DEFAULT '' COMMENT '语音模板', `DATE` date NOT NULL COMMENT '通话日期', `START_TIME` varchar(20) DEFAULT '' COMMENT '通话开始时间', `END_TIME` varchar(20) DEFAULT '' COMMENT '通话结束时间', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(1000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `model` (`MODEL`,`COMPANY_ID`), KEY `list` (`COMPANY_ID`,`DATE`) ) ENGINE=InnoDB AUTO_INCREMENT=245377 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `user` -- DROP TABLE IF EXISTS `user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `user` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户ID', `USER_NAME` varchar(50) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '用户名', `PASSWORD` varchar(32) NOT NULL COMMENT '密码', `NICKNAME` varchar(50) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '昵称', `COUNTRY_ID` int(11) DEFAULT '1' COMMENT '国家ID', `PHONE` varchar(64) DEFAULT NULL, `SHORT_NUMBER` varchar(20) DEFAULT '' COMMENT '手机号码短号', `EMAIL` varchar(50) DEFAULT '' COMMENT '邮箱地址', `USER_STATUS` int(11) NOT NULL COMMENT '账号状态', `USER_TYPE` int(11) NOT NULL COMMENT '帐号类型', `USER_LANGUAGE` varchar(45) NOT NULL DEFAULT 'zh_cn', `TYPE_ID` int(11) DEFAULT NULL COMMENT '外表 ID，比如当 type=2 时为司机信息 ID', `GROUP_CODE` bigint(20) NOT NULL DEFAULT '0' COMMENT '分组信息', `CREATE_BY` int(11) DEFAULT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) DEFAULT NULL COMMENT '最后更新人 ID', `COMPANY_ID` int(11) DEFAULT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后修改时间', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) DEFAULT '' COMMENT '拓展字段（以json串存储）', `PC_TOKEN` varchar(32) DEFAULT NULL COMMENT 'pc token', `APP_TOKEN` varchar(32) DEFAULT NULL COMMENT 'app token', `OPENID` varchar(64) DEFAULT NULL, `QYWX_OPENID` varchar(64) DEFAULT NULL, `QYWX_USER_ID` varchar(64) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `user_phone` (`PHONE`,`USER_TYPE`,`COMPANY_ID`), KEY `user_driver` (`TYPE_ID`,`USER_TYPE`), KEY `user_type` (`USER_TYPE`), KEY `user_group` (`GROUP_CODE`), KEY `user_pc` (`PC_TOKEN`), KEY `user_app` (`APP_TOKEN`), KEY `user_openid` (`OPENID`), KEY `u_driver` (`COMPANY_ID`,`USER_TYPE`,`IS_DELETED`,`USER_NAME`), KEY `user_qywx` (`QYWX_OPENID`), KEY `qywx_userid` (`QYWX_USER_ID`), KEY `u_name` (`USER_NAME`,`USER_TYPE`), KEY `user_nick_name` (`NICKNAME`) ) ENGINE=InnoDB AUTO_INCREMENT=1050401 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `user_log` -- DROP TABLE IF EXISTS `user_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `user_log` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户登录日志ID', `USER_ID` int(11) NOT NULL COMMENT '登录的用户 ID', `IP` varchar(20) DEFAULT '' COMMENT '登录时的 IP', `STORE` varchar(20) DEFAULT '' COMMENT 'app 的来源', `UNIQ` varchar(50) DEFAULT '' COMMENT '设备唯一识别码', `VERSION` varchar(20) DEFAULT '' COMMENT 'app 版本号', `METHOD` varchar(50) DEFAULT '' COMMENT '调用方法', `COMPANY_ID` int(11) DEFAULT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间', `LOGIN_TYPE` int(11) NOT NULL COMMENT '登录类型', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后操作时间', `TOKEN` varchar(64) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `log_token` (`TOKEN`), KEY `ul_user` (`USER_ID`), KEY `company` (`COMPANY_ID`), KEY `modified` (`GMT_MODIFIED`) ) ENGINE=InnoDB AUTO_INCREMENT=4630259 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `user_menu` -- DROP TABLE IF EXISTS `user_menu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `user_menu` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `COMPANY_ID` int(11) NOT NULL, `SUB_MENU_ID` int(11) NOT NULL, `USER_ID` int(11) NOT NULL, `ORDER_WEIGHT` int(11) NOT NULL DEFAULT '0', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) CHARACTER SET utf8mb4 DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', `CREATE_BY` int(11) NOT NULL, `UPDATE_BY` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `idx` (`COMPANY_ID`,`SUB_MENU_ID`,`USER_ID`), KEY `m_user` (`USER_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=208695 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `user_open_rel` -- DROP TABLE IF EXISTS `user_open_rel`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `user_open_rel` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `USER_ID` int(11) NOT NULL COMMENT '用户ID', `OPEN_ID` varchar(64) CHARACTER SET utf8mb4 NOT NULL DEFAULT '', `OPEN_TYPE` int(11) NOT NULL DEFAULT '1' COMMENT '1 微信 2 支付宝', `OPEN_NAME` varchar(64) CHARACTER SET utf8mb4 DEFAULT NULL, `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1024) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '备注', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '删除标识', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', PRIMARY KEY (`ID`), KEY `ids` (`USER_ID`,`OPEN_ID`,`OPEN_TYPE`,`COMPANY_ID`), KEY `openid` (`OPEN_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=17408 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `vehicle` -- DROP TABLE IF EXISTS `vehicle`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `vehicle` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '车辆ID', `PLATE_NO` varchar(50) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '车牌号码', `VEHICLE_NAME` varchar(50) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '车辆别名', `CAPACITY` float DEFAULT '0' COMMENT '车辆容量（载客量/载货量）', `VEHICLE_MODEL` varchar(50) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '车辆型号', `VEHICLE_STATUS` int(11) NOT NULL COMMENT '车辆状态', `VEHICLE_TYPE` int(11) NOT NULL COMMENT '车辆类型', `VEHICLE_GROUP_ID` int(11) DEFAULT NULL COMMENT '车辆监控分组ID', `VEHICLE_ICON` int(11) DEFAULT '1' COMMENT '车辆图标', `WEIGHT` int(11) NOT NULL DEFAULT '0' COMMENT '车辆排序权重', `WXCODE` varchar(50) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '微信小程序', `DRIVER_ID` int(11) DEFAULT NULL COMMENT '默认司机的ID', `OIL_TYPE` varchar(50) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '油品类型', `DATE_OF_PURCHASE` date DEFAULT NULL COMMENT '购置日期', `INIT_MILES` bigint(20) DEFAULT '0' COMMENT '上次保养里程', `MAINTENANCE_INTERVAL` int(11) DEFAULT NULL COMMENT '保养间隔里程数', `TOTAL_TRAVEL` bigint(20) NOT NULL DEFAULT '0' COMMENT '总行驶里程', `VIN` varchar(50) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '车架号', `ENGINE_NO` varchar(50) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '发动机号', `VIO_TYPE` varchar(10) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '车辆违章类型', `VIO_DATE` bigint(20) unsigned DEFAULT '0' COMMENT '违章查询日期', `DRIVING_LICENSE` varchar(200) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '行驶证', `OPERATING_LICENSE` varchar(200) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '营运许可证', `PIC1` varchar(200) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '其他1', `PIC2` varchar(200) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '其他2', `PIC3` varchar(200) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '其他3', `IMEI` varchar(50) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '车载 gps 设备号', `SPEED_LIMIT` int(11) DEFAULT NULL COMMENT '速度上限', `SPEED_LOW_LIMIT` int(11) DEFAULT NULL COMMENT '国道速度上限', `FATIGUE_LIMIT` int(11) DEFAULT NULL COMMENT '连续行驶时长上限', `STOP_LIMIT` int(11) DEFAULT NULL COMMENT '静止超时', `DEGREE_MAX` float DEFAULT NULL, `DEGREE_MIN` float DEFAULT NULL, `GROUP_CODE` bigint(20) NOT NULL DEFAULT '0' COMMENT '分组信息', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `vehicle_plate` (`PLATE_NO`,`VEHICLE_TYPE`,`COMPANY_ID`), KEY `vehicle_driver` (`DRIVER_ID`,`IMEI`), KEY `vehicle_company` (`COMPANY_ID`), KEY `vio` (`VIO_DATE`), KEY `v_imei` (`IMEI`,`IS_DELETED`,`ID`), KEY `vehicle_group` (`VEHICLE_GROUP_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=141248 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `vehicle_group` -- DROP TABLE IF EXISTS `vehicle_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `vehicle_group` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '分组ID', `NAME` varchar(45) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '分组名字', `PARENT_ID` int(11) NOT NULL DEFAULT '0' COMMENT '分组上级ID', `COMPANY_ID` int(11) NOT NULL COMMENT '公司ID', `CREATE_BY` int(11) NOT NULL COMMENT '创建人 ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人 ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后修改时间', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '是否删除', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `EXTEND` varchar(10000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '拓展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `list` (`COMPANY_ID`,`NAME`) ) ENGINE=InnoDB AUTO_INCREMENT=982 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `vehicle_inspection` -- DROP TABLE IF EXISTS `vehicle_inspection`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `vehicle_inspection` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', `TYPE_ID` int(11) NOT NULL COMMENT '排班ID', `TYPE` int(11) NOT NULL COMMENT '1出车前、2出车后', `VEHICLE_ID` int(11) NOT NULL COMMENT '车辆ID', `DATE` date NOT NULL COMMENT '检查日期', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '修改人ID', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`ID`), KEY `COMPANY_ID` (`COMPANY_ID`), KEY `VEHICLE_ID` (`VEHICLE_ID`), KEY `TYPE_ID` (`TYPE_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `vehicle_maintenance` -- DROP TABLE IF EXISTS `vehicle_maintenance`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `vehicle_maintenance` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '车辆维保ID', `VEHICLE_ID` int(11) NOT NULL COMMENT '车辆ID', `EXPENSE_ID` int(11) DEFAULT NULL COMMENT '关联费用', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GROUP_CODE` bigint(20) NOT NULL DEFAULT '0' COMMENT '分组信息', `MAINTENANCE_TYPE` int(11) NOT NULL COMMENT '1 维修 2 保养 4其他', `AMOUNT` double DEFAULT NULL COMMENT '维保金额', `REPAIRER` varchar(45) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '维修厂', `START_DATE` date NOT NULL COMMENT '起始日期', `END_DATE` date NOT NULL COMMENT '结束日期', `START_TIME` time DEFAULT NULL, `END_TIME` time DEFAULT NULL, `REASON` varchar(1024) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '维保内容', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '删除状态', `MAINTENANCE_STATUS` int(11) NOT NULL DEFAULT '0' COMMENT '0 司机申请；1 通过（或者管理员自己创建）；2 否决', `EXTEND` varchar(4096) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '扩展字段', PRIMARY KEY (`ID`), KEY `ForeginIndex` (`VEHICLE_ID`,`MAINTENANCE_TYPE`,`START_DATE`,`END_DATE`,`IS_DELETED`,`COMPANY_ID`), KEY `create_by` (`CREATE_BY`,`START_DATE`,`END_DATE`), KEY `list` (`COMPANY_ID`,`START_DATE`,`END_DATE`) ) ENGINE=InnoDB AUTO_INCREMENT=11596 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='车辆维保表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `version_method` -- DROP TABLE IF EXISTS `version_method`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `version_method` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `METHOD_NAME` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '方法名', `VERSION_METHOD` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '方法', `VERSION_TYPE` int(11) NOT NULL COMMENT '版本类型', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '是否删除', `CREATE_BY` int(11) NOT NULL COMMENT '创建人', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人', PRIMARY KEY (`ID`), KEY `METHOD_NAME` (`METHOD_NAME`), KEY `VERSION_METHOD` (`VERSION_METHOD`), KEY `VERSION_TYPE` (`VERSION_TYPE`) ) ENGINE=InnoDB AUTO_INCREMENT=701 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `video_file_info` -- DROP TABLE IF EXISTS `video_file_info`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `video_file_info` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `CLIENT_ID` int(11) NOT NULL, `IP` varchar(32) CHARACTER SET utf8mb4 DEFAULT '', `VHOST` varchar(45) CHARACTER SET utf8mb4 DEFAULT '', `APP` varchar(45) CHARACTER SET utf8mb4 DEFAULT '', `STREAM` varchar(45) CHARACTER SET utf8mb4 NOT NULL DEFAULT '', `PARAM` varchar(45) CHARACTER SET utf8mb4 DEFAULT '', `CWD` varchar(45) CHARACTER SET utf8mb4 DEFAULT '', `FILE` varchar(45) CHARACTER SET utf8mb4 NOT NULL DEFAULT '', `COMPANY_ID` int(11) NOT NULL, `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) CHARACTER SET utf8mb4 DEFAULT '', `IS_DELETED` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`ID`), KEY `uniqIdx` (`FILE`,`STREAM`) ) ENGINE=InnoDB AUTO_INCREMENT=23947 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `violation` -- DROP TABLE IF EXISTS `violation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `violation` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '违章记录ID', `VEHICLE_ID` int(11) NOT NULL COMMENT '车辆ID', `DRIVER_ID` int(11) DEFAULT NULL COMMENT '司机ID', `CONTACTS_ID` int(11) DEFAULT NULL COMMENT '用车人ID', `TIME` datetime NOT NULL COMMENT '违章时间', `AREA` varchar(512) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '违章地点', `ACT` varchar(512) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '违章行为', `ARCHIVE_NO` varchar(64) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '文书编号(不一定获取到)', `CODE` varchar(64) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '文书代码(不一定获取到)', `FEN` int(11) DEFAULT NULL COMMENT '违章扣分(仅供参考，不一定有值)', `MONEY` int(11) DEFAULT NULL COMMENT '违章罚款(仅供参考，不一定有值)', `HANDLED` int(11) DEFAULT '1' COMMENT '是否处理,1处理 0未处理 空未知', `IF_PAID` int(11) NOT NULL DEFAULT '0', `CITY` varchar(64) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '违章城市(仅供参考，不一定有值)', `ORGAN` varchar(64) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '采集机关', `VIOLATION_TYPE` int(11) DEFAULT '1' COMMENT '违章记录类型 1.在线查询 2.手动录入', `UPDATE_BY` int(11) DEFAULT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `IS_DELETED` int(11) NOT NULL DEFAULT '1' COMMENT '删除状态', PRIMARY KEY (`ID`), KEY `vio_list` (`COMPANY_ID`,`TIME`), KEY `vio_vehicle` (`VEHICLE_ID`,`TIME`) ) ENGINE=InnoDB AUTO_INCREMENT=7702 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `violation_city` -- DROP TABLE IF EXISTS `violation_city`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `violation_city` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '违章记录ID', `PROVINCE` varchar(45) NOT NULL COMMENT '省份', `PROVINCE_CODE` varchar(45) DEFAULT NULL COMMENT '省份代码', `CITY_NAME` varchar(45) NOT NULL COMMENT '城市', `CITY_CODE` varchar(45) DEFAULT NULL COMMENT '城市代码', `ABBR` varchar(45) DEFAULT NULL COMMENT '车牌前缀', `ENGINE` int(11) DEFAULT NULL COMMENT '是否需要发动机号，0:不需要 1:需要', `ENGINE_NO` int(11) DEFAULT NULL COMMENT '需要几位发动机号0:全部 1-9 :需要发动机号后N位', `CLASS_A` int(11) DEFAULT NULL COMMENT '是否需要车架号0,不需要 1,需要', `CLASS_NO` int(11) DEFAULT NULL COMMENT '需要几位车架号0:全部 1-9: 需要车架号后N位', `REGIST` int(11) DEFAULT NULL, `REGIST_NO` int(11) DEFAULT NULL, `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `PROVINCE` (`PROVINCE`), KEY `CITY_NAME` (`CITY_NAME`) ) ENGINE=InnoDB AUTO_INCREMENT=273 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `work_detail` -- DROP TABLE IF EXISTS `work_detail`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `work_detail` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `COMPANY_ID` int(11) NOT NULL, `WORK_TIME_ID` int(11) NOT NULL, `TYPE` int(11) NOT NULL COMMENT '1 上班打卡 2 下班打卡', `USER_ID` int(11) NOT NULL COMMENT '打卡人', `ACTUAL_TIME` datetime NOT NULL COMMENT '实际打卡时间', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1000) DEFAULT NULL, `EXTEND` varchar(10000) DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', `CREATE_BY` int(11) NOT NULL, `UPDATE_BY` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `ids` (`COMPANY_ID`,`WORK_TIME_ID`,`USER_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=2806 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `work_time` -- DROP TABLE IF EXISTS `work_time`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `work_time` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `COMPANY_ID` int(11) NOT NULL, `START_TIME` time NOT NULL, `END_TIME` time NOT NULL, `WEEK` int(11) NOT NULL COMMENT '班次日期', `NAME` varchar(128) NOT NULL, `GROUP_CODE` bigint(20) NOT NULL DEFAULT '0' COMMENT '分组信息', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1000) DEFAULT NULL, `EXTEND` varchar(10000) DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', `CREATE_BY` int(11) NOT NULL, `UPDATE_BY` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `ids` (`COMPANY_ID`,`WEEK`) ) ENGINE=InnoDB AUTO_INCREMENT=108 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `work_time_driver_rel` -- DROP TABLE IF EXISTS `work_time_driver_rel`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `work_time_driver_rel` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `WORK_TIME_ID` int(11) NOT NULL COMMENT '考勤班次ID', `DRIVER_ID` int(11) NOT NULL COMMENT '司机ID', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', `COMPANY_ID` int(11) NOT NULL, `CREATE_BY` int(11) NOT NULL, `UPDATE_BY` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `workTimeId` (`WORK_TIME_ID`), KEY `driverId` (`DRIVER_ID`), KEY `companyId` (`COMPANY_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=1595 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `workflow` -- DROP TABLE IF EXISTS `workflow`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `workflow` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `NAME` varchar(45) NOT NULL, `COMPANY_ID` int(11) NOT NULL, `APPROVAL_TYPE` int(11) NOT NULL, `GROUP_CODE` bigint(20) NOT NULL DEFAULT '0' COMMENT '分组信息', `TYPE_ID` int(11) DEFAULT NULL COMMENT '订单类型ID', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', `CREATE_BY` int(11) NOT NULL, `UPDATE_BY` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `list` (`COMPANY_ID`,`APPROVAL_TYPE`) ) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4 COMMENT='工作流'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `workflow_node` -- DROP TABLE IF EXISTS `workflow_node`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `workflow_node` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `COMPANY_ID` int(11) NOT NULL, `WORKFLOW_ID` int(11) NOT NULL, `NAME` varchar(45) NOT NULL, `TYPE` int(11) NOT NULL DEFAULT '1' COMMENT '发起人， 审批人 ，抄送', `PARENT_ID` int(11) NOT NULL DEFAULT '0', `SELECT_TYPE` int(11) NOT NULL DEFAULT '1' COMMENT '指定成员，发起人自选，上级', `ACTION_TYPE` int(11) NOT NULL DEFAULT '1' COMMENT '依次审批 会签 或签', `DIRECTOR_LEVEL` int(11) NOT NULL DEFAULT '1', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', `CREATE_BY` int(11) NOT NULL, `UPDATE_BY` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `idx` (`COMPANY_ID`,`WORKFLOW_ID`,`PARENT_ID`), KEY `workflow` (`WORKFLOW_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=432 DEFAULT CHARSET=utf8mb4 COMMENT='工作流节点'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `workflow_user` -- DROP TABLE IF EXISTS `workflow_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `workflow_user` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `COMPANY_ID` int(11) NOT NULL, `WORKFLOW_ID` int(11) NOT NULL, `WORKFLOW_NODE_ID` int(11) NOT NULL, `USER_ID` int(11) NOT NULL, `TYPE` int(11) NOT NULL DEFAULT '1', `GMT_CREATED` datetime NOT NULL, `GMT_MODIFIED` datetime NOT NULL, `REMARK` varchar(1024) DEFAULT NULL, `IS_DELETED` int(11) NOT NULL DEFAULT '1', `CREATE_BY` int(11) NOT NULL, `UPDATE_BY` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `idx` (`COMPANY_ID`,`WORKFLOW_NODE_ID`,`USER_ID`), KEY `workflow` (`WORKFLOW_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=191 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `zu` -- DROP TABLE IF EXISTS `zu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `zu` ( `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '分组ID', `GROUP_NAME` varchar(50) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '分组名字', `CODE` bigint(20) NOT NULL DEFAULT '0' COMMENT '分组编码', `CREATE_BY` int(11) NOT NULL COMMENT '创建人ID', `UPDATE_BY` int(11) NOT NULL COMMENT '最后更新人ID', `COMPANY_ID` int(11) NOT NULL COMMENT '所属公司ID', `GMT_CREATED` datetime NOT NULL COMMENT '创建时间（不可修改）', `GMT_MODIFIED` datetime NOT NULL COMMENT '最后更新时间', `REMARK` varchar(1000) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '备注', `IS_DELETED` int(11) NOT NULL COMMENT '删除状态', `EXTEND` varchar(10000) DEFAULT '' COMMENT '扩展字段（以json串存储）', PRIMARY KEY (`ID`), KEY `zu_company` (`COMPANY_ID`), KEY `zu_name` (`COMPANY_ID`,`GROUP_NAME`), KEY `zu_list` (`COMPANY_ID`,`CODE`), KEY `zu_code` (`CODE`) ) ENGINE=InnoDB AUTO_INCREMENT=42071 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2021-11-25 16:30:17