/*
 Navicat Premium Data Transfer

 Source Server         : mysql
 Source Server Type    : MySQL
 Source Server Version : 50719
 Source Host           : localhost:3306
 Source Schema         : mydata

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

 Date: 06/05/2021 11:24:37
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for announcement
-- ----------------------------
DROP TABLE IF EXISTS `announcement`;
CREATE TABLE `announcement`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '公告id',
  `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '标题',
  `releaseTime` date NULL DEFAULT NULL COMMENT '发布时间',
  `roleToSee` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '谁可以看',
  `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '内容',
  `author` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发布者',
  `eid` int(11) NULL DEFAULT NULL COMMENT '发布者id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of announcement
-- ----------------------------
INSERT INTO `announcement` VALUES (5, '工资调整', '2020-03-25', '全部员工', '        关于工资调整的内容，我司将决定对全体员工的工资在之前的基础上加500元，以鼓励大家对公司的贡献，请全体员工再接再厉，为我司再创辉煌！！！哈哈哈哈', '管理员', 173);
INSERT INTO `announcement` VALUES (21, '发布公告', '2020-05-07', '全部员工', '   我就要随便发布公告', '客服经理', 446);
INSERT INTO `announcement` VALUES (23, '四月二十二号', '2021-04-22', '全部员工', '今天加班', '管理员', 2021010200);

-- ----------------------------
-- Table structure for attendancesetting
-- ----------------------------
DROP TABLE IF EXISTS `attendancesetting`;
CREATE TABLE `attendancesetting`  (
  `starttime` time(0) NOT NULL COMMENT '签到时间',
  `lateststarttime` time(0) NOT NULL COMMENT '最迟签到时间',
  `endtime` time(0) NULL DEFAULT NULL COMMENT '签退时间',
  PRIMARY KEY (`starttime`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of attendancesetting
-- ----------------------------
INSERT INTO `attendancesetting` VALUES ('09:00:00', '23:00:00', '14:00:00');

-- ----------------------------
-- Table structure for depart
-- ----------------------------
DROP TABLE IF EXISTS `depart`;
CREATE TABLE `depart`  (
  `dept_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '部门id',
  `dept_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '部门名',
  `dept_address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门地址',
  `established` date NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`dept_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of depart
-- ----------------------------
INSERT INTO `depart` VALUES (1, '研发部', '广东省', '2020-03-04');
INSERT INTO `depart` VALUES (2, '推广部', '广东省', '2020-03-05');
INSERT INTO `depart` VALUES (3, '客服部', '广东省', '2020-03-05');
INSERT INTO `depart` VALUES (4, '财务部', '广东省', '2020-03-05');
INSERT INTO `depart` VALUES (5, '行政部', '广东省', '2020-03-05');

-- ----------------------------
-- Table structure for employee
-- ----------------------------
DROP TABLE IF EXISTS `employee`;
CREATE TABLE `employee`  (
  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT 'id(工号）',
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '姓名',
  `sex` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别',
  `edu` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学历',
  `wage` double(50, 0) NULL DEFAULT NULL COMMENT '工资',
  `password` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
  `hiredate` date NULL DEFAULT NULL COMMENT '入职时间',
  `birthday` date NULL DEFAULT NULL COMMENT '出生日期',
  `phone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号',
  `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2021010211 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of employee
-- ----------------------------
INSERT INTO `employee` VALUES (446, '赵武', '男', '本科', 0, '123456', '2020-03-13', '1995-06-15', '18532563258', '[email protected]');
INSERT INTO `employee` VALUES (475, '长老', '女', '本科', 6800, '0kLi3Q', '2020-03-26', '1998-02-20', '16352874126', '[email protected]');
INSERT INTO `employee` VALUES (478, '张锋', '女', '本科', 6300, 'kCm7ii', '2020-03-27', '1988-07-22', '13526358745', '[email protected]');
INSERT INTO `employee` VALUES (479, '李志斌', '女', '研究生', 8900, '123456', '2020-03-28', '1997-12-10', '18536258745', '[email protected]');
INSERT INTO `employee` VALUES (480, '李白', '男', '本科', 12000, 'x72uE7', '2020-03-27', '1998-04-10', '12536259856', '[email protected]');
INSERT INTO `employee` VALUES (481, '赵四', '女', '本科', 7960, 'xhQuQH', '2020-03-11', '1999-01-14', '13652475869', '[email protected]');
INSERT INTO `employee` VALUES (482, '五百', '男', '大专', 5900, 'M4KKTS', '2020-03-11', '2001-03-09', '13625412362', '[email protected]');
INSERT INTO `employee` VALUES (507, '362', '男', '本科', 3620, '0xs7T0', '2020-03-27', '1998-03-27', '13652458795', '[email protected]');
INSERT INTO `employee` VALUES (508, '武当山', '男', '本科', 23000, '5n6Jh4', '2013-03-14', '1983-08-26', '15896586325', '[email protected]');
INSERT INTO `employee` VALUES (509, '武当山', '男', '本科', 23000, '5n6Jh4', '2013-03-14', '1983-08-26', '15896586325', '[email protected]');
INSERT INTO `employee` VALUES (510, '武当山', '男', '本科', 23000, '5n6Jh4', '2013-03-14', '1983-08-26', '15896586325', '[email protected]');
INSERT INTO `employee` VALUES (511, '武当山', '男', '本科', 23000, '5n6Jh4', '2013-03-14', '1983-08-26', '15896586325', '[email protected]');
INSERT INTO `employee` VALUES (512, '武当山', '男', '本科', 23000, '5n6Jh4', '2013-03-14', '1983-08-26', '15896586325', '[email protected]');
INSERT INTO `employee` VALUES (513, '武当山', '男', '本科', 23000, '5n6Jh4', '2013-03-14', '1983-08-26', '15896586325', '[email protected]');
INSERT INTO `employee` VALUES (514, '武当山', '男', '本科', 23000, '5n6Jh4', '2013-03-14', '1983-08-26', '15896586325', '[email protected]');
INSERT INTO `employee` VALUES (515, '武当山', '男', '本科', 23000, '5n6Jh4', '2013-03-14', '1983-08-26', '15896586325', '[email protected]');
INSERT INTO `employee` VALUES (516, '武当山', '男', '本科', 23000, '5n6Jh4', '2013-03-14', '1983-08-26', '15896586325', '[email protected]');
INSERT INTO `employee` VALUES (517, '武当山', '男', '本科', 23000, '5n6Jh4', '2013-03-14', '1983-08-26', '15896586325', '[email protected]');
INSERT INTO `employee` VALUES (518, '武当山', '男', '本科', 23000, '5n6Jh4', '2013-03-14', '1983-08-26', '15896586325', '[email protected]');
INSERT INTO `employee` VALUES (519, '武当山', '男', '本科', 23000, '5n6Jh4', '2013-03-14', '1983-08-26', '15896586325', '[email protected]');
INSERT INTO `employee` VALUES (520, '武当山', '男', '本科', 23000, '5n6Jh4', '2013-03-14', '1983-08-26', '15896586325', '[email protected]');
INSERT INTO `employee` VALUES (521, '武当山', '男', '本科', 23000, '5n6Jh4', '2013-03-14', '1983-08-26', '15896586325', '[email protected]');
INSERT INTO `employee` VALUES (522, '武当山', '男', '本科', 23000, '5n6Jh4', '2013-03-14', '1983-08-26', '15896586325', '[email protected]');
INSERT INTO `employee` VALUES (523, '武当山', '男', '本科', 23000, '5n6Jh4', '2013-03-14', '1983-08-26', '15896586325', '[email protected]');
INSERT INTO `employee` VALUES (524, '武当山', '男', '本科', 23000, '5n6Jh4', '2013-03-14', '1983-08-26', '15896586325', '[email protected]');
INSERT INTO `employee` VALUES (525, '武当山', '男', '本科', 23000, '5n6Jh4', '2013-03-14', '1983-08-26', '15896586325', '[email protected]');
INSERT INTO `employee` VALUES (2021010200, 'admin4', '男', '博士后', 0, '123456', '2021-04-12', '2021-02-25', '13677949176', '[email protected]');
INSERT INTO `employee` VALUES (2021010203, 'qq', '男', '大专', 0, '123456', '2021-02-24', '2021-02-20', '13799469176', '[email protected]');
INSERT INTO `employee` VALUES (2021010204, '123', '男', '本科', 0, '123123', '2021-03-03', '2021-02-09', '13677949176', '[email protected]');
INSERT INTO `employee` VALUES (2021010205, '123123', '男', '本科', 0, '123123', '2021-02-23', '2021-02-16', '1231231231231', '1231231321123123');
INSERT INTO `employee` VALUES (2021010206, '张三', '男', '大专', 0, '123456', '2021-04-22', '2021-02-11', '13677949176', '[email protected]');
INSERT INTO `employee` VALUES (2021010208, '某某人1', '男', '高中', 0, '123456', '2021-04-23', '2021-04-23', '13677949176', '[email protected]');
INSERT INTO `employee` VALUES (2021010210, '玩玩', '男', '本科', 0, '111111', '2021-04-06', '2021-04-06', '13131311313131331', '12312312312312');

-- ----------------------------
-- Table structure for employee_depart
-- ----------------------------
DROP TABLE IF EXISTS `employee_depart`;
CREATE TABLE `employee_depart`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '员工部门id',
  `eid` int(11) NOT NULL COMMENT '员工表id',
  `did` int(11) NOT NULL COMMENT '部门表id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 109 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of employee_depart
-- ----------------------------
INSERT INTO `employee_depart` VALUES (1, 2021010200, 1);
INSERT INTO `employee_depart` VALUES (10, 446, 3);
INSERT INTO `employee_depart` VALUES (39, 475, 4);
INSERT INTO `employee_depart` VALUES (42, 478, 3);
INSERT INTO `employee_depart` VALUES (43, 479, 1);
INSERT INTO `employee_depart` VALUES (44, 480, 5);
INSERT INTO `employee_depart` VALUES (45, 481, 3);
INSERT INTO `employee_depart` VALUES (46, 482, 2);
INSERT INTO `employee_depart` VALUES (71, 507, 1);
INSERT INTO `employee_depart` VALUES (72, 508, 1);
INSERT INTO `employee_depart` VALUES (73, 509, 1);
INSERT INTO `employee_depart` VALUES (74, 510, 1);
INSERT INTO `employee_depart` VALUES (75, 511, 3);
INSERT INTO `employee_depart` VALUES (76, 512, 1);
INSERT INTO `employee_depart` VALUES (77, 513, 3);
INSERT INTO `employee_depart` VALUES (78, 514, 1);
INSERT INTO `employee_depart` VALUES (79, 515, 3);
INSERT INTO `employee_depart` VALUES (80, 516, 1);
INSERT INTO `employee_depart` VALUES (81, 517, 1);
INSERT INTO `employee_depart` VALUES (82, 518, 4);
INSERT INTO `employee_depart` VALUES (83, 519, 1);
INSERT INTO `employee_depart` VALUES (84, 520, 1);
INSERT INTO `employee_depart` VALUES (85, 521, 3);
INSERT INTO `employee_depart` VALUES (86, 522, 3);
INSERT INTO `employee_depart` VALUES (87, 523, 1);
INSERT INTO `employee_depart` VALUES (88, 524, 1);
INSERT INTO `employee_depart` VALUES (89, 525, 1);
INSERT INTO `employee_depart` VALUES (101, 2021010203, 1);
INSERT INTO `employee_depart` VALUES (102, 2021010204, 2);
INSERT INTO `employee_depart` VALUES (103, 2021010205, 1);
INSERT INTO `employee_depart` VALUES (104, 2021010206, 3);
INSERT INTO `employee_depart` VALUES (106, 2021010208, 1);
INSERT INTO `employee_depart` VALUES (108, 2021010210, 1);

-- ----------------------------
-- Table structure for employee_role
-- ----------------------------
DROP TABLE IF EXISTS `employee_role`;
CREATE TABLE `employee_role`  (
  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT '员工角色id',
  `eid` int(20) NULL DEFAULT NULL COMMENT '员工id',
  `rid` int(20) NULL DEFAULT NULL COMMENT '角色id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 428 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of employee_role
-- ----------------------------
INSERT INTO `employee_role` VALUES (328, 446, 7);
INSERT INTO `employee_role` VALUES (357, 475, 2);
INSERT INTO `employee_role` VALUES (360, 478, 2);
INSERT INTO `employee_role` VALUES (361, 479, 3);
INSERT INTO `employee_role` VALUES (362, 480, 2);
INSERT INTO `employee_role` VALUES (363, 481, 2);
INSERT INTO `employee_role` VALUES (364, 482, 2);
INSERT INTO `employee_role` VALUES (389, 507, 2);
INSERT INTO `employee_role` VALUES (390, 508, 2);
INSERT INTO `employee_role` VALUES (391, 509, 2);
INSERT INTO `employee_role` VALUES (392, 510, 2);
INSERT INTO `employee_role` VALUES (393, 511, 2);
INSERT INTO `employee_role` VALUES (394, 512, 2);
INSERT INTO `employee_role` VALUES (395, 513, 2);
INSERT INTO `employee_role` VALUES (396, 514, 2);
INSERT INTO `employee_role` VALUES (397, 515, 2);
INSERT INTO `employee_role` VALUES (398, 516, 2);
INSERT INTO `employee_role` VALUES (399, 517, 2);
INSERT INTO `employee_role` VALUES (400, 518, 2);
INSERT INTO `employee_role` VALUES (401, 519, 2);
INSERT INTO `employee_role` VALUES (402, 520, 2);
INSERT INTO `employee_role` VALUES (403, 521, 2);
INSERT INTO `employee_role` VALUES (404, 522, 2);
INSERT INTO `employee_role` VALUES (405, 523, 2);
INSERT INTO `employee_role` VALUES (406, 524, 2);
INSERT INTO `employee_role` VALUES (407, 525, 2);
INSERT INTO `employee_role` VALUES (418, 2021010200, 1);
INSERT INTO `employee_role` VALUES (420, 2021010203, 2);
INSERT INTO `employee_role` VALUES (421, 2021010204, 2);
INSERT INTO `employee_role` VALUES (422, 2021010205, 2);
INSERT INTO `employee_role` VALUES (423, 2021010206, 3);
INSERT INTO `employee_role` VALUES (425, 2021010208, 3);
INSERT INTO `employee_role` VALUES (427, 2021010210, 2);

-- ----------------------------
-- Table structure for leavetime
-- ----------------------------
DROP TABLE IF EXISTS `leavetime`;
CREATE TABLE `leavetime`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '请假id',
  `eid` int(11) NOT NULL COMMENT '员工id',
  `starttime` date NULL DEFAULT NULL COMMENT '开始时间',
  `endtime` date NULL DEFAULT NULL COMMENT '结束时间',
  `reason` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请假理由',
  `filldate` date NULL DEFAULT NULL COMMENT '填表时间',
  `status` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审批状态',
  `days` int(6) NULL DEFAULT NULL COMMENT '请假天数',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 42 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of leavetime
-- ----------------------------
INSERT INTO `leavetime` VALUES (36, 446, '2020-04-15', '2020-04-16', '请假', '2020-03-28', '已通过', 2);
INSERT INTO `leavetime` VALUES (37, 2021010200, '2021-04-15', '2021-04-30', '出差', '2021-04-12', '已通过', 12);
INSERT INTO `leavetime` VALUES (38, 2021010200, '2021-05-01', '2021-05-09', '出差', '2021-04-12', '已通过', 5);
INSERT INTO `leavetime` VALUES (39, 2021010200, '2021-04-14', '2021-04-15', '家中有事', '2021-04-22', '已通过', 2);
INSERT INTO `leavetime` VALUES (40, 2021010200, '2021-04-06', '2021-04-09', '有事情', '2021-04-23', '未通过', 4);
INSERT INTO `leavetime` VALUES (41, 2021010200, '2021-04-14', '2021-04-15', '家中有事情', '2021-04-24', '待审批', 2);

-- ----------------------------
-- Table structure for overtime
-- ----------------------------
DROP TABLE IF EXISTS `overtime`;
CREATE TABLE `overtime`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '加班id',
  `eid` int(11) NOT NULL COMMENT '员工id',
  `days` int(20) NULL DEFAULT NULL COMMENT '加班天数',
  `starttime` date NULL DEFAULT NULL COMMENT '开始时间',
  `endtime` date NULL DEFAULT NULL COMMENT '结束时间',
  `reason` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '理由',
  `filldate` date NULL DEFAULT NULL COMMENT '填表时间',
  `status` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 45 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of overtime
-- ----------------------------
INSERT INTO `overtime` VALUES (43, 446, 2, '2020-05-09', '2020-05-10', '请假', '2020-05-07', '已通过');
INSERT INTO `overtime` VALUES (44, 2021010200, 2, '2021-04-17', '2021-04-18', '未完成任务', '2021-04-12', '未通过');

-- ----------------------------
-- Table structure for permission
-- ----------------------------
DROP TABLE IF EXISTS `permission`;
CREATE TABLE `permission`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `desc_` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `url` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of permission
-- ----------------------------
INSERT INTO `permission` VALUES (1, 'addProduct', '研发部权限', '/addProduct');
INSERT INTO `permission` VALUES (2, 'deleteProduct', '推广部权限', '/deleteProduct');
INSERT INTO `permission` VALUES (3, 'editeProduct', '客服部权限', '/editeProduct');
INSERT INTO `permission` VALUES (4, 'updateProduct', '财务部权限', '/updateProduct');
INSERT INTO `permission` VALUES (5, 'listProduct', '行政部权限', '/listProduct');

-- ----------------------------
-- Table structure for picture
-- ----------------------------
DROP TABLE IF EXISTS `picture`;
CREATE TABLE `picture`  (
  `eid` int(11) NOT NULL COMMENT '员工id',
  `date` timestamp(0) NULL DEFAULT NULL COMMENT '最近更改日期',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片名',
  `path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片路径',
  PRIMARY KEY (`eid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of picture
-- ----------------------------
INSERT INTO `picture` VALUES (173, '2021-01-06 09:27:40', '1609896726736.jpg', '/images/1609896726736.jpg');
INSERT INTO `picture` VALUES (175, '2020-02-04 09:34:28', '1580792551610.jpg', '/images/1580792551610.jpg');
INSERT INTO `picture` VALUES (446, '2021-01-05 14:05:34', '1609827115781.jpg', '/images/1609827115781.jpg');
INSERT INTO `picture` VALUES (2021010200, '2021-04-12 09:31:24', '1618192584422.jpg', '/images/1618192584422.jpg');

-- ----------------------------
-- Table structure for punchclock
-- ----------------------------
DROP TABLE IF EXISTS `punchclock`;
CREATE TABLE `punchclock`  (
  `id` int(8) NOT NULL AUTO_INCREMENT COMMENT '考勤id',
  `employeeid` int(8) NOT NULL COMMENT '员工号id',
  `punch_inTime` datetime(0) NULL DEFAULT NULL COMMENT '签到时间',
  `punch_outTime` datetime(0) NULL DEFAULT NULL COMMENT '签退时间',
  `attendanceTime` date NULL DEFAULT NULL COMMENT '考勤当天日期',
  `ps` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 118 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of punchclock
-- ----------------------------
INSERT INTO `punchclock` VALUES (39, 173, '2020-01-21 17:19:15', '2020-01-21 17:19:23', '2020-01-21', '迟到');
INSERT INTO `punchclock` VALUES (40, 173, '2020-01-23 13:27:20', NULL, '2020-01-23', '正常');
INSERT INTO `punchclock` VALUES (42, 173, '2020-01-24 09:08:27', NULL, '2020-01-24', '迟到');
INSERT INTO `punchclock` VALUES (43, 173, '2020-01-29 10:37:01', '2020-01-29 18:00:28', '2020-01-29', '正常');
INSERT INTO `punchclock` VALUES (44, 173, '2020-01-31 10:00:08', '2020-01-31 18:02:15', '2020-01-31', '正常');
INSERT INTO `punchclock` VALUES (47, 173, '2020-02-03 10:50:00', '2020-02-03 19:31:37', '2020-02-03', '正常');
INSERT INTO `punchclock` VALUES (48, 173, '2020-02-04 09:34:58', NULL, '2020-02-04', '正常');
INSERT INTO `punchclock` VALUES (49, 173, '2020-02-05 10:23:25', '2020-02-05 18:22:02', '2020-02-05', '正常');
INSERT INTO `punchclock` VALUES (50, 173, '2020-02-06 09:15:11', '2020-02-06 21:02:55', '2020-02-06', '正常');
INSERT INTO `punchclock` VALUES (54, 173, '2020-02-12 09:27:14', '2020-02-12 19:53:14', '2020-02-12', '正常');
INSERT INTO `punchclock` VALUES (55, 173, '2020-02-13 09:41:09', '2020-02-13 20:59:30', '2020-02-13', '正常');
INSERT INTO `punchclock` VALUES (56, 173, '2020-02-14 08:17:17', '2020-02-14 18:13:57', '2020-02-14', '正常');
INSERT INTO `punchclock` VALUES (59, 173, '2020-02-17 09:24:35', '2020-02-17 18:02:33', '2020-02-17', '正常');
INSERT INTO `punchclock` VALUES (60, 173, '2020-02-18 08:48:00', '2020-02-18 18:50:48', '2020-02-18', '正常');
INSERT INTO `punchclock` VALUES (61, 295, '2020-02-18 09:08:24', '2020-02-18 21:23:23', '2020-02-18', '正常');
INSERT INTO `punchclock` VALUES (63, 305, '2020-02-18 10:51:27', '2020-02-18 21:21:42', '2020-02-18', '正常');
INSERT INTO `punchclock` VALUES (64, 173, '2020-02-19 08:45:39', '2020-02-19 19:33:55', '2020-02-19', '正常');
INSERT INTO `punchclock` VALUES (66, 305, '2020-02-19 09:26:39', '2020-02-19 21:26:44', '2020-02-19', '正常');
INSERT INTO `punchclock` VALUES (67, 173, '2020-02-20 09:06:28', NULL, '2020-02-20', '正常');
INSERT INTO `punchclock` VALUES (68, 173, '2020-02-21 10:18:15', '2020-02-21 18:03:34', '2020-02-21', '正常');
INSERT INTO `punchclock` VALUES (71, 173, '2020-02-24 08:25:02', NULL, '2020-02-24', '正常');
INSERT INTO `punchclock` VALUES (72, 173, '2020-02-25 11:05:23', '2020-02-25 22:42:19', '2020-02-25', '迟到');
INSERT INTO `punchclock` VALUES (73, 173, '2020-02-26 09:50:01', NULL, '2020-02-26', '正常');
INSERT INTO `punchclock` VALUES (74, 173, '2020-03-02 09:39:58', '2020-03-02 19:16:35', '2020-03-02', '正常');
INSERT INTO `punchclock` VALUES (75, 173, '2020-03-03 16:06:40', '2020-03-03 16:33:21', '2020-03-03', '迟到');
INSERT INTO `punchclock` VALUES (76, 173, '2020-03-04 15:17:33', NULL, '2020-03-04', '迟到');
INSERT INTO `punchclock` VALUES (77, 173, '2020-03-05 10:36:32', '2020-03-05 18:36:26', '2020-03-05', '迟到');
INSERT INTO `punchclock` VALUES (80, 309, '2020-03-05 11:35:17', NULL, '2020-03-05', '迟到');
INSERT INTO `punchclock` VALUES (81, 173, '2020-03-11 09:37:59', NULL, '2020-03-11', '迟到');
INSERT INTO `punchclock` VALUES (82, 173, '2020-03-20 09:30:08', NULL, '2020-03-20', '迟到');
INSERT INTO `punchclock` VALUES (87, 173, '2020-03-24 08:38:50', '2020-03-24 22:30:57', '2020-03-24', '正常');
INSERT INTO `punchclock` VALUES (89, 173, '2020-03-25 09:24:15', NULL, '2020-03-25', '迟到');
INSERT INTO `punchclock` VALUES (90, 446, '2020-03-26 08:46:23', '2020-03-26 18:46:31', '2020-03-26', '正常');
INSERT INTO `punchclock` VALUES (91, 173, '2020-03-27 08:33:10', NULL, '2020-03-27', '正常');
INSERT INTO `punchclock` VALUES (92, 446, '2020-03-27 08:36:35', NULL, '2020-03-27', '正常');
INSERT INTO `punchclock` VALUES (93, 446, '2020-04-09 08:38:58', '2020-04-09 18:09:13', '2020-04-09', '正常');
INSERT INTO `punchclock` VALUES (94, 446, '2020-04-07 08:40:41', '2020-04-25 18:26:52', '2020-04-07', '正常');
INSERT INTO `punchclock` VALUES (95, 446, '2020-04-15 08:41:30', '2020-04-15 18:41:53', '2020-04-15', '正常');
INSERT INTO `punchclock` VALUES (96, 446, '2020-04-13 09:11:17', '2020-04-13 18:02:44', '2020-04-13', '迟到');
INSERT INTO `punchclock` VALUES (97, 446, '2020-04-14 09:00:00', '2020-04-14 18:01:56', '2020-04-14', '正常');
INSERT INTO `punchclock` VALUES (98, 446, '2020-04-23 08:45:37', '2020-04-23 18:01:49', '2020-04-23', '正常');
INSERT INTO `punchclock` VALUES (99, 173, '2021-01-05 14:54:11', '2021-01-05 14:54:35', '2021-01-05', '迟到');
INSERT INTO `punchclock` VALUES (100, 173, '2021-01-06 08:30:09', NULL, '2021-01-06', '正常');
INSERT INTO `punchclock` VALUES (101, 173, '2021-01-07 09:26:57', '2021-01-07 16:40:45', '2021-01-07', '迟到');
INSERT INTO `punchclock` VALUES (102, 173, '2021-01-08 11:04:21', '2021-01-08 14:17:33', '2021-01-08', '迟到');
INSERT INTO `punchclock` VALUES (105, 173, '2021-02-01 15:18:38', '2021-02-01 15:18:40', '2021-02-01', '迟到');
INSERT INTO `punchclock` VALUES (106, 2021010200, '2021-02-22 09:49:55', NULL, '2021-02-22', '迟到');
INSERT INTO `punchclock` VALUES (107, 475, '2021-03-09 08:37:53', NULL, '2021-03-09', '正常');
INSERT INTO `punchclock` VALUES (108, 2021010200, '2021-03-09 08:51:59', '2021-03-09 16:23:07', '2021-03-09', '正常');
INSERT INTO `punchclock` VALUES (109, 2021010200, '2021-04-12 09:31:35', NULL, '2021-04-12', '迟到');
INSERT INTO `punchclock` VALUES (111, 2021010206, '2021-04-12 11:09:59', NULL, '2021-04-12', '迟到');
INSERT INTO `punchclock` VALUES (112, 2021010200, '2021-04-20 11:50:52', NULL, '2021-04-20', '迟到');
INSERT INTO `punchclock` VALUES (113, 2021010200, '2021-04-22 10:47:37', NULL, '2021-04-22', '迟到');
INSERT INTO `punchclock` VALUES (115, 2021010200, '2021-04-23 20:45:58', NULL, '2021-04-23', '迟到');
INSERT INTO `punchclock` VALUES (116, 2021010208, '2021-04-23 22:35:49', NULL, '2021-04-23', '迟到');
INSERT INTO `punchclock` VALUES (117, 2021010200, '2021-04-28 11:10:57', NULL, '2021-04-28', '迟到');

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role`  (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '角色id',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色名称',
  `desc_` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色描述',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES (1, 'admin', '管理员');
INSERT INTO `role` VALUES (2, 'employee', '普通员工');
INSERT INTO `role` VALUES (3, 'yfManager', '研发经理');
INSERT INTO `role` VALUES (4, 'cwManager', '财务经理');
INSERT INTO `role` VALUES (5, 'xzManager', '行政经理');
INSERT INTO `role` VALUES (6, 'tgManager', '推广经理');
INSERT INTO `role` VALUES (7, 'kfManager', '客服经理');

-- ----------------------------
-- Table structure for role_permission
-- ----------------------------
DROP TABLE IF EXISTS `role_permission`;
CREATE TABLE `role_permission`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `rid` bigint(20) NULL DEFAULT NULL,
  `pid` bigint(20) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 61 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of role_permission
-- ----------------------------
INSERT INTO `role_permission` VALUES (1, 1, 1);
INSERT INTO `role_permission` VALUES (2, 1, 2);
INSERT INTO `role_permission` VALUES (3, 1, 3);
INSERT INTO `role_permission` VALUES (4, 1, 4);
INSERT INTO `role_permission` VALUES (5, 1, 5);
INSERT INTO `role_permission` VALUES (6, 2, 1);
INSERT INTO `role_permission` VALUES (57, 3, 2);
INSERT INTO `role_permission` VALUES (58, 4, 3);
INSERT INTO `role_permission` VALUES (59, 5, 4);
INSERT INTO `role_permission` VALUES (60, 6, 5);

-- ----------------------------
-- Table structure for travelschedule
-- ----------------------------
DROP TABLE IF EXISTS `travelschedule`;
CREATE TABLE `travelschedule`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '出差id',
  `eid` int(11) NOT NULL COMMENT '员工id',
  `starttime` date NULL DEFAULT NULL COMMENT '开始时间',
  `endtime` date NULL DEFAULT NULL COMMENT '结束时间',
  `reason` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '理由',
  `filldate` date NULL DEFAULT NULL COMMENT '填表时间',
  `status` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',
  `days` int(6) NULL DEFAULT NULL COMMENT '天数',
  `address` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出差地址',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 34 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of travelschedule
-- ----------------------------
INSERT INTO `travelschedule` VALUES (33, 446, '2020-04-08', '2020-04-16', '出差', '2020-03-28', '已通过', 7, '广东省深圳市龙岗区');

-- ----------------------------
-- Triggers structure for table employee
-- ----------------------------
DROP TRIGGER IF EXISTS `e_l`;
delimiter ;;
CREATE TRIGGER `e_l` AFTER DELETE ON `employee` FOR EACH ROW begin
delete from overtime where overtime.eid = old.id;
delete from leavetime where leavetime.eid = old.id;
delete from picture where picture.eid = old.id;
delete from punchclock where punchclock.employeeid = old.id;
delete from travelschedule where travelschedule.eid = old.id;
delete from employee_role where employee_role.eid = old.id;
delete from employee_depart where employee_depart.eid = old.id;
end
;;
delimiter ;

SET FOREIGN_KEY_CHECKS = 1;

set @@GLOBAL.sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';