java-ee-course-design
/
excellent.sql

/*
 Navicat Premium Data Transfer

 Source Server         : MySQL
 Source Server Type    : MySQL
 Source Server Version : 80020
 Source Host           : localhost:3306
 Source Schema         : excellent

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

 Date: 15/04/2022 11:07:24
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for classes
-- ----------------------------
DROP TABLE IF EXISTS `classes`;
CREATE TABLE `classes`  (
  `classId` int(0) NOT NULL AUTO_INCREMENT,
  `classNum` int(0) NOT NULL,
  PRIMARY KEY (`classId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of classes
-- ----------------------------
INSERT INTO `classes` VALUES (1, 18130041);
INSERT INTO `classes` VALUES (2, 18130042);
INSERT INTO `classes` VALUES (3, 18130043);
INSERT INTO `classes` VALUES (4, 18130044);
INSERT INTO `classes` VALUES (5, 18130045);
INSERT INTO `classes` VALUES (6, 18130046);

-- ----------------------------
-- Table structure for company
-- ----------------------------
DROP TABLE IF EXISTS `company`;
CREATE TABLE `company`  (
  `comId` int(0) NOT NULL AUTO_INCREMENT,
  `comName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `comMeg` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `comAddress` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `comHr` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `comHrTel` int(0) NOT NULL,
  `comJobId` int(0) NOT NULL,
  PRIMARY KEY (`comId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of company
-- ----------------------------
INSERT INTO `company` VALUES (1, '字节跳动', '字节跳动', '北京', '张三', 123456789, 1);
INSERT INTO `company` VALUES (2, '百度', '百度', '上海', '李四', 1234568525, 2);
INSERT INTO `company` VALUES (3, '1223', '55822', '5852', '2552', 2563, 2);

-- ----------------------------
-- Table structure for direction
-- ----------------------------
DROP TABLE IF EXISTS `direction`;
CREATE TABLE `direction`  (
  `dirID` int(0) NOT NULL AUTO_INCREMENT,
  `dirName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`dirID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of direction
-- ----------------------------
INSERT INTO `direction` VALUES (1, '软件开发与测试（A）');
INSERT INTO `direction` VALUES (2, '云计算与大数据（Y）');
INSERT INTO `direction` VALUES (3, '移动互联网（X）');
INSERT INTO `direction` VALUES (4, '企业信息化（B）');
INSERT INTO `direction` VALUES (5, '智慧城市（Z）');

-- ----------------------------
-- Table structure for graduate
-- ----------------------------
DROP TABLE IF EXISTS `graduate`;
CREATE TABLE `graduate`  (
  `graID` int(0) NOT NULL AUTO_INCREMENT,
  `graSex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `graTel` int(0) NOT NULL,
  `graClassId` int(0) NOT NULL,
  `graTime` datetime(0) NOT NULL,
  `graComId` int(0) NOT NULL,
  `graDirId` int(0) NOT NULL,
  `graSalary` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`graID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of graduate
-- ----------------------------
INSERT INTO `graduate` VALUES (1, '男', 123456789, 1, '2020-12-15 18:25:42', 1, 1, '4K');
INSERT INTO `graduate` VALUES (2, '男', 2425, 5, '2020-12-08 00:00:00', 1, 1, '8K');
INSERT INTO `graduate` VALUES (3, '男', 110, 1, '2020-10-21 00:00:00', 1, 3, '1k');
INSERT INTO `graduate` VALUES (4, '男', 1111, 3, '2020-10-10 00:00:00', 1, 1, '1');
INSERT INTO `graduate` VALUES (5, '男', 1111, 1, '2020-10-11 00:00:00', 1, 1, '11');
INSERT INTO `graduate` VALUES (6, '男', 258963, 1, '2020-09-09 00:00:00', 1, 3, '20K');
INSERT INTO `graduate` VALUES (8, '女', 120, 2, '2020-02-02 00:00:00', 1, 2, '20K');
INSERT INTO `graduate` VALUES (9, '男', 123456, 2, '2020-10-11 00:00:00', 1, 2, '52K');
INSERT INTO `graduate` VALUES (10, '女', 310, 6, '2020-10-20 00:00:00', 1, 2, '30K');
INSERT INTO `graduate` VALUES (11, '女', 457, 2, '1997-10-20 00:00:00', 2, 2, '2k');
INSERT INTO `graduate` VALUES (13, '男', 123, 2, '2019-12-01 00:00:00', 1, 1, '1K');
INSERT INTO `graduate` VALUES (15, '女', 1145, 2, '1988-12-30 00:00:00', 2, 4, '20K');
INSERT INTO `graduate` VALUES (16, '男', 110, 1, '2020-10-20 00:00:00', 1, 1, '52K');
INSERT INTO `graduate` VALUES (18, '男', 110, 4, '2020-12-20 00:00:00', 1, 2, '12K');
INSERT INTO `graduate` VALUES (19, '女', 123568, 3, '2020-10-11 00:00:00', 2, 4, '20K');
INSERT INTO `graduate` VALUES (20, '女', 125656, 6, '2021-01-05 00:00:00', 4, 5, '25K');

-- ----------------------------
-- Table structure for groups
-- ----------------------------
DROP TABLE IF EXISTS `groups`;
CREATE TABLE `groups`  (
  `id` int(0) NOT NULL,
  `userid` int(0) NOT NULL COMMENT '外键--user表',
  `groupid` int(0) NOT NULL COMMENT '队伍编号',
  `usertype` int(0) NOT NULL COMMENT '用户类型1-组长 0-组员',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of groups
-- ----------------------------
INSERT INTO `groups` VALUES (1, 1, 1, 1);
INSERT INTO `groups` VALUES (2, 2, 1, 0);
INSERT INTO `groups` VALUES (3, 3, 1, 0);
INSERT INTO `groups` VALUES (4, 2, 2, 1);

-- ----------------------------
-- Table structure for jobs
-- ----------------------------
DROP TABLE IF EXISTS `jobs`;
CREATE TABLE `jobs`  (
  `jobId` int(0) NOT NULL AUTO_INCREMENT,
  `jobName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `jobDe` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`jobId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of jobs
-- ----------------------------
INSERT INTO `jobs` VALUES (1, '架构师', '1122');
INSERT INTO `jobs` VALUES (2, '大数据', '565');
INSERT INTO `jobs` VALUES (3, 'java开发', '852');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `userId` int(0) NOT NULL AUTO_INCREMENT,
  `userName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `useraccount` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `userPassword` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `types` int(0) NOT NULL,
  `graID` int(0) NULL DEFAULT NULL,
  PRIMARY KEY (`userId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, '张朝亮', '520', '520', 2, 2);
INSERT INTO `user` VALUES (2, '张翔宇', '111', '111', 0, NULL);
INSERT INTO `user` VALUES (3, '李四', '222', '222', 1, 1);
INSERT INTO `user` VALUES (5, '1111', '1', '1', 1, 3);
INSERT INTO `user` VALUES (6, '222', '2', '2', 1, 4);
INSERT INTO `user` VALUES (8, '张三', '123', '123', 1, 8);
INSERT INTO `user` VALUES (9, '李四', '1', '1', 1, 9);
INSERT INTO `user` VALUES (10, '王五', '2', '2', 1, 10);
INSERT INTO `user` VALUES (11, '赵六', '3', '3', 1, 11);
INSERT INTO `user` VALUES (13, '菲菲', '5', '5', 1, 13);
INSERT INTO `user` VALUES (15, '小张', '9', '9', 1, 15);
INSERT INTO `user` VALUES (18, '111两', '1123456', '111', 1, 18);
INSERT INTO `user` VALUES (19, '张小小', '7890', '张小小', 0, NULL);
INSERT INTO `user` VALUES (20, '丽丽', '125', '125', 1, 19);
INSERT INTO `user` VALUES (21, '李艾', '7895', '123', 1, 20);

SET FOREIGN_KEY_CHECKS = 1;