公司绩效考评系统 -- 数据库设计, 接口方法

最新推荐文章于 2024-07-04 16:15:06 发布

JingXingLiang

最新推荐文章于 2024-07-04 16:15:06 发布

阅读量2.1k

点赞数 1

分类专栏：个人项目文章标签：数据库设计

本文链接：https://blog.csdn.net/qq_36241003/article/details/88043316

版权

本文介绍了一个公司绩效考评系统的数据库设计，包括员工评分的周排名和月排名查询。通过SQL查询，可以获取特定员工的总分、自评得分和他评得分。目前内容仍在更新中。

摘要由CSDN通过智能技术生成

个人项目

数据库表

/*
 Navicat Premium Data Transfer

 Source Server         : mysql
 Source Server Type    : MySQL
 Source Server Version : 50540
 Source Host           : localhost:3306
 Source Schema         : company

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

 Date: 26/02/2019 18:27:01
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for controller
-- ----------------------------
DROP TABLE IF EXISTS `controller`;
CREATE TABLE `controller`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `controller_path` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资源权限路径',
  `controller_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资源权限名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of controller
-- ----------------------------
INSERT INTO `controller` VALUES (1, 'sorce/findAll', NULL);

-- ----------------------------
-- Table structure for department
-- ----------------------------
DROP TABLE IF EXISTS `department`;
CREATE TABLE `department`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '部门id',
  `dept_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '部门名称',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `id`(`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of department
-- ----------------------------
INSERT INTO `department` VALUES (1, '技术部');
INSERT INTO `department` VALUES (2, '设计部');
INSERT INTO `department` VALUES (3, '人事部');

-- ----------------------------
-- Table structure for mark_history
--