/*
SQLyog 企业版 - MySQL GUI v8.14
MySQL - 5.7.18-log : Database - logisticssystem
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!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 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`logisticssystem` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `logisticssystem`;
/*Table structure for table `b_approvalrecord` */
DROP TABLE IF EXISTS `b_approvalrecord`;
CREATE TABLE `b_approvalrecord` (
`ApprovalRecordID` int(11) NOT NULL AUTO_INCREMENT COMMENT '审批记录ID',
`OrderFormID` int(11) NOT NULL COMMENT '订单ID',
`ApproverID` int(11) DEFAULT NULL COMMENT '审批人ID',
PRIMARY KEY (`ApprovalRecordID`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;
/*Data for the table `b_approvalrecord` */
insert into `b_approvalrecord`(`ApprovalRecordID`,`OrderFormID`,`ApproverID`) values (1,12,2),(2,13,2),(3,10,2),(4,16,2),(5,11,2),(6,45,2),(33,45,2),(34,14,2);
/*Table structure for table `b_attendance` */
DROP TABLE IF EXISTS `b_attendance`;
CREATE TABLE `b_attendance` (
`AttendanceID` int(11) NOT NULL AUTO_INCREMENT COMMENT '考勤ID',
`AuditorID` int(11) DEFAULT NULL COMMENT '审核人ID',
`UserID` int(11) NOT NULL COMMENT '用户ID',
`CarID` int(11) DEFAULT NULL COMMENT '车辆ID',
`IsRatification` bit(1) DEFAULT NULL COMMENT '批准否',
`StartWorkTime` datetime DEFAULT NULL COMMENT '上班时间',
`OffWork` datetime DEFAULT NULL COMMENT '下班时间',
`Remark` varchar(100) DEFAULT NULL COMMENT '备注',
`Mark` varchar(20) NOT NULL COMMENT '区分上下班',
`IsAudit` bit(1) DEFAULT NULL COMMENT '审核否',
`AuditTime` datetime DEFAULT NULL COMMENT '审核时间',
`ApplicationTime` datetime DEFAULT NULL COMMENT '申请时间',
`Reason` varchar(100) DEFAULT NULL COMMENT '请假理由',
`LeaveDay` varchar(20) DEFAULT NULL COMMENT '请假天数',
`StartMileage` float DEFAULT NULL COMMENT '上班的车辆里程',
`StartOilMass` float DEFAULT NULL COMMENT '上班车辆油量',
`StartLocation` varchar(100) DEFAULT NULL COMMENT '上班车辆位置',
`OffMileage` float DEFAULT NULL COMMENT '下帮的车辆里程',
`OffOilMass` float DEFAULT NULL COMMENT '下班的车辆油量',
`OffLocation` varchar(100) DEFAULT NULL COMMENT '下班的车辆位置',
PRIMARY KEY (`AttendanceID`)
) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8;
/*Data for the table `b_attendance` */
insert into `b_attendance`(`AttendanceID`,`AuditorID`,`UserID`,`CarID`,`IsRatification`,`StartWorkTime`,`OffWork`,`Remark`,`Mark`,`IsAudit`,`AuditTime`,`ApplicationTime`,`Reason`,`LeaveDay`,`StartMileage`,`StartOilMass`,`StartLocation`,`OffMileage`,`OffOilMass`,`OffLocation`) values (1,0,1,NULL,NULL,'2018-06-06 08:00:00','2018-06-06 18:00:00',NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,0,1,NULL,NULL,'2018-06-07 08:00:00','2018-06-07 18:00:00',NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,0,1,NULL,'','2018-06-08 15:07:36','2018-06-08 21:05:39',NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,0,1,NULL,'','2018-06-09 08:09:26','2018-06-08 21:05:39','已批准,可以下班了!','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,0,1,NULL,NULL,'2018-06-10 21:39:12',NULL,NULL,'上班已签到',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,0,1,NULL,'','2018-06-11 16:13:26','2018-06-11 18:04:19',NULL,'下班已签到','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,0,1,NULL,'\0','2018-07-20 15:59:05','2018-07-21 17:05:16',NULL,'下班已签到',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,0,1,NULL,'','2018-07-22 16:43:07','2018-07-22 17:02:13','测试','下班已签到','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,0,1,NULL,'\0','2018-07-26 20:11:04','2018-07-27 14:35:29',NULL,'下班已签到',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,0,1,NULL,'\0','2018-07-28 19:42:29','2018-07-29 20:02:53',NULL,'下班已签到',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,0,1,NULL,'\0','2018-07-30 10:31:04','2018-07-31 08:55:09',NULL,'下班已签到',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,0,1,NULL,'\0','2018-07-31 21:06:29','2018-08-03 20:54:40',NULL,'下班已签到',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,0,3,NULL,'\0','2018-08-01 08:43:46','2018-08-04 11:40:03',NULL,'下班已签到',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,0,2,NULL,'\0','2018-08-01 08:47:50','2018-08-01 21:34:44',NULL,'下班已签到',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,0,2,NULL,'\0','2018-08-02 14:42:59','2018-08-03 09:31:40',NULL,'下班已签到',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,0,2,NULL,'\0','2018-08-04 09:33:41','2018-08-05 19:43:34',NULL,'下班已签到',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,0,1,NULL,'\0','2018-08-04 11:09:53','2018-08-07 09:16:16',NULL,'下班已签到',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,0,2,NULL,'\0','2018-08-06 08:40:36','2018-08-07 16:31:35',NULL,'下班已签到',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,0,4,NULL,'\0','2018-08-07 20:59:42','2018-09-11 20:15:56',NULL,'下班已签到',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,0,6,NULL,'\0','2018-08-08 20:30:12','2018-08-09 09:28:23',NULL,'下班已签到',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,0,1,NULL,'\0','2018-08-09 09:17:23','2018-08-12 20:44:57',NULL,'下班已签到',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,0,2,NULL,'\0','2018-08-10 09:49:42','2018-08-13 11:43:48',NULL,'下班已签到',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,0,8,NULL,'\0','2018-08-10 20:43:18','2018-08-13 15:54:16',NULL,'下班已签到',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,0,9,NULL,'\0','2018-08-13 09:22:29','2018-08-29 16:00:44',NULL,'下班已签到',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,0,1,NULL,'\0','2018-08-14 16:44:33','2018-08-16 10:44:55',NULL,'下班已签到',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,0,2,NULL,'\0','2018-08-14 20:43:10','2018-09-01 09:33:34',NULL,'下班已签到',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,0,8,NULL,'\0','2018-08-21 14:57:49','2018-08-27 09:27:40',NULL,'下班已签到',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,0,1,NULL,'\0','2018-08-21 16:30:50','2018-08-25 08:06:40',NULL,'下班已签到',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,0,1,NULL,'\0','2018-08-27 08:04:49','2018-08-29 15:59:22',NULL,'下班已签到',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,0,7,NULL,'\0','2018-08-27 09:45:37','2018-08-29 09:06:16',NULL,'下班已签到',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,0,7,NULL,'\0','2018-08-30 11:16:25','2018-09-11 20:08:34',NULL,'下班已签到',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,0,1,NULL,'\0','2018-09-01 15:19:50','2018-09-08 11:00:56',NULL,'下班已签到',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,0,8,NULL,'\0','2018-09-01 15:56:41','2018-09-03 11:17:52',NULL,'下班已签到',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,0,9,NULL,'\0','2018-09-02 20:22:51','2018-09-04 20:07:53',NULL,'下班已签到',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,0,8,NULL,'','2018-09-04 16:48:28','2018-09-05 09:40:10',NULL,'下班已签到','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,0,9,NULL,'\0','2018-09-05 11:05:57','2018-09-05