/*
Navicat Premium Data Transfer

Source Server : mysql
Source Server Type : MySQL
Source Server Version : 50645
Source Host : localhost:3306
Source Schema : leave

Target Server Type : MySQL
Target Server Version : 50645
File Encoding : 65001

Date: 23/05/2021 20:12:02
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- Table structure for classes

DROP TABLE IF EXISTS classes;
CREATE TABLE classes (
id int(20) NOT NULL AUTO_INCREMENT COMMENT '编码',
class_id varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '班级编号',
class_name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '班级名称',
dep_id varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '二级学院编号',
major varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '专业',
grade varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '年级',
create_time timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
update_time timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '班级表' ROW_FORMAT = Compact;

-- Records of classes

INSERT INTO classes VALUES (1, 'DSJ-18RJ01', '18软件工程1班', 'G1', '软件工程', '2018级', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO classes VALUES (2, 'DSJ-18RJ02', '18软件工程2班', 'G1', '软件工程', '2018级', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO classes VALUES (3, 'DSJ-18RJ03', '18软件工程3班', 'G1', '软件工程', '2018级', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO classes VALUES (4, 'DSJ-18RJ04', '18软件工程4班', 'G1', '软件工程', '2018级', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO classes VALUES (5, 'DSJ-18RJ05', '18软件工程5班', 'G1', '软件工程', '2018级', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO classes VALUES (6, 'DSJ-18RJ06', '18软件工程6班', 'G1', '软件工程', '2018级', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO classes VALUES (7, 'DSJ-19RJ01', '19软件工程1班', 'G1', '软件工程', '2019级', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO classes VALUES (8, 'DSJ-19RJ02', '19软件工程2班', 'G1', '软件工程', '2019级', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO classes VALUES (9, 'DSJ-19RJ03', '19软件工程3班', 'G1', '软件工程', '2019级', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO classes VALUES (10, 'DZGC-19DZ01', '19电子工程1班', 'G2', '电子工程', '2019级', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO classes VALUES (11, 'GC-19JX01', '19机械1班', 'G6', '机械工程', '2019级', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO classes VALUES (12, 'S-19SW01', '19商务1班', 'G3', '商务', '2019级', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO classes VALUES (13, 'SF-19ZX01', '19哲学1班', 'G7', '哲学', '2019级', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO classes VALUES (14, 'WF-19FX01', '19法学1班', 'G4', '法学', '2019级', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO classes VALUES (15, 'YSSJ-19BS01', '19宝石与艺术设计1班', 'G5', '宝石与艺术设计', '2019级', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO classes VALUES (16, 'YSSJ-19BS02', '19宝石与艺术设计2班', 'G5', '宝石与艺术设计', '2019级', '2021-05-08 16:28:38', '2021-05-08 16:28:44');

-- Table structure for sys_course

DROP TABLE IF EXISTS sys_course;
CREATE TABLE sys_course (
id int(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
course_id varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '课程名称',
class_id varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '班号',
course_name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '课程名称',
year varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学年',
term varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学期',
hour int(11) NULL DEFAULT NULL COMMENT '学时',
create_time timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
update_time timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '课程表' ROW_FORMAT = Compact;

-- Records of sys_course

INSERT INTO sys_course VALUES (1, '1800001201', 'DSJ-18RJ03', '数据库', '2020', '上半学期', 120, '2021-05-09 22:48:12', '2021-05-16 11:18:43');
INSERT INTO sys_course VALUES (2, '1800001202', 'DSJ-18RJ03', '软件工程', '2020', '上半学期', 112, '2021-05-09 22:48:12', '2021-05-16 11:18:43');
INSERT INTO sys_course VALUES (3, '1800001203', 'DSJ-18RJ03', 'java应用', '2020', '上半学期', 106, '2021-05-09 22:48:12', '2021-05-16 11:18:43');
INSERT INTO sys_course VALUES (4, '1800001204', 'DSJ-18RJ03', 'UI设计', '2020', '上半学期', 98, '2021-05-09 22:48:12', '2021-05-16 11:18:43');
INSERT INTO sys_course VALUES (5, '1800001205', 'DSJ-18RJ03', '创新创业', '2020', '上半学期', 64, '2021-05-09 22:48:12', '2021-05-16 11:18:43');
INSERT INTO sys_course VALUES (6, '1800001303', 'DSJ-18RJ03', 'WEB前端', '2020', '下半学期', 100, '2021-05-09 22:48:12', '2021-05-16 11:18:43');
INSERT INTO sys_course VALUES (7, '1800001304', 'DSJ-18RJ03', 'WEB应用', '2020', '下半学期', 114, '2021-05-09 22:48:12', '2021-05-16 11:18:43');
INSERT INTO sys_course VALUES (8, '测试', 'DSJ-18RJ03', '测试', '2020', '测试', 56, '2021-05-09 22:48:12', '2021-05-16 11:18:43');

-- Table structure for sys_department

DROP TABLE IF EXISTS sys_department;
CREATE TABLE sys_department (
id int(20) NOT NULL AUTO_INCREMENT COMMENT '编码',
dep_id varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '二级学院编码',
dep_name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
create_time timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
update_time timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '二级学院表' ROW_FORMAT = Compact;

-- Records of sys_department

INSERT INTO sys_department VALUES (1, 'G1', '大数据与软件工程学院', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO sys_department VALUES (2, 'G2', '电子信息工程学院', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO sys_department VALUES (3, 'G3', '商学院', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO sys_department VALUES (4, 'G4', '文法学院', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO sys_department VALUES (5, 'G5', '宝石与艺术设计学院', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO sys_department VALUES (6, 'G6', '机械与材料工程学院', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO sys_department VALUES (7, 'G7', '师范教育学院', '2021-05-08 16:27:59', '2021-05-08 16:27:59');

-- Table structure for sys_instructor

DROP TABLE IF EXISTS sys_instructor;
CREATE TABLE sys_instructor (
id int(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
inst_id varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工号',
inst_name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',
dep_id varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '二级学院编号',
telephone varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系电话',
create_time timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
update_time timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '辅导员表' ROW_FORMAT = Compact;

-- Records of sys_instructor

INSERT INTO sys_instructor VALUES (1, '201812378', '舰载机', 'G1', '13758952158', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO sys_instructor VALUES (2, '201812399', '张佳辉', 'G1', '17683869523', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO sys_instructor VALUES (3, '201925428', '僚机', 'G4', '14789652145', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO sys_instructor VALUES (4, '201932147', '直升机', 'G6', '13985421236', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO sys_instructor VALUES (5, '201965245', '轰炸机', 'G2', '17685475215', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO sys_instructor VALUES (6, '201965412', '客载机', 'G7', '13587459682', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO sys_instructor VALUES (7, '201986321', '战斗机', 'G5', '13658745214', '2021-05-08 16:27:59', '2021-05-08 16:27:59');

-- Table structure for sys_leave

DROP TABLE IF EXISTS sys_leave;
CREATE TABLE sys_leave (
id int(20) NOT NULL AUTO_INCREMENT COMMENT '编码',
leave_id varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请假编号',
course_id varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '课程编码',
reason varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请假理由',
day_num int(11) NULL DEFAULT NULL COMMENT '天数',
stu_no varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学号',
apply_time datetime(0) NULL DEFAULT NULL COMMENT '请假时间',
status varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',
audit_time datetime(0) NULL DEFAULT NULL COMMENT '审核已经',
opinion varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
create_time timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
update_time timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '请假表' ROW_FORMAT = Compact;

-- Records of sys_leave

INSERT INTO sys_leave VALUES (1, '测试', '1800001201', '测试', 3, '201809512328', '2021-05-12 00:03:04', '拒批', '2021-05-19 00:04:05', '无', '2021-05-10 21:46:40', '2021-05-14 22:47:29');
INSERT INTO sys_leave VALUES (3, '测试1', '1800001202', '测试1', 3, '201809512328', '2021-05-27 10:56:40', '通过', '2021-05-29 10:56:34', '无1', '2021-05-10 23:04:16', '2021-05-14 22:47:34');
INSERT INTO sys_leave VALUES (4, '测试2', '1800001203', '测试2', 30, '201809512328', '2021-05-18 10:56:38', '未审批', '2021-05-11 10:56:34', '无2', '2021-05-11 10:43:52', '2021-05-14 22:47:37');
INSERT INTO sys_leave VALUES (7, 'WZ1621003806463635', '1800001203', '回家', 31, '201809512328', '2021-05-14 22:50:22', '通过', '2021-05-14 22:51:16', '通过，无其他情况', '2021-05-14 22:50:23', '2021-05-14 22:51:23');
INSERT INTO sys_leave VALUES (8, 'WZ1621134488471315', '1800001203', '回家', 12, '201809512328', '2021-05-16 11:08:17', '未审批', NULL, NULL, '2021-05-16 11:08:18', '2021-05-16 11:08:18');
INSERT INTO sys_leave VALUES (9, 'WZ1621134686607722', '1800001201', '回家', 11, '201909512328', '2021-05-16 11:11:34', '拒批', '2021-05-16 11:12:19', '无', '2021-05-16 11:11:35', '2021-05-16 11:12:22');
INSERT INTO sys_leave VALUES (10, 'WZ1621134698081933', '1800001205', '回家', 1, '201909512328', '2021-05-16 11:11:45', '通过', '2021-05-16 11:12:30', '通过，无其他情况', '2021-05-16 11:11:46', '2021-05-16 11:12:31');

-- Table structure for sys_student

DROP TABLE IF EXISTS sys_student;
CREATE TABLE sys_student (
id int(20) NOT NULL AUTO_INCREMENT COMMENT '编码',
stu_id varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学号',
class_id varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '班号',
stu_name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',
sex int(1) NULL DEFAULT NULL COMMENT '性别',
address varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '通讯地址',
stu_tel varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学生电话',
contact varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系人',
contact_tel varchar(11) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '联系人电话',
create_time timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
update_time timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '学生表' ROW_FORMAT = Compact;

-- Records of sys_student

INSERT INTO sys_student VALUES (1, '201809512326', 'DSJ-18RJ03', '工具人', 1, '梧州学院', '17683864164', '工具人爸爸', '13578542365', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO sys_student VALUES (2, '201809512327', 'DSJ-18RJ03', '风飒飒', 1, '梧州学院', '14586255568', '风飒飒爸爸', '13784525242', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO sys_student VALUES (3, '201809512328', 'DSJ-18RJ03', '张佳辉', 1, '梧州学院', '12345686453', '张佳辉妈妈', '12854282528', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO sys_student VALUES (4, '201809512340', 'DSJ-18RJ01', '艾丽丝', 0, '梧州学院', '15864562345', '艾丽丝爸爸', '17953574575', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO sys_student VALUES (5, '201909512328', 'DSJ-19RJ03', '傅凌湘', 0, '梧州学院', '13868653453', '傅凌湘妈妈', '14852756868', '2021-05-08 16:27:59', '2021-05-16 11:13:26');
INSERT INTO sys_student VALUES (6, '201909512330', 'DSJ-19RJ03', '弗朗叙', 1, '梧州学院', '18755354686', '弗朗叙爸爸', '15825282285', '2021-05-08 16:27:59', '2021-05-16 11:13:28');
INSERT INTO sys_student VALUES (7, '测试', '测试', '测试', 1, '测试', '测试', '测试', '测试', '2021-05-09 12:35:25', '2021-05-09 12:35:25');

-- Table structure for sys_user

DROP TABLE IF EXISTS sys_user;
CREATE TABLE sys_user (
id int(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
user_id varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工号',
full_name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',
password varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
telephone varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',
create_time timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
update_time timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户表' ROW_FORMAT = Compact;

-- Records of sys_user

INSERT INTO sys_user VALUES (1, '123', '超级管理员', '123', '17683864164', '2021-05-07 22:05:47', '2021-05-07 22:05:47');
INSERT INTO sys_user VALUES (2, '111', '超级管理员', '111', '14254634564', '2021-05-08 19:47:56', '2021-05-09 16:51:57');
INSERT INTO sys_user VALUES (3, '201809512327', '学生', '123456', '15782586425', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO sys_user VALUES (4, '201809512328', '学生', '123456', '14258725257', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO sys_user VALUES (5, '201809512340', '学生', '123456', '14256754287', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO sys_user VALUES (6, '201812378', '辅导员', '123456', '14248557598', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO sys_user VALUES (7, '201812399', '辅导员', '123456', '17842534254', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO sys_user VALUES (8, '201909512328', '学生', '123456', '12587542825', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO sys_user VALUES (9, '201909512330', '学生', '123456', '17854424255', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO sys_user VALUES (10, '201925428', '辅导员', '123456', '15782424557', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO sys_user VALUES (11, '201932147', '辅导员', '123456', '17977454282', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO sys_user VALUES (12, '201965245', '辅导员', '123456', '12428258325', '2021-05-08 16:27:59', '2021-05-08 16:27:59');
INSERT INTO sys_user VALUES (13, '测试', '测试', '测试', '测试', '2021-05-08 23:56:16', '2021-05-08 23:56:16');

SET FOREIGN_KEY_CHECKS = 1;