-- MySQL dump 10.13 Distrib 8.0.25, for Win64 (x86_64)
--
-- Host: localhost Database: emp_ms
-- ------------------------------------------------------
-- Server version 8.0.25
/*!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 */;
/*!50503 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 */;
--
-- Table structure for table `department`
--
DROP TABLE IF EXISTS `department`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `department` (
`id` int NOT NULL AUTO_INCREMENT,
`dep_name` varchar(255) NOT NULL,
`manager_id` int NOT NULL,
PRIMARY KEY (`id`),
KEY `manager_id` (`manager_id`),
CONSTRAINT `department_ibfk_1` FOREIGN KEY (`manager_id`) REFERENCES `employee` (`id`),
CONSTRAINT `department_ibfk_2` FOREIGN KEY (`manager_id`) REFERENCES `employee` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `department`
--
LOCK TABLES `department` WRITE;
/*!40000 ALTER TABLE `department` DISABLE KEYS */;
INSERT INTO `department` VALUES (1,'财政部',8001),(2,'人事部',8002),(3,'市场部',8004),(4,'生产部',8003),(5,'信息部',8074);
/*!40000 ALTER TABLE `department` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `employee`
--
DROP TABLE IF EXISTS `employee`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `employee` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`passwd` varchar(255) NOT NULL,
`sex` char(2) NOT NULL,
`rate` float DEFAULT '0',
`birth` date NOT NULL,
`address` varchar(255) NOT NULL,
`cardId` varchar(20) NOT NULL,
`tel` varchar(20) NOT NULL,
`dep_id` int NOT NULL,
`job_id` int NOT NULL,
PRIMARY KEY (`id`),
KEY `idx_emp_id` (`id`),
KEY `job_id` (`job_id`),
KEY `dep_id` (`dep_id`),
CONSTRAINT `employee_ibfk_1` FOREIGN KEY (`dep_id`) REFERENCES `department` (`id`),
CONSTRAINT `employee_ibfk_3` FOREIGN KEY (`job_id`) REFERENCES `job` (`id`),
CONSTRAINT `employee_ibfk_4` FOREIGN KEY (`dep_id`) REFERENCES `department` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8391 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `employee`
--
LOCK TABLES `employee` WRITE;
/*!40000 ALTER TABLE `employee` DISABLE KEYS */;
INSERT INTO `employee` VALUES (8001,'佚名wz','123456123456','男',0.4,'2002-05-08','吉林省','220182200001013213','18245644564',1,1),(8002,'佚名f','123456123456','男',0.6,'2002-04-16','吉林省','318153987998798799','15464656546',2,10),(8003,'佚名l','123456123456','男',0.3,'2000-08-03','吉林省','532730198708246240','18298390167',4,23),(8004,'佚名wq','123456123456','男',0.3,'1972-08-05','吉林省','152301197208059650','18995513128',3,16),(8005,'俟司信茜','123456','女',0,'1988-02-06','四川省阿坝藏族羌族自治州','513200198802062466','18995513128',3,17),(8006,'明中厚','123456','男',0,'1997-06-15','广西壮族自治区桂林市雁山区','450311199706156892','18995513128',4,29),(8007,'芮歌永','123456','男',0,'1991-06-17','湖北省武汉市黄陂区','420116199106174398','18995513128',4,29),(8008,'康世','123456','男',0.3,'1985-10-16','湖北省武汉市青山区','420107198510169776','18995513128',1,7),(8009,'束凯茜','123123','女',0,'1982-02-23','西藏自治区阿里地区札达县','542522198202233566','18995513128',4,29),(8010,'于单娜','123456','女',0.2,'1971-09-16','河北省承德市滦平县','130824197109169244','18995513128',5,33),(8011,'景园','123456','女',0.3,'1988-03-28','山东省菏泽地区单县','372925198803289740','18995513128',1,7),(8012,'卫芸','123456','女',0.3,'1983-06-17','河北省沧州市孟村回族自治县','130930198306179545','18995513128',4,28),(8013,'胡信美','123456','女',0,'1999-08-12','江苏省南通市港闸区','320611199908127763','18995513128',1,3),(8014,'武筠','123456','女',0,'1995-10-28','西藏自治区林芝地区波密县','542625199510287020','18995513128',4,26),(8015,'马玉以','123456','男',0.2,'1990-09-07','河北省邢台市市辖区','130501199009078837','18995513128',5,33),(8016,'乔加月','123456','女',0,'1980-09-15','山西省长治市黎城县','140426198009153103','18995513128',1,6),(8017,'毛琬','123456','女',0,'1994-09-01','四川省巴中地区','513700199409016860','18995513128',5,35),(8018,'彭家辉','124242','男',0,'1996-10-17','广东省梅州市兴宁市','441481199610173712','18995513128',2,15),(8019,'汪被行','123456','男',0,'1994-11-07','湖南省益阳市桃江县','430922199411075874','18995513128',1,3),(8020,'骆九风','123456','男',0,'1996-04-10','福建省福州市','350100199604108853','18995513128',5,31),(8021,'俞蕊','123456','女',0.3,'1977-09-24','辽宁省铁岭市昌图县','211224197709247064','18995513128',5,35),(8022,'松瑶','123456','女',0,'1982-04-05','黑龙江省大庆市萨尔图区','230602198204053003','18995513128',4,4),(8023,'孙兴','123456','男',0,'1978-06-11','江苏省盐城市大丰市','32098219780611709X','18995513128',2,13),(8024,'强钰娴','031214','女',0,'1970-06-16','湖南省湘潭市','430300197006152987','18995513128',5,37),(8025,'贺翔','123456','男',0,'1992-02-13','湖南省邵阳市绥宁县','430527199202136538','18995513128',5,31),(8026,'郁马萍','123456','女',0,'1981-07-25','四川省泸州市泸县','510521198107259705','18995513128',1,8),(8027,'尹笑敬','123456','男',0,'1985-12-01','山东省德州市临邑县','371424198512014419','18995513128',4,27),(8028,'邢器平','123456','男',0,'1970-11-08','山西省太原市尖草坪区','140108197011087770','18995513128',4,29),(8029,'步妍','123456','女',0,'1976-12-18','广东省汕头市潮阳市','44058219761218904X','18995513128',5,31),(8030,'宣静','123456','女',0,'1972-01-13','四川省绵阳市安县','510724197201131666','18995513128',3,19),(8031,'葛秀','123456','女',0.4,'1987-01-18','广西壮族自治区柳州地区武宣县','452225198701186283','18995513128',1,8),(8032,'车轮','123456','男',0.4,'1984-11-27','江西省宜春地区','362200198411271798','18995513128',1,8),(8033,'于都雅','123456','女',0,'1993-07-28','北京市市辖区','110100199307283802','18995513128',4,24),(8034,'都无爱','123456','女',0,'1987-02-16','河北省邢台市临西县','130535198702168223','18995513128',4,26),(8035,'茹凯振','123456','男',0.4,'1973-01-04','安徽省阜阳市颍泉区','34120419730104665X','18995513128',1,8),(8036,'冀栋','123456','男',0.3,'1974-06-13','安徽省淮北市相山区','340603197406137739','18995513128',1,7),(8037,'百里婵','123456','女',0,'1993-02-21','黑龙江省绥化地区海伦市','232304199302213368','18995513128',4,26),(8038,'崔忠慧','123456','女',0.3,'1975-12-24','安徽省黄山市屯溪区','341002197512248821','18995513128',2,14),(8039,'束贝菊','123456','女',0.3,'1986-07-27','江苏省徐州市泉山区','320311198607278268','13140375456',2,14),(8040,'逄泽','123456','男',0,'1999-05-29','宁夏回族自治区银川市市辖区','640101199905293998','18995513128',2,15),(8041,'干百卡坚','123456','男',0,'1980-02-09','黑龙江省双鸭山市友谊县','230522198002096013','18995513128',3,18),(8042,'刁哲','123456','男',0,'1974-01-08','陕西省延安市宝塔区','610602197401086054','18995513128',3,18),(8043,'伊好翠','123456','女',0.3,'1970-01-23','湖北省省直�
基于Servlet+MySQL,+Mybatis+Vue实现的人事工资管理系统.zip
196 浏览量
2023-08-16
15:44:06
上传
评论
收藏 3.36MB ZIP 举报
![avatar](https://profile-avatar.csdnimg.cn/af75bb4a0dad4d63bda6fae1e6d9f61b_qq_35831906.jpg!1)
LeapMay
- 粉丝: 3w+
- 资源: 2305
最新资源
- 使用ASP.NET Core和Entity Framework Core来构建一个基本的进销存系统.rar
- 深度学习经典数据集+FER2013面部表情识别+附带使用方法的python代码
- Python中,要实现连接多个相机并识别多个二维码.rar
- 使用FFT算法对一个信号进行分析.rar
- 171cms游戏应用下载系统源码.zip
- 基于jsp+servlet+mysql蛋糕甜品店购物网站源码+数据库(期末大作业).zip
- Java项目:在线蛋糕商城系统(java+jsp+mysql)源码+数据库+期末大作业.zip
- ZapyaClient10_7-1.apk
- 织梦cms站长导航网站源码.zip
- 基于SSM+MySQL的网络投票调查问卷系统源码+数据库(java期末大作业).zip
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
![feedback](https://img-home.csdnimg.cn/images/20220527035711.png)
![feedback](https://img-home.csdnimg.cn/images/20220527035711.png)
![feedback-tip](https://img-home.csdnimg.cn/images/20220527035111.png)