diff --git a/leaveschool/leaving/src/main/java/com/supwisdom/leaveschool/leaving/config/FilterConfig.java b/leaveschool/leaving/src/main/java/com/supwisdom/leaveschool/leaving/config/FilterConfig.java
index dfd5712..53dffa2 100644
--- a/leaveschool/leaving/src/main/java/com/supwisdom/leaveschool/leaving/config/FilterConfig.java
+++ b/leaveschool/leaving/src/main/java/com/supwisdom/leaveschool/leaving/config/FilterConfig.java
@@ -4,6 +4,7 @@
 import org.springframework.web.servlet.config.annotation.CorsRegistry;
 import org.springframework.web.servlet.config.annotation.WebMvcConfigurerAdapter;
 
+@SuppressWarnings("deprecation")
 @Configuration
 public class FilterConfig extends WebMvcConfigurerAdapter{
 
diff --git a/leaveschool/leaving/src/main/java/com/supwisdom/leaveschool/leaving/controller/Api1AuditNodeController.java b/leaveschool/leaving/src/main/java/com/supwisdom/leaveschool/leaving/controller/Api1AuditNodeController.java
index 15c1c7d..fe86559 100644
--- a/leaveschool/leaving/src/main/java/com/supwisdom/leaveschool/leaving/controller/Api1AuditNodeController.java
+++ b/leaveschool/leaving/src/main/java/com/supwisdom/leaveschool/leaving/controller/Api1AuditNodeController.java
@@ -1,5 +1,7 @@
 package com.supwisdom.leaveschool.leaving.controller;
 
+import java.util.List;
+
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.http.HttpStatus;
 import org.springframework.util.MimeTypeUtils;
@@ -8,10 +10,10 @@
 import org.springframework.web.bind.annotation.ResponseStatus;
 import org.springframework.web.bind.annotation.RestController;
 
-import com.supwisdom.leaveschool.common.controller.api.CrudApiController;
 import com.supwisdom.leaveschool.common.model.PagerRequestModel;
 import com.supwisdom.leaveschool.common.model.PagerResponseModel;
 import com.supwisdom.leaveschool.leaving.domain.AuditNode;
+import com.supwisdom.leaveschool.leaving.repository.AuditNode1Repository;
 import com.supwisdom.leaveschool.leaving.repository.AuditNodeRepository;
 
 import io.swagger.annotations.ApiImplicitParam;
@@ -20,15 +22,12 @@
 
 @RestController
 @RequestMapping("/api/v1/leaving/audit_node")
-public class Api1AuditNodeController extends CrudApiController<AuditNode, AuditNodeRepository>{
+public class Api1AuditNodeController{
 	
 	@Autowired
 	private AuditNodeRepository auditNodeRepository;
-	
-	@Override
-	protected AuditNodeRepository getRepository() {
-		return auditNodeRepository;
-	}
+	@Autowired
+	private AuditNode1Repository auditNode1Repository;
 	
 	@GetMapping(path = "/getById",produces = MimeTypeUtils.APPLICATION_JSON_VALUE)
 	@ResponseStatus(value = HttpStatus.OK)
@@ -50,19 +49,28 @@
 	
 	@GetMapping(path = "/pageList",produces = MimeTypeUtils.APPLICATION_JSON_VALUE)
 	@ResponseStatus(value = HttpStatus.OK)
-	@ApiOperation(value="根据查询条件获取审核环节列表",notes="注意问题点")
+	@ApiOperation(value="根据查询条件获取审核环节分页列表",notes="注意问题点")
 	@ApiImplicitParams({
 		@ApiImplicitParam(name = "pageIndex", value = "当前第页数，默认0，为第一页", dataType = "integer",required = true,  paramType = "query", defaultValue = "0"),
 		@ApiImplicitParam(name = "pageSize", value = "每页条数，默认20", dataType = "integer",required = true,  paramType = "query", defaultValue = "20"),
 		@ApiImplicitParam(name = "name", value = "审核环节名称", dataType = "string",required = false,  paramType = "query", defaultValue = ""),
 		@ApiImplicitParam(name = "auditType", value = "审核方式", dataType = "string",required = false,  paramType = "query", defaultValue = "")
 	})
-	public PagerResponseModel<AuditNode> list(String name,String auditType, PagerRequestModel pagerRequestModel){
-		
-		
+	public PagerResponseModel<AuditNode> pageList(String name,String auditType, PagerRequestModel pagerRequestModel){
 		return null;
 	}
 	
+	@GetMapping(path = "/list",produces = MimeTypeUtils.APPLICATION_JSON_VALUE)
+	@ResponseStatus(value = HttpStatus.OK)
+	@ApiOperation(value="根据查询条件获取审核环节List",notes="注意问题点")
+	@ApiImplicitParams({
+		@ApiImplicitParam(name = "name", value = "审核环节名称", dataType = "string",required = false,  paramType = "query", defaultValue = ""),
+		@ApiImplicitParam(name = "auditType", value = "审核方式", dataType = "string",required = false,  paramType = "query", defaultValue = "")
+	})
+	public List<AuditNode> list(String name,String auditType, PagerRequestModel pagerRequestModel){
+		return auditNode1Repository.getList(null);
+	}
+	
 	
 	
 	
diff --git a/leaveschool/leaving/src/main/java/com/supwisdom/leaveschool/leaving/repository/AuditNode1Repository.java b/leaveschool/leaving/src/main/java/com/supwisdom/leaveschool/leaving/repository/AuditNode1Repository.java
new file mode 100644
index 0000000..a7371f6
--- /dev/null
+++ b/leaveschool/leaving/src/main/java/com/supwisdom/leaveschool/leaving/repository/AuditNode1Repository.java
@@ -0,0 +1,27 @@
+package com.supwisdom.leaveschool.leaving.repository;
+
+import java.util.List;
+
+import javax.persistence.EntityManager;
+
+import org.springframework.data.jpa.repository.support.SimpleJpaRepository;
+import org.springframework.stereotype.Component;
+
+import com.supwisdom.leaveschool.leaving.domain.AuditNode;
+
+@Component
+public class AuditNode1Repository extends SimpleJpaRepository<AuditNode, String>{
+	
+	private EntityManager entityManager;
+	
+	public AuditNode1Repository(Class<AuditNode> domainClass, EntityManager em) {
+		super(domainClass, em);
+		this.entityManager = em;
+	}
+	
+	public List<AuditNode>  getList(String id) {
+		List<AuditNode> list = entityManager.createNativeQuery("select * from TB_L_AUDIT_NODE").getResultList();
+		return list;
+	}
+
+}
diff --git a/leaveschool/leaving/src/main/java/com/supwisdom/leaveschool/leaving/repository/AuditNodeRepository.java b/leaveschool/leaving/src/main/java/com/supwisdom/leaveschool/leaving/repository/AuditNodeRepository.java
index 32e81c5..a859026 100644
--- a/leaveschool/leaving/src/main/java/com/supwisdom/leaveschool/leaving/repository/AuditNodeRepository.java
+++ b/leaveschool/leaving/src/main/java/com/supwisdom/leaveschool/leaving/repository/AuditNodeRepository.java
@@ -1,5 +1,8 @@
 package com.supwisdom.leaveschool.leaving.repository;
 
+import java.util.List;
+
+import org.springframework.data.jpa.repository.Query;
 import org.springframework.stereotype.Repository;
 
 import com.supwisdom.leaveschool.common.repository.BaseJpaRepository;
@@ -7,5 +10,8 @@
 
 @Repository
 public interface AuditNodeRepository extends BaseJpaRepository<AuditNode>{
-
+	
+	
+	@Query()
+	public List<AuditNode> getList();
 }
diff --git a/leaveschool/leaving/src/main/java/com/supwisdom/leaveschool/leaving/viewModel/AuditNodeModel.java b/leaveschool/leaving/src/main/java/com/supwisdom/leaveschool/leaving/viewModel/AuditNodeModel.java
new file mode 100644
index 0000000..a02b990
--- /dev/null
+++ b/leaveschool/leaving/src/main/java/com/supwisdom/leaveschool/leaving/viewModel/AuditNodeModel.java
@@ -0,0 +1,111 @@
+package com.supwisdom.leaveschool.leaving.viewModel;
+
+import com.supwisdom.leaveschool.leaving.domain.basicdata.Department;
+import com.supwisdom.leaveschool.leaving.domain.enums.AuditType;
+import com.supwisdom.leaveschool.leaving.domain.enums.DefaultAuditStatus;
+import com.supwisdom.leaveschool.leaving.domain.enums.Scope;
+import com.supwisdom.leaveschool.leaving.viewModel.common.BaseModel;
+
+public class AuditNodeModel extends BaseModel{
+
+	private static final long serialVersionUID = 4394536154933574896L;
+	
+	/**
+	 * 名称
+	 */
+	private String name;
+	/**
+	 * 联系人
+	 */
+	private String contact;
+	
+	/**
+	 * 所属部门
+	 */
+	private Department department;
+	
+	/**
+	 * 联系电话
+	 */
+	private String phoneNumber;	
+	
+	/**
+	 * 范围控制（全校范围、院系范围、辅导员范围）
+	 */
+	private Scope scope;
+	
+	/**
+	 * 审核方式（手动、自动，默认手动）
+	 */
+	private AuditType auditType;
+	
+	/**
+	 * 审核状态（待审核、审核通过、审核不通过 ，默认待审核）
+	 */
+	private DefaultAuditStatus defaultAuditStatus;
+	
+	/**
+	 * 审核环节职责
+	 */
+	private String auditNodeDuty;
+	
+	/**
+	 * 审核环节地址
+	 */
+	private String auditNodeAddress;
+	
+	public String getName() {
+		return name;
+	}
+	public void setName(String name) {
+		this.name = name;
+	}
+	public String getContact() {
+		return contact;
+	}
+	public void setContact(String contact) {
+		this.contact = contact;
+	}
+	public Department getDepartment() {
+		return department;
+	}
+	public void setDepartment(Department department) {
+		this.department = department;
+	}
+	public String getPhoneNumber() {
+		return phoneNumber;
+	}
+	public void setPhoneNumber(String phoneNumber) {
+		this.phoneNumber = phoneNumber;
+	}
+	public Scope getScope() {
+		return scope;
+	}
+	public void setScope(Scope scope) {
+		this.scope = scope;
+	}
+	public AuditType getAuditType() {
+		return auditType;
+	}
+	public void setAuditType(AuditType auditType) {
+		this.auditType = auditType;
+	}
+	public DefaultAuditStatus getDefaultAuditStatus() {
+		return defaultAuditStatus;
+	}
+	public void setDefaultAuditStatus(DefaultAuditStatus defaultAuditStatus) {
+		this.defaultAuditStatus = defaultAuditStatus;
+	}
+	public String getAuditNodeDuty() {
+		return auditNodeDuty;
+	}
+	public void setAuditNodeDuty(String auditNodeDuty) {
+		this.auditNodeDuty = auditNodeDuty;
+	}
+	public String getAuditNodeAddress() {
+		return auditNodeAddress;
+	}
+	public void setAuditNodeAddress(String auditNodeAddress) {
+		this.auditNodeAddress = auditNodeAddress;
+	}
+}
diff --git a/leaveschool/leaving/src/main/java/com/supwisdom/leaveschool/leaving/viewModel/common/BaseModel.java b/leaveschool/leaving/src/main/java/com/supwisdom/leaveschool/leaving/viewModel/common/BaseModel.java
new file mode 100644
index 0000000..00644d9
--- /dev/null
+++ b/leaveschool/leaving/src/main/java/com/supwisdom/leaveschool/leaving/viewModel/common/BaseModel.java
@@ -0,0 +1,43 @@
+package com.supwisdom.leaveschool.leaving.viewModel.common;
+
+import java.io.Serializable;
+
+public class BaseModel  implements Serializable {
+	
+	private static final long serialVersionUID = -466583573597500155L;
+
+	private String id;
+	/**
+	 * 是否删除  0：有效  1：删除  默认有效
+	 */
+	private Boolean deleted = false;
+	/**
+	 * 操作人用户名
+	 */
+	private String operatorUaseName;
+
+	public String getId() {
+		return id;
+	}
+
+	public void setId(String id) {
+		this.id = id;
+	}
+
+	public Boolean getDeleted() {
+		return deleted;
+	}
+
+	public void setDeleted(Boolean deleted) {
+		this.deleted = deleted;
+	}
+
+	public String getOperatorUaseName() {
+		return operatorUaseName;
+	}
+
+	public void setOperatorUaseName(String operatorUaseName) {
+		this.operatorUaseName = operatorUaseName;
+	}
+	
+}
diff --git a/leaveschool/leaving/src/main/resources/db/leave_school.sql b/leaveschool/leaving/src/main/resources/db/leave_school.sql
new file mode 100644
index 0000000..077c029
--- /dev/null
+++ b/leaveschool/leaving/src/main/resources/db/leave_school.sql
@@ -0,0 +1,443 @@
+/*
+Navicat MySQL Data Transfer
+
+Source Server         : 180.166.150.114
+Source Server Version : 50640
+Source Host           : 180.166.150.114:9512
+Source Database       : leave_school
+
+Target Server Type    : MYSQL
+Target Server Version : 50640
+File Encoding         : 65001
+
+Date: 2018-08-29 14:06:26
+*/
+
+SET FOREIGN_KEY_CHECKS=0;
+
+-- ----------------------------
+-- Table structure for tb_b_classes
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_b_classes`;
+CREATE TABLE `tb_b_classes` (
+  `ID` varchar(255) COLLATE utf8_bin NOT NULL,
+  `ADD_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '创建人',
+  `ADD_TIME` datetime DEFAULT NULL COMMENT '创建时间',
+  `COMPANY_ID` varchar(200) COLLATE utf8_bin DEFAULT NULL,
+  `DELETE_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '删除人',
+  `DELETE_TIME` datetime DEFAULT NULL COMMENT '删除时间',
+  `DELETED` int(1) DEFAULT '1' COMMENT '是否删除  0：有效  1：删除',
+  `EDIT_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '修改人',
+  `EDIT_TIME` datetime DEFAULT NULL COMMENT '修改时间',
+  `CODE` varchar(120) COLLATE utf8_bin NOT NULL COMMENT '班级代码',
+  `ENABLED` int(11) DEFAULT '1' COMMENT '是否可用',
+  `NAME` varchar(120) COLLATE utf8_bin NOT NULL COMMENT '班级名称',
+  `YEAR` varchar(120) COLLATE utf8_bin NOT NULL COMMENT '年级（yyyy）',
+  `DEPARTMENT_ID` varchar(100) COLLATE utf8_bin NOT NULL COMMENT '所在院系,引用字典类型表id',
+  `MAJOR_ID` varchar(100) COLLATE utf8_bin NOT NULL COMMENT '所在专业,引用专业表id',
+  PRIMARY KEY (`ID`),
+  UNIQUE KEY `UK_aqmo5w1r2s7davfgemc3h4axn` (`CODE`),
+  UNIQUE KEY `UK_c5v6yi0lxjc8k6nhls8uecixa` (`YEAR`),
+  KEY `FK1auavp3s3m4okk6nu5ra0tnpm` (`DEPARTMENT_ID`),
+  KEY `FKjr0gsjf99maynvyupwi7wvgti` (`MAJOR_ID`),
+  CONSTRAINT `FK1auavp3s3m4okk6nu5ra0tnpm` FOREIGN KEY (`DEPARTMENT_ID`) REFERENCES `tb_b_department` (`ID`),
+  CONSTRAINT `FKjr0gsjf99maynvyupwi7wvgti` FOREIGN KEY (`MAJOR_ID`) REFERENCES `tb_b_major` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='班级表';
+
+-- ----------------------------
+-- Table structure for tb_b_department
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_b_department`;
+CREATE TABLE `tb_b_department` (
+  `ID` varchar(255) COLLATE utf8_bin NOT NULL,
+  `ADD_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '创建人',
+  `ADD_TIME` datetime DEFAULT NULL COMMENT '创建时间',
+  `COMPANY_ID` varchar(200) COLLATE utf8_bin DEFAULT NULL,
+  `DELETE_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '删除人',
+  `DELETE_TIME` datetime DEFAULT NULL COMMENT '删除时间',
+  `DELETED` int(1) DEFAULT '1' COMMENT '是否删除  0：有效  1：删除',
+  `EDIT_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '修改人',
+  `EDIT_TIME` datetime DEFAULT NULL COMMENT '修改时间',
+  `CODE` varchar(120) COLLATE utf8_bin NOT NULL COMMENT '单位代码',
+  `EN_NAME` varchar(200) COLLATE utf8_bin NOT NULL COMMENT '单位英文名称',
+  `ENABLED` int(11) DEFAULT '1' COMMENT '是否可用',
+  `NAME` varchar(200) COLLATE utf8_bin NOT NULL COMMENT '单位简称',
+  `SORT` int(11) DEFAULT NULL COMMENT '排序',
+  `CLASS_CODE` varchar(100) COLLATE utf8_bin NOT NULL COMMENT '类别码,引用字典类型表id',
+  PRIMARY KEY (`ID`),
+  UNIQUE KEY `UK_k1ayr1evmn7vp2t97x9o2kdih` (`CODE`),
+  KEY `FKk7pvj4yi40cl0pvfu00jjto6` (`CLASS_CODE`),
+  CONSTRAINT `FKk7pvj4yi40cl0pvfu00jjto6` FOREIGN KEY (`CLASS_CODE`) REFERENCES `tb_b_dictionary` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='部门院系表';
+
+-- ----------------------------
+-- Table structure for tb_b_dictionary
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_b_dictionary`;
+CREATE TABLE `tb_b_dictionary` (
+  `ID` varchar(255) COLLATE utf8_bin NOT NULL,
+  `ADD_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '创建人',
+  `ADD_TIME` datetime DEFAULT NULL COMMENT '创建时间',
+  `COMPANY_ID` varchar(200) COLLATE utf8_bin DEFAULT NULL,
+  `DELETE_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '删除人',
+  `DELETE_TIME` datetime DEFAULT NULL COMMENT '删除时间',
+  `DELETED` int(1) DEFAULT '1' COMMENT '是否删除  0：有效  1：删除',
+  `EDIT_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '修改人',
+  `EDIT_TIME` datetime DEFAULT NULL COMMENT '修改时间',
+  `CODE` varchar(120) COLLATE utf8_bin NOT NULL COMMENT '字典代码',
+  `TB_B_DICTIONARY_TYPE_ID` tinyblob,
+  `ENABLED` int(11) DEFAULT '1' COMMENT '是否可用',
+  `NAME` varchar(200) COLLATE utf8_bin NOT NULL COMMENT '名称',
+  `SORT` int(11) DEFAULT NULL COMMENT '排序',
+  PRIMARY KEY (`ID`),
+  UNIQUE KEY `UK_q80b6qny1fja7wg6wyudyechm` (`CODE`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='字典表';
+
+-- ----------------------------
+-- Table structure for tb_b_dictionary_type
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_b_dictionary_type`;
+CREATE TABLE `tb_b_dictionary_type` (
+  `ID` varchar(255) COLLATE utf8_bin NOT NULL,
+  `CODE` varchar(120) COLLATE utf8_bin NOT NULL COMMENT '类型码',
+  `NAME` varchar(200) COLLATE utf8_bin NOT NULL COMMENT '名称',
+  `SORT` int(11) DEFAULT NULL COMMENT '排序',
+  `ENABLED` int(11) DEFAULT '1' COMMENT '是否可用',
+  `ADD_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '创建人',
+  `ADD_TIME` datetime DEFAULT NULL COMMENT '创建时间',
+  `COMPANY_ID` varchar(200) COLLATE utf8_bin DEFAULT NULL,
+  `DELETE_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '删除人',
+  `DELETE_TIME` datetime DEFAULT NULL COMMENT '删除时间',
+  `DELETED` int(1) DEFAULT '1' COMMENT '是否删除  0：有效  1：删除',
+  `EDIT_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '修改人',
+  `EDIT_TIME` datetime DEFAULT NULL COMMENT '修改时间',
+  PRIMARY KEY (`ID`),
+  UNIQUE KEY `UK_tbbcrrq6sxlu20h5618hrd51r` (`CODE`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='字典类型表';
+
+-- ----------------------------
+-- Table structure for tb_b_major
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_b_major`;
+CREATE TABLE `tb_b_major` (
+  `ID` varchar(255) COLLATE utf8_bin NOT NULL,
+  `ADD_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '创建人',
+  `ADD_TIME` datetime DEFAULT NULL COMMENT '创建时间',
+  `COMPANY_ID` varchar(200) COLLATE utf8_bin DEFAULT NULL,
+  `DELETE_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '删除人',
+  `DELETE_TIME` datetime DEFAULT NULL COMMENT '删除时间',
+  `DELETED` int(1) DEFAULT '1' COMMENT '是否删除  0：有效  1：删除',
+  `EDIT_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '修改人',
+  `EDIT_TIME` datetime DEFAULT NULL COMMENT '修改时间',
+  `CODE` varchar(120) COLLATE utf8_bin NOT NULL COMMENT '专业代码',
+  `ENABLED` int(11) DEFAULT '1' COMMENT '是否可用',
+  `GB_MAJOR` varchar(200) COLLATE utf8_bin DEFAULT NULL COMMENT '所属国标专业',
+  `DEPARTMENT_ID` varchar(100) COLLATE utf8_bin NOT NULL COMMENT '所在院系,引用字典类型表id',
+  PRIMARY KEY (`ID`),
+  UNIQUE KEY `UK_b0m1172bkbvr9lf3krdueb545` (`CODE`),
+  KEY `FKgf8aht9hqgj65q62wnlcnws7i` (`DEPARTMENT_ID`),
+  CONSTRAINT `FKgf8aht9hqgj65q62wnlcnws7i` FOREIGN KEY (`DEPARTMENT_ID`) REFERENCES `tb_b_department` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='专业表';
+
+-- ----------------------------
+-- Table structure for tb_b_year
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_b_year`;
+CREATE TABLE `tb_b_year` (
+  `ID` varchar(255) COLLATE utf8_bin NOT NULL,
+  `ADD_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '创建人',
+  `ADD_TIME` datetime DEFAULT NULL COMMENT '创建时间',
+  `COMPANY_ID` varchar(200) COLLATE utf8_bin DEFAULT NULL,
+  `DELETE_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '删除人',
+  `DELETE_TIME` datetime DEFAULT NULL COMMENT '删除时间',
+  `DELETED` int(1) DEFAULT '1' COMMENT '是否删除  0：有效  1：删除',
+  `EDIT_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '修改人',
+  `EDIT_TIME` datetime DEFAULT NULL COMMENT '修改时间',
+  `CODE` varchar(120) COLLATE utf8_bin NOT NULL COMMENT '学年代码',
+  `NAME` varchar(200) COLLATE utf8_bin NOT NULL COMMENT '学年名称',
+  PRIMARY KEY (`ID`),
+  UNIQUE KEY `UK_3f2a3s7jtus2nxicvu50l4uer` (`CODE`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='学年表';
+
+-- ----------------------------
+-- Table structure for tb_l_audit_node
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_l_audit_node`;
+CREATE TABLE `tb_l_audit_node` (
+  `ID` varchar(255) COLLATE utf8_bin NOT NULL,
+  `ADD_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '创建人',
+  `ADD_TIME` datetime DEFAULT NULL COMMENT '创建时间',
+  `COMPANY_ID` varchar(200) COLLATE utf8_bin DEFAULT NULL,
+  `DELETE_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '删除人',
+  `DELETE_TIME` datetime DEFAULT NULL COMMENT '删除时间',
+  `DELETED` int(1) DEFAULT '1' COMMENT '是否删除  0：有效  1：删除',
+  `EDIT_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '修改人',
+  `EDIT_TIME` datetime DEFAULT NULL COMMENT '修改时间',
+  `AUDIT_NODE_ADDRESS` varchar(200) COLLATE utf8_bin NOT NULL COMMENT '审核环节地址',
+  `AUDIT_NODE_DUTY` varchar(200) COLLATE utf8_bin NOT NULL COMMENT '审核环节职责',
+  `AUDIT_TYPE` varchar(20) COLLATE utf8_bin NOT NULL COMMENT '审核方式（手动、自动，默认手动）',
+  `CONTACT` varchar(120) COLLATE utf8_bin DEFAULT NULL COMMENT '联系人',
+  `DEFAULT_AUDIT_STATUS` varchar(20) COLLATE utf8_bin NOT NULL COMMENT '审核状态（待审核、审核通过、审核不通过 ，默认待审核）',
+  `NAME` varchar(150) COLLATE utf8_bin NOT NULL COMMENT '名称',
+  `PHONE_NUMBER` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '联系电话',
+  `SCOPE` varchar(20) COLLATE utf8_bin NOT NULL COMMENT '范围控制（全校范围、院系范围、辅导员范围）',
+  `DEPARTMENT_ID` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '所属部门id',
+  PRIMARY KEY (`ID`),
+  KEY `FKhagjedhk0npq3w4esky8dum93` (`DEPARTMENT_ID`),
+  CONSTRAINT `FKhagjedhk0npq3w4esky8dum93` FOREIGN KEY (`DEPARTMENT_ID`) REFERENCES `tb_b_department` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='审核环节';
+
+-- ----------------------------
+-- Table structure for tb_l_leave_audit_log
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_l_leave_audit_log`;
+CREATE TABLE `tb_l_leave_audit_log` (
+  `AUDIT_ID` varchar(64) COLLATE utf8_bin NOT NULL COMMENT '离校流程审核ID',
+  `LOG_ID` varchar(64) COLLATE utf8_bin NOT NULL COMMENT '离校流程审核日志ID',
+  KEY `FKmy5g4diqdrfhxb32d6ttoj2r3` (`LOG_ID`),
+  KEY `FKd8xtnyp7mytu5nfs8sc886tti` (`AUDIT_ID`),
+  CONSTRAINT `FKd8xtnyp7mytu5nfs8sc886tti` FOREIGN KEY (`AUDIT_ID`) REFERENCES `tb_l_leave_sch_pro_audit` (`ID`),
+  CONSTRAINT `FKmy5g4diqdrfhxb32d6ttoj2r3` FOREIGN KEY (`LOG_ID`) REFERENCES `tb_l_leave_sch_pro_audit_log` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
+
+-- ----------------------------
+-- Table structure for tb_l_leave_batch_process
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_l_leave_batch_process`;
+CREATE TABLE `tb_l_leave_batch_process` (
+  `BATCH_ID` varchar(64) COLLATE utf8_bin NOT NULL COMMENT '离校批次ID',
+  `PROCESS_ID` varchar(64) COLLATE utf8_bin NOT NULL COMMENT '离校流程ID',
+  KEY `FK84kdx8345yysdv5malr2mclr7` (`PROCESS_ID`),
+  CONSTRAINT `FK84kdx8345yysdv5malr2mclr7` FOREIGN KEY (`PROCESS_ID`) REFERENCES `tb_l_leave_sch_pro` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
+
+-- ----------------------------
+-- Table structure for tb_l_leave_process_dependence
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_l_leave_process_dependence`;
+CREATE TABLE `tb_l_leave_process_dependence` (
+  `PROCESS_ID` varchar(64) COLLATE utf8_bin NOT NULL COMMENT '离校流程ID',
+  `DEPENDENCE_ID` varchar(64) COLLATE utf8_bin NOT NULL COMMENT '离校流程依赖ID',
+  KEY `FKtgqlah237uwe75x9hjeej15mc` (`DEPENDENCE_ID`),
+  KEY `FK8n2agj2hx1wq7i4xxpcu800a1` (`PROCESS_ID`),
+  CONSTRAINT `FK8n2agj2hx1wq7i4xxpcu800a1` FOREIGN KEY (`PROCESS_ID`) REFERENCES `tb_l_leave_sch_pro` (`ID`),
+  CONSTRAINT `FKtgqlah237uwe75x9hjeej15mc` FOREIGN KEY (`DEPENDENCE_ID`) REFERENCES `tb_l_leave_sch_pro_depen` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
+
+-- ----------------------------
+-- Table structure for tb_l_leave_sch_pro
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_l_leave_sch_pro`;
+CREATE TABLE `tb_l_leave_sch_pro` (
+  `ID` varchar(255) COLLATE utf8_bin NOT NULL,
+  `ADD_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '创建人',
+  `ADD_TIME` datetime DEFAULT NULL COMMENT '创建时间',
+  `COMPANY_ID` varchar(200) COLLATE utf8_bin DEFAULT NULL,
+  `DELETE_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '删除人',
+  `DELETE_TIME` datetime DEFAULT NULL COMMENT '删除时间',
+  `DELETED` int(1) DEFAULT '1' COMMENT '是否删除  0：有效  1：删除',
+  `EDIT_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '修改人',
+  `EDIT_TIME` datetime DEFAULT NULL COMMENT '修改时间',
+  `NEEDED_DEPARTMENT` int(11) DEFAULT NULL COMMENT '是否必办部门',
+  `ORDER_NUM` int(11) DEFAULT NULL COMMENT '显示顺序',
+  `AUDIT_NODE_ID` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '审核环节id',
+  `LEAVE_SCH_BATCH_ID` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '离校批次id',
+  PRIMARY KEY (`ID`),
+  KEY `FKrulca368cqgrj0txjve9mgmyo` (`AUDIT_NODE_ID`),
+  CONSTRAINT `FKrulca368cqgrj0txjve9mgmyo` FOREIGN KEY (`AUDIT_NODE_ID`) REFERENCES `tb_l_audit_node` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='离校流程';
+
+-- ----------------------------
+-- Table structure for tb_l_leave_sch_pro_audit
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_l_leave_sch_pro_audit`;
+CREATE TABLE `tb_l_leave_sch_pro_audit` (
+  `ID` varchar(255) COLLATE utf8_bin NOT NULL,
+  `ADD_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '创建人',
+  `ADD_TIME` datetime DEFAULT NULL COMMENT '创建时间',
+  `COMPANY_ID` varchar(200) COLLATE utf8_bin DEFAULT NULL,
+  `DELETE_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '删除人',
+  `DELETE_TIME` datetime DEFAULT NULL COMMENT '删除时间',
+  `DELETED` int(1) DEFAULT '1' COMMENT '是否删除  0：有效  1：删除',
+  `EDIT_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '修改人',
+  `EDIT_TIME` datetime DEFAULT NULL COMMENT '修改时间',
+  `AUDIT_STATUS` varchar(20) COLLATE utf8_bin NOT NULL COMMENT '审核状态（待审核、审核通过、审核不通过 ，默认待审核）',
+  `LEAVE_SCH_BATCH_ID` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '离校批次id',
+  `LEAVE_SCH_PRO_ID` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '离校流程id',
+  `LEAVE_SCH_STUDENT_ID` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '离校学生id',
+  PRIMARY KEY (`ID`),
+  KEY `FKl0erxg66at51u3whbwb17060h` (`LEAVE_SCH_PRO_ID`),
+  KEY `FK2i4jyp06972cpdhvblvppdk81` (`LEAVE_SCH_STUDENT_ID`),
+  CONSTRAINT `FK2i4jyp06972cpdhvblvppdk81` FOREIGN KEY (`LEAVE_SCH_STUDENT_ID`) REFERENCES `tb_l_leave_sch_student` (`ID`),
+  CONSTRAINT `FKl0erxg66at51u3whbwb17060h` FOREIGN KEY (`LEAVE_SCH_PRO_ID`) REFERENCES `tb_l_leave_sch_pro` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='离校流程审核';
+
+-- ----------------------------
+-- Table structure for tb_l_leave_sch_pro_audit_log
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_l_leave_sch_pro_audit_log`;
+CREATE TABLE `tb_l_leave_sch_pro_audit_log` (
+  `ID` varchar(255) COLLATE utf8_bin NOT NULL,
+  `ADD_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '创建人',
+  `ADD_TIME` datetime DEFAULT NULL COMMENT '创建时间',
+  `COMPANY_ID` varchar(200) COLLATE utf8_bin DEFAULT NULL,
+  `DELETE_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '删除人',
+  `DELETE_TIME` datetime DEFAULT NULL COMMENT '删除时间',
+  `DELETED` int(1) DEFAULT '1' COMMENT '是否删除  0：有效  1：删除',
+  `EDIT_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '修改人',
+  `EDIT_TIME` datetime DEFAULT NULL COMMENT '修改时间',
+  `AUDIT_OPTION` varchar(400) COLLATE utf8_bin NOT NULL COMMENT '审核意见',
+  `AUDIT_STATUS` varchar(20) COLLATE utf8_bin NOT NULL COMMENT '审核状态（待审核、审核通过、审核不通过 ，默认待审核）',
+  `LEAVE_SCH_PRO_AUDIT_ID` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '离校流程审核id',
+  PRIMARY KEY (`ID`),
+  KEY `FK8t5oab3vh813ew8ruii3befmm` (`LEAVE_SCH_PRO_AUDIT_ID`),
+  CONSTRAINT `FK8t5oab3vh813ew8ruii3befmm` FOREIGN KEY (`LEAVE_SCH_PRO_AUDIT_ID`) REFERENCES `tb_l_leave_sch_pro_audit` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='离校流程审核日志';
+
+-- ----------------------------
+-- Table structure for tb_l_leave_sch_pro_depen
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_l_leave_sch_pro_depen`;
+CREATE TABLE `tb_l_leave_sch_pro_depen` (
+  `ID` varchar(255) COLLATE utf8_bin NOT NULL,
+  `ADD_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '创建人',
+  `ADD_TIME` datetime DEFAULT NULL COMMENT '创建时间',
+  `COMPANY_ID` varchar(200) COLLATE utf8_bin DEFAULT NULL,
+  `DELETE_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '删除人',
+  `DELETE_TIME` datetime DEFAULT NULL COMMENT '删除时间',
+  `DELETED` int(1) DEFAULT '1' COMMENT '是否删除  0：有效  1：删除',
+  `EDIT_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '修改人',
+  `EDIT_TIME` datetime DEFAULT NULL COMMENT '修改时间',
+  `AUDIT_NODE_ID` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '审核环节id',
+  `LEAVE_SCH_PRO_ID` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '离校流程id',
+  PRIMARY KEY (`ID`),
+  KEY `FKseosmwxwt4brth7k55rx5hvhg` (`AUDIT_NODE_ID`),
+  KEY `FKjk5ki774t3r6rq75xxehbi9y8` (`LEAVE_SCH_PRO_ID`),
+  CONSTRAINT `FKjk5ki774t3r6rq75xxehbi9y8` FOREIGN KEY (`LEAVE_SCH_PRO_ID`) REFERENCES `tb_l_leave_sch_pro` (`ID`),
+  CONSTRAINT `FKseosmwxwt4brth7k55rx5hvhg` FOREIGN KEY (`AUDIT_NODE_ID`) REFERENCES `tb_l_audit_node` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='离校流程依赖';
+
+-- ----------------------------
+-- Table structure for tb_l_leave_sch_student
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_l_leave_sch_student`;
+CREATE TABLE `tb_l_leave_sch_student` (
+  `ID` varchar(255) COLLATE utf8_bin NOT NULL,
+  `ADD_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '创建人',
+  `ADD_TIME` datetime DEFAULT NULL COMMENT '创建时间',
+  `COMPANY_ID` varchar(200) COLLATE utf8_bin DEFAULT NULL,
+  `DELETE_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '删除人',
+  `DELETE_TIME` datetime DEFAULT NULL COMMENT '删除时间',
+  `DELETED` int(1) DEFAULT '1' COMMENT '是否删除  0：有效  1：删除',
+  `EDIT_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '修改人',
+  `EDIT_TIME` datetime DEFAULT NULL COMMENT '修改时间',
+  `ALLOWED_LEAVE` int(11) DEFAULT NULL COMMENT '是否准予离校',
+  `GRADUATE_MONTH` varchar(10) COLLATE utf8_bin DEFAULT NULL COMMENT '毕业月份MM',
+  `GRADUATE_YEAR` varchar(10) COLLATE utf8_bin DEFAULT NULL COMMENT '毕业年份yyyy',
+  `NAME` varchar(150) COLLATE utf8_bin NOT NULL COMMENT '姓名',
+  `STUDNET_NUMBER` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '学号',
+  `CLAZZ_ID` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '班级id',
+  `DEPARTMENT_ID` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '院系id',
+  `LEAVE_SCH_BATCH_ID` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '离校批次id',
+  `LEAVE_SCHOOL_TYPE_ID` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '离校类型',
+  `MAJOR_ID` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '专业id',
+  `STUDENT_TYPE_ID` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '学生类别',
+  PRIMARY KEY (`ID`),
+  KEY `FKi869693ev77m6padav52w63dk` (`CLAZZ_ID`),
+  KEY `FKlad5nxf34dq5id1m5u20m6b3f` (`DEPARTMENT_ID`),
+  KEY `FKcwpeg8ruswtxspc1br2jvv9ae` (`LEAVE_SCHOOL_TYPE_ID`),
+  KEY `FKsylcd1ke2br0fp1l7oplju0mt` (`MAJOR_ID`),
+  KEY `FKelc2uju93mbeg23trus61bi6w` (`STUDENT_TYPE_ID`),
+  CONSTRAINT `FKcwpeg8ruswtxspc1br2jvv9ae` FOREIGN KEY (`LEAVE_SCHOOL_TYPE_ID`) REFERENCES `tb_b_department` (`ID`),
+  CONSTRAINT `FKelc2uju93mbeg23trus61bi6w` FOREIGN KEY (`STUDENT_TYPE_ID`) REFERENCES `tb_b_department` (`ID`),
+  CONSTRAINT `FKi869693ev77m6padav52w63dk` FOREIGN KEY (`CLAZZ_ID`) REFERENCES `tb_b_department` (`ID`),
+  CONSTRAINT `FKlad5nxf34dq5id1m5u20m6b3f` FOREIGN KEY (`DEPARTMENT_ID`) REFERENCES `tb_b_department` (`ID`),
+  CONSTRAINT `FKsylcd1ke2br0fp1l7oplju0mt` FOREIGN KEY (`MAJOR_ID`) REFERENCES `tb_b_department` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='离校名单';
+
+-- ----------------------------
+-- Table structure for tb_l_leave_student_audit
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_l_leave_student_audit`;
+CREATE TABLE `tb_l_leave_student_audit` (
+  `STUDENT_ID` varchar(64) COLLATE utf8_bin NOT NULL COMMENT '离校名单ID',
+  `AUDIT_ID` varchar(64) COLLATE utf8_bin NOT NULL COMMENT '离校流程审核ID',
+  KEY `FKm99oloebiq97mqmo1qs83x2dw` (`AUDIT_ID`),
+  KEY `FK4061tssmwd9oes5cbff9m8qr2` (`STUDENT_ID`),
+  CONSTRAINT `FK4061tssmwd9oes5cbff9m8qr2` FOREIGN KEY (`STUDENT_ID`) REFERENCES `tb_l_leave_sch_student` (`ID`),
+  CONSTRAINT `FKm99oloebiq97mqmo1qs83x2dw` FOREIGN KEY (`AUDIT_ID`) REFERENCES `tb_l_leave_sch_pro_audit` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
+
+-- ----------------------------
+-- Table structure for tb_l_node_auditor
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_l_node_auditor`;
+CREATE TABLE `tb_l_node_auditor` (
+  `ID` varchar(255) COLLATE utf8_bin NOT NULL,
+  `ADD_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '创建人',
+  `ADD_TIME` datetime DEFAULT NULL COMMENT '创建时间',
+  `COMPANY_ID` varchar(200) COLLATE utf8_bin DEFAULT NULL,
+  `DELETE_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '删除人',
+  `DELETE_TIME` datetime DEFAULT NULL COMMENT '删除时间',
+  `DELETED` int(1) DEFAULT '1' COMMENT '是否删除  0：有效  1：删除',
+  `EDIT_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '修改人',
+  `EDIT_TIME` datetime DEFAULT NULL COMMENT '修改时间',
+  `AUDIT_NODE_ID` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '审核环节id',
+  `USER_ID` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '审核人id',
+  PRIMARY KEY (`ID`),
+  KEY `FKj9d12cx0bm8rdm4b1s8bt1vsy` (`AUDIT_NODE_ID`),
+  KEY `FKgfqu40j6cflp2cew84io9e1y` (`USER_ID`),
+  CONSTRAINT `FKgfqu40j6cflp2cew84io9e1y` FOREIGN KEY (`USER_ID`) REFERENCES `tb_u_user` (`ID`),
+  CONSTRAINT `FKj9d12cx0bm8rdm4b1s8bt1vsy` FOREIGN KEY (`AUDIT_NODE_ID`) REFERENCES `tb_l_audit_node` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='环节审核人';
+
+-- ----------------------------
+-- Table structure for tb_l_node_principal
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_l_node_principal`;
+CREATE TABLE `tb_l_node_principal` (
+  `ID` varchar(255) COLLATE utf8_bin NOT NULL,
+  `ADD_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '创建人',
+  `ADD_TIME` datetime DEFAULT NULL COMMENT '创建时间',
+  `COMPANY_ID` varchar(200) COLLATE utf8_bin DEFAULT NULL,
+  `DELETE_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '删除人',
+  `DELETE_TIME` datetime DEFAULT NULL COMMENT '删除时间',
+  `DELETED` int(1) DEFAULT '1' COMMENT '是否删除  0：有效  1：删除',
+  `EDIT_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '修改人',
+  `EDIT_TIME` datetime DEFAULT NULL COMMENT '修改时间',
+  `AUDIT_NODE_ID` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '审核环节id',
+  `USER_ID` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '审核人id',
+  PRIMARY KEY (`ID`),
+  KEY `FK7s24tkhawwuhwxqdk8t5ips8a` (`AUDIT_NODE_ID`),
+  KEY `FK21n51h0y6ncm5fvhplc64j73v` (`USER_ID`),
+  CONSTRAINT `FK21n51h0y6ncm5fvhplc64j73v` FOREIGN KEY (`USER_ID`) REFERENCES `tb_u_user` (`ID`),
+  CONSTRAINT `FK7s24tkhawwuhwxqdk8t5ips8a` FOREIGN KEY (`AUDIT_NODE_ID`) REFERENCES `tb_l_audit_node` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='环节负责人';
+
+-- ----------------------------
+-- Table structure for tb_u_user
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_u_user`;
+CREATE TABLE `tb_u_user` (
+  `ID` varchar(255) COLLATE utf8_bin NOT NULL,
+  `ADD_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '创建人',
+  `ADD_TIME` datetime DEFAULT NULL COMMENT '创建时间',
+  `COMPANY_ID` varchar(200) COLLATE utf8_bin DEFAULT NULL,
+  `DELETE_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '删除人',
+  `DELETE_TIME` datetime DEFAULT NULL COMMENT '删除时间',
+  `DELETED` int(1) DEFAULT '1' COMMENT '是否删除  0：有效  1：删除',
+  `EDIT_ACCOUNT` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '修改人',
+  `EDIT_TIME` datetime DEFAULT NULL COMMENT '修改时间',
+  `ACCOUNT_NON_EXPIRED` bit(1) DEFAULT NULL,
+  `ACCOUNT_NON_LOCKED` bit(1) DEFAULT NULL,
+  `CREDENTIALS_NON_EXPIRED` bit(1) DEFAULT NULL,
+  `EMAIL` varchar(255) COLLATE utf8_bin DEFAULT NULL,
+  `ENABLED` bit(1) DEFAULT NULL,
+  `MOBILE` varchar(255) COLLATE utf8_bin DEFAULT NULL,
+  `NAME` varchar(255) COLLATE utf8_bin DEFAULT NULL,
+  `PASSWORD` varchar(255) COLLATE utf8_bin DEFAULT NULL,
+  `STATUS` varchar(255) COLLATE utf8_bin DEFAULT NULL,
+  `USERNAME` varchar(255) COLLATE utf8_bin DEFAULT NULL,
+  PRIMARY KEY (`ID`),
+  UNIQUE KEY `UK_m85n4fagxg9gtbho0y2nls1cg` (`USERNAME`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;