反射提交到common
diff --git a/leaveschool/leaving/src/main/resources/application.yml b/leaveschool/leaving/src/main/resources/application.yml
index 4981a80..7287745 100644
--- a/leaveschool/leaving/src/main/resources/application.yml
+++ b/leaveschool/leaving/src/main/resources/application.yml
@@ -15,14 +15,14 @@
name: leaving
datasource:
driver-class-name: com.mysql.jdbc.Driver
- url: jdbc:mysql://180.166.150.114:9512/leave_school?useUnicode=true&characterEncoding=utf8&characterSetResults=utf8&autoReconnect=true&zeroDateTimeBehavior=convertToNull
- #url: jdbc:mysql://172.50.10.15:3306/leave_school?useUnicode=true&characterEncoding=utf8&characterSetResults=utf8&autoReconnect=true&zeroDateTimeBehavior=convertToNull
+ #url: jdbc:mysql://180.166.150.114:9512/leave_school?useUnicode=true&characterEncoding=utf8&characterSetResults=utf8&autoReconnect=true&zeroDateTimeBehavior=convertToNull
+ url: jdbc:mysql://172.50.10.15:3306/leave_school?useUnicode=true&characterEncoding=utf8&characterSetResults=utf8&autoReconnect=true&zeroDateTimeBehavior=convertToNull
#url: jdbc:mysql://172.18.101.207:3306/leave_school?useUnicode=true&characterEncoding=utf8&characterSetResults=utf8&autoReconnect=true&zeroDateTimeBehavior=convertToNull
username: leave_school
password: 111111
jpa:
hibernate:
- ddl-auto: none
+ ddl-auto: update
naming:
physical-strategy: org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl
database-platform: org.hibernate.dialect.MySQL5InnoDBDialect
diff --git a/leaveschool/leaving/src/main/resources/db/leave_school.sql b/leaveschool/leaving/src/main/resources/db/leave_school.sql
deleted file mode 100644
index 077c029..0000000
--- a/leaveschool/leaving/src/main/resources/db/leave_school.sql
+++ /dev/null
@@ -1,443 +0,0 @@
-/*
-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;