基于微信小程序的服装企业人事OA管理系统+后台管理系统(SSM+mysql)-JAVA.VUE【数据库设计、论文、源码、开题报告】

功能介绍

管理员；首页，个人中心，部门管理，员工管理，员工考勤管理，员工请假管理，部门调动管理，出差申请管理，员工工资管理，系统管理等

小程序：首页、我的（员工考勤，员工请假，部门调动，出差申请，员工工资等）等

数据库脚本

-- MySQL dump 10.13  Distrib 5.7.31, for Linux (x86_64)
--
-- Host: localhost    Database: springboot1h3t5
-- ------------------------------------------------------
-- Server version	5.7.31

/*!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 utf8 */;
/*!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 */;

--
-- Current Database: `springboot1h3t5`
--

/*!40000 DROP DATABASE IF EXISTS `springboot1h3t5`*/;

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `springboot1h3t5` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;

USE `springboot1h3t5`;

--
-- Table structure for table `bumen`
--

DROP TABLE IF EXISTS `bumen`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bumen` (
  `id` BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `bumen` VARCHAR(200) DEFAULT NULL COMMENT '部门',
  PRIMARY KEY (`id`)
) ENGINE=INNODB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='部门';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bumen`
--

LOCK TABLES `bumen` WRITE;
/*!40000 ALTER TABLE `bumen` DISABLE KEYS */;
INSERT INTO `bumen` VALUES (11,'2022-04-18 07:01:02','生产部门'),(12,'2022-04-18 07:01:02','部门2'),(13,'2022-04-18 07:01:02','部门3'),(14,'2022-04-18 07:01:02','部门4'),(15,'2022-04-18 07:01:02','部门5'),(16,'2022-04-18 07:01:02','部门6');
/*!40000 ALTER TABLE `bumen` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bumendiaodong`
--

DROP TABLE IF EXISTS `bumendiaodong`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bumendiaodong` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `yuangongzhanghao` varchar(200) DEFAULT NULL COMMENT '员工账号',
  `yuangongxingming` varchar(200) DEFAULT NULL COMMENT '员工姓名',
  `touxiang` varchar(200) DEFAULT NULL COMMENT '头像',
  `bumen` varchar(200) DEFAULT NULL COMMENT '部门',
  `shenqingbumen` varchar(200) DEFAULT NULL COMMENT '申请部门',
  `shenqingyuanyin` longtext COMMENT '申请原因',
  `shenqingshijian` datetime DEFAULT NULL COMMENT '申请时间',
  `sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
  `shhf` longtext COMMENT '审核回复',
  `userid` bigint(20) DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='部门调动';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bumendiaodong`
--

LOCK TABLES `bumendiaodong` WRITE;
/*!40000 ALTER TABLE `bumendiaodong` DISABLE KEYS */;
INSERT INTO `bumendiaodong` VALUES (51,'2022-04-18 07:01:02','员工账号1','员工姓名1','upload/bumendiaodong_touxiang1.jpg','部门1','申请部门1','申请原因1','2022-04-18 15:01:02','是','',1),(52,'2022-04-18 07:01:02','员工账号2','员工姓名2','upload/bumendiaodong_touxiang2.jpg','部门2','申请部门2','申请原因2','2022-04-18 15:01:02','是','',2),(53,'2022-04-18 07:01:02','员工账号3','员工姓名3','upload/bumendiaodong_touxiang3.jpg','部门3','申请部门3','申请原因3','2022-04-18 15:01:02','是','',3),(54,'2022-04-18 07:01:02','员工账号4','员工姓名4','upload/bumendiaodong_touxiang4.jpg','部门4','申请部门4','申请原因4','2022-04-18 15:01:02','是','',4),(55,'2022-04-18 07:01:02','员工账号5','员工姓名5','upload/bumendiaodong_touxiang5.jpg','部门5','申请部门5','申请原因5','2022-04-18 15:01:02','是','',5),(56,'2022-04-18 07:01:02','员工账号6','员工姓名6','upload/bumendiaodong_touxiang6.jpg','部门6','申请部门6','申请原因6','2022-04-18 15:01:02','是','',6);
/*!40000 ALTER TABLE `bumendiaodong` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `chuchashenqing`
--

DROP TABLE IF EXISTS `chuchashenqing`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chuchashenqing` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `yuangongzhanghao` varchar(200) DEFAULT NULL COMMENT '员工账号',
  `yuangongxingming` varchar(200) DEFAULT NULL COMMENT '员工姓名',
  `touxiang` varchar(200) DEFAULT NULL COMMENT '头像',
  `bumen` varchar(200) DEFAULT NULL COMMENT '部门',
  `chuchariqi` date DEFAULT NULL COMMENT '出差日期',
  `chuchatianshu` varchar(200) DEFAULT NULL COMMENT '出差天数'